Cash Register Reconciliation Calculator
Reconcile your cash drawer count with expected sales.
Inputs
$
$
$
Results
Over / Short
-$29.25
Total Cash Counted$820.75
Expected Total$850.00
Over/Short %3.44%
Status (1=Over, 0=Even, -1=Short)-1
Deposit Amount$620.75
Cash in Drawer$820.75
How to Use This Calculator
- Enter the starting cash drawer amount at the beginning of the shift.
- Input total cash sales and any cash refunds processed during the shift.
- Enter the physical cash counted at drawer close.
- Review the Expected Cash Balance vs Actual Count to find overages or shortages.
- Use the Variance output to identify whether a discrepancy requires investigation.
How the result changes with Expected Cash Sales
| Expected Cash Sales | Over / Short |
|---|---|
| $100,000.00 | -$99,379.25 |
| $350,000.00 | -$349,379.25 |
| $650,000.00 | -$649,379.25 |
| $900,000.00 | -$899,379.25 |
What each input means
- Starting Cash
- Cash in drawer at start of shift.
- $100 Bills
- Number of $100 bills.
- $50 Bills
- Number of $50 bills.
- $20 Bills
- Number of $20 bills.
- $10 Bills
- Number of $10 bills.
- $5 Bills
- Number of $5 bills.
- $1 Bills
- Number of $1 bills.
- Total Coins
- Total value of all coins.
- Expected Cash Sales
- Cash sales reported by POS system.
How this is calculated
Worked example, using the default values
- Identify Input Parameters4 parametersStarting Cash = 200, $100 Bills = 2, $50 Bills = 3, $20 Bills = 15 = 9 input(s) provided
- Calculate Over / ShortOver / Short-29.25 = $-29.25
- Calculate Total Cash CountedTotal Cash Counted820.75 = $820.75
- Calculate Expected TotalExpected Total850 = $850
Engine last updated . Checked against 2 independently-derived tests — how we verify calculators.
Related Calculators
The questions that sit next to this one — chosen by subject, including calculators filed under a different category.
Small Business
POS Comparison Calculator
Calculate monthly POS cost including subscriptions and transaction fees.
Small BusinessProfit First Calculator
Allocate revenue using Profit First percentages.
Math & StatisticsMoney Counter
Total cash by denomination, with rolls and over/short.
Small BusinessDiscount Calculator
Calculate discounted prices, savings amount, and discount percentage. Perfect for sales and pricing.
More in Business & Entrepreneurship.