How to Recover Missing Bank Transactions in QuickBooks Online (USA)

You can recover missing transactions in QuickBooks Online (USA) even if you skipped reconciling for several months and your bank connection became inactive. The recovery steps depend on how your bank feed was connected and how much data QuickBooks Online was able to download.

What You Should Try First

1. Reconnect the Bank Feed

• Go to Banking/Transactions and reconnect your existing bank account.
• When reconnecting, QuickBooks Online (USA) usually allows you to select a start date. Choose the date immediately after your last completed reconciliation.
• After reconnection, select Update in the Banking screen to refresh the feed and pull in the newest transactions.

2. Review the Banking Tabs

• In the Banking → For Review tab, check whether the missing transactions are waiting to be categorised.
• Review the Categorized and Excluded tabs as well, in case earlier transactions were auto-sorted or excluded by mistake.

3. Check the Account Register

• Go to Chart of Accounts → locate your bank → click View Register / Account History.
• If transactions exist in the register but were never matched or categorised, you will need to clean them up manually.

When the Bank Feed Cannot Pull Older Transactions

Some USA banks only allow QuickBooks Online to download up to 90 days of historical data. If you skipped many months, you may need to import the older transactions manually.

• Download a CSV, OFX, or QBO file from your bank’s USA online banking portal for all missing months.
• In QuickBooks Online (USA), go to Banking → Upload Transactions and import the file.
• Map the columns correctly and complete the upload.

After importing the file, you must categorise and match each transaction so your books remain accurate and duplicate-free.

Recovery Steps for This Scenario

1. Identify the last date your bank account was fully reconciled in QuickBooks Online.
2. Reconnect the account and select a start date that begins the day after your last completed reconciliation.
3. Update the bank feed to download as many transactions as your USA bank allows.
4. Download the missing months directly from your bank and import them manually.
5. Match, categorise, or clean up all transactions to avoid duplicates.
6. Reconcile month by month (or quarter by quarter) until you reach the current period.
7. Set up a consistent monthly reconciliation routine to prevent future gaps.

Important Pitfalls to Avoid

• Do not create a new bank account inside QuickBooks Online when reconnecting; you must reconnect the existing one to avoid duplicates.
• Most USA banks limit automatic downloads to roughly 90 days, so older transactions will require manual import.
• Imported transactions still require review, matching, and categorisation.
• If several months were skipped, your opening balance may be incorrect and may require adjustment.
• If transactions were deleted when the bank feed was disconnected, they must be restored or manually re-imported.