Blog · Finance metrics and formulas · Finance and FP&A teams
Cash variance is the difference between counted and expected physical cash. Reconcile opening floats, cash receipts, refunds, and deposits by store and day, then investigate overages and shortages without letting them offset each other.
Cash variance is counted physical cash minus expected cash for the same register, store, and business day. Positive means an overage; negative means a shortage. The calculation starts with the opening float and follows the cash receipts, refunds, and removals that should explain the closing count.
A cash count needs a boundary. This example reconciles the money left in each store's register drawers at closing. It excludes card settlements, checks, sealed deposit bags, and money already transferred out of those drawers.
Expected closing cash = Opening float + Cash receipts − Cash refunds − Cash removed for deposit
Cash variance = Counted closing cash − Expected closing cash
If your business counts the safe and drawers together, transfers between them stay inside that boundary. Do not deduct an internal transfer when both locations remain in the count. Write the counting boundary on the reconciliation so everyone follows the same rule.
This is a cash over/short review. A cash flow forecast compares planned business inflows and outflows with actual results and answers a different question. Here, every expected dollar should have an operational record and every counted dollar should have a count sheet.
Start with register closing reports, opening-float records, cash refund records, deposit-removal records, and signed count sheets. Match them by store, register or shift, business date, and closing time. A store-and-day total is useful for reporting only after its contributing drawers reconcile.
Cash receipts should mean cash accepted from customers after change given, before the cash refunds shown separately. Exclude card sales even if the register's headline sales total includes them. If refunds are already netted into the receipt column, do not subtract them again.
Deposit removals mean cash physically taken out of the drawers before the closing count. A sealed bag can still be awaiting transport or bank credit. Record its identifier and amount so a later deposit reconciliation can follow it without forcing the register review to use the bank's posting date.
Keep the supporting records attached to the review. The IRS's recordkeeping guidance explains that purchases, sales, payroll, and other business transactions generate documents used to record the business's books. For this review, the useful evidence is the receipt, refund, removal record, and signed count behind each summary amount.
A US retailer closes its stores on September 30, 2026. Each starts with a $300 float. There are no other cash additions or authorized cash payouts in this example, and all figures are in whole dollars without rounding.
| Store | Opening float (USD) | Cash receipts (USD) | Cash refunds (USD) | Removed for deposit (USD) | Expected cash (USD) | Counted cash (USD) | Cash variance (USD) |
|---|---|---|---|---|---|---|---|
| North | 300 | 2,450 | 100 | 2,200 | 450 | 435 | -15 |
| Central | 300 | 1,800 | 50 | 1,600 | 450 | 462 | 12 |
| South | 300 | 2,100 | 150 | 1,900 | 350 | 350 | 0 |
| Total | 900 | 6,350 | 300 | 5,700 | 1,250 | 1,247 | -3 |
North's expected cash is 300 + 2,450 − 100 − 2,200 = $450. The count is $435, so 435 − 450 = negative $15: a shortage.
Central expects 300 + 1,800 − 50 − 1,600 = $450. Its $462 count produces a $12 overage. South expects 300 + 2,100 − 150 − 1,900 = $350 and counts exactly that amount.
Across the stores, expected cash is 900 + 6,350 − 300 − 5,700 = $1,250. Counted cash is $1,247, leaving a net shortage of $3. That net result must match the sum of store variances: -15 + 12 + 0 = -3.
Rearrange the formula to explain the cash available before the closing count. This gives finance a second presentation of the same reconciliation.
| Reconciliation step | Calculation | Amount (USD) |
|---|---|---|
| Cash available after refunds | 900 + 6,350 − 300 | 6,950 |
| Removed for deposit | Sum of store removals | 5,700 |
| Left in drawers, counted | Sum of store counts | 1,247 |
| Unexplained shortage | 6,950 − 5,700 − 1,247 | 3 |
| Accounted-for total | 5,700 + 1,247 + 3 | 6,950 |
The $3 shortage is shown as a positive reconciling amount here because it fills the missing-cash gap. The reported variance remains negative $3 under counted-minus-expected. Label both presentations rather than switching signs silently.
This drawer reconciliation does not prove that the $5,700 reached the bank. Check the deposit records separately, including bags still in transit and any differences in the bank's acknowledgment. IRS Publication 583 describes comparing recorded deposits and disbursements with bank statements and resolving differences so adjusted balances agree. That bank review complements the physical count; it does not replace it.
Keep the $15 shortage and $12 overage visible. Their absolute amounts total $27 of exceptions, even though the net company shortage is only $3. A net total alone would make the day's operational discrepancies look smaller than the items requiring review.
The supervisor first checks the count and verifies the opening float. Next, compare receipt totals with tender reports, refunds with approved cash-refund records, and each removal with its deposit-bag amount. Check whether an event belongs to a neighboring shift before searching for more complicated explanations.
Assign North and Central separate owners and evidence requests. Neither result proves a cause. A shortage could come from a counting error or an overstated expected balance; an overage could come from an omitted receipt or an understated float. Avoid labeling either one theft or a saving without evidence.
Finance should retain the original amount, any supported correction, and the unresolved balance. After review, a journal entry may record the remaining cash over/short under the company's accounting policy. The entry closes the accounting difference; the review explains why it happened and whether a control needs attention.
Use consistent signs with other variance analysis, while preserving this count-based definition. Broader retail cash flow management also considers payment settlements and upcoming outflows that do not belong in a register count.
Upload register, refund, deposit-removal, and count summaries, or bring a Google Sheet, and Covirage maps the columns. Its tools compute and check expected balances and cash variances; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See spreadsheet analysis with Covirage for the supporting workflow.
Possible causes include incorrect change, missing cash receipts, refunds recorded under the wrong payment method, deposit errors, and mismatched closing times. A variance identifies an unexplained difference. Recount and check the supporting records before deciding whether the difference is a recording problem or a physical loss.
No. Physical cash variance compares counted money with the amount expected from recorded register activity. A cash flow forecast variance compares actual company cash movements with a forecast. The two reviews use different records, timing rules, and owners, even when finance oversees both.
Show the net amount for reconciliation, but preserve individual overages and shortages for investigation. An overage in one register does not establish the cause of a shortage in another. Separate totals also reveal the scale of exceptions that a small net amount can hide.
The register operator supports the count, the store supervisor checks the activity and deposit records, and finance reconciles the summaries with accounting records. Assign unresolved items to an owner under the company's cash-handling policy, with evidence, a review date, and a documented resolution.