A premium daily reconciliation workbook that helps cash-heavy agent businesses track cash, float, platform balances, staff activity, missing references, and shortages before money disappears.
Stop guessing. Know what should be in the drawer, what should remain in the wallet/platform, and where the shortage happened.
Built for mobile money agents, POS agents, remittance points, money exchange desks, and agent banking businesses.
If your business handles mobile money, POS withdrawals, remittance payouts, money exchange, airtime, LEC/bill payments, or agent banking deposits, the biggest risk is not always one big theft.
It is the small daily gaps:
* A cash-out recorded without a reference number* A POS withdrawal not matched to the cash drawer* Mobile money float that does not agree with physical cash* Staff mixing Orange, MTN, Lonestar, Opay, M-Pesa, or POS cash together* Remittance payouts recorded without proper slip control* Money exchange transactions done without checking USD and local currency movement* Shortages discovered days later when nobody remembers what happened
This template helps you catch the problem the same day — before the shortage becomes normal.
Most shortages are not discovered because nobody checks the expected balance against the actual closing count. Use this calculator to compare what should be in the drawer or platform against what was actually counted.
Your Shortage Risk ResultBalanced: Your closing count matches the expected balance. Keep the receipt trail.Review Needed: There is a small gap, missing reference, or unclear transaction. Review before the next business day.High Risk: Cash, POS, mobile money, or remittance records do not match. Staff should not close without manager review.Critical Risk: Missing cash, unmatched transactions, or customer credit may be hiding a shortage. You need a daily control system immediately.
A mobile money reconciliation template is a daily control sheet used by agents and cash-handling businesses to compare opening cash, transaction records, platform or float balances, actual counted cash, POS activity, remittance payouts, and closing balances. It helps the owner or manager identify shortages, missing references, unbalanced float, and staff accountability issues before closing the business day.
This template is built for businesses that handle:
* Mobile money cash-in and cash-out* POS withdrawals and deposits* Agent banking transactions* RIA, MoneyGram, and Western Union records* Money exchange services* Airtime and bill payments* Daily cash drawer reconciliation
This workbook is designed for owners and managers who need a simple but serious way to control daily cash and float.
Use it if you run:
* Mobile money agency* POS agent business* Agent banking point* Ecobank Express Point or similar service desk* RIA, MoneyGram, or Western Union remittance point* Money exchange desk* Airtime and bill payment business* Small financial service counter with staff handling cash
Do not use it if:
You only need a simple sales tracker. This is a reconciliation and control system, not a basic income sheet.
At the end of the day, your staff should not just say, “Everything balanced.”
They should prove it.
This template helps you compare:
* Opening cash* Opening platform or float balance* Daily transactions* Cash-in and cash-out movement* POS activity* Remittance records* Money exchange movement* Actual counted cash* Actual closing float* Shortage or overage* Missing reference numbers* High-risk transactions* Manager sign-off
The workbook includes dedicated sections for the daily activities most agent businesses struggle to control.
Included tracking areas:
Opening Balances
Enter opening physical cash, platform balance, float, service bucket, currency, staff, and manager initials.Daily Transactions
Record mobile money cash-in, cash-out, POS withdrawals, Ecobank deposits, Ecobank withdrawals, airtime, LEC/bill payments, remittance activity, and corrections.Money Exchange Register
Track USD to local currency, local currency to USD, exchange rate used, fee collected, and cash movement in both currencies.Cash Count by Denomination
Count actual physical cash by bill size instead of guessing the drawer total.Daily Close
Compare expected cash and float against actual closing balances.High-Risk Register
Flag suspicious, missing, reversed, corrected, or unusual transactions for manager review.Staff Review
See which staff member has missing references, exceptions, or unbalanced activity.Printable Daily Close Report
Create a clean daily sign-off record for the owner, manager, and staff.
Most daily transaction sheets only record activity. That is not enough.
A serious control sheet should help answer:
* How much cash should be in the drawer?* How much float should remain in the platform?* Which staff handled the transaction?* Which transactions are missing references?* Which services caused the difference?* Was the shortage cash, float, POS, remittance, or exchange-related?* Did the manager sign off before the staff left?
This template does not accuse anyone. It gives the owner a clear daily trail so shortages cannot hide inside messy records.
The template is market-agnostic. You can customize the currency, services, staff names, denominations, and tax/levy settings.
Use it for:
* Liberia: LRD / USD, Orange Money, Lonestar, Ecobank Express Point* Ghana: GHS / USD, MTN Mobile Money, Telecel Cash, AirtelTigo, E-Levy tracking* Nigeria: NGN / USD, Opay, Moniepoint, POS agents, bank transfers* Kenya: KES / USD, M-Pesa, Airtel Money, agent services* Other cash-heavy markets with mobile money, POS, remittance, and float management
Buyers can edit service names, currency names, denominations, staff names, and platform names from the setup area.
You receive a clean, buyer-ready Excel workbook designed for daily use.
Included sheets:
* Start Here Guide* Global Setup* Opening Balances* Daily Transactions* Money Exchange Register* Cash Count* Daily Close* Dashboard* Staff Review* High-Risk Register* High-Risk Review* Receipt Log* Shortage Investigation* Printable Daily Close Report* SOP & Controls* Setup & Lists
The workbook is macro-free, protected, and designed so staff enter data only in designated input cells.
A normal transaction record tells you what staff wrote down.This system helps you check whether what they wrote down agrees with the money.
Comparison table:
| Title | Author |
|---|---|
| Records transactions only | Reconciles cash, float, and platform balances |
| Easy for staff to skip details | Flags missing references and incomplete rows |
| No daily sign-off control | Includes manager review and staff accountability |
| No denomination count | Counts actual cash by bill size |
| No shortage investigation | Includes shortage explanation and review section |
| Usually country-specific | Editable for different currencies and services |
Metus
Gravida
Use this workbook when:
* Staff says the day balanced but cash is short* POS withdrawals do not match the cash drawer* Mobile money float does not agree with cash movement* A remittance payout has no proper reference* Money exchange records are unclear* Staff mixes cash from different services* You need a clean report before closing the business day* You want daily accountability without waiting for month-end
The workbook includes controls that help the owner or manager review the day before signing off.
Control features:
* Dropdowns for cleaner staff entry* Protected formula cells* Editable service names* Editable currency settings* Editable denomination setup* Missing reference alerts* Missing currency alerts* Cash shortage/overage calculation* Float shortage/overage calculation* Money exchange movement tracking* High-risk transaction register* Staff review summary* Manager sign-off report
The goal is simple: make it harder for mistakes, missing records, and shortages to pass unnoticed.
If you have staff handling cash while you are not watching every transaction, you need a daily control system.This template gives your staff a clear way to record the day and gives you a clear way to review it.
It helps you see:
* What came in* What went out* What should remain* What was actually counted* Who handled the activity* What needs review before closing
You should not discover missing money after the staff has gone home.
If one daily cash shortage goes unnoticed, it can repeat again and again.
This workbook gives you a practical system to review cash, float, POS, remittance, and exchange activity every business day.
This is a spreadsheet-based control tool. It does not replace accounting software, bank statements, or professional audit advice.
Want this system customized for your own mobile money, POS, remittance, and cash drawer setup?I can configure it for your services, currencies, staff names, daily close process, and transaction types — including Orange Money, Lonestar Mobile Money, Ecobank Express Point, POS/PIS, RIA, MoneyGram, Western Union, LEC, Airtime, and money exchange.This is best for business owners who want the system ready for staff to use immediately.
* Your business name added* Your currencies added* Your services added* Your staff names added* Your cash count denominations adjusted* Your platform/float balances configured* Your daily close process reviewed* Your staff input areas cleaned for use
FAQ 1:
Can I use this for mobile money cash-in and cash-out?
Yes. The Daily Transactions sheet includes cash-in, cash-out, platform/float movement, staff entry, reference number, and daily close checks.
FAQ 2:
Can POS agents use this template?
Yes. POS withdrawals, deposits, card terminal activity, settlement differences, and cash drawer impact can be tracked inside the workbook.
FAQ 3:
Can I use it for MoneyGram, Western Union, and RIA?
Yes. The workbook includes remittance transaction tracking and reference control for MoneyGram, Western Union, RIA, and similar services.
FAQ 4:
Does it support money exchange services?
Yes. The Money Exchange Register tracks local currency, foreign currency, exchange rate, fees, and cash movement in both currencies.
FAQ 5:
Can I change the currency?
Yes. The Global Setup section lets you set your local currency and optional foreign currency.
FAQ 6:
Can I change service names like Orange, Lonestar, MTN, Opay, or M-Pesa?
Yes. Service names are editable so the template can fit different countries and agent businesses.
FAQ 7:
Will this prevent staff theft?
No spreadsheet can physically stop theft. But this system helps expose shortages, missing references, unbalanced cash, and suspicious activity before the day is closed.
FAQ 8:
Is this macro-free?
Yes. The buyer version is macro-free and does not require VBA.
FAQ 9:
Do I need advanced Excel skills?
No. The workbook uses guided sheets, dropdowns, protected formulas, and clear input areas.
Use this daily reconciliation system to track your cash drawer, mobile money float, POS activity, remittance transactions, money exchange service, and staff accountability in one clean workbook.
Built for mobile money agents, POS agents, remittance points, and agent banking businesses that need better daily control.
© Digital Echoes Academy