QuickBooks Bank Feed Duplicates: Match or Add?
See how to investigate duplicate bank-feed entries in QuickBooks Online. Use a worked deposit example and a printable review log before changing your books.
Your bank statement shows one customer deposit. QuickBooks appears to show two. Before you remove either line, find out what each line represents. One could be the sales record and the other the downloaded bank activity waiting to be matched. Two receipts for the same amount might also belong to different customers. A repeated amount is a clue. The bank statement, the books and the supporting documents establish what happened.
This guide is for a U.S. small-business owner reviewing QuickBooks Online before asking a bookkeeper or independent QuickBooks consultant for help. It includes a worked example and a review log you can copy or print. Keep the live entries intact while gathering evidence, especially if the month has already been reconciled.
Match or add: what decision are you making?
Match connects a downloaded transaction to a record that already represents the activity in your books. Add or categorize can create a record from a downloaded line when the transaction has not already been recorded. If the sale or expense has already been entered, creating another record can count the activity twice. The wording you see can vary with your QuickBooks view. Check the suggested match before accepting it.
Start with three questions. Did cash actually move once or twice on the bank statement? Did someone enter the sale, payment or expense in QuickBooks already? Did a payment processor, invoicing app or point-of-sale system also send a record? A bank feed sees the movement of cash. It may not tell you which invoices made up a deposit or whether a processor kept part of the gross receipts as fees.
Worked example: two customers, one bank deposit
Consider a fictional repair business. On Monday, Customer A pays $700 and Customer B pays $500. The owner records both customer payments. The business takes one $1,200 deposit to the bank, and the bank posts that single deposit on Tuesday. The statement is correct. The difference between the customer lines and the bank line comes from grouping.
First, check that the two payments are recorded against the correct customers and invoices. Next, determine whether the books already have one deposit combining those payments into the correct checking account. If that $1,200 deposit exists and its date and support line up, the downloaded $1,200 is a candidate to match to that deposit. Adding a new $1,200 sale would describe money the business only received once.
If there is no grouped deposit, find where the two payments currently sit. Intuit documents how the Undeposited Funds account and bank deposit feature can combine customer payments to match a real deposit. Confirm that workflow fits the records you have. If an integration already grouped the payments or a staff member has already reconciled the period, ask the person responsible for the books to review the trail before entering another deposit.
When a $1,200 batch lands as $1,164
Suppose a third-party processor pays out that same $1,200 after withholding $36. The statement now shows $1,164. The bank line alone does not show the full customer receipts. Get the processor payout detail, confirm the $36 deduction and compare the payout reference and settlement date. In this simple example, $1,200 gross less $36 fees equals $1,164 deposited. If the processor also withheld a refund or moved money to a reserve, account for those separate items in your comparison.
Some processors make a gross deposit and withdraw fees separately. QuickBooks Payments can record deposits and fees through its own workflow. Look at the statement and the integration records for this specific bank account. Treat a $36 difference as a question to resolve. Posting another $36 expense when one already exists would introduce a second problem.
Printable duplicate-transaction review log
Use one row per suspected duplicate. Keep full statements, customer details and account numbers in your secure bookkeeping workspace. For an initial consultation, an account nickname, masked reference and the figures involved will usually make the question clear.
Statement evidence. Write the account nickname, statement month, posted date, amount and number of actual bank movements.
QuickBooks evidence. Record each candidate’s transaction type, amount, date, masked reference and source. Distinguish a bank-feed item awaiting review from an entry already in the register.
Supporting record. Note the invoice, receipt, transfer confirmation, payout detail or deposit slip that explains what happened.
Reconciliation status. Is the month closed or the entry reconciled? If unclear, mark it for the bookkeeper before making a change.
Decision. Choose “candidate match,” “possible duplicate,” “separate valid activity” or “more evidence needed.” Record the reason and the reviewer.
Closeout. Record what the reviewer approved and when. Recheck the statement balance and the affected invoice, fee or transfer afterward.
Filled example: Operating checking | Nov 3 | statement +$1,200 once | payments A $700 and B $500 | grouped deposit +$1,200 | deposit slip confirms both | period open | candidate match | reviewer to confirm. This log explains why the two customer payments should remain visible even though the bank shows one deposit.
Four common lookalikes
Credit card payment. Checking shows money leaving and the card account shows money arriving. Those can be the two sides of one payment. Review the card statement and the bank statement before classifying the payment as a new business expense.
Two equal vendor charges. The same supplier may bill two jobs at the same price in one week. Compare receipts, invoice numbers and posting dates. Two matching amounts and similar labels do not establish a duplicate.
Refund and original sale. A customer payment followed by a refund can have the same amount and opposite signs. Look at dates, transaction types and customer history. Removing the pair could erase a genuine sale and refund.
Overlapping imports. A CSV covering dates already downloaded through the bank feed can create a cluster of similar lines. Record the import window and compare references against the statement. The free duplicate transaction finder can flag candidates for review. Its results are a shortlist for inspection.
What if the transaction belongs to two different months?
A deposit entered late on the final day of one month can appear on the statement at the start of the next. Record both dates and the deposit reference in the log. Check the following statement before changing either entry. If a prior month has already been reconciled, keep its reconciliation report with the review notes so the person making a correction can explain any effect on the opening balance.
When to hire a QuickBooks consultant
A focused consultation makes sense when the issue concerns one payout workflow, an unclear match, or a repeated import. Ask for a written explanation of the example and a process your staff can repeat. A cleanup engagement may be more suitable if several months or accounts are affected, reconciliations no longer agree, or customer balances changed after prior edits. Missing months with little activity entered may also require catch-up work.
Bring the last reconciled month, one representative statement line and the corresponding records to your independent QuickBooks consultation. Use the cleanup preparation checklist for a larger review. When comparing quotes, ask which accounts and months are included, what supporting documents are required and how the reviewer will demonstrate the finished balances.
Product references: Intuit’s guides to matching QuickBooks Online transactions and grouping payments into bank deposits.
Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States
Get in touch
LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.