Why your card money should be reconciled every day, not every month
By the time a month-end reconciliation finds a missing card batch, the trail is cold. Here is what goes wrong, how to check it daily by hand, and how to stop doing it by hand.
- LitreIQ
On most South African forecourts, card payments are now a large share of what goes through the till. That money does not arrive in your bank the moment the customer taps. It travels from the terminal, through your card provider, into a settlement batch and finally into your account, usually a day or more later. Every step is a place where some of it can go missing, quietly.
Many dealers only compare card sales with bank deposits at month-end, often when the bookkeeper does the books. By then you are looking for a problem among thirty days of transactions, the staff on duty may not remember what happened, and some claim windows may already be closing. Checking daily turns a needle-in-a-haystack hunt into a short list of yesterday's exceptions.
What goes wrong with card money
Hung sales
A hung sale happens when a fill is completed at the pump but the transaction is not properly finalised on the till or terminal, for example because of a communication drop or an interrupted shift change. The fuel has left the tank. If the sale is never closed off, or is closed off against the wrong tender, your sales and your card records stop agreeing.
Batches that do not settle
Terminals group transactions into batches. If a batch is not closed, or fails to upload, the money for those transactions may not be paid until someone notices and fixes it. One unsettled batch on a busy day can be a meaningful amount, and it will not fix itself.
Fleet amounts not claimed
Fleet card transactions are often settled separately from bank cards, on their own schedule and in their own files. If nobody matches fleet sales on the till against fleet settlements, an amount that was never claimed or never paid can sit unnoticed for weeks.
Terminals billed but not installed
Card providers charge rental and fees per terminal. Over time, terminals are swapped, returned or replaced. It is worth checking that the number of terminals on your monthly statement matches the number actually on site and in use. Paying for a device you returned months ago is a small, steady leak.
Reversals and refunds
Most refunds and reversals are legitimate. But a reversal a few minutes after a fill, or several voids clustered on one shift, deserve a second look. Daily checking makes these patterns visible while the shift is still fresh in everyone's mind.
How to reconcile card money by hand
You do not need software to start. You need three things every morning, and about twenty to thirty minutes:
- Yesterday's card sales from your back office, split by tender type (bank cards, fleet cards and any others).
- The terminal or card provider report for the same trading day, showing transactions and batches.
- Your bank statement, showing what has actually landed, bearing in mind that settlement usually lags by a day or more.
Then work through it in order:
- Compare back office card sales with the terminal totals for the day. A difference points to hung sales, wrong tender types or a terminal problem.
- Check that every batch on the terminal report was closed and uploaded.
- Match each batch to a deposit on your bank statement. Keep a simple list of batches still waiting, with the date you expect them.
- Match fleet card sales against fleet settlement files separately.
- Look at reversals and refunds for the day, and note any that need a conversation.
- Once a month, count the terminals on site and compare with the rental lines on the statement.
The key habit is the "still waiting" list. Anything older than your normal settlement time goes to your card provider the same day, with the batch number and date. Small amounts chased early are far easier to recover than a pile of queries at month-end.
Why most owners stop doing it
The process is simple, but it is relentless. The reports arrive in different formats, at different times, from different systems. The person doing it needs to be careful and needs to do it every single day, including after a long weekend when there are three days to catch up on. When the owner is not on site, it often slips, and month-end becomes the only check again.
How LitreIQ automates it
LitreIQ reads the reports you already receive: scheduled back office reports, your card terminal provider's exports, your bank statements and your fleet settlement files. It does this read-only, so nothing in those systems changes. Every day it matches card sales to terminal batches to bank deposits, and fleet sales to fleet settlements.
When everything agrees, you do not hear from it. When something does not agree, it opens a case with the Rand amount, the batch or transaction involved, the likely causes (including innocent ones such as a settlement that is simply late) and the steps to follow up. The amounts are calculated by fixed, auditable rules from your own files.
At one pilot site, LitreIQ reconciled R408,894.95 in card sales across 905 transactions over six days, every day rather than at month-end. That is one site and a short period, but it shows the daily habit can run without someone sitting with three spreadsheets each morning.
LitreIQ does not process payments and never holds card numbers. It only sees the masked digits where a report includes them.
Try it on your own numbers
If you want to see what daily reconciliation finds at your site, start a free 14-day trial on one site with no card details needed, or ask for a free Profit Protection check and we will walk through your reports with you.