Week 3: Matching Made Simple : Connect Bank Transactions to What's Already in QuickBooks
Welcome to Week 3 of QuickBooks Without the Guesswork, our 10-week guide to making your books clearer, calmer, and easier to manage.
In Week 2, we looked at bank feeds, which bring transactions from your bank account into QuickBooks Online (QBO). This week, we’re talking about what happens next: connecting those downloaded transactions to the invoices, bills, payments, checks, and expenses you may have already entered.
That connection is called matching.
It sounds simple because it is simple: once you know what to look for. Think of matching as introducing two transactions that already belong together:
“Bank deposit, meet customer payment. Customer payment, meet bank deposit.”
No awkward small talk required.
What Does Matching Mean in QuickBooks Online?
When a transaction appears in your QBO bank feed, QuickBooks may recognize that the same transaction has already been recorded in your books.
For example:
You created an invoice for $1,200.
Your customer paid that invoice.
You recorded the customer payment in QBO.
The $1,200 deposit now appears in your connected bank account.
The bank feed transaction and the customer payment are two views of the same activity. Matching tells QBO that they belong together.
When you match them, QBO connects the bank activity to the existing record instead of creating a brand-new income transaction.
This is different from adding or categorizing a transaction. Adding means the transaction is new to your books. Matching means the transaction is already there: you are simply linking it to the bank activity.
Match Instead of Add When:
Use Match when the transaction has already been entered in QBO as an:
Invoice payment
Bill payment
Check
Expense
Sales receipt
Bank transfer
Credit card payment
Other existing transaction
Use Categorize or Add when the bank transaction is new and has not already been recorded.
This distinction is one of the most important habits in everyday bookkeeping. Choosing the wrong option can make your income or expenses appear twice. And while double income may sound exciting for about three seconds, it makes your reports: and possibly your tax return: very unhappy.
How the Find Match Feature Works
To review your downloaded transactions:
Open QuickBooks Online.
Go to All apps.
Select Accounting, then Bank transactions.
Choose the bank or credit card account you want to review.
Find the transaction in the For review section.
Click the transaction to expand its details.
QBO may display a suggested match. If the suggestion looks correct, you can review it and select Match.
If QBO does not suggest the correct transaction: or does not suggest one at all: look for Find match, Find other matches, or a similar option. The wording can vary slightly depending on your QBO version and account settings.
The Find Match window lets you search existing transactions using details such as:
Date range
Amount
Customer
Vendor
Transaction type
You can then select the record or records that belong with the bank transaction.
The key requirement is that the selected transaction total should generally equal the amount shown by the bank.
Always Review the Suggested Match
A suggested match is helpful, but it is not a substitute for reviewing your books. QBO is making an educated guess based on details it sees. Sometimes it is right. Sometimes it has confidently invited the wrong transaction to the party.
Before selecting Match, review four things.
1. Date
Does the date make sense?
A deposit may reach your bank a day or two after a customer payment is recorded. A weekend, holiday, or payment processor may create a timing difference. But a transaction dated several months away deserves a closer look.
2. Amount
Does the amount match exactly?
A $750 bank deposit should generally connect to a $750 payment or a group of existing payments totaling $750. If the amounts do not agree, pause before matching.
3. Payee or Customer
Is the money connected to the correct customer or vendor?
Business names can look similar, especially when vendors use payment processors or abbreviated bank descriptions. Confirm that the transaction belongs to the right business relationship.
4. Related Transaction
What record is QBO suggesting?
Open or review the related invoice, bill, check, payment, or expense. Make sure the transaction reflects what actually happened: not merely something with a similar amount.
A few seconds of review can save a lengthy cleanup later.
Matching Customer Payments to Invoices
Let’s say you sent your customer, Green Oak Design, an invoice for $2,400. You entered the invoice in QBO, and later recorded the customer’s payment.
When the $2,400 deposit appears in the bank feed, QBO may suggest the existing payment. Review the customer, date, amount, and invoice details. If everything lines up, select Match.
For deposits that combine several customer payments, Find Match can be especially useful.
For example:
Customer A paid $500.
Customer B paid $800.
Customer C paid $700.
The bank deposit shows $2,000.
You can select the three related payments if their total equals the deposit. QBO then connects the combined deposit to the payments already recorded.
This helps your accounts receivable records stay accurate. Your customer invoices show as paid, your income is not overstated, and your bank account reflects the actual deposit.
Matching Vendor Bills to Checks and Expenses
Matching works on the expense side, too.
Suppose you entered a $425 vendor bill in QBO. You later paid it by check or electronic payment, and the withdrawal appears in your bank feed.
Use Find Match to locate the related bill payment or check. Review the vendor, date, amount, and account details before selecting Match.
You may also match a bank withdrawal to an expense that was already entered manually. This can happen when:
Someone recorded a receipt before the bank feed downloaded.
A bookkeeper entered expenses from source documents.
A recurring vendor payment was entered ahead of time.
A check was created in QBO before it cleared the bank.
In each case, the goal is the same: connect the bank activity to the existing bookkeeping record rather than recording the expense again.
What If QBO Cannot Find a Match?
No match does not always mean something is wrong. It may simply mean the related transaction has not been entered yet.
If you cannot find a match, ask:
Was the invoice, bill, payment, or expense actually recorded?
Is the date range wide enough?
Is the amount correct?
Is the transaction in the right bank or credit card account?
Could the bank have combined multiple transactions into one deposit?
Could a payment processor have withheld a fee?
If the transaction is genuinely new, switch from matching to Categorize or Add. This records the bank transaction and assigns it to the appropriate income, expense, asset, liability, or other account.
When a transaction includes multiple components, you may need to use Split. For example, a deposit could include customer payments minus a processing fee. The bookkeeping treatment should reflect the gross customer payments, the fee, and the net amount deposited.
When the situation is unclear, it is better to pause than to force a match. A mystery transaction does not become less mysterious because we click a button quickly.
Common Matching Questions
Why does QBO suggest a match?
QBO compares the bank transaction with records already in your books. It may consider the amount, date, payee, customer, transaction type, and other available details.
A suggestion is a starting point: not an automatic approval.
What if the amounts differ slightly?
QBO generally expects the amount of the existing transaction or selected transactions to equal the downloaded bank amount.
A small difference could be caused by:
A payment processing fee
A foreign currency conversion
Rounding
A tip or adjustment
A partial payment
A bank error
Do not force the match. First determine why the amount differs. You may need to adjust the transaction in QBO, record the fee separately, create a deposit that reflects the net amount, split the bank transaction, or exclude the bank line after recording the activity correctly.
For more detailed guidance, review Intuit’s instructions for matching online bank transactions in QuickBooks Online.
What about partial payments?
A partial payment usually needs to be recorded for the amount actually received. For example, if a customer pays $500 toward a $1,200 invoice, record the $500 payment against that invoice.
When the $500 deposit appears in the bank feed, you can match it to the $500 payment.
If a single bank transaction does not equal the existing QBO transaction, QBO may not allow a direct match. In that case, record the payment correctly first and determine whether the bank feed transaction should be matched, split, or excluded.
Why Matching Matters for Accurate Bookkeeping
Matching is a small step with a big impact.
When transactions are matched correctly:
Income is not recorded twice.
Expenses are not duplicated.
Invoices and bills show the correct payment status.
Accounts receivable and accounts payable are more reliable.
Profit and loss reports are easier to trust.
Bank reconciliations are less stressful.
Your financial story is clearer.
This is where good bookkeeping becomes more than data entry. It is about connecting the details so your financial reports reflect what really happened.
At Ledgers By Liisa LLC, our approach is Clear. Creative. Calm. We keep two eyes on your books so you can spend less time wondering whether a transaction was entered, matched, or accidentally invited in twice.
The Tip Jar: Match Before You Add
Before you select Add or Categorize, ask one simple question:
“Could this transaction already be recorded somewhere in QuickBooks Online?”
If the answer might be yes, use Find Match and investigate first.
A good matching routine is:
Review the suggested match.
Confirm the date, amount, customer or vendor, and related transaction.
Search Find Match if needed.
Match only when the details make sense.
Categorize or add the transaction when it is genuinely new.
Stop and investigate amount differences instead of forcing the match.
That routine helps keep your books accurate without making bookkeeping feel like a scavenger hunt.
Need help matching transactions or setting up a reliable QBO workflow? Book a QuickBooks Online coaching session for personalized support, or schedule a consultation and advisory session. If you would rather have an expert handle the details, explore our monthly bookkeeping services.
Visit www.ledgersbyliisa.com to connect with Ledgers By Liisa LLC and keep two eyes on your books.
Comments