How to match receipts to credit card transactions

What “matching” means

Every business card charge needs two things in your books: the transaction itself, which comes from the card or bank, and the document that explains it, which is the receipt. Matching is pairing each receipt with the transaction it belongs to, so that every charge has support and a clear business purpose.

It matters most at month-end. Your bookkeeper or accountant needs both halves to code an expense correctly, and an unmatched charge is the one that holds up the close.

How to match receipts by hand

1. Pull the transactions. Export the card or bank transactions for the period you are reconciling, usually as a CSV, or work from the statement.
2. Collect the receipts. Put every receipt in one place first. Paper receipts, photos, emailed receipts and app receipts are all fair game, but matching is slow if you are searching three inboxes as you go.
3. Pair on three fields. Match each receipt to a transaction by amount, date and merchant. Start with the unusual amounts, because they are the easiest to match with confidence, then work through the common ones.
4. Allow for differences. The total on a receipt often differs from the card charge. Restaurant tips are added after the receipt prints, foreign purchases convert at a different rate, and a transaction can post a day or several days after the purchase.
5. Record the purpose. Next to each pair, note what the expense was for and which category or account it belongs to.
6. List the leftovers. Whatever has no receipt goes on a missing-receipts list with the cardholder’s name, so it can be chased.

Why it goes wrong

• Cryptic merchant names. A card statement shows what the merchant’s payment processor sent, such as AMZN MKTP US*2K4H71QX0 or SQ *BLUEBRD CFE, not “Amazon” or “Bluebird Coffee”. You have to recognise it.
• Timing gaps. A purchase on the 30th may post on the 2nd and land in the next month’s statement.
• Split and combined charges. One receipt can cover two cards, and one charge can cover several receipts.
• Receipts in the wrong place. The receipt exists, but it is in a personal inbox or a Slack thread, so nobody finds it on the day it is needed.
• Late discovery. Missing receipts found at month-end are the hardest to replace. The person has forgotten the details and the merchant has moved on.

Habits that make matching easier

• Ask people to send the receipt on the day of the purchase, to one address or number, rather than saving them up.
• Match weekly rather than monthly.
• Use one card per person where you can, so each missing receipt has an obvious owner.
• Agree what happens when a receipt is lost, and write it into your expense policy.

What changes when you automate it

Matching software does the pairing in step 3 for you. It reads the receipt, compares it with your transactions, and attaches it when it finds the right one. What you review is the short list it could not match, rather than every line.

Barespend works this way. Your team emails, texts or uploads receipts as they spend. Barespend finds the card or bank transaction each receipt belongs to, attaches it, and codes the expense to your chart of accounts. Anything it can’t match is flagged for a quick review, and transactions without a receipt stand out on the day they happen. It works with any business card or bank account and syncs with QuickBooks Online, Xero and Sage Intacct.

If you are weighing tools, the checklist for choosing receipt matching software covers what to test before you commit, and the month-end checklist shows where matching fits in your close.

If a line on your statement doesn’t look like any merchant you know, the charge finder decodes common processor prefixes and well-known merchants.