Day-end closing sheet with cash, UPI, card, and variance.
The close a shop actually has to do: opening float, expected cash, counted cash, the variance, and a payment-mode split so UPI and card settlements are not mistaken for missing money. Plus discounts, refunds, overrides, and two signatures. Copy it as CSV and use it tonight.
The template, filled with an example
The example is one shift at a fictional retail counter, with a ₹50.00 cash short left in deliberately. A sheet that only ever shows a perfect close is a sheet nobody trusts.
Illustrative example only. The counter, cashier, manager, terminal, and every amount are invented for this page. Discount approval limits and settlement timings are properties of your own business and your own payment provider — this sheet records them, it does not set them.
Shift header
- Date
- 04-10-2026
- Location
- Sample Retail Counter — Bengaluru (example)
- Shift
- 09:00 to 18:00
- Counter / terminal
- Counter 1, terminal T-04 (example)
- Cashier
- Sample Cashier (example)
- Closing reviewed by
- Sample Shift Manager (example)
- Opening cash float
- 2,000.00
- Closed at
- 18:25
Payment-mode reconciliation
| Payment mode | System total (INR) | Counted or settled (INR) | Variance (INR) | Note |
|---|---|---|---|---|
| Cash (sales only) | 18,450.00 | 18,450.00 | 0.00 | Matches the counter total |
| UPI | 64,200.00 | 64,200.00 | 0.00 | Matches the provider counter for the day |
| Card | 31,300.00 | 31,300.00 | 0.00 | Settlement expected next business day |
| Bank transfer (NEFT / RTGS) | 0.00 | 0.00 | 0.00 | Not used during this shift |
| Total collections | 1,13,950.00 | 1,13,900.00 | (50.00) | Variance is the cash difference below |
The single total across all four modes is the number most counters get wrong. A UPI settlement that has not landed yet is not a shortage; writing it as one is how a good day is made to look like a bad one.
Cash reconciliation
| Line | Amount (INR) | Basis |
|---|---|---|
| Opening float issued | 2,000.00 | Recorded at shift start, counted with the cashier |
| Cash sales during the shift | 18,450.00 | From the counter, cash drawer only |
| Expected cash in drawer | 20,450.00 | Opening float plus cash sales |
| Counted cash in drawer | 20,400.00 | Counted once, then counted a second time |
| Cash variance | (50.00) | Short. Cause not identified; logged for manager review |
Expected in the drawer is 20,450.00 — the 2,000.00 float plus 18,450.00 of cash sales. Counted was 20,400.00, so the variance is a ₹50.00 short. Total collections across all modes were 1,13,950.00 against 1,13,900.00 counted.
Exceptions to review
- Discounts recorded
- 1,250.00
- Refunds issued
- 0.00
- Manual or overridden entries
- 1
- Stock issues raised at close
- 0
Close and sign
- Cashier
- Name / signature / time
- Shift manager
- Name / signature / time
- Variance reviewed
- Yes / No — and by whom
- Banked or carried over
- Banked at / carried to the next float
Day-end closing sheet (CSV — illustrative example data) Field,Value Date,04-10-2026 Location,Sample Retail Counter — Bengaluru (example) Shift,09:00 to 18:00 Counter / terminal,"Counter 1, terminal T-04 (example)" Cashier,Sample Cashier (example) Closing reviewed by,Sample Shift Manager (example) Opening cash float,"2,000.00" Closed at,18:25 Payment mode,System total (INR),Counted or settled (INR),Variance (INR),Note Cash (sales only),18450.00,18450.00,0.00,Matches the counter total UPI,64200.00,64200.00,0.00,Matches the provider counter for the day Card,31300.00,31300.00,0.00,Settlement expected next business day Bank transfer (NEFT / RTGS),0.00,0.00,0.00,Not used during this shift Total collections,113950.00,113900.00,(50.00),Variance is the cash difference below Cash reconciliation,Amount (INR),Basis Opening float issued,2000.00,"Recorded at shift start, counted with the cashier" Cash sales during the shift,18450.00,"From the counter, cash drawer only" Expected cash in drawer,20450.00,Opening float plus cash sales Counted cash in drawer,20400.00,"Counted once, then counted a second time" Cash variance,(50.00),Short. Cause not identified; logged for manager review Exception,Value,Note Discounts recorded,"1,250.00","Two discounts. Whether they needed approval depends on your own limit, which this sheet does not set." Refunds issued,0.00,"No refunds in this shift. A refund changes the mode total for that mode, not just the day total." Manual or overridden entries,1,One card entry keyed by hand. Reason recorded at the counter. Stock issues raised at close,0,Raise them before closing if the shift consumed stock — see the inventory count template. Approval,Value Cashier,Name / signature / time Shift manager,Name / signature / time Variance reviewed,Yes / No — and by whom Banked or carried over,Banked at / carried to the next float
The sheet is deliberately short. A closing routine that takes longer than counting the cash is a routine that gets skipped, so the value is in doing the same four things in the same order every day and writing down anything that does not match.
How to fill it in
Four steps, in the order that keeps the count honest.
Open the sheet at the start of the shift
Record the opening float while the cashier is present, and have it counted by two people. A float recorded at the end is a reconstruction.
Take the system figures before touching the cash
Read the counter totals for cash, UPI, card, and bank first, then count. Counting first and comparing afterwards invites the number to fit whatever was found.
Reconcile each mode separately
Cash against the drawer, UPI against the counter total and the provider figure, card against the counter total, and mark anything that is still in transit rather than forcing it to match.
Write down the exceptions and get it signed
Discounts, refunds, manual entries, stock issues, and any variance with the action you took. Two signatures — the cashier and the person who reviewed it — is what turns a private habit into a routine that survives staff changes.
When to use this, and when to stop
A printed close sheet is a perfectly good answer for a long time. The sign that it has run out is when producing the figures takes longer than checking them.
When this template is the right tool
- You close a counter every day and the close is currently done from memory at the end of a long shift.
- You want the same close routine whoever is on the till, so a new cashier is not left guessing.
- You take cash, UPI, and card and cannot yet say reliably which mode is short on a bad day.
- You are still learning where your cash differences actually come from, and a written record is how you find out.
When you have outgrown it
- The close takes longer than the counting, because the totals are being re-derived by hand from receipts.
- Payment-mode totals are visible only inside the billing system, with no independent count to compare them against.
- A variance is discovered days later, when the bank or the cash box does not agree, and nobody can reconstruct the day.
- Discount approvals and overrides are not visible at close, so exceptions are found during an audit rather than at the counter.
The same process in NoxOrigin
The point of a closing sheet is that expected cash is already known, so closing is a comparison rather than a reconstruction. In NoxOrigin the expected figures are produced from the transactions of the shift — payment mix, discounts, refunds, overrides — and the cashier records what was actually counted against them. Employee access, discount approvals, and shift close are role-based, so the routine is the same whoever was on the counter, and exceptions stay visible to the person who reviews rather than being summarised away in a total.
- Day-end business reportingShifts, payment mix, expected cash, counted cash, variance, and exceptions produced from the transactions themselves.
- Day-end reconciliation calculatorThe arithmetic on its own, if all you need this evening is expected cash against counted cash.
- Commerce in NoxOriginCatalog, stock, purchasing, point-of-sale billing, and day-end reconciliation for businesses that sell stock.
- A practical day-end routineShift close, expected cash, counted cash, variance, approvals, and review — written as roles rather than as tasks.
- UPI reconciliation at day-endCounter total, provider settlement, refunds and timing gaps, and where to record the difference.
- Inventory count sheetThe stock half of the close, for a day that consumed stock and needs a count raised.
Day-end closing sheet questions
Why separate cash from UPI and card when counting?
Because only cash is physically in the drawer. UPI and card are checked against the counter and against the provider's figure for the day, which arrive by a different route and on a different timetable. Treating all three as one number means a UPI settlement delay looks exactly like missing money.
What should I do about a small cash variance?
Count again, record it, and write down what you did — the example shows a ₹50.00 short with a second count performed and no identified cause. Some businesses set a tolerance below which nothing is recorded; that is your policy, not something this sheet should decide. The habit worth keeping is that a variance is written down at the moment it happens rather than reconstructed a month later.
When do I close the day for UPI?
The UPI figure on this sheet is the counter total for the day, which should match the provider's figure. Actual settlement timing — whether money lands the same evening or the next business day — is a separate check, and it is the reason a day-end sheet has both a counter figure and a settled figure. Confirm the timing your own provider follows rather than assuming one.
Does the opening float belong in the day's takings?
No. The example keeps it on its own line: cash in the drawer is the float plus cash sales, while total collections exclude the float. Mixing them is how a drawer that is exactly right looks like a business that earned ₹2,000 it did not earn.
Close the day by comparing, not by remembering.
If expected cash currently has to be worked out by hand at the end of a long shift, that is a few minutes a day you are spending re-typing numbers you already have.