How much cash should be in the petty cash box? (SUM)
Test case
1
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
Test case
1
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
The problem
Problem statement
The float is in E1 and the receipts collected are in B2:B4. Put the cash that should remain in the box in the Cash left cell E2.
The float minus the receipts — a negative answer is a real finding, not something to hide.
Problem data
Show the sheet as a table (selectable, copyable)
| A | B | D | E | |
|---|---|---|---|---|
| 1 | Receipt | Amount | Float | 500 |
| 2 | Taxi | 120 | Cash left | |
| 3 | Postage | 80 | ||
| 4 | Stationery | 150 |
Notes
This is a physical control, so the arithmetic must be trivial and the answer must match what you count in the box. A negative result means either a missing receipt or money taken: both are findings, so do not clamp it at zero.
How to approach
Your answer goes in E2.
- Target cell is E2
- Add the receipts
- Subtract from the float
- Shape: =?-SUM(?)
FAQ
How do I reconcile petty cash?
Float − sum of receipts = cash that should be present. Compare it with the physical count.
Should I show a negative result as zero?
No. A negative answer means missing receipts or missing cash, which is exactly what the control exists to surface.