Credit card statement reconciliation without losing a day a month

If you look after the company cards at a UK or Irish SME, you already know the shape of the first week of the month. The statements arrive as PDFs. You copy the lines into a spreadsheet, tidy up the rows that pasted badly, then work down the list trying to find a receipt for each charge in whatever system or folder people used. The ones you cannot find go into an email to the cardholder. Then you wait.

Credit card statement reconciliation is not difficult work. It is just slow, repetitive, and spread across too many places. This article sets out what makes it slow, a process that removes most of the waiting, how Costrix runs that process, and a realistic estimate of the time it gives back.

Why reconciling company cards by hand takes so long

The PDF does not want to be a spreadsheet

Corporate card statements are designed to be printed, not processed. A document-processing vendor, Tofu, describes the common UK formats: Barclays multi-column PDFs tend to merge rows when copied, and HSBC statements embed mid-document summary lines that look like transactions. Their estimate for a 50-page statement of 300 to 500 transactions is three to four hours of manual work, and that is before a single receipt has been looked at. This is a vendor blog rather than independent research, but anyone who has pasted an HSBC statement into Excel will recognise the description.

The receipts live somewhere else

Once the lines are in a spreadsheet, each one has to be paired with a receipt or a claim. In most setups those sit in a different screen: a shared drive, an inbox, or the expense module of the accounting system. A Dynamics 365 partner, DATABASICS, describes accounts payable "manually matching receipts to card charges" in separate screens, and reports a median month-end close of 6.4 days against 4.8 for the top quartile, with card reconciliation alone taking three to five business days at 50 or more cards. That is a partner's figure, not an audited benchmark, but the gap between 6.4 and 4.8 days is largely the card reconciliation and the chasing it causes.

Many businesses simply do not finish

A YouGov poll of 4,000 UK businesses commissioned by Soldo in 2018 found that 22% leave spending unreconciled every month. It is a dated survey, but it is large, and it matches what most accountants see: when the process takes a day, the last few unmatched lines get carried forward, and then carried forward again.

Card feeds are not the automatic answer

The obvious fix is a live bank feed into an expense tool. In practice reviewers of those tools report their own reconciliation headaches. One Rydoo reviewer on Capterra in 2021 wrote that "every month two of our statements fail to update correctly, and it's random which ones". A vendor-commissioned survey reported by Navan lists credit card reconciliation among the top three finance challenges even for teams already using software. A feed that silently misses a statement is worse than a PDF you can see, because you do not know what is missing.

If the wider cost of a manual process is what you are trying to put a number on, The true cost of manual expense claims in the UK covers the employee and approver side too.

A better process to reconcile company card expenses

The goal is not to remove the human check. Finance should still confirm anything uncertain. The goal is to stop doing the copying, searching and emailing by hand.

1. Import the statement, do not retype it. Read the lines directly from the bank's PDF and check the parsed total against the printed total before anything else happens. If the two do not agree, refuse the import rather than work from a partial list.
2. Auto-match by amount and date. Most charges have a claim of exactly the same amount within a day or two. Those can be matched automatically and ticked off without a person looking at them.
3. Review the near-misses as suggestions. Charges that are close on amount and date, with a merchant word in common, are offered to finance as suggestions. A person confirms or rejects each one; nothing ambiguous is linked on your behalf.
4. Push missing lines to the cardholder, not into an email. Instead of a list sent to twelve people, each unmatched charge appears where the cardholder already records their expenses, so they can add the receipt or explain the charge in the same place.
5. Tally by person. Finance needs one view that says who still has outstanding charges and how many, sorted with the worst first, so chasing is targeted rather than broadcast.
6. Lock matched receipts, then export once. A receipt that settles a statement line must not be deletable by its owner, or the statement quietly comes undone. When everything ties, export approved spend once for posting.

The month-end chasing problem is mostly steps 4 and 5: the chase disappears when the missing charge finds its own cardholder.

How Costrix matches receipts to a card statement

