Payment reconciliation means matching the money that reaches your bank to the invoices in your accounts, so every receipt is explained and every paid invoice is closed. It's quick when each customer pays each invoice by bank transfer, and slow when a payment provider pays you lump sums with its fees, refunds and failed payments already taken out. A weekly routine, a clearing account for provider payouts and a provider that pays you in full keep the job small.
In this article
The short version
- Reconciliation ties each bank line to the invoice it pays, so your debtors list and bank balance are right.
- Provider payouts are lump sums with fees, refunds and failures taken out, so they rarely equal an invoice.
- A clearing account records payments at full value, fees as an expense and the payout as one transfer.
- VAT is due on what your customer paid, not on the smaller payout.
- A provider that pays out in full and bills its fee separately removes the fee split from every payout.
What payment reconciliation involves
You've got two records of the same money. Your accounting software holds your invoices and the payments recorded against them. Your bank statement holds what actually arrived, and on which day. Reconciling means tying each bank line to the right invoice, or invoices, so your aged debtors list shows who really owes you and the bank balance in your books agrees with the bank.
When a customer pays one invoice by bank transfer and quotes the invoice number, it's a two-second job: £1,250 arrives from the customer, you match it to the £1,250 invoice and move on. The time goes on three other situations:
- a customer pays without a reference, or pays several invoices in one transfer;
- a customer pays part of an invoice and leaves a balance;
- a payment provider, such as a card processor or direct debit provider, collects for you and then pays you its own lump sums.
The first two come down to your customers' habits. The third comes from the way payouts are built, and it's the one that tends to grow with your business.
Why provider payouts don't match your invoices
Most payment providers hold what they collect in a balance on your behalf and pay that balance out on their own schedule. Stripe and GoCardless both pay out lump sums with their fees already deducted. One payout can hold:
- several customers' payments, grouped into one figure;
- the provider's fees on those payments, taken off before the money reaches you;
- money clawed back on older invoices, such as a refund, a chargeback or a direct debit that failed after it looked successful;
- payments from a different day than you'd expect, because the payout runs on the provider's timetable rather than your customers'.
So the figure in your bank feed is the result of a calculation and won't match any single invoice. Say three customers pay £400, £250 and £600 on a Monday. The provider takes £14.50 in fees and recovers a £90 refund you gave another customer last month. On Wednesday £1,145.50 lands in your bank. None of your invoices says £1,145.50, and one of the deductions belongs to an invoice you closed weeks ago.
A payout can even come to nothing, if a deduction cancels out the day's collections. And Stripe can take money out of your bank account when refunds and disputes leave your Stripe balance below zero. Both are normal, and it helps to know about them before the first one turns up in your bank feed.
How to reconcile payments step by step
For bank transfers and other payments that arrive one at a time:
- Reconcile from your bank feed at least once a week, or daily if you take a lot of payments.
- Match each line to its invoice. Where a customer has paid several invoices in one transfer, Xero and QuickBooks both let you match a single bank line to more than one invoice, as long as the totals agree.
- For a payment with no reference, compare the amount with that customer's open invoices and confirm with them before you allocate it. A wrong guess usually comes back as a reminder sent to someone who's already paid.
- For a part payment, record the amount that arrived and leave the balance open on the invoice.
For provider payouts, the standard method is a clearing account: an account in your books that stands in for the balance the provider is holding for you.
- Download the breakdown for that specific payout, using the payout reference rather than a date range.
- Record each customer's payment against its invoice at the full amount they paid, into the clearing account.
- Post the fees out of the clearing account to an expense account such as bank charges.
- Record any refund, chargeback or failed payment against the invoice it belongs to, reopening the invoice if the money has gone back.
- Record the payout as a transfer from the clearing account to your bank account. It matches the bank line exactly.
In the example above, that's £1,250 of payments in, £14.50 of fees and the £90 refund out, and a £1,145.50 transfer that agrees with your bank feed. Once every payout has landed, the clearing account should be back to zero, and any balance left in it tells you which payout you're still waiting for.
Keep an eye on VAT while you do this. VAT on your sales is due on what your customer paid, not on the smaller amount the provider passed on, so the net payout shouldn't set your output tax. If you use cash accounting, HMRC treats money collected by someone acting for you as received when they collect it, so a payment taken on the last day of a quarter can belong in that quarter even though the payout lands in the next. Your accountant can confirm how that applies to your provider.
At month end, check three things: the bank balance in your books matches the statement, each clearing account matches what the provider is still holding for you, and nothing on your aged debtors list has in fact been paid.
How to cut the time it takes
Some of the work never goes away, because someone has to decide what an unexplained payment is for, but quite a lot of it can be designed out.
Payments that arrive already labelled save a lot of time. A payment link with the amount and invoice reference filled in, or bank details that are unique to each customer, means the money comes in tied to the right invoice instead of to a guess.
The fees line is the next thing to remove. A provider that pays you the full amount and bills its fee separately takes the fee split out of every payout. Adfin works this way: it pays out every weekday with no fees taken off, and its fee arrives as a separate invoice. Pay by bank payments reach you the same day, card and bank transfer payments two working days after payment, and direct debits within three working days of the collection date.
Then there's the matching itself. Adfin matches payments to invoices, including part payments and payments with a missing reference, and syncs both ways with Xero and QuickBooks, so the invoice shows as paid without anyone keying it in. Its Customer Agents chase whatever is still unpaid on the schedule you set.
Common questions
What is payment reconciliation? It's matching the payments that reach your bank to the invoices in your accounting software, so every receipt is explained and every paid invoice is marked as paid.
How often should I reconcile payments? At least weekly, and daily if you take a lot of payments. The longer you leave it, the harder it is to work out what an unexplained payment was for.
Why doesn't my payout match my invoices? Most providers pay out several payments in one lump sum, with their fees and any refunds or failed payments deducted, so the total rarely equals a single invoice.
What is a clearing account? It's an account in your books that stands in for your provider's balance. Payments go in at full value, fees come out as an expense, and each payout leaves as one transfer that matches your bank line.
Do I pay VAT on the full invoice or the net payout? On the full amount your customer paid. The provider's fee is a separate business cost and doesn't reduce your output tax.
Can reconciliation be fully automatic? Software can match most payments for you, but someone still has to decide what an unexplained or disputed payment is for. A provider that pays out in full and bills its fee separately removes the fee split from every payout.
Sources
- HMRC - VAT cash accounting scheme (VAT Notice 731) (accurate as of October 2026) https://www.gov.uk/guidance/vat-cash-accounting-scheme-notice-731
- HMRC - VAT Time of Supply manual, VATTOS5115 (accurate as of October 2026) https://www.gov.uk/hmrc-internal-manuals/vat-time-of-supply/vattos5115
- Stripe - Receive payouts (accurate as of October 2026) https://docs.stripe.com/payouts
- GoCardless Support Centre - Receiving a payout (accurate as of October 2026) https://support.gocardless.com/hc/en-gb/articles/17485089478940-Receiving-a-payout
- GoCardless Support Centre - Payout deductions (accurate as of October 2026) https://support.gocardless.com/hc/en-gb/articles/17143453091868-Payout-deductions
- Adfin - Pricing (accurate as of October 2026) https://www.adfin.com/pricing
