QuickBooks Online Bank Feed Recovery: Matching, Duplicates, and Reconciliation

• Preserve statements, bank-feed state, registers, reconciliation reports, audit history, connection status, and the current difference before changing transactions.
• Match a download to an existing QuickBooks Online record when it represents the same economic event; categorize only when the download should create a new record.
• Exclude or delete only after evidence proves a true duplicate or error, and use Undo or accountant-guided correction when the item has already affected the books or a reconciliation.
• Diagnose opening, beginning, and ending balances separately, protect closed or previously reconciled periods, and escalate uncertain adjustments to the accountant.

Current Intuit guidance explains that downloaded bank transactions appear for review and do not affect the books until they are matched or categorized. Match when an existing QuickBooks Online record already represents the event. Categorize when the download should create a new transaction. For a bill payment, invoice receipt, check, transfer, payroll item, card payment, refund, or deposit, inspect the source document, counterparty, date, amount, account, and related records before accepting a suggestion. A plausible candidate is not proof.

Use duplicate handling narrowly. Current Intuit guidance notes that duplicates can occur after manual upload and automatic update, and allows a proven duplicate in review to be excluded. Excluded items do not enter the registers or financial reports and can be restored with Undo. Another Intuit guide warns that a personal expense generally should not be excluded merely to keep it off the profit and loss; it may need appropriate equity treatment so the bank register still reconciles. Ask the accountant when the accounting treatment is uncertain.

Correct already-reviewed items through the supported state. If a downloaded item was added or matched incorrectly, current guidance provides Undo, unmatch, or move workflows. If it has already been reconciled, Intuit explicitly advises contacting the accountant because unreconciling and correction can materially affect the accounts. Preserve the existing accounting record, match history, reconciliation status, and replacement plan. Never delete and recreate a reconciled item simply to make the feed look clean.

• Match only when the existing record and download represent the same economic event and intended account.
• Categorize a genuinely new item to the accountant-approved account, payee, class, location, project, and tax treatment.
• Use Exclude only after proving the download should not become a new accounting record.
• Use Undo to return an incorrectly reviewed item to review, then document the corrected disposition.
• Escalate changes to reconciled items, customer-paid invoices, payroll, sales tax, loans, and equity treatment.

An opening balance is the starting amount when the account begins in QuickBooks Online. A beginning balance in a new reconciliation reflects the prior reconciled state. The ending balance and ending date come from the current statement. Diagnose each separately. Current Intuit guidance for a first reconciliation directs the reviewer to find the Opening Balance Equity entry, compare its date and amount with the real statement, and confirm that no other transaction is incorrectly marked reconciled at that starting point.

For a previously reconciled account, begin with the saved reconciliation report and current beginning-balance discrepancy. Trace deleted, edited, unreconciled, or newly inserted prior-period transactions through the register and audit history. Do not overwrite the beginning balance with the current statement's opening number without understanding the prior change. If older transactions were added before the original starting date, their relationship to the opening balance must be reconciled or the same activity can be represented twice.

At the current statement end, verify the entered ending balance and date, then clear only the transactions on the statement. Current Intuit guidance lists missing or duplicate transactions, uncleared activity, incorrect ending information, and combined bank deposits as common causes. Narrow the difference by matching known-correct items, reviewing missing records and extra QuickBooks records, checking combined deposits, fees, transfers, and timing. Finish only when the difference is zero for the right reasons and preserve the resulting reconciliation report.

• Compare the opening-balance entry with the bank balance on the same date for a first reconciliation.
• Use prior reconciliation reports and audit history to explain a changed beginning balance.
• Enter the ending balance and ending date directly from the exact statement being reconciled.
• Trace combined deposits, outstanding checks, deposits in transit, transfers, fees, refunds, and late posting explicitly.
• Never use an unexplained adjustment merely to reach zero; obtain accountant approval and evidence.

Current Intuit guidance says downloaded items appear for review and do not affect the books until they are matched or categorized. That separation is central to recovery. Preserve the queue, determine whether an existing record already represents each event, and approve the accounting disposition before posting or excluding it.

Match when an existing QuickBooks Online transaction represents the same real-world event, such as a payment, bill payment, check, transfer, receipt, refund, or deposit. Verify the account, date, amount, counterparty, and related document. Categorize only when the download should create a genuinely new accounting record.

Exclude only after evidence proves the downloaded item duplicates an existing accounting record or otherwise should not enter the books. Confirm the statement, register, source document, and match history. An excluded item can be restored with Undo. If the treatment is uncertain or the item is reconciled, consult the accountant first.

Not automatically. Intuit guidance notes that excluding a personal transaction can make the QuickBooks register fail to match the bank statement. It may need to be recorded to an accountant-approved equity account such as owner's draw. Ask the accountant for the correct treatment rather than hiding the cash movement from reconciliation.

Not as the first response. Current Intuit guidance warns against disconnecting while a bank-connection error remains because a reconnect may download duplicates. Capture pending items and evidence, verify bank and browser status, resolve the connection error, and define the date boundary before any approved disconnect or reconnect.

A documented accountant-approved adjustment can be appropriate in limited circumstances, but it should not be a shortcut. First verify opening, beginning, and ending balances, missing and duplicate transactions, combined deposits, transfers, fees, timing, prior reports, and audit changes. An unexplained adjustment hides the root cause and can distort reports.

Escalate changes to reconciled or locked periods, opening balances, customer-paid invoices, payroll, sales tax, loans, equity, uncertain duplicates, unsupported journal entries, or material differences. The support team can preserve evidence and test product behavior, but the accountant should approve treatment that changes financial statements or prior closes.