Match receipts to bank transactions in QuickBooks Online, a practical guide

What matching actually means in QuickBooks Online

In QuickBooks Online, a bank or card transaction and a receipt are two separate records of one purchase. The bank feed tells you money left the account. The receipt tells you what was bought, from whom, and how much was tax. Matching joins the two so the books hold one transaction with full evidence behind it.

QuickBooks uses the word match in a few places, and that causes confusion. In the bank transactions screen, matching means linking a downloaded bank line to a transaction already recorded in the books, such as a bill payment or an expense you entered by hand. In the receipts list, matching means pairing an uploaded receipt with a bank line so the receipt image gets attached. Both lead to the same goal: one purchase, one transaction, one attached document.

Getting this right matters for more than tidiness. Sales tax amounts come from the receipt, not the bank line. Job costing often needs the line items. And when a client is audited, a categorized charge with the receipt attached answers questions that a bare bank line cannot. This guide covers the manual method in QuickBooks Online first, then how ReceiptQBO handles the same job across many clients.

Why you should match instead of adding

When a receipt arrives, the fastest-looking action is to create a new expense from it. That is also the action that causes the most cleanup. If the card charge is already in the feed, adding the receipt as a fresh expense puts the purchase in the books twice. One copy gets categorized from the feed, the other from the receipt, and the profit and loss shows double the cost.

Matching avoids that by design. The bank line is the record of payment. The receipt becomes its evidence. Nothing new is created.

There are a few cases where adding is correct. Cash purchases have no bank line. A purchase on a card or account that is not connected to QuickBooks has no feed line either, unless you import the statement. Owner spending on a personal card that the business reimburses needs its own entry. Outside those cases, assume there is a bank line waiting and look for it before you create anything. We cover the duplicate side of this in our guide on how to scan receipts into QuickBooks Online.

The manual method in the For review tab

Here is the routine most bookkeepers use in QuickBooks Online. Menu names shift a little between QuickBooks views, but the steps are the same.

1. Upload or forward the period's receipts so they sit in the company's receipts list.
2. Open the bank transactions screen and choose the bank or card account.
3. Stay on the For review tab. Each downloaded line that has not been accepted is listed here.
4. Click a line to expand it. Where QuickBooks has found a likely partner, it suggests a match. Compare amount, date and payee with the receipt.
5. If the suggestion is right, confirm it. If there is no suggestion, use the option to find other records, and search by amount or a date range.
6. For lines you categorize directly, add the receipt as an attachment before you accept the line, so the image stays with the transaction.

Work one account at a time and finish it before moving on. Jumping between cards makes it easy to accept a line on one card that belongs with a receipt for another. When the For review tab for an account is empty, every line from that period has been either matched or categorized.

Why matches fail and how to spot the cause

QuickBooks suggests matches when amount and date line up closely. When they do not, the match is missed, and a preparer often creates a new expense instead. Knowing the usual reasons helps you find the partner quickly.

• Tips. A restaurant receipt shows the pre-tip total, or the tip is handwritten. The card charge is higher.
• Posting delays. The receipt date is the purchase day. The card line may post one to three days later, and longer over weekends and holidays.
• Hotel and fuel holds. The final charge differs from the first amount you saw.
• Foreign currency. The receipt is in euros or Canadian dollars, and the card line is in US dollars after conversion and fees.
• Payee names. The statement shows a processor code or a parent company, not the store name on the receipt.
• Split shipments. One order produces two charges, or two receipts produce one charge.

When a receipt will not match, search the feed by amount first, then by a wider date range, then by payee. Most missing partners turn up in the first search.

Handling tips, refunds and split charges

Some cases need a small decision, not just a click. Here is how to handle the common ones cleanly.

Tips. Match the receipt to the higher card amount. Record the full card amount, and if your client tracks tips separately, split the line between meals and the tip.

Refunds. A return shows as money coming back on the card. Match it to the refund receipt or credit note, and record it against the same expense account as the original purchase. Do not create a new purchase from a refund slip.

One charge, two receipts. Attach both receipts to the single bank line, and split the line across the right accounts if the receipts cover different kinds of purchase.

Two charges, one receipt. Attach the receipt to both lines and note the split in the memo, so a reviewer understands why one document appears twice.

Bills paid by card. If the vendor invoice was entered as a bill, the card line should be matched to the bill payment, not categorized to expense. Otherwise the bill stays open and the cost is counted twice. More on that side is on our page about scanning bills into QuickBooks.

When the bank feed is missing or incomplete

Matching needs bank lines to match against. Sometimes they are not there. A bank connection breaks, a small credit union does not support a feed, or a client opens a new card and does not tell you. Receipts pile up with nothing to pair with.

The fix is to import the statement. QuickBooks Online accepts statement files in several formats, and most banks offer at least one of them for download: CSV, OFX, QFX, or QBO Web Connect files. Import the period you are missing, and the lines appear for review just like feed lines. Then match receipts as usual.

Two cautions. First, when a feed is reconnected after a break, it sometimes downloads lines you already imported. Check for duplicates in the overlap period before you accept anything. Second, CSV files vary by bank, so check that amounts and signs come through the right way round, with charges as money out.

Keep a short note for each client listing which accounts are on a live feed and which need a monthly statement import. That note saves a surprising amount of time when a different preparer picks up the file.

How ReceiptQBO matches receipts across clients

The manual method works, but it is done inside one company at a time, and the receipt and the bank line often reach you on different days. ReceiptQBO, a QuickBooks receipt scanner built only for QuickBooks Online, does the pairing as receipts arrive.

Each receipt is read for vendor, date, total, tip and payment method, including the card's last four digits when the receipt shows them. It is then matched by amount within a short date window to bank and card transactions already in QuickBooks, and to any statements you import as CSV, OFX, QFX or QBO Web Connect files. A matched receipt is attached to the existing transaction instead of creating a new expense. A receipt with no bank partner is posted as an Expense or a Bill with the image attached, coded to the client's own accounts and classes.

A duplicate check runs alongside. The same file fingerprint, or the same vendor and amount within three days, is flagged and not posted. And bank lines that still have no receipt form the client's missing receipts list. See receipt to bank matching for details.

Checks to run before you reconcile

Matching is the step before reconciliation, and a few checks make reconciliation quick.

• The For review tab for each account is empty, or holds only lines you are asking the client about.
• Every line above the client's documentation limit has a receipt attached or a written note in the memo.
• No two expenses share the same vendor and amount within a few days unless you know why.
• Open bills were reviewed against card and bank payments in the period.
• Refunds were recorded against the original expense account.
• Accounts without a feed had their statements imported for the full period.

When these checks pass, reconciliation is usually a matter of confirming the ending balance. When they fail, it is far easier to fix them now than after the statement is reconciled and the period is closed. If a lot of lines are still missing receipts, our guide to a monthly missing receipts workflow covers how to ask clients for them without nagging.

Questions about matching receipts to bank transactions

Where do I match receipts in QuickBooks Online?

In the bank transactions screen, on the For review tab, or from the receipts list where QuickBooks suggests a bank line for each uploaded receipt. Confirm the match instead of creating a new expense.

Why does a receipt not match its card charge?

Common causes are tips, posting delays, foreign currency conversion, and payee names that differ between the receipt and the statement. Search the feed by amount and a wider date range.

What if the bank account has no feed?

Import the statement as a CSV, OFX, QFX or QBO Web Connect file, then match receipts against the imported lines.

Does ReceiptQBO create a new expense for matched receipts?

No. A receipt matched to an existing bank or card transaction is attached to that transaction. A new Expense or Bill is created only when no match exists.