How do I match receipts to bank and credit-card transactions?

What makes a receipt and a transaction the same purchase?

A receipt shows what you bought; the bank or card line shows that you paid. The IRS's Publication 583 says supporting documents include sales slips, paid bills, invoices, receipts, deposit slips and canceled checks, that they support the entries in your books and on your tax return, and that they should show the amount paid and that the amount was for a business expense. It also says proof of payment of an amount, by itself, does not establish you are entitled to a tax deduction, and that you should also keep documents such as credit card sales slips and invoices to show that you also incurred the cost. Matching is what ties each document to its payment.

Treat a document and a transaction as one purchase only when all of these agree:

• Payee. The merchant on the receipt is the merchant on the transaction, allowing for a shortened name on the statement.
• Date. The transaction falls inside the window you allow around the receipt date.
• Amount. The amounts are equal, or they differ for a cause you can document.
• Card or account. The card or account the receipt shows as paying is the one the transaction sits in.
• Reference. Any order, invoice or check number on one side agrees with the other.

No single field is enough. A 64.00 fuel receipt pairs just as readily with a 64.00 parking charge from the same week, and the wrong pairing looks finished while both true counterparts sit unmatched. Payee alone fails with any vendor you buy from repeatedly, and date alone fails on any busy day.

Why do the receipt date and the posted date differ?

A receipt carries the date of the sale; a card merchant can capture the payment later, and a statement shows a check on the date the bank posted it. Stripe's undated documentation on placing a hold on a payment method describes a merchant authorizing a card payment and capturing the money later, with the example of hotels that authorize a payment in full before a guest arrives, then capture the money when the guest checks out.

Publication 583's table of acceptable account statements lists, for a check, the date the check amount was posted to the account by the financial institution, and, for a credit card, the transaction date. That posting date is set by the bank, not by your document.

Set a window rather than hunting for an exact date:

• Where your card statement or software shows a transaction date as well as a posted date, compare the receipt with the transaction date first, and use the window for what remains.
• Search forward from the receipt date, and further for hotels, rentals, orders charged at shipment and checks.
• Search back a little too, since a deposit, a prepayment or an invoice issued after payment puts the charge before the document.
• Match to the posted transaction, not a pending one, because the final amount can still change.
• Search every card and account the purchase could have been paid from before calling a receipt unmatched.

What if the amounts differ?

A different amount is not a failed match when the difference has a documented cause. Confirm each cause from a document:

Never edit a recorded transaction's amount or date to agree with a receipt. The recorded transaction has to keep agreeing with the bank or card statement, because that agreement is what a reconciliation tests; bend it to the receipt and you bury the difference the match was meant to explain. If a recorded amount disagrees with the statement, settle that in the account's reconciliation, which is its own question; if you think the statement itself is wrong, contact the bank or card issuer. A difference with no documented cause is not a match: query it with the merchant straight away and, if you think the charge is wrong, contact the card issuer or bank promptly, using the contact details on your card or statement, rather than holding it until the pass ends. Dispute rights and their time limits are a separate question.

What if one receipt covers several charges, or several receipts one charge?

Not every correspondence is one to one:

Should you work from the transactions or from the receipts?

The side you drive the pass from decides what you can prove:

• From the recorded transactions. Every transaction is considered and ends with a document or a disposition, so you can say the books are supported. It cannot find a purchase that never reached the books.
• From the pile of documents. Every document is placed, which surfaces unrecorded purchases and purchases paid personally. It cannot show that every transaction has support, because bank fees, personal charges and purchases whose receipt never arrived never come up.

For a routine pass, drive from the transactions, then sweep the pile for anything still unplaced. With a long backlog, still drive from the transactions, but take the largest amounts and the documents hardest to recover first, rather than in date order, so the pass gives useful coverage even if it stops early.

Where should the match be recorded?

