QuickBooks Bank Feed Skipped Weeks? Recover Missing Transactions
A gap in a bank feed can look alarming. Early July entries and this week’s entries appear, but the six week block between them never imports. In most cases that missing span is recoverable without retyping anything. Work through the checks in order.
First, confirm the gap is in QuickBooks rather than a filtered view
Open the bank account in QuickBooks Online and choose Transactions, then Bank transactions. Set the date range wide enough to cover the missing weeks. Look in both the For review tab and the Excluded tab. A narrow filter can hide entries, and a bank rule or duplicate prompt can send a run of transactions into Excluded.
Refresh the connection before changing any records
Select Update and give the feed a few minutes. If the bank connection dropped during those weeks, the feed may resume only from today, leaving a hole in the middle. Some banks also limit how much history the automatic feed sends after a long break. If the update returns new items but not the middle span, move to the file import step. For a stalled connection, our QuickBooks Online bank feed help covers the usual refresh and reauthorization steps.
Check excluded transactions and bank rules
Open the Excluded tab and scan the missing dates. A rule that matches a payee or amount can exclude several weeks of recurring charges at once. If you find valid entries there, select them and undo the exclusion. Review the bank rules list and turn off or adjust any rule that is too broad.
Compare the bank register with a downloaded statement
Log in to your bank and download a CSV, QBO, or OFX file for the missing dates. Open the QuickBooks register for the account and compare it line by line. If the bank’s own file shows no items in that span, the transactions may not have posted during that period. If the bank file shows them but QuickBooks does not, the feed simply missed them.
Import the missing span and reconcile the period
Use the import option on the same bank account to upload the file, map the columns, and review the incoming transactions before accepting them. QuickBooks checks for matches to help avoid duplicates, but glance at the imported list anyway. In QuickBooks Desktop, import the Web Connect file from your bank through the Bank Feeds menu. Then reconcile the affected period so the register and the bank statement agree. Download the bank file for just the missing dates and import it now; that closes the gap without waiting for the feed to catch up.