Download the POS daily closing worksheet
You may copy and adapt this template for your own business. Keep one completed sheet for every cashier shift or business day, attach supporting receipts where needed and review differences before the shift is locked.
Use one workbook per cashier and shift. Record cash movements, count the drawer independently and reconcile non-cash payments against the same period and transaction records.
The Excel workbook calculates expected cash, the physical count and differences from your entries. Use the PDF for a handwritten record. Leave an unknown amount blank and enter 0 when you have confirmed there was no amount; review incomplete entries before sign-off.
Why a daily closing sheet matters
A sales total alone does not prove that the counter is correct. The business must also account for opening cash, returns, refunds, discounts, counter expenses, card settlements, bank transfers, customer credit and any shortage or excess.
A consistent closing routine makes unusual differences visible while the shift is still fresh in the cashier’s memory. It also protects responsible employees because each adjustment has a clear reason and supporting record.
POS daily closing template
Section A — Business and shift details
| Business name | ____________________________ | Branch | ____________________________ |
|---|---|---|---|
| Date | ____________________________ | Counter | ____________________________ |
| Cashier name | ____________________________ | Shift | Opening / Closing / Custom |
| Shift start | ____________________________ | Shift end | ____________________________ |
| POS user ID | ____________________________ | Closing reference | ____________________________ |
Section B — POS sales summary
| Description | Amount (PKR) | Reference or note |
|---|---|---|
| Gross sales | ____________ | POS report |
| Sales discounts | ____________ | Approved discounts |
| Sales returns | ____________ | Return report |
| Refunds issued | ____________ | Cash/card refund |
| Net sales | ____________ | Gross − discounts − returns |
| Credit sales | ____________ | Customer balance |
| Advance received | ____________ | Not included in sale, if applicable |
| Customer recovery | ____________ | Old balance collected |
Section C — Payment method reconciliation
Use the same cashier, shift, transaction set and refund basis for each comparison. For cash, carry the expected drawer amount from Section D and the independently counted cash from Section E.
| Payment record | Expected / POS amount (PKR) | Independent record (PKR) | Difference (PKR) |
|---|---|---|---|
| Cash drawer | ____________ Expected cash from Section D | ____________ Counted cash from Section E | ____________ |
| Debit/credit card | ____________ | ____________ Terminal transaction record | ____________ |
| Bank transfer | ____________ | ____________ Matched transfer records | ____________ |
| Mobile wallet/digital payment | ____________ | ____________ Wallet transaction record | ____________ |
| Other non-cash method: ____________ | ____________ | ____________ Supporting transaction record | ____________ |
Difference = independent record − expected / POS amount. For the cash drawer, a positive difference is an excess and a negative difference is a shortage. For non-cash methods, the sign shows which record is higher; investigate the transaction records before deciding the cause.
For non-cash methods, compare receipts minus refunds for the same transaction set. Enter receipts before refunds and the refunds separately in the workbook. Record fees and pending or earlier settlements in a reconciliation note; a net bank payout is not the same figure as gross payment receipts.
In Excel, choose Reconcile for a payment method you used, Not used for one you have confirmed was unused, or To confirm while its scope is uncertain. A reconciled method needs the POS and provider gross receipts and refunds, a Confirmed comparison basis and a record reference. Enter 0 for a confirmed zero amount; missing entries remain unresolved.
Customer credit: check unpaid credit sales against the customer ledger separately. Record a payment collected from an old customer balance under its actual payment method; it is not a new sale or an additional credit-sale total.
Section D — Cash calculation
Include only money that entered or left this drawer during the shift. Gross cash sales receipts means cash retained from current sales after change and any sale discount, before cash refunds. Record customer recoveries, advances and other cash receipts separately.
Subtract each cash refund once. If your report deducts refunds from receipts, reconstruct the gross receipt amount from its transaction details before using this calculation. Enter deductions as positive amounts in the worksheet; the calculation subtracts them.
In Excel, check the receipt basis and choose Confirmed gross. Enter all eight cash amounts, including 0 when you have confirmed no activity. Expected cash remains blank while the required amounts or basis confirmation are missing.
| Cash calculation | Amount (PKR) |
|---|---|
| Opening cash | ____________ |
| Gross cash sales receipts (before cash refunds) | ____________ |
| Cash customer recovery | ____________ |
| Cash advances received | ____________ |
| Other cash received | ____________ |
| Less: cash refunds | ____________ |
| Less: approved counter expenses paid in cash | ____________ |
| Less: cash deposited or transferred out during shift | ____________ |
| Expected closing cash | ____________ |
| Physical cash counted (Section E) | ____________ |
| Cash difference: counted − expected | ____________ |
Section E — Cash denomination count
| Denomination | Quantity | Total (PKR) |
|---|---|---|
| PKR 5,000 notes | ______ | ______ |
| PKR 1,000 notes | ______ | ______ |
| PKR 500 notes | ______ | ______ |
| PKR 100 notes | ______ | ______ |
| PKR 50 notes | ______ | ______ |
| PKR 20 notes | ______ | ______ |
| PKR 10 notes | ______ | ______ |
| Coins — independently counted amount | Not applicable | ______ |
| Total physical cash | ______ | |
Section F — Returns, cancellations and discounts
| Invoice | Type | Amount | Reason | Approved by |
|---|---|---|---|---|
| ________ | Return / Cancel / Discount | ______ | ________________ | ________ |
| ________ | Return / Cancel / Discount | ______ | ________________ | ________ |
| ________ | Return / Cancel / Discount | ______ | ________________ | ________ |
Section G — Counter expenses
| Expense | Amount | Receipt/reference | Approved by |
|---|---|---|---|
| ________________ | ______ | ________________ | ________ |
| ________________ | ______ | ________________ | ________ |
| ________________ | ______ | ________________ | ________ |
Section H — Difference explanation and sign-off
| Difference amount | PKR ____________ |
|---|---|
| Cashier explanation | ____________________________________________________________ ____________________________________________________________ |
| Action required | None / Recount / Correct payment type / Manager review / Investigation |
| Cashier signature | ________________ |
| Supervisor signature | ________________ |
| Accounts review | ________________ |
Simple closing formula
Expected closing cash = Opening cash + gross cash receipts − cash refunds − approved cash expenses − cash removed from the drawer.
Cash difference = physical cash counted − expected closing cash. Positive means excess; negative means shortage. A zero difference means the two amounts agree, while supporting records and sign-off still need review.
Physical cash should be counted independently and compared with the expected amount. A difference should never be hidden by changing sales or opening balances without an authorized correction.
How to use the template each day
- Stop new transactions for the cashier or shift.
- Generate the POS closing and payment-method reports.
- Count physical cash by denomination.
- Match card, bank and digital-payment totals with external records.
- Review returns, cancellations, discounts and counter expenses.
- Calculate the shortage or excess.
- Record an explanation and manager action.
- Sign and retain the closing sheet with supporting evidence.
- Lock the shift after review so old transactions cannot be changed casually.
Multi-counter closing summary
Businesses with several counters should complete one sheet for each cashier and then prepare a consolidated branch summary.
| Counter | Cashier | Net sales | Expected cash | Counted cash | Difference |
|---|---|---|---|---|---|
| 1 | ________ | ______ | ______ | ______ | ______ |
| 2 | ________ | ______ | ______ | ______ | ______ |
| 3 | ________ | ______ | ______ | ______ | ______ |
| Branch total | ______ | ______ | ______ | ______ | |
Common causes of closing differences
- A card sale recorded as cash
- Incorrect change returned to a customer
- A refund processed without reducing cash
- A counter expense paid but not entered
- An opening float entered incorrectly
- Cash removed for deposit without a record
- Several employees sharing one POS login
- A cancelled invoice not approved correctly
- Customer recovery recorded as a new sale
Controls that make the template more effective
- Give every cashier an individual login.
- Limit returns, cancellations and price changes by permission.
- Require reasons for discounts and stock adjustments.
- Reconcile every payment method separately.
- Do not let the same person count, approve and investigate a large difference.
- Review repeated shortages by cashier, counter, time and transaction type.
- Keep closing records according to the business’s accounting and legal requirements.
Related POS resources
- POS cashier closing and reconciliation guide
- How to prepare your team before installing POS software
- POS security, users and backup controls
- Request a POS software demo
Need this process inside your software?
NexZion Solutions can configure cashier shifts, payment methods, daily closing, user permissions and management reporting for retail stores, marts, pharmacies, restaurants and service businesses. Discuss your current closing process with our team.
NexZion Solutions publishes practical guides based on business-software, compliance-workflow, website and automation implementation experience in Pakistan.