On the transaction itself. Attach the receipt file to the entry in your accounting software, or link to it, so anyone who opens the entry later sees its support without asking you. A match kept in a side spreadsheet is invisible to everyone else and disappears with the file. Publication 583 says all requirements that apply to hard copy books and records also apply to electronic storage systems that maintain tax books and records; that such a system must index, store, preserve, retrieve and reproduce the records in legible format and provide a complete and accurate record accessible to the IRS; and that if it does not meet the requirements, you may be subject to penalties unless you continue to maintain your original hard copy books and records in a manner that allows you and the IRS to determine your correct tax. So check that each attached image is legible and can be retrieved.

Check what your own product can attach and what it does with the document. Zoho Books' undated Documents help, for example, says a document added to a new transaction, matched with an existing expense or bill, or moved into a folder is automatically cleared from the Inbox; that attaching a file from the Inbox removes it from the Documents module permanently; and that to keep a file there, or use it in more than one new transaction, you move it into a folder first, from which it can still be attached. So confirm the pairing before you attach, and before deleting or re-entering a transaction that carries a document, check your product's help for what happens to the attachment. If your software cannot attach files, write the document's file name or number in the transaction's memo and store the file under that name. Record each disposition in the memo the same way. Attachment steps for a particular product are a separate question.

What do you do with what's left over?

Every leftover on either side gets exactly one disposition, recorded on the transaction or with the document, and stays open until it is acted on:

Treating every unmatched transaction as a missing receipt hides the two findings that matter most: spending that never reached the books and spending that was never business.

How does a mixed business and personal card change the pass?

On a card or account that also carries personal spending, many transactions correctly have no business document, so an unmatched line stops being a warning sign. Set the rule before you start: each line that is not business is labeled Not business when you reach it, with no receipt hunt. The reverse happens too: a business purchase on a personal card leaves a receipt with no line for it in the business's accounts, which is Paid personally, not a lost entry. How those items are recorded, and whether to separate the accounts, belong to the question of separating business and personal spending.

How do processor and marketplace deposits fit in?

A payout from a payment processor or marketplace is one bank line standing for many sales, less refunds and fees, so no single receipt or invoice matches it. The matching document is that payout's settlement report. Stripe's undated documentation on its payout reconciliation report says the report helps you match the payouts you receive in your bank account with the batches of payments and other transactions they relate to, and that its itemized download lets you review every payment, refund, dispute, fee and other balance transaction included in the payout. It says the report is only available with automatic payouts enabled (or to a platform whose connected accounts have them), points manual-payout users to its Balance report, and says that for instant payouts Stripe can't identify which transactions each payout includes, so you reconcile them against your own transaction history. The same page says weekends, holidays and bank processing can affect when the funds arrive, so give payouts a date window too. Where your processor gives you a report for each payout, attach it to the deposit and check that its net for that payout equals the deposit. Recording the gross sales and fees is a separate question, as is matching deposits and customer payments to invoices in a bank feed.

What does a worked pass look like?

This invented pass covers one business card for May, driven from the transactions and then swept from the pile:

At the end, every card line and every document has a match or a disposition.

How often should you match?

Run matching as a routine through the period rather than a year-end project, and finish it before you close each period, so every transaction in the closed period has a document or a disposition. The leftovers are exactly the items that need someone to remember what a charge was for, which vendor owes a copy or whether a purchase was personal, and that recall fades. Deferred to year end, the leftover pile is not merely late; much of it can no longer be resolved. A weekly receipt routine is a separate question.

Why isn't a fully matched pile a reconciled account?

They test different things. AccountingTools defines a bank reconciliation as comparing the cash balance in your accounting records with the corresponding balance on the bank statement, and says it should be supported by, among other records, documentation for reconciling items such as service charges, interest, transfers, returned checks and errors. Matching tests whether each recorded transaction has support. Service charges and interest have no receipt, so they never surface from the pile; a statement line that never reached the books never surfaces from the recorded transactions; and a transaction entered twice can carry the same receipt twice. In the other direction, an account can agree with its statement to the cent while no line has a document. Do both; reconciling an account to its statement is its own question.