Cash Register Reconciliation Calculator

Cash register reconciliation, also called till counting or end-of-day balancing, compares the actual cash in the drawer against what the point-of-sale system says should be there. Discrepancies reveal miscounts, unrecorded voids, or theft, and in tight-margin retail every cent of it comes off the bottom line.

Formula:

Expected Cash = Opening Float + Total Cash Sales − Cash Paid Out

Variance:

Variance = Actual Cash Count − Expected Cash

A positive variance is an overage, meaning more cash than expected. A negative one is a shortage. Both are worth looking at: a consistent overage usually means someone is undercharging or failing to record sales, which is a different problem from theft but still a problem.

What each variable means:

• Opening float is the change fund you start the shift with. Typically $100 to $300 for a small retailer.
• Total cash sales is every transaction the customer paid for in cash, taken from the POS report rather than from memory.
• Cash paid out is anything removed from the drawer mid-shift: vendor payments, cash refunds, manager pulls to the safe.
• Actual cash count is the physical total of bills and coins, which is what the denomination fields above produce.

Worked example: Opening float: $200 Cash sales from the POS: $1,847.50 Paid outs: $45.00 for a vendor delivery

Expected cash = $200 + $1,847.50 − $45.00 = $2,002.50 Actual count: $1,988.75

Variance = $1,988.75 − $2,002.50 = a $13.75 shortage

Counting denominations methodically: Count largest to smallest, every time, in the same order: $100s, $50s, $20s, $10s, $5s, $1s, then quarters, dimes, nickels and pennies. Doing it in a fixed order is what makes a recount meaningful, because you can compare the two passes line by line rather than starting over.

Acceptable variance thresholds:

The thresholds are per shift, not per day. A store running three shifts at $4 short each is $12 down and looks fine on a daily total, which is exactly how a persistent problem hides.

Note on currency: the denomination fields are United States bills and coins, so this page stays in dollars regardless of the site-wide currency setting. Quarters, dimes and nickels are not a general concept.