1. Introduction
If you run a WiFi hotspot, work behind a shop counter, or resell vouchers for someone else, you probably take two kinds of payment in the same day. One customer hands you cash and walks away with a printed slip. The next sends money from a phone and waits for you to activate a plan. Both are sales, and both need the same answer at the end of the day: was it paid, and was it recorded?
This guide shows you how to reconcile WiFi voucher sales and mobile money payments with a simple routine. You do not need accounting training. You need a few clear records, one fixed time to close each day, and the habit of checking your work while errors are still easy to fix.
Here is what we will cover. First, the two sales channels and why you track them together. Then the small set of details to write down for every sale. After that comes the daily matching routine: linking activations to payment references, comparing your sales ledger to the mobile money statement, and counting cash and stock so the cash balances. We will also cover fees and settlement statements, how to find and fix variances, a light weekly rhythm, simple controls for small shops, and answers to common questions. If you want to confirm every WiFi voucher sale is paid and recorded, this is the routine to follow.
2. Two Sales Channels to Track
Most small hotspots sell through two channels. Printed vouchers are sold for cash from physical stock, while mobile money payments arrive on a phone and are confirmed by a message and a reference. Each channel leaves a different trail, so each one hides a different kind of mistake. A printed slip can leave the shop without being written down. A phone payment can arrive without a voucher ever being activated.
That is why wifi voucher sales tracking works best when both channels sit in one place. If you track cash on one page and phone payments on another, or in your head, something will slip between them. The goal is one combined picture of the day.
2.1. Printed Voucher Sales
A printed voucher sale is a cash sale from physical stock. The customer pays, you hand over the slip, and the voucher code on it becomes theirs to use.
Every slip sold must be logged. Write the voucher code in your printed wifi voucher sales records at the moment of sale, not later from memory. Remaining stock matters just as much. At close, the slips still in your hands plus the slips you logged as sold should equal the stock you started with. If the numbers do not agree, a slip was sold without a record, given away, or lost, and you want to know that today.
2.2. Mobile Money Sales
A mobile money sale is a phone-based payment. The customer sends money, and you receive a payment confirmation message that carries a transaction reference. That reference is the proof of payment.
Each payment must be linked to a voucher activation. When you activate a plan for a customer, note the reference next to the voucher code. Without that link, you cannot show later that a specific plan was paid for, and you cannot tell whether a payment on your statement ever turned into a working voucher.
2.3. One Daily Total Across Both Channels
To build one daily total, add the value of printed voucher sales for the day to the value of mobile money sales for the day. Use the sales ledger as the single source for both. Every line in the ledger is one sale, whichever channel it came through.
A single total prevents missed sales, because a sale missing from either channel makes the total look wrong. It also makes cash balancing possible. You cannot decide how much cash should be in the drawer until you know how much of the day’s sales was cash and how much arrived by phone.
3. What to Record for Every Sale
Every sale needs a small, consistent record that lets any attendant prove it was paid and recorded. Keep it short so people actually do it. Write it at the time of sale, or at the very least on the same day, and use the same layout every time. A record that is complete on most days but skipped on busy ones is hard to trust.
If you keep your records in software, a tool built for voucher management can hold these details in one place. A paper ledger with the same columns works too. What matters is that the same details are captured for every sale.
3.1. Voucher Code and Activation Status
Record the voucher code and its status: sold, active, or unused. “Sold” means the customer has paid and holds the code. “Active” means the code has been used or switched on. “Unused” means it is still in stock or sold but not yet started.
The activation log shows which plan was actually given for that code. When you match your ledger against it, you can confirm that the plan you sold is the plan that went live.
3.2. Payment Reference and Phone Number
For every mobile money sale, record the transaction reference and the customer’s phone number. Copy the reference exactly as it appears in the payment confirmation message.
The reference together with the confirmation message proves the payment. The phone number gives you someone to contact if the reference is missing or looks wrong. Cash sales have no reference, so mark them clearly as cash instead of leaving the field blank.
3.3. Amount Paid and Plan Given
Record the amount the customer paid and the exact plan or time you gave in return. Be specific. “One-day plan” is better than “internet.”
Amount and plan must match the sales ledger entry for that voucher code. If the ledger says one plan and the customer paid for a different one, you have found a variance before it grows into a habit.
4. Daily Matching Routine
Here is a shop daily sales closing routine you can repeat every day. Do the steps in the order given, and do them at the same time each day. A routine that happens at a fixed moment becomes automatic, and automatic routines get finished.
This routine is the heart of daily voucher sales reconciliation. The four steps below make up a simple reconciliation workflow that needs nothing more than a ledger, a statement, and a calculator.
4.1. Set a Fixed Day Close Time
Choose one close time and stick to it. Once the time passes, stop adding new entries to that day. Anything sold afterward goes on the next day’s page.
A fixed cutoff makes shift handover clean, because the outgoing and incoming attendants agree on where one day ends. It also makes next-day comparison simple, since each day’s records cover the same window.
4.2. Match Activations to Payment References
Go through your activation log one voucher at a time. For each activation, find its payment reference in the ledger, or its cash entry if it was a printed sale. Put a tick beside each matched pair.
Anything without a tick is unmatched. Flag it, write a short note about what looks wrong, and plan follow-up. This is how you match voucher activations to payments in practice, and it is also the answer to how to match wifi voucher activations to mobile money references without special tools.
4.3. Match Sales Log to Mobile Money Statement
Now compare the day’s sales ledger to the mobile money statement, line by line. This is mobile money statement matching. For each mobile money sale, check three things: the reference matches, the amount matches, and the entry appears on the statement. Also look at any payout entries, so you know which money has moved to you and which is still on its way.
Tick each line that agrees. Circle anything that appears on one side but not the other. That is your mobile money payment reconciliation for the day, and every circle becomes a variance to resolve.
4.4. Count Cash and Voucher Stock
Count three things at close: the cash float you started with, the cash taken in from printed sales, and the printed vouchers still in stock.
Work out what you expect. Expected cash is the opening cash float plus cash taken from printed voucher sales, less any cash you recorded as paid out during the day. Compare that with what you actually counted. The result is your daily closing balance. Write it down, and record any difference as a variance instead of adjusting figures to make it disappear. This is the core of wifi voucher cash balancing, and it answers how to balance cash from voucher and mobile money sales: mobile money sales do not add cash to the drawer, so only the cash channel counts toward the cash total.
Do the same for stock. Opening slips, minus slips logged as sold, should equal the slips still in hand.
5. Fees and Settlement Statements
Fees are the reason your payout will not equal your sales, and that catches many owners by surprise. Once you understand it, it is simple. This section stays general on purpose. Your own statement will show exactly which charges apply to you, so read it rather than assume.
5.1. Common Mobile Money Fees
Mobile money sales usually carry a transaction fee that reduces what you actually receive. Generic examples include a charge taken when a customer sends a payment, a charge for withdrawing or cashing out, and a charge for moving funds to another account. Which of these apply, and how they are charged, depends on your service.
Do mobile money fee reconciliation the same way you do everything else: with the statement in front of you. Note each fee as it appears, so you know what was taken and why. That is how to track mobile money fees on wifi sales without guessing.
5.2. Gross Amount Versus Net Payout
Gross sales are the total your ledger says you sold. Net payout is what lands with you after fees are taken out. Net is lower than gross, and that is expected.
So when your settlement statement total is lower than your sales ledger total, do not assume a sale went missing. Instead, check that the gap is explained by the fees listed on the statement. If the difference matches the fees, the books agree. If it does not, look for a missing or mismatched sale.
5.3. How to Save Daily Statements
Save each daily settlement statement together with that day’s sales ledger. Give it a simple name that starts with the date, for example the year, month, and day followed by the word “statement.” Use the same pattern every day so files sort themselves.
File the statement and ledger as a pair, on paper or on screen, and keep the week’s pairs together. When it is time for weekly review, everything is already in one place.
6. Finding and Fixing Variances
A variance is a difference between two records that should agree. Variances happen in every shop, so finding one is not a failure. Ignoring one is. Treat each as a small puzzle: stay calm, find the cause, fix the record, and write down what you did.
For the wider picture of hotspot income, see revenue tracking. For now, here are the five variances you are most likely to meet.
6.1. Missing Payment References
When a mobile money sale has no transaction reference, pause the match. Look for the payment confirmation message on the phone and check the statement for a matching amount and time. If you still cannot find it, ask the customer to show their confirmation message.
Log every step in the sales ledger as missing voucher payment follow up: what you checked, who you asked, and the result. Do not guess a reference to fill the gap.
6.2. Duplicate or Wrong References
Duplicates and typing errors are common. Someone copies a reference twice, swaps two characters, or enters a reference under the wrong voucher. A careful mobile money transaction reference check catches these: compare each reference in the ledger to the confirmation message and the statement, and look for the same reference on more than one line.
Correct the log without deleting the original entry. Cross out the wrong reference so it stays readable, write the right one beside it, and add a short note with the date and your initials. That keeps a clear trail.
6.3. Activated but Unpaid Vouchers
Sometimes the activation log shows a voucher as active but you cannot find a payment or cash entry for it. This is what to do when a voucher activation has no matching payment.
Follow up right away. Check the ledger, the statement, and any confirmation messages. Ask the attendant who handled it and, if needed, contact the customer. Record the outcome: paid and now recorded, unpaid and collected, or unpaid and written up for the owner to decide.
6.4. Paid but Unactivated Vouchers
The reverse happens too. A payment shows up on the statement, but no active voucher matches it. Start by confirming the payment: check the reference, the confirmation message, and the amount.
Once the payment is confirmed, issue or activate the correct plan for that customer. Then record the fix in the ledger and the activation log, with the reference beside the voucher code, so the sale now shows as paid and recorded.
6.5. Cash Shortages and Overages
If counted cash is less than expected, record it as cash short. If it is more, record it as cash over. Write the difference in the ledger with the date, the amounts you compared, and your initials. Do not tuck it away.
Next, recount the cash and recheck the sales entries and any payouts you noted. If the difference remains, pass it to the owner for review and sign-off. Small overages deserve the same care as shortages, since they often point to an unrecorded sale.
7. Weekly Reconciliation Rhythm
Daily closing catches most problems. A short weekly review catches the rest, and it shows patterns no single day can. Keep it light. A short review you do every week beats a long one you keep postponing.
7.1. Weekly Sales and Payout Totals
Add up your seven daily totals for sales, fees, payouts, and cash. Put them side by side.
Weekly totals reveal patterns you miss in one day. You might notice that fees are higher than you expected, that cash variances cluster on one shift, or that unmatched items keep coming from the same type of sale. Those clues tell you where to tighten your routine.
7.2. Clearing Unresolved Variances
Go through every variance still open from the week. Close each one as resolved, pending, or written up for owner decision. Every open item gets one of those three labels.
Nothing should carry over without a note. If something stays pending, write why and what happens next. This keeps small problems from becoming permanent ones.
7.3. Records to Keep for Review
Build one weekly file with the daily ledgers, activation logs, statements, variance notes, and handover sheets. Keep them in date order.
Complete records support reseller trust, because you can show a reseller exactly what was sold and paid. They also support owner review, since the owner can check any day without asking anyone to reconstruct it.
8. Segregation and Simple Controls
Controls do not need extra staff or heavy paperwork. A few habits prevent most losses and protect honest attendants from unfair suspicion. The main idea is segregation of duties: no single person handles everything from sale to record.
8.1. Separate Selling, Cash Handling, and Recording
Segregation of duties means different handling for three jobs: selling, holding cash, and recording. If one person does all three, nobody else can spot a mistake.
You can split tasks even with one or two attendants. One attendant sells and hands over the voucher while the other writes the ledger entry. If you are alone, ask the owner or a second person to check your cash count and sign the ledger at close. Even a partial split adds a second pair of eyes.
8.2. Attendant Shift Handover Checks
At each shift change, run a short handover check. Count the cash. Count the vouchers. Sign the log. Note any open variances.
Both attendants sign. The outgoing attendant confirms what they hand over, and the incoming attendant confirms what they receive. Later, no one has to argue about who was responsible for what.
8.3. Controls for Owners and Resellers
Owners can add a few simple controls: occasional spot checks of the ledger against the statement, a weekly review of the file, and a limit on how much cash float stays in the drawer. Resellers should keep their own sales records so they can show what they sold and what they owe.
Keep these controls simple and consistent. A control that is applied every week does more good than a strict one that is dropped after a month.
9. FAQ
9.1. How often should I reconcile voucher and mobile money sales?
Close daily and add up weekly totals. Daily matching catches errors while people still remember the sale and the customer can still be reached. The weekly review then shows patterns and clears anything left open.
9.2. What should I do if a payment has no reference?
Pause the match for that sale. Check the payment confirmation message and the statement for a matching amount and time. Log the missing voucher payment follow up in the ledger. If you cannot resolve it, escalate it to the owner.
9.3. How do I confirm a mobile money payment is real?
Check four things together: the transaction reference, the payment confirmation message, the amount, and the entry on the statement. When all four agree, the payment is real. Never rely on a verbal claim alone.
9.4. Why does my payout differ from total sales?
Your payout is net, and your sales total is gross. Transaction fees come out before the money reaches you. Use the settlement statement to confirm the gap is fees and not a missing sale.
9.5. How do I handle a customer who paid but has no active voucher?
First confirm the payment reference. Then activate or reissue the correct plan. Record the fix in the ledger and the activation log so the sale shows as paid and recorded.
9.6. What records should I keep for each day?
Keep the sales ledger, the activation log entries, the payment references, the statement, the cash count, and any variance notes. Store them together for review. One day, one bundle.
9.7. How do I prevent cash loss with multiple attendants?
Use a fixed close time, control the float, and have both attendants sign at handover. Keep recording separate from selling where you can. A consistent routine matters more than extra paperwork.