Ask a jobber where the card money is, and the honest answer is usually a spreadsheet.
A station sells fuel on cards all day. The processor settles those sales in batches, takes its fees, and deposits what's left — one batch might settle the next day, a weekend's batches land together, and the deposit that hits the bank rarely equals any single number anybody wrote down. Meanwhile the jobber owes that money onward: applied against the station's account, net of what the station owes, paid out on a schedule.
Reconciling that flow by hand — batch reports on one side, bank deposits on the other, a spreadsheet in the middle — eats half a day at a time in most offices. And until it is done, nobody can say with confidence how much card money the jobber is actually holding for each station. That number has a name in this business: the available CC net. Getting it wrong in one direction means paying out money that never arrived. Getting it wrong in the other means a station's money sits in your account while the station asks where it is.
The money itself is not complicated. The path it takes is.
It moves in batches, not in sales. A day's card sales are grouped, settled, and deposited as batches — and the grouping at the processor is not the grouping at the bank. Friday's batch might arrive Tuesday. Two batches might land as one deposit.
It arrives net, not gross. Processing fees come out before the deposit does, and fees are not one flat rate: card type, transaction size, and how the card was accepted all change the cut. The deposit is the batch minus a number that has to be worked out, not read off.
Things go missing quietly. A batch can fail to settle, settle short, or settle twice in the report and once at the bank. Chargebacks reverse money weeks after it looked final. None of these announce themselves — they surface only when somebody lines the batch report up against the bank, line by line.
It is not your money — but it is your problem. Card proceeds belong to the station whose customers swiped the cards. The jobber holds them, applies them, and pays them out. That makes accuracy a trust issue, not just a bookkeeping one: the station's manager can see their card sales, and they will notice if the payout does not match.
The discipline is the same one good offices already follow by hand. Software just removes the lining-up by eye.
Bring the batches in automatically. Batch and settlement reports arrive from processors as emailed reports and export files, in more than one format. Those reports should be collected and read automatically — every batch, with its date, station, gross amount, and fees — instead of being downloaded and re-typed when someone has time.
Match batches to deposits. Each deposit at the bank gets matched against the batches that should make it up. A deposit that matches its batches exactly is done — no human needs to see it. The point of matching is what it leaves behind.
Flag every gap instantly. What is left unmatched is the real work: a batch with no deposit, a deposit short of its batches, a fee that does not fit the pattern. Those exceptions should be flagged the moment the match runs, with the amounts involved — not discovered at month end when the trail is cold and the processor's answer is a shrug.
Keep the available CC net as a running number. With batches matched and deposits confirmed, the balance per station stops being a calculation and becomes a fact: how much card money has come in, how much has been applied to the station's invoices, and what is still outstanding. One number, current, per station — the number the payout is made from.
Pay out from the same numbers. When it is time to pay the station, the payout file should be generated from the reconciled balance — an ACH file in NACHA format, ready for the bank — instead of a fresh spreadsheet built from the old spreadsheet. And the whole flow should land in the books without re-keying: invoices and card activity syncing to QuickBooks Online when you run the sync, so the accounting agrees with the reconciliation because it came from it.
The half-day disappears. Matching is arithmetic and pattern-spotting — exactly the work software is good at. The office's time goes to the flagged exceptions, which is the only part that ever needed a person.
Short-pays get caught while they are still fixable. A batch that settled short last week can be chased. The same batch found at quarter end is usually just absorbed. Multiply that by every station, every week, and the "small" leaks stop being small.
Payout arguments end. When a station questions a payout, the answer is the matched record: these batches, these deposits, these fees, this net. A reconciliation you can show beats a spreadsheet you have to explain.
You always know the float. At any moment, the jobber can see how much station card money is on hand, what is applied, and what is owed out — which is simply the truth about a liability the business carries every day.
Why doesn't the bank deposit ever equal the day's card sales? Because the deposit is not the sales. It is one or more batches, settled on the processor's schedule, minus processing fees that vary by card and transaction — and it can include a reversal or skip a batch entirely. Expecting the two numbers to match is what makes manual reconciliation so frustrating; the match has to happen at batch level, not day level.
How long should reconciliation take? The matching itself, minutes. What takes time in a manual office is collecting the reports and lining them up — the parts that can be automated. Human time should be spent only on the flagged gaps, and on a normal week there are not many.
What is the available CC net, and why does it matter? It is the card money you are holding for a station right now: settled and deposited, minus what has already been applied to their invoices or paid out. It matters because payouts are made from it. Pay out more than the net and you are fronting money the processor never sent; pay out less and the station is financing you without agreeing to.
What happens when a batch is missing? It should appear as a flagged gap — batch reported, no matching deposit — with the amount and date attached. That is the chase list: most missing batches are timing or a processor error, and both are easier to resolve with the exact batch in hand than with a month-end total that "seems off."
Card reconciliation is not glamorous work, but it guards the two things a jobber cannot afford to fumble: other people's money, and the trust that comes with handling it. The offices that do it well are not the ones with the biggest spreadsheets. They are the ones where every batch is matched to the bank, every gap is flagged the day it happens, and the available CC net is a number you can say out loud without checking first.
FuelJobberX reconciles card money this way: batches are pulled in and matched to deposits automatically, gaps and discrepancies are flagged instantly, the available CC net stays current per station, and ACH payout files come straight from the reconciled balance. If you want to see your last week of card money reconcile in minutes instead of half a day, you can book a demo at fueljobberx.com — a walkthrough with real data in under 30 minutes, no sales pressure.
We'll walk you through the full platform in under 30 minutes — with real data, no sales pressure.
Book a Demo →