UseFreeTools

Cash Drawer Reconciliation

Compare counted cash denominations with the expected drawer balance from opening cash and entered cash movements.

Inputs stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

Showing an example. Edit to see your own.

One positive denomination per row. Counts are whole numbers. Use one currency with up to two decimal places.

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

How to use Cash Drawer Reconciliation

  1. Enter opening cash and the cash movements.
  2. Count each denomination and enter its quantity.
  3. Compare counted cash with the expected amount and review any difference.

Example: Cash Drawer Reconciliation

Cash Drawer Reconciliation: Balanced: counted 150.50, expected 150.50.

You add
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 20.00,2 10.00,1 0.50,1
You get
Balanced: counted 150.50, expected 150.50. Opening + cash sales + other cash received - cash paid out - cash refunds. Do not include refunds again in cash paid out. Expected cash | 150.50 Counted cash | 150.50 Over / short | 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.

Supported inputs and limits

One currency with two decimal places; up to 60 distinct denomination rows and whole counts up to 1 million. Expected cash equals opening plus cash sales and other receipts, minus payouts and refunds. Negative expected cash is refused. No mixed currencies, tax calculation, profit report or account connection.

Where your input is processed

This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save 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.

Project manager: Tony Hines · Content updated 4 October 2026 · Report a problem

Related tools

All tools in Finance