Cash Drawer Reconciliation

Count a cash drawer using editable bill and coin rows, then compare it with expected cash.

On-device No sign-up Free to use

Check cash controls

Showing an example. Edit to see your own.

?

One positive denomination per row with a whole count. The grid starts with the US bills and coins; edit the counts to match your drawer. Use one currency with up to two decimal places.

More options
?

Labels the amounts you enter. It does not convert currencies or fetch rates.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

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.

Balanced: counted $150.50, expected $150.50. Difference $0.00.

https://usefreetools.net/cash-drawer-reconciliation · 20 November 2026

Was this helpful?

How to use Cash Drawer Reconciliation

  1. Enter Opening cash, then cash sales and Other cash received for the period. Exclude card or other noncash sales.
  2. Enter Cash paid out excluding refunds, and enter Cash refunds separately. Counting the same refund in both fields would subtract it twice.
  3. 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.
  4. 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.
  5. 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.

You add
Currency used for display: USD; Opening cash: 100.00; Cash sales: 65.50; Other cash received: 0.00; Cash paid out, excluding refunds: 10.00; Cash refunds: 5.00; Counted denominations CSV: value,count 100.00,1 50.00,0 20.00,2 10.00,1 5.00,0 2.00,0 1.00,0 0.50,1 0.25,0 0.10,0 0.05,0 0.01,0
You get
Balanced: counted $150.50, expected $150.50. Difference $0.00.

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.

Page updated · Project managed by Tony Hines · Report a problem with Cash Drawer Reconciliation