How to use Cash Drawer Reconciliation
- Enter Opening cash, then cash sales and Other cash received for the period. Exclude card or other noncash sales.
- Enter Cash paid out excluding refunds, and enter Cash refunds separately. Counting the same refund in both fields would subtract it twice.
- Update the Bill and coin count grid with your actual denomination values and whole counts. Changing the currency label does not change the prefilled US denominations; edit values or add denominations for your own drawer.
- Select Check cash. Over / short is counted cash minus expected cash: positive is Over, negative is Short, and zero is Balanced. Recount and check the entered movements before using a difference.
- Download cash-reconciliation.json for the calculated amounts and denomination subtotals. It is a result record, not an importable project; keep the currency and period with your own notes.
Example: Cash Drawer Reconciliation
Opening $100 plus $65.50 cash sales, minus $10 payouts and $5 refunds, gives $150.50 expected cash. The sample denomination counts also total $150.50, so the difference is $0.
Options
- Expected cash
- Opening cash plus cash sales and other receipts, less payouts and refunds, gives the expected drawer balance. Keep non-cash sales outside these entries.
- Counted denominations
- Enter each denomination value and its whole count in the CSV. The page totals value times count.
- Currency display
- Choose a symbol for monetary results. This neither converts amounts nor swaps the starting US denomination list. The result JSON contains numeric amounts without a currency identifier.
Supported inputs and limits
- Use one currency, with nonnegative amounts of at most 1,000,000,000.00 and no more than two decimal places per input.
- Grouping commas and a leading $ are accepted in the five cash-movement fields.
- Use plain decimal values in the denomination grid.
- Expected cash cannot be negative.
- The denomination list needs the exact value,count CSV header and 1 to 60 positive, distinct values.
More details
Counts are whole numbers from 0 to 1,000,000.
The editable grid supports up to 20,000 input characters; raw CSV processing has a 100,000-character bound.
Values are not inferred from the selected currency.
Expected cash = Opening + Cash sales + Other cash received − Cash paid out − Cash refunds.
This is a physical-cash comparison, not a profit report, tax calculation or proof that transactions are complete.
There is no till/account connection, automatic saving or result-file importer.
Processing is local.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Investigate a difference before adjusting records
The difference is counted cash minus expected cash. A positive result means an overage under this convention, and a negative result means a shortage. Recount the denominations and check transaction timing before recording an adjustment. A balanced drawer alone does not prove every transaction was recorded correctly.
Questions about Cash Drawer Reconciliation
Should card sales be included?
No. Include only money that physically enters or leaves the cash drawer.
What does short mean?
The counted cash is below the expected cash amount.
Can I mix currencies?
No. All amounts and denominations must use one currency and two decimal places.