One purchase, three records: match receipts to charges without counting twice

One restaurant meal can leave three records: the receipt, a pending charge in your banking app, and the final posted charge a few days later with the tip added. Add a transaction you typed in at the table and an imported statement, and it is easy to count the meal twice or to think it is missing. Card payments explain most of these gaps. Merchants such as restaurants, hotels, and gas stations often place an authorization hold for an estimate, and the final charge replaces it with the real amount, which can be lower or higher (Stripe, authorization holds explained).

This guide gives you a matching routine you can run once a week or once a month, a worked example with the usual mismatches, and a short list of what to do with records that still do not match. The example is fictional.

Why do receipts and bank charges not match?

Most mismatches have an ordinary cause. Check these before you decide a record is a duplicate or missing:

• Tips. The receipt you kept shows the bill before the tip. The posted charge includes it.
• Authorization holds. A pump or a hotel holds an estimate, then charges what you actually used. The pending amount you saw is not the final one.
• Split shipments. One online order can become two or three charges as items ship.
• Refunds and returns. A return arrives as a separate credit days or weeks later, not as a change to the original charge.
• Dates. The receipt shows the day you paid. The statement may show the day the charge posted, often one to three business days later.
• Merchant names. The statement can show a parent company or payment processor instead of the name on the shop.

How do you match receipts to a bank statement?

1. Choose one account and a date range. Match one card or bank account at a time, using a statement period or a week. Mixing accounts is how a cash receipt gets matched to a card charge.
2. Gather every record for that range. Receipts, order confirmations, the statement lines, and the transactions already in your budget.
3. Match on amount first. Exact amounts are the strongest evidence. Then confirm the merchant, then allow a few days of date difference.
4. Explain every near match. A charge that is $7.50 more than the receipt at a restaurant is probably the tip. Write the reason down.
5. Keep one record per real charge. The statement line decides what happened. The receipt adds detail, such as what you bought, but it is not a second purchase.
6. List what is left. Unmatched statement lines and unmatched receipts each go on a short list to check.

What does a matching worksheet look like?

Take Alex, a fictional reader checking one credit card for October 12 to 18. Alex has typed some purchases in by hand, scanned a few receipts, and imported the card's transactions.

Two records came out as duplicates, one was in the wrong account, and the order that looked short was complete. Nothing was missing. Without the worksheet, Alex's card spending for the week would have been $146.10 too high: the $50.00 manual bistro entry, the second $84.10 grocery record, and the $12.00 cash purchase.

When is a mismatch really a duplicate?

Two records are duplicates when they describe the same charge: same account, same merchant, and the same amount or an amount you can explain, such as a tip. They are not duplicates just because they look alike. You can buy the same coffee twice in one day, and a store can legitimately charge you twice for two separate orders.

When in doubt, leave both records and check the next statement. A pending charge that disappears, a second charge that turns into a refund, or a merchant that answers your question will settle it. Deleting a real purchase is harder to notice later than keeping a suspected duplicate for a week.

What do you do with records that still do not match?

• A statement line with no receipt. Search your email for the merchant, and check whether someone else in the household used the card. If you do not recognize the charge at all, contact your card issuer. For a credit card, the CFPB says to send a written dispute within 60 days of the statement that shows the charge (CFPB, disputing a credit card charge).
• A receipt with no statement line. Check the other accounts, then the next few days of the statement. A charge that never posts may have been paid in cash or cancelled.
• A receipt that covers several categories. Keep one transaction and split it, as setting a grocery budget shows for supermarket receipts that include household items.

How do you match receipts in Nethaven?

Nethaven helps with the parts that slow matching down, and leaves the decision to you. It does not match receipts to charges automatically.

• Search before you save a scan. On desktop, search covers your full transaction history, and filters narrow it by account, amount, date, and review state. Search for the amount in that account before saving a scanned receipt as a new transaction.
• Scan on mobile, review before saving. The mobile app can scan receipts and transaction screenshots. You choose the account and correct each proposed transaction before it is saved, which is the moment to skip a receipt that is already recorded.
• Keep unresolved items pending. Leave an uncertain transaction Pending and add a note, such as the order number, then mark it Reviewed once the statement confirms it. The review guide walks through this.
• Split mixed receipts. One charge can be split across categories while staying one transaction that matches the statement, which keeps your budget categories accurate.

If you import statements as files, the CSV import guide explains how to review imported rows, which is where duplicates with manual entries most often appear.