Skip to article
POS Software Guide

Free POS Daily Closing Sheet Template for Retail Stores in Pakistan

A free, copyable POS daily closing template for Pakistani retailers to reconcile cash, cards, digital payments, returns, expenses and cashier differences.

August 1, 2026Updated November 14, 20266 min readPakistan-focused
Free POS Daily Closing Sheet Template for Retail Stores in Pakistan
POS
Practical business guidanceClear steps, implementation considerations and links to relevant NexZion Solutions resources.
Free to use

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____________________________ShiftOpening / Closing / Custom
Shift start____________________________Shift end____________________________
POS user ID____________________________Closing reference____________________________

Section B — POS sales summary

DescriptionAmount (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.

Compare each payment record separately; do not add the cash drawer balance, non-cash payments and customer credit into one total.
Payment recordExpected / 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.

Expected cash and the independent physical count for one drawer and shift.
Cash calculationAmount (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

Multiply each note denomination by its count. Count coins separately and enter their total amount.
DenominationQuantityTotal (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 amountNot applicable______
Total physical cash______

Section F — Returns, cancellations and discounts

InvoiceTypeAmountReasonApproved by
________Return / Cancel / Discount______________________________
________Return / Cancel / Discount______________________________
________Return / Cancel / Discount______________________________

Section G — Counter expenses

ExpenseAmountReceipt/referenceApproved by
______________________________________________
______________________________________________
______________________________________________

Section H — Difference explanation and sign-off

Difference amountPKR ____________
Cashier explanation____________________________________________________________
____________________________________________________________
Action requiredNone / 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

  1. Stop new transactions for the cashier or shift.
  2. Generate the POS closing and payment-method reports.
  3. Count physical cash by denomination.
  4. Match card, bank and digital-payment totals with external records.
  5. Review returns, cancellations, discounts and counter expenses.
  6. Calculate the shortage or excess.
  7. Record an explanation and manager action.
  8. Sign and retain the closing sheet with supporting evidence.
  9. 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.

CounterCashierNet salesExpected cashCounted cashDifference
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.

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.

Implementation note: Hardware, integrations, offline continuity and tax-connected workflows should be confirmed against the actual business setup before implementation.
NZ
Published by NexZion Solutions

NexZion Solutions publishes practical guides based on business-software, compliance-workflow, website and automation implementation experience in Pakistan.

Ready to apply this guidance to your business?

Share your current workflow, challenge or project requirement. NexZion Solutions will help you identify a practical next step, scope and implementation path.

Book Free Demo
WhatsApp DemoCall Now