Your QuickBooks bank feed only goes back so far: how to fill the gap

Connecting a bank account to QuickBooks Online brings in recent transactions, not the account's whole history. If the books need to start earlier than the feed does, for a catch-up, a year-end request or a new client, the months before the feed have to come from somewhere else. Usually that means the PDF statements.

Why the feed stops where it does

• Intuit's help article on connecting accounts says download timespans vary by bank, from 90 days up to 24 months (Intuit, updated Oct 2026).
• The start date is also chosen when the account is connected. Intuit's walkthrough says the default is the beginning of the year, so a feed may start later than the bank allows.
• Don't assume a number. Check what your feed actually pulled.

1. Find the first feed date

1. Open the account's register (Chart of accounts, then View register on the bank account) and sort by date, oldest first.
2. Also check the For review and Excluded tabs in Bank transactions. Feed transactions that haven't been added yet sit there, not in the register.
3. Note the date of the earliest transaction that came from the feed. Everything before it is the gap.

2. Get the PDF statements for the earlier months

• Download one PDF per statement period from online banking, back to the month the books need to start. How many years online banking shows depends on the bank and account type. For older months, ask the bank for copies (some charge a fee).
• Name each file by account and period (for example 4821_2025-03.pdf) so a missing month is obvious.
• Also keep the statement that contains the first feed date. You need it for the boundary check in step 4.

3. Convert the statements

Turn each statement into a file QuickBooks accepts: QBO (Web Connect), QFX or CSV. Intuit's upload limits are 350 KB and 1,000 lines per file, so keep one file per month or split long periods. See QBO vs CSV vs OFX for which format to pick.

4. End the file the day before the feed starts

• The import file must stop on the day before the first feed transaction. If the earliest feed transaction is dated March 4, the file ends on March 3.
• Look at the boundary days on the statement and in the feed side by side. The feed and the statement can date the same transaction differently (posted date vs transaction date), so check a few days either side for anything that would appear twice or not at all.
• If a transaction does come in twice, exclude the extra copy in For review. See duplicate transactions after a bank upload.
• Upload oldest month first.

5. Check the opening balance and reconcile in order

• If the account has an opening balance entry from when it was set up, it is now in the middle of the history. Its amount and date should match the beginning balance of the oldest statement you are bringing in, or the register will be off by that amount.
• Reconcile one statement at a time, oldest first, to each statement's ending balance.
• If months after the feed start are already reconciled, be careful: changing the opening balance or anything already reconciled can throw off the beginning balance on the reconcile screen. See beginning balance doesn't match before you change anything.

6. Tie out each month before you import

1. For each statement: opening balance + deposits − withdrawals = closing balance.
2. Chain the months: each closing balance must equal the next statement's opening balance.
3. At the boundary, the balance after your last imported day should equal the account balance just before the first feed transaction.

If a month doesn't tie, find the missing or doubled row before you import. Our free tie-out checker shows the row where a CSV stops balancing.

QuickBooks Online can now read a PDF statement itself

Intuit's "Manually upload transactions" article (updated Aug 24, 2026) says QuickBooks Online accepts an account statement as a PDF or image, as well as QBO, QFX and CSV files (Intuit). For one or two missing months that can be the simplest route. See importing a PDF statement into QuickBooks Online. The same rules apply: stop the day before the feed starts and check the balances.

A converted file plus a per-month tie-out sheet tends to help more when:

• the gap is many months and you want each month proven against its statement before anything is posted;
• the books are in QuickBooks Desktop, which takes bank files through Web Connect (.qbo);
• the books are in Xero, which imports CSV or OFX statement files and, in Xero organizations in the US and Canada that are not on the Ledger plan, PDF statements too (Xero Central, Import a PDF bank statement). The same rule applies: import only dates before the feed starts; see statement into Xero;
• you need a plain CSV for a spreadsheet or a tax preparer, or a written tie-out to keep with the workpapers.

Bringing in many months at once? See importing multiple months of bank statements into QuickBooks.

The full routine is in how pros do catch-up.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.