Why receipts and bank lines drift apart
Reconciliation in QuickBooks Online compares your books with the bank statement. It answers one question: does the balance agree? It does not ask whether each charge has the receipt behind it. A month can reconcile to the penny while half the card charges have no support, and that only becomes a problem when a client is audited, a lender asks for backup, or a charge needs to be split between personal and business use.
The drift happens because receipts and bank lines arrive on different paths. The charge comes in through the bank feed on day two. The receipt sits in someone's truck, inbox or wallet until whenever. By the time it reaches the bookkeeper, the transaction is already categorized, maybe already reconciled, and attaching the receipt means searching for it by hand.
Worse, if the receipt is entered as a new expense instead of attached to the bank line, the cost is now in the books twice. That double entry often shows up later as a reconciliation difference that takes an hour to trace.
How matching by amount and date works
When a receipt arrives and is read, ReceiptQBO already knows its total, date, vendor, payment method and the last 4 digits of the card. It uses the amount and date to look for the matching charge.
The rule is simple on purpose: the same amount within a short date window around the receipt date. A window is needed because a card charge often posts a day or two after the purchase, and a hotel or fuel pre-authorization can settle later still. When more than one charge fits, the card digits and vendor on the receipt are what a person uses to tell them apart.
When there is a single clear match, the receipt is linked to it. When several charges could fit, for example two 45 dollar charges at the same coffee shop in one week, it is worth a human look in review rather than a guess.
Tips change the total. A restaurant receipt printed before the tip will not equal the charge that posts after it, which is why the tip is read as its own field. Receipts like that are the ones to check in review before month end.
Fwd: Your Lowe's receipt
Forwarded email, 2 min ago
IMG_4471.HEIC
Client link, 9 min ago
Invoice #88213 from Sunbelt Rentals
Gmail filter, 22 min ago
38 files from October folder
Batch upload, 1 hr ago
What it matches against, and what it does not
It is worth being exact here. ReceiptQBO matches receipts to two sources:
- Bank and card transactions already in QuickBooks Online, usually from the bank feed.
- Statements you import as CSV, OFX, QFX or QBO Web Connect files. This covers cards and accounts that are not connected to a feed, and catch-up work on old months.
It does not connect to banks itself and does not pull transactions from anywhere else. If a charge is not in QuickBooks and not in an imported statement, there is nothing to match, and the receipt is treated as a new purchase.
It also does not reconcile the account in QuickBooks for you. Reconciliation stays a step you or your team completes in QuickBooks Online. What changes is that by the time you reconcile, the receipts are already attached to the lines you are ticking off, and the missing ones are already listed.
Attach to the existing transaction, or create a new one
Once a match is found, the receipt image is attached to the existing transaction in QuickBooks. No new expense is created. The bank line keeps its place in reconciliation and gains the proof behind it.
When there is no match, ReceiptQBO creates a new record with the image attached:
- an Expense for something already paid, such as a cash purchase or a charge on a card that is not in QuickBooks yet,
- a Bill for a supplier invoice that still has to be paid. More on that on scanning bills into QuickBooks.
Before anything is created, the duplicate check runs. The same file, or the same vendor and amount within 3 days, is flagged and held. That catches the receipt that was forwarded by both the owner and the office manager.
The overall flow is described on how it works.
Expense, ready to post
96%- Vendor
- Sunbelt Rentals
- Account
- 6600 Equipment Rental
- Class
- Field Ops
- Location
- Round Rock
- Project
- Lakeview Deck Project
- Billable
- Yes, to customer
The missing receipts list
Matching works in both directions. Receipts look for bank lines, and bank lines that never got a receipt are collected into the client's missing receipts list. That list is the honest answer to "are we covered for this month".
On the Bookkeeper and Firm plans, the list drives the weekly reminder. On a weekday you choose, the client contact gets an email listing the charges without a receipt, plus the no-login upload link. The client sends photos from the phone, they are matched, and the list gets shorter on its own. A send-now button handles the push before month end.
For a practice, this changes the close. Instead of an email thread asking about a dozen charges, there is one list per client that clears as receipts arrive. The routine is laid out in a monthly workflow for missing receipts, and reminders are described on missing receipt reminders.
Before reconciliation, not instead of it
A useful way to think about it: ReceiptQBO does the receipt side of the month, and QuickBooks reconciliation does the balance side. When both are done, every line is backed by a document and the balance agrees with the bank.
A practical order for each client each month:
- Import any statement that is not on a bank feed.
- Clear the Review queue, starting with the lowest confidence receipts.
- Send the missing receipt reminder and give the client a few days.
- Reconcile in QuickBooks Online with receipts already attached.
On the Firm plan, the monthly reconciliation report lists what came in, what posted, what matched and what is still missing, which is a tidy record to hand to a CPA. Plans start at 49 dollars a month for one company. Upload a receipt on the QuickBooks receipt scanner home page to see how it reads.