Calculation guide
Cash sales exclude card payments. Enter refunds and payouts as positive cash outflows. Count till cash before removing the bank deposit.
Inputs
Opening till float
Example entry 200 (in the selected currency).
Cash sales
Example entry 1250 (in the selected currency).
Cash refunds
Example entry 40 (in the selected currency).
Other cash payouts
Example entry 60 (in the selected currency).
Counted cash
Example entry 1345 (in the selected currency).
Retained till float
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening till float | 200 |
| Cash sales | 1,250 |
| Cash refunds | 40 |
| Other cash payouts | 60 |
| Counted cash | 1,345 |
| Retained till float | 200 |
| Result | Value |
|---|---|
| Till overage or shortage | -5 |
| Cash for bank deposit | 1,145 |
| Expected till cash | 1,350 |
Calculation steps
Till overage or shortage = (Counted cash − (((Opening till float + Cash sales) − Cash refunds) − Other cash payouts))
(1,345 − (((200 + 1,250) − 40) − 60)) = -5
Cash for bank deposit = (Counted cash − Retained till float)
(1,345 − 200) = 1,145
Expected till cash = (((Opening till float + Cash sales) − Cash refunds) − Other cash payouts)
(((200 + 1,250) − 40) − 60) = 1,350
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening till float | 200 | 220 | Till overage or shortage | -5 | -25 |
| Cash sales | 1,250 | 1,375 | Till overage or shortage | -5 | -130 |
| Cash refunds | 40 | 44 | Till overage or shortage | -5 | -1 |
| Other cash payouts | 60 | 66 | Till overage or shortage | -5 | 1 |
| Counted cash | 1,345 | 1,480 | Till overage or shortage | -5 | 130 |
| Retained till float | 200 | 220 | Cash for bank deposit | 1,145 | 1,125 |
