Know what should be there
Turn opening cash, collections and money movements into one expected closing position instead of relying on memory.
Free business template
Daily Cash
Reconciliation Template
Do not close the day until the money makes sense.
Compare expected cash with actual cash, reconcile M-Pesa and other payment channels, and catch daily shortages or overages while the transactions and handovers are still traceable.
Free to use. No sign up required.
Daily Cash Reconciliation
Trading day: 12 March 2026 · Till 1
| Reconciliation line | Expected | Actual | Status |
|---|---|---|---|
| Opening cash balance | 15,000 | 15,000 | Balanced |
| Cash collections | 48,300 | 48,300 | Balanced |
| M-Pesa & digital payments | 34,500 | 34,000 | Review |
| Cash movements | 3,500 | 3,700 | Review |
| Expected closing cash | 59,800 | ||
| Actual closing cash | 59,300 | ||
| Cash variance | -500 | Shortage |
Find what does not match
Compare the records with the money that is actually there. A clean sales report is not proof that every shilling arrived.
Catch leakage while it is traceable
A small shortage is easy to dismiss. Repeated shortages are how money quietly leaves a business.
Create real accountability
Keep a record of who handled the money, who counted it, who reconciled it and what happened when the numbers did not agree.
Everything you need to close the day with a clearer cash position.
Use one practical record for what should be there, what is actually there and what needs investigating before tomorrow starts.
Opening cash balance
Cash collections
M-Pesa and digital payments
Cash movements
Expected closing cash
Actual closing cash
Shortage and overage tracking
Variance notes and sign-off
Use it where you already work.
Google SheetsUse it online
Reconcile the day in your browser, keep the latest version available across devices and share the close with the person responsible for review.
The live Google Sheets link will appear here after delivery is approved.Microsoft ExcelWork offline
Download the Daily Cash Reconciliation Template, work offline and keep each day’s closing record inside your existing business files.
The Excel file will appear here after the download-delivery approach is approved.How to use your Daily Cash Reconciliation Template
A variance is not the end of reconciliation. It is the start of the investigation.
Start with what should be there
Record opening cash, money received and every movement that changed the amount your business should have at closing.
| Expected position | Amount / note |
|---|---|
| Opening cash | 15,000 |
| Cash collections | 48,300 |
| Cash movements | 3,500 |
| Expected closing cash | 59,800 |
Count what is actually there
Physically count closing cash and confirm M-Pesa and other digital collections against the payment account itself.
| Actual position | Amount / note |
|---|---|
| Cash counted | 25,300 |
| M-Pesa confirmed | 34,000 |
| Actual closing cash | 59,300 |
Investigate the difference
Check sales, refunds, expenses, change given, withdrawals, banking, reversals and staff handovers while the day is still fresh.
| Variance review | Amount / note |
|---|---|
| Expected closing cash | 59,800 |
| Actual closing cash | 59,300 |
| Cash variance | -500 |
Explain it before tomorrow starts
Record the cause, unresolved amount, person responsible and next action. Do not make a difference disappear by changing the numbers.
| Sign-off | Amount / note |
|---|---|
| Variance | -500 |
| Reason | Pending review |
| Reviewed by | A. Wanjiku |
Cash that cannot be explained is a control problem.
What is daily cash reconciliation?
Daily cash reconciliation compares the money your business expected to have with what was actually available at the end of a day or shift. It connects sales, collections, payment channels and cash movements so differences stay visible.
Did the money that should have arrived actually arrive?
Close tills properly instead of assuming recorded sales and physical cash automatically agree. Reconcile M-Pesa, COD, pickup collections and other payment channels without mixing them into one number. Create a clear handover trail for the people collecting, counting, reconciling and reviewing money.
Frequently asked questions
Is this Daily Cash Reconciliation Template free?
Yes. The Daily Cash Reconciliation Template is free to use. You can open the Google Sheets version online or download the Excel version and keep your own copy once those file links are connected.
What does daily cash reconciliation mean?
Daily cash reconciliation compares the money your business expected to have at the end of a day or shift with the money actually available. If the two amounts do not match, the difference should be investigated and explained before the day is considered closed.
Is counting cash the same as reconciling cash?
Counting tells you how much physical money is there. Reconciliation tells you whether that amount is correct. You can count 48,300 perfectly and still have a problem if your records say 49,000 should be there.
How do I calculate expected closing cash?
A simple expected closing cash formula is: Opening Cash + Cash Received - Cash Paid Out - Cash Removed = Expected Closing Cash. Then compare Actual Closing Cash - Expected Closing Cash = Cash Variance. A zero variance means the cash balances. A negative number is a shortage and a positive number is an overage.
Should I include M-Pesa in the cash reconciliation?
Yes, but keep M-Pesa separate from physical cash. Compare the payments recorded by the business against the transactions actually confirmed in the relevant Till, PayBill, Pochi or other account. A screenshot, an STK prompt or a customer saying they paid is not the same thing as a confirmed payment.
What causes cash shortages?
Common causes include incorrect change, missing cash, unrecorded expenses, unauthorized withdrawals, refund errors, counting mistakes, missing transactions and poor staff handovers. The point of reconciliation is to identify the cause rather than automatically writing the shortage off.
Can there be an overage?
Yes. More cash than expected may mean an unrecorded sale, too little change given, a duplicate entry or another transaction error. An overage still means the records and the money disagree, so it should be investigated.
How often should I reconcile?
For a business receiving payments every day, reconcile at the end of every trading day or shift. A missing 500 may take minutes to trace tonight and become almost impossible to reconstruct several weeks later.
Should every cashier have a separate reconciliation?
Where possible, yes. If different people use separate tills, shifts or cash drawers, reconciling them separately makes it much easier to identify where a difference started and creates stronger accountability.
What should I do if the money does not balance?
Do not change the numbers until they match. Check the sales, payments, refunds, cash expenses, withdrawals, banking, payment reversals and staff handovers. Record the difference and the explanation you found. If part of the variance remains unresolved, keep it visible instead of making it disappear.