When the bank connection has dropped and you're missing months of transactions, the fastest way to bring them in is by downloading them directly from your bank and uploading them to QuickBooks. Here's how to do both: recover the missing transactions and reduce the chance of the disconnection happening again.
Step 1: Upload the missing transactions
- Sign in to your bank's website and download your transaction history for the missing date range as a CSV file. Most banks let you choose the date range in the statements or account history section.
- In QuickBooks, go to All apps, then Accounting, then Bank transactions.
- Select the account, then select the Upload from file option (it appears near the Update button when the bank feed has an error or gap).
- Upload the CSV file. QuickBooks will map the columns (date, description, amount). Confirm the mapping and import.
- The imported transactions will appear in the For Review tab, where you can categorize or match them as usual.
If your bank exports in OFX or QFX format instead of CSV, those formats also upload cleanly.
Step 2: Fix the recurring disconnection
A connection that keeps dropping usually means one of the following:
- Your bank has posted a security notice or update that requires you to re-authorize the connection.
- Your bank's website was temporarily unavailable when QuickBooks tried to sync.
- Your bank requires re-authentication on a regular schedule (every few months is common).
To check and refresh the connection:
- Go to All apps, then Accounting, then Bank transactions.
- Select the account with the error.
- Select Update to trigger a fresh sync.
- If you see an error code, sign in to your bank's website directly and look for any messages, alerts, or new security prompts that need your attention.
If the disconnection keeps coming back after you reconnect, contact QuickBooks Live Support. They can look at the specific connection type for your bank and help set up a more stable sync.
If you have questions as you work through the import or reconnection, we're happy to help.
Helpful Resources: