How do you reconcile a monthly statement? A process that turns thirty minutes into three
2026-08-17 · Reconciliation · Blog
The most time-consuming part of an expense claim usually isn't photographing receipts — it's reconciling them. At month end you pick up your credit card statement and work through it line by line against the receipts in hand: which café was this $72 from? Is there a receipt for that $380? You go cross-eyed doing it, and you almost always find a few charges you simply can't match to anything. With a few dozen transactions in a month, working through them slowly really does take more than half an hour.
Reconciling is a mechanical job, though. Get the process right and you can cut it from thirty minutes down to three. Here's an approach that actually works in practice.
1. Reconciling is really just finding three kinds of gap
Don't start by reading every line. The goal is clear: you're looking for three things. First, on the statement but no receipt — you paid by card but the receipt is lost or was never photographed. These matter most, because anything you miss can't be claimed. Second, receipt but nothing on the statement — usually cash, a colleague paying on your behalf, or a charge that hasn't posted yet. Third, both sides exist but the amounts don't agree — normally a tip, a service charge, or a partial refund after the fact.
Once you know those three categories, you stop reading from top to bottom and go straight for the differences instead. That alone saves a big chunk of time.
2. Line up your date basis first
The easiest trap to fall into is dates that don't line up. A receipt shows the transaction date, but a statement very often shows the posting date. A gap of one to three days is common, and after a weekend or a public holiday it can stretch to five.
So when you reconcile, don't insist on an exact date match — allow a window of a few days. In practice, matching on the same amount plus dates within five days already gives you a high hit rate. If two charges in the same month have identical amounts, use the merchant name to tell them apart.
3. Foreign currency charges need separate treatment
For business travel or overseas online services, the receipt is printed in foreign currency while the statement posts in Hong Kong dollars — and the bank's rate won't be exactly the one you looked up that day, on top of a possible cross-border fee. If you demand that the two numbers match exactly, you'll never reconcile them.
The fix is to loosen the tolerance on foreign currency items — allow a gap of three to five percent, say — then confirm with the date and merchant name. Once matched, use the Hong Kong dollar figure from the statement as your claim amount, because that is what the company is actually reimbursing you.
4. Instalments, deposits and refunds
A few types of charge never line up cleanly, and knowing that in advance saves you hunting for them. Instalment payments appear on the statement spread across several months, with each instalment nothing like the amount on the receipt. Hotel and car rental pre-authorisations (holds) sometimes post one figure first and get adjusted to the real amount later. Refunds post as a negative line, separate from the original charge.
For these, write a short note — "instalment 1 of 3", for example — so that next month you understand it at a glance instead of investigating from scratch.
5. Decide what to do about unmatched items immediately
The value of reconciling isn't just the checking — it's acting on what you find. For anything on the statement with no receipt, go back to the merchant straight away. Restaurants and retail shops can usually reprint from the date and amount; for online orders, search your email for the confirmation. The longer you leave it, the lower your chances of getting a copy.
If you genuinely can't get one, write a short explanation: date, merchant, amount, purpose, and why there's no receipt. Most companies accept this, but don't lean on it every time — once or twice a month is reasonable, a whole stack will raise questions.
6. Let a tool do the matching for you
The dullest part of the whole process is comparing line by line, and that step can be handed over completely. Upload your statement (PDF or CSV both work), the system reads out every transaction in it, matches them against the receipts you've already recorded by amount and date, and then lists exactly which charges have no receipt and which receipts have no matching charge.
ThatReceipt's statement reconciliation does precisely this: upload it and the report comes back immediately, and anything unmatched can be added to your records with one tap as an item still awaiting a receipt. The statement itself is never kept on the server — it's gone once processed, exactly as with photographed receipts.
7. Make it a once-a-month habit
Ideally you reconcile as soon as the statement arrives, rather than the day before the claim deadline. The reason is simple: getting a duplicate receipt takes time, and merchants don't keep their records for long. Doing it once a month, three to five minutes each time, adds up to less time than doing it once a year — and far fewer missed claims.
In short: use a date window rather than an exact match, loosen the tolerance on foreign currency, flag instalments and refunds separately, chase missing receipts the moment you spot them, and do it once a month. Once the process is settled, reconciling stops being a chore and becomes a three-minute routine check at month end.
Other languages：繁體中文 · 简体中文 · English · Español · Deutsch · 日本語 · 한국어 · Français · Português · العربية · ไทย