[Blog]()Retail # 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. **[Jonathan Perez]()**Co-founder · Design, product and sales October 8, 2026 · 8 min read **Short answer** To close a cash drawer, record opening cash, add cash receipts and other cash additions, subtract cash refunds and withdrawals, and compare the result with counted notes and coins. Keep cards and transfers separate from the drawer. At each shift close, retain its times, owners, supporting records and any unresolved discrepancy before handing cash 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. [Download CSV worksheet]() In this guide - [How to calculate expected cash at shift close]() - [Cash drawer example: receipts, payments and a discrepancy]() - [Cash close template for Excel or Google Sheets]() - [Daily close and cashier handoff: keep the records separate]() - [Retrying or correcting a close must not move cash twice]() - [What to bring before changing your cash system]() ## 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 **Fictional exercise in MXN** Drawer C-08, shift from 09:00 to 15:00. Opening cash 1,000; cash receipts 2,400; cash refund 200; extra change float 300; safe withdrawal 1,500 and authorized expense 100. Another 1,600 was collected by card. These figures illustrate the method; they are not client records or measured results. | 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. 1. Record drawer, currency, start, end and the people handing over and receiving cash. Count opening cash before the first receipt. 2. Record receipts and refunds by payment method. Add every cash addition or withdrawal with a reference and reason. 3. Multiply each denomination by its counted quantity and sum subtotals. Add rows for the coins or notes you actually use. 4. Calculate expected cash with the formula, then subtract expected from counted. Preserve the difference without inventing an adjustment. 5. 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. ## Review a shift whose cash does not reconcile With the close, supporting records and count, we can review what belongs to the drawer and how to retain a discrepancy when shifts change. A free diagnosis can help define the checks before choosing or changing your system. - An anonymized shift with opening cash, receipts, refunds and withdrawals - The denomination count and an unresolved discrepancy - Who hands over, receives and authorizes close corrections [Book a free consultation]()[Ask on WhatsApp]() Related - [Retail software]() ## Frequently asked questions ### Do card sales enter expected drawer cash? Not in this example's drawer balance. They are shown separately with references. Provider and bank reconciliation is a separate step. ### What if the cash close does not reconcile? 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. ### Can I close cash when shifts change? Yes, define the period and record cash handed over and received. The daily close can combine shifts while preserving their differences and owners. ### Does the CSV calculate the close automatically? 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. ### How do I correct a close after handoff? 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 1. [Shift management]()Loyverse 2. [Cash close configuration]()eleventa Last updated: October 8, 2026 ## Keep reading [GuidesOct 5, 2026 ### How much does an inventory system cost in Mexico? 2026 prices]()[GuidesOct 4, 2026 ### How much does an online store cost in Mexico? (2026)]()[AutomationOct 2, 2026 ### WhatsApp automation for business: costs and how to start]() --- Canonical: https://nightlysoftware.com/en/blog/cash-drawer-close-shift-differences Updated: 2026-10-08 Description: Close a cash drawer by shift using opening cash, receipts, withdrawals and denomination counts. Includes a reconciled example and editable CSV.