Open calculator ↗

Retail till discrepancy and cash deposit reconciliation · Calculation guide

Estimate till overage or shortage using your figures.

Calculation guide

Cash sales exclude card payments. Enter refunds and payouts as positive cash outflows. Count till cash before removing the bank deposit.

difference = count-(opening+sales-refund-paid); deposit = count-float; expected = opening+sales-refund-paid

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

InputValue
Opening till float200
Cash sales1,250
Cash refunds40
Other cash payouts60
Counted cash1,345
Retained till float200
ResultValue
Till overage or shortage-5
Cash for bank deposit1,145
Expected till cash1,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening till float200220Till overage or shortage-5-25
Cash sales1,2501,375Till overage or shortage-5-130
Cash refunds4044Till overage or shortage-5-1
Other cash payouts6066Till overage or shortage-51
Counted cash1,3451,480Till overage or shortage-5130
Retained till float200220Cash for bank deposit1,1451,125
Retail till discrepancy and cash deposit reconciliation →