How to Reconcile Mobile Money Payments and MoMo Fees at Your Hotel
A practical routine for matching MoMo, Telecel Cash and AirtelTigo payments to bookings, catching missing money, and recording gateway fees correctly.
Innkeeper Team · · 4 min read
Mobile money is how most guests in Ghana want to pay, and it is far safer than a drawer full of cash. But it creates its own gap: the payment your front desk recorded, the payment the guest actually sent and the amount that landed in your account after fees are three different numbers. Reconciling them every week is what keeps that gap from swallowing money.
Why mobile money goes missing
- Personal-number payments. Guests send money to a staff member's personal MoMo number "because the merchant line wasn't working". It may never reach you.
- Screenshot fraud. A guest shows a convincing "payment successful" screenshot that was never sent, or was reversed.
- Short payments. The guest sends GHS 400 against a GHS 450 bill and the difference is waved through.
- Fees nobody records. The gateway keeps a percentage. If revenue is recorded gross and fees are never booked as a cost, your profit is overstated every month.
Step 1: take payments through a gateway, not a phone
Use a merchant collection through a payment gateway so that the payment request comes from your system, the guest approves it on their phone, and the confirmation comes back to your system automatically. No screenshots, no personal numbers.
Check that your system compares the amount received with the amount requested before marking a bill paid. A partial payment should stay partial.
Step 2: record the reference on every manual payment
Some payments will still arrive outside the system, for example a corporate client paying a merchant number directly. Record each one against the right folio with the MoMo transaction ID. That reference is what you'll match on later.
Step 3: export the gateway statement weekly
Every gateway lets you download a statement of settled transactions. Pick a fixed day each week and download the statement for the previous week.
Step 4: match line by line
For each line in the statement, find the payment in your system with the same reference, amount and date. You'll end up with three lists:
| Result | What it means | What to do |
|---|---|---|
| Matched | Statement and system agree | Nothing |
| In the statement, not in the system | Money arrived but wasn't recorded against a guest | Find the booking and record it |
| In the system, not in the statement | Staff recorded a payment the gateway never received | Investigate straight away |
The third list is where leakage hides. Follow up every line.
Step 5: book the fees as an expense
The statement shows each payment's gross amount and the fee the gateway kept. Say the week brought in GHS 38,400 and the fees came to GHS 590. Record the GHS 590 as a payment processing fees expense.
Your revenue stays at the full amount the guest paid, and the fee appears as a cost. That's the correct accounting treatment, and it means your profit and loss reflects what you actually received.
Step 6: refunds through the same channel
When a guest is owed money back, refund through the gateway to the number they paid from, with a manager's approval. Cash refunds of mobile money payments are a classic way for money to disappear.
How long should this take?
Done by hand in a spreadsheet, a busy week can take an hour or two. The routine matters more than the tool: the same day each week, every unmatched line followed up.
Automating it
Innkeeper's mobile money payments take MTN MoMo, Telecel Cash and AirtelTigo Money through the gateway and check the amount received before a payment counts. Upload the gateway statement and Innkeeper matches each line to a payment, lists what doesn't match, and posts the fees as an expense automatically. Your profit and loss stays right without anyone re-typing numbers.