Cash Reconciliation Calculator

Count your actual cash by denomination, enter the expected amount from your POS system, and instantly see whether you are over, short, or balanced. The cash reconciliation calculator produces a variance report showing the exact difference.

Expected vs Actual
Variance Report
Over/ Short
Monto Total
$ 0.00
Ingrese las denominaciones a continuación para comenzar

Billetes

Subtotal: $0.00

Monedas

Subtotal: $0.00
Reconciliation Logic

How Cash Reconciliation Works

Cash reconciliation compares two numbers: the expected cash balance (from sales records, POS reports, or ledger entries) and the actual cash balance (from physically counting the cash). The difference between these two numbers is the variance — also called the cash over and short amount.

The reconciliation formula is: Variance = Actual Cash − Expected Cash. A positive variance means you have more cash than expected (over). A negative variance means you have less cash than expected (short). Zero variance means the cash balances perfectly.

The cash reconciliation calculator combines denomination counting with variance calculation. Enter your bill and coin quantities to determine the actual cash total. Then compare against the expected amount to find the overage or shortage.

  1. Count all bills and coins in the cash drawer or deposit bag by denomination
  2. Enter quantities into the calculator to get the actual total
  3. Enter the expected amount from your POS system, sales report, or ledger
  4. Read the variance: positive = over, negative = short, zero = balanced
Reconciliation Denominations
Bills
$100$50$20$10$5$2$1
Coins
$150¢25¢10¢5¢1¢
Variance Analysis

Understanding Cash Over and Short

Cash over and short is an accounting term for the difference between the expected cash balance and the actual cash count. In bookkeeping, the Cash Over and Short account tracks these variances. Small variances are normal; large or consistent variances indicate a problem.

Common causes of cash shortages: giving too much change, not ringing up a sale, counting errors, theft, or denomination misidentification (e.g., counting a $10 as a $20). Common causes of cash overages: shortchanging a customer, double-ringing a sale, or finding a bill that was stuck between others.

The cash over and short calculator documents these variances at the denomination level, making it easier to trace the source of a discrepancy.

Over/Short Examples
1
Expected: $500, Actual: $500
Variance: $0.00 — perfect balance ✓
2
Expected: $500, Actual: $507
Variance: +$7.00 — cash is over by $7
3
Expected: $500, Actual: $493
Variance: −$7.00 — cash is short by $7
4
Expected: $500, Actual: $499.75
Variance: −$0.25 — short by one quarter
Applications

Cash Reconciliation Calculator Use Cases

Cash reconciliation is a daily control process in any business that handles physical cash. The reconciliation calculator supports these standard workflows.

End-of-Day Register Close

Hover for details

Compare the POS report's expected cash total against the actual drawer count. The calculator shows the variance and whether it falls within the acceptable range (usually ±$5).

Shift Handover Verification

Hover for details

Outgoing and incoming cashiers both verify the drawer count. The reconciliation calculator provides an agreed-upon total that both parties sign off on.

Daily Deposit Reconciliation

Hover for details

Compare the bank deposit amount against the expected deposit from sales records. Any discrepancy is documented on the reconciliation report.

Petty Cash Audits

Hover for details

Reconcile the petty cash fund: receipts + remaining cash should equal the fund total. The calculator counts the remaining cash; you add the receipt total for the full reconciliation.

Vault Balance Verification

Hover for details

Banks verify vault cash against the vault ledger daily. The reconciliation calculator provides the denomination-level count needed for regulatory compliance.

Cash Over/Short Tracking

Hover for details

Track daily variances over time to identify patterns. Consistent shortages at a specific register or shift may indicate a training issue or theft.

The cash reconciliation calculator provides the denomination count needed for the actual-vs-expected comparison. Export the count as a PDF for your reconciliation records.

Best Practices

Cash Reconciliation Best Practices

Effective cash reconciliation depends on consistent process, accurate counting, and timely documentation. These 5 practices reduce variances and speed up the reconciliation process:

  1. Reconcile at every shift change — don't wait until end of day to find a shortage that occurred at 10 AM
  2. Count the drawer in a secure area — accuracy decreases when counting under time pressure or in view of others
  3. Use the same counting order every time — consistency reduces skipped denominations and miscounts
  4. Document every variance with a brief explanation — 'short $1.25, likely incorrect change on a cash sale' creates an audit trail
  5. Set a variance threshold ($3–$5) below which no investigation is required — chasing a 10-cent variance wastes management time
Common Questions

FAQ

What is a cash reconciliation calculator?

A cash reconciliation calculator compares expected cash (from sales records) against actual cash counted, showing any over/short variance.

What is cash over and short?

Cash over and short refers to the difference between the expected cash balance and the actual cash count.

What is an acceptable cash variance?

Most businesses accept variances under $5 per shift. Repeated shortages in the same range suggest a systematic issue.

What causes cash shortages?

Common causes: giving incorrect change, missed transactions, theft, counterfeit bills, or coin counting errors.