Costrix was built around exactly this process for UK and Irish businesses of roughly 20 to 150 staff. Here is what happens, with the actual rules rather than a general description.

Statement import. Finance uploads corporate card statement PDFs, one at a time with a "whose card" picker or several at once. The parser is built for HSBC's statement layout, which is the supported format today; other banks' layouts are on the to-do list. The parser reads every transaction from the positioned text, treats the mid-document summary lines as what they are, and refuses the import if the sum of parsed debits does not equal the printed "Debits" total. Unreadable rows become warnings rather than silently disappearing. Bulk import matches the cardholder name printed on the statement to a person and asks, rather than guesses, when two people share a name.

Exact matches. At import, each line is compared with that cardholder's unmatched expenses. Same amount to the penny and a date within three days is an exact match, and it is ticked off automatically. Where two expenses qualify, the one sharing a merchant word wins, so a £5.00 charge at Starbucks lands on the Starbucks receipt rather than the Costa one from the same day. Matching is GBP only; a £6.00 line will never be offered a €6.00 expense.

Suggested matches. Lines still unmatched get suggestions: an exact amount within seven days, or an amount within £5 and a date within three days where the merchant text shares at least one word. Suggestions are never linked automatically. Finance confirms a suggestion, links a different expense from a ranked picker, or rejects it. A rejected pairing is remembered and will not be suggested again.

The ledger. Each statement shows one row per line in statement order, with reconciled-of-total, the statement total and the amount still missing. Matched lines are ticked; unmatched lines are red. Finance can create draft expenses from unmatched lines individually or in bulk, and those drafts belong to the cardholder, never to whoever clicked.

Missing lines on the cardholder's month. Every unmatched charge also appears as a red strip at the top of the cardholder's own month page in the app. Tapping it offers "Add an image", which opens the camera, or "No image possible" with a reason. The line leaves the strip the moment it is resolved. Nobody has to write the email.

Tallies by person. The Finance page shows reconciled and outstanding counts per cardholder, filtered by month, sorted most outstanding first. That is the chase list, and it maintains itself.

Protected receipts. A receipt matched to a statement line cannot be deleted by its owner, admins included. Only an admin-only path on the expense detail page can remove it, and that unlinks the line first and records it in the audit log.

Export. Approved expenses export as a finance-ready CSV with per-person, per-category and per-cost-centre summaries. Native posting to Microsoft Dynamics 365 Finance & Operations is on the roadmap; there is no direct Xero, Sage or QuickBooks integration today, so treat the CSV as the handover.

How much time this gives back

Our estimate for a 50-person firm with corporate cards is that finance goes from about 10 hours a month on card reconciliation and the close work it drives to about 3. Those 7 hours at a loaded management accountant rate of £38 an hour are worth roughly £266 a month, or about £3,200 a year, before counting a faster close.

How we worked this out

These are estimates. Every survey figure above is vendor-commissioned, and your own time will depend on how many cards you run and how disciplined cardholders already are. The true cost article shows the same assumptions applied to the whole claims process.

What to check on your current process

• How long does it take from the statements arriving to the last line being matched? If the honest answer is "we don't always finish", you are in the 22%.
• Do you retype or paste statement lines? Count the hours spent tidying rows before any matching starts.
• Where do the receipts live, and is it the same screen as the statement lines?
• How do cardholders learn about a missing receipt: a personal notification, or an email list with everyone on it?
• Can a person delete a receipt after it has been matched? If yes, your reconciliation can be undone without anyone noticing.
• Does the process check the parsed total against the bank's printed total?
• Can you see, in one place, who has outstanding charges and how many?

What to do next

If your month starts with a PDF and a spreadsheet, try the import on a real statement. Costrix comes with a 7-day free trial on all plans: card details up front, nothing charged for a week, cancel any time. Start your free trial, import last month's HSBC statement, and see how many lines match before you touch anything. Pricing starts at £8 per user per month on the pricing page.