BlogRetail
How to close a cash drawer by shift and review differences
Compare drawer cash with cash movements, rather than all sales. Preserve the count, discrepancy and handoff to the next shift.
Editable cash close and denomination template
Compare cash movements, count notes and document a discrepancy and handoff. Fictional example; your shift fields remain blank.
How to calculate expected cash at shift close
The comparison is: opening cash + cash receipts + other cash additions − cash refunds − withdrawals and expenses = expected cash. The difference is counted cash minus expected cash. Use the same drawer, currency and period on both sides. A card sale can be paid without adding notes to the drawer; including it in this balance would create an apparent drawer shortage.
Loyverse documents opening cash, pay-ins, pay-outs, sales, refunds and expected-versus-actual cash comparison by shift. eleventa lets users configure actual-amount entry and view differences by shift and day. These are published features of those products; the rehearsal must establish how your system records each movement.
Cash drawer example: receipts, payments and a discrepancy
| Item | MXN | Effect on the drawer |
|---|---|---|
| Opening cash | 1,000 | +1,000 |
| Cash receipts | 2,400 | +2,400 |
| Cash refund | 200 | −200 |
| Added change float | 300 | +300 |
| Withdrawal to safe custody | 1,500 | −1,500 |
| Expense paid from drawer | 100 | −100 |
| Card receipts | 1,600 | 0; reconcile separately |
| Expected cash | 1,900 | 1,000 + 2,400 − 200 + 300 − 1,500 − 100 |
If you count 1,900, the drawer difference is zero. That does not establish that card payments reached the bank or that every order was delivered. Use order and payment reconciliation for those checks. Opening cash is not a sale either: it was already in the drawer when the shift began.
Denomination count: a case with 1,870
| Denomination MXN | Counted quantity | Subtotal MXN |
|---|---|---|
| 200 | 5 | 1,000 |
| 100 | 5 | 500 |
| 50 | 5 | 250 |
| 20 | 6 | 120 |
| Total | 21 notes | 1,870 |
In this variant, 1,870 − 1,900 = −30 MXN requiring explanation. Recount and preserve both counts if they differ. Review supporting records, change given, refunds and withdrawals within the interval. Do not change opening cash to 970 to force a match. A discrepancy shows that cash and records disagree; it does not establish the cause or who caused it.
Cash close template for Excel or Google Sheets
Download the editable cash-movement and denomination template. It includes example columns and blank fields for your shift: amounts, note or coin quantities, evidence and owner. Import the CSV into your spreadsheet, retain a template copy and replace only the working fields. The file does not execute formulas or contain measured data.
You can compare your amounts in the cash close calculator. Use movements from the same drawer and period, and review the count separately; a numeric result does not resolve an open supporting record.
- Record drawer, currency, start, end and the people handing over and receiving cash. Count opening cash before the first receipt.
- Record receipts and refunds by payment method. Add every cash addition or withdrawal with a reference and reason.
- Multiply each denomination by its counted quantity and sum subtotals. Add rows for the coins or notes you actually use.
- Calculate expected cash with the formula, then subtract expected from counted. Preserve the difference without inventing an adjustment.
- Document handoff to the next shift and who reviews open items. The same notes must not be recorded as a new sale.
Daily close and cashier handoff: keep the records separate
A daily report may combine several shifts while retaining each opening, close and handoff. When people share the physical drawer, a user account identifies who recorded an operation. Define who may move money and how handoff is recorded; do not automatically attribute physical custody to the account on a receipt.
| Situation | Record | What remains unresolved |
|---|---|---|
| Counted matches expected | Close and handoff with the verified amount | Other payment reconciliation where applicable |
| Counted 1,870; expected 1,900 | Difference −30 and actual handoff of 1,870 | Review of the previous shift |
| Withdrawal lacks sufficient support | Amount, reason and assigned reviewer | Accept or correct the record |
| Close response was lost | Query reference C-08 before retrying | Confirm that only one close exists |
If the next shift receives 1,870, that is its counted opening cash; the previous difference retains its own review. Do not open the next shift with 1,900 while thirty pesos are physically missing. Do not transfer the unresolved discrepancy to the new cashier by erasing the previous close. Company policy determines who reviews and authorizes corrections.
Retrying or correcting a close must not move cash twice
Test closing C-08 and losing confirmation. A retry should return the existing close without another withdrawal or handoff. Authorized reopening needs a reason, person and version; preserve the original count and balance. If the next shift has started, the correction must not silently rewrite its opening cash or sales.
Suppose a valid receipt is later found for an expense of 30 paid during C-08 but not yet recorded. After authorized review, corrected expected cash is 1,900 − 30 = 1,870 and the discrepancy becomes zero. Retain the original −30 and the receipt link; physical cash did not increase. Entering that receipt again should find the existing correction rather than subtract another 30.
What to bring before changing your cash system
Bring an anonymized shift with opening cash, receipts by method, refunds, withdrawals and count, plus a case that currently fails to reconcile. Include times, authorized people and what happens when connectivity is lost during close. Check reference lookup, correction permission and history; printing a receipt does not establish that these cases pass.
For money returned after a purchase, read retail returns and exchanges; for correction history, read the change audit log. A free consultation about retail software can help define opening cash, close and handoff using your records.
Related
Frequently asked questions
Not in this example's drawer balance. They are shown separately with references. Provider and bank reconciliation is a separate step.
Retain counted cash, expected cash and difference; recount and review movements from the same period. Assign the review without changing opening cash or adding an unexplained adjustment.
Yes, define the period and record cash handed over and received. The daily close can combine shifts while preserving their differences and owners.
No. It is an editable comparison with fictional figures, blank fields and calculation rules. You can add spreadsheet formulas and verify them using the example before using them.
Use an authorized correction linked to the original close and supporting receipt. Preserve both versions and verify that it does not change handed-over cash again or the next shift's opening balance.
Sources
- Shift managementLoyverse
- Cash close configurationeleventa
Last updated: