Card Payment Reconciliation: Matching Sales to Bank Deposits

Your till says you took one figure in card sales this week, but the money that landed in your bank account is a different number, and it arrived on different days. Sound familiar? Card payment reconciliation is simply the job of explaining that gap. Your payment provider may bundle several days into one payout, take off its charges, deduct refunds, and pay you after the day of sale. If each bank deposit is treated as a brand new sale, the same income can end up in your books twice.

The aim is straightforward: record each sale once, account for everything the provider has adjusted, and know what’s still on its way to the bank. Here’s how we’d suggest approaching it.

Three records, three questions

Think of reconciliation as getting three documents to agree. Your sales record shows what customers bought. The provider’s settlement report shows how those payments were processed and what was taken off. Your bank statement shows the money that actually arrived. Each one answers a different question, and you need all three to tell the full story.

A card terminal summary on its own may not hold every detail your accounts need. Equally, a bank feed can’t explain a deduction that happened before the payout reached you. It’s worth downloading the full settlement reports, including refunds and charges, rather than saving a screenshot of the total.

If you take payments in more than one way, list every channel. A shop might have a counter terminal, a website checkout, and a separate payment link service. Even when all three pay into the same bank account, their reports, references, and payout timings can differ. Our bookkeeping service works from the records your systems actually produce, so knowing where each report lives saves time for everyone.

Gross sales and net payouts

Gross card takings are what your customers paid before any deductions. A net settlement is what the provider sends to your bank after its adjustments. Don’t assume the whole difference is a processing fee. Refunds, amounts held back, chargebacks, and corrections can all sit in that gap.

Here’s a simple example with illustrative figures, not a real provider rate or an FD client result. Say a settlement report shows £1,000 of customer card payments, £100 of refunds, and £20 of processing charges, with nothing else deducted. The payout you’d expect in the bank is £1,000 minus £100 minus £20, which is £880. That’s three separate things to record (sales, refunds, and charges), not one sale of £880.

The example doesn’t settle how VAT applies, when income is recognised for tax, or which entries your particular software needs. Those depend on your business, your accounting basis, and your provider’s terms, so speak to us for advice tailored to your situation.

For limited companies, GOV.UK’s guidance on company accounting records covers keeping records of money received and spent. Keeping the settlement breakdown means every bank receipt has an explanation behind it, rather than an unexplained gap between sales and cash.

Avoid recording sales twice

Duplicated income is a common problem with card takings. It usually happens when your till or online shop sends sales into your accounting software and the bank feed then suggests creating another sale for the payout. Both imports may be doing exactly what they were set up to do. The problem is that nobody has connected them.

Before you accept a bank feed suggestion, check whether those sales are already in your books. A payment against a customer invoice normally needs matching to that invoice, not a fresh sale. For grouped card takings, many businesses route the payouts through a clearing account.

A clearing account is a holding record that follows money between systems. It shows card receipts waiting to settle and the adjustments that explain each payout. It isn’t a second bank account, and its balance should always have an explanation rather than quietly growing month after month.

If you’re not sure how your software has been set up, ask before you bulk approve suggested transactions. Our accounting support can review how your records are being treated, so a handy automation doesn’t keep repeating the same mistake.

Timing differences at month end

A sale on the last trading day of the month may not reach your bank until the next month. That’s a timing difference to explain, not missing income. Keep both the transaction date and the settlement reference wherever your system provides them.

At month end, list the amounts your provider still owes you. When the next payout arrives, match it against that list. If a deposit doesn’t turn up when you expect it, use the provider’s report and reference to chase it, rather than changing sales dates to make the totals line up.

The same thinking helps when one payout covers a weekend or several sites. Check which days and locations the settlement actually includes. A daily bank total and a daily till total can both be accurate while describing different sets of transactions.

It also helps to know which accounting basis your business uses. Reconciliation proves what happened to the money, but a bank date doesn’t automatically decide the tax treatment. We can apply the right rules once each transaction can be identified.

Refunds, chargebacks, and fees

A refund should stay linked to the original sale and to the evidence for the return or cancellation. If your provider takes it out of a later payout, that later deposit will look low even if the day’s new sales were healthy.

A chargeback isn’t the same as a routine refund. It’s a disputed payment that can involve a temporary deduction and a later outcome. Keep the provider’s notices and any correspondence, and don’t record a temporary movement as a final loss until you know where it stands.

Hold on to the provider’s fee statements too. Transaction charges, a monthly subscription, and terminal rental may all appear in different places. Don’t guess the VAT treatment just because a line says “fee”. Keep the invoice or statement so the charge can be reviewed properly.

HMRC’s record-keeping guidance for small businesses suggests keeping card summaries and bank statements alongside your sales records. Storing them together makes a query far easier to answer than hunting through different inboxes after the year end.

A monthly routine you can repeat

1. Start from a checked balance. Pick up from last month’s reconciled position, not from scratch.
2. Gather the reports. Download the sales report and settlement reports for the same dates.
3. Match payouts to the bank. Tick off each deposit against its settlement reference.
4. List what’s left. Note each item you can’t match with a reason and a next action.
5. Fix the cause. If the same problem keeps appearing, correct the setting or import behind it.

A good exception list records the date, amount, provider reference, likely cause, and who’s looking into it. “Difference to check” isn’t much help. “Refund on settlement report, original sale reference missing” tells the next person exactly what evidence to find.

Watch for files imported twice, a missing day’s export, or transactions filtered out by accident. If you’re self-employed, GOV.UK’s list of records to keep if you’re self-employed is a useful check that nothing important is missing.

Reliable reconciliation also gives your management accounts a firmer foundation. Sales trends, charges, and money still to arrive are much easier to discuss when they aren’t mixed together in one bank feed category.

Questions about card payment reconciliation

Can I reconcile card payments in a spreadsheet?

Yes, if it suits the number of transactions and it’s kept organised. Use clear references, control who can edit it, and keep one agreed version. A spreadsheet should support your accounting records, not become a separate set of figures that nobody else can follow.

What if a customer pays one invoice in several instalments?

Keep every payment linked to the same invoice and check the balance left after each one. Don’t create a new sale because another instalment arrived. Give your bookkeeper the invoice number and any settlement references that help match it.

How should we share the work between several people?

Agree who supplies the reports, who prepares the reconciliation, and who reviews anything unresolved. Keep a shared query log so answers don’t get lost in one person’s inbox, and note corrections clearly enough that the next person can see what changed and why.

What if our payment provider account has closed?

Download the statements, settlement reports, and transaction history before access ends if you can, and keep them with your business records. If access has already gone, ask the provider for copies and tell whoever prepares your accounts which records are missing.

How do I record a partial refund?

Keep the original sale and the partial refund separately identifiable, with the reason and the amount left. Don’t overwrite the original transaction to make it look as though the customer paid less in the first place. Your sales records and the provider’s report should let anyone follow the sequence.

How long should I keep card settlement reports?

Keep them with the rest of your business records for the period HMRC requires, which depends on whether you’re a sole trader or a limited company. Our guide on how long to keep business records explains the main time limits.