Importing old bank statements into QuickBooks Online

Why QuickBooks Online's bank feed doesn't reach back that far

• QuickBooks Online's own instructions say that when you connect a bank or credit card account, QuickBooks automatically downloads transactions only up to a certain date. If you can't connect the account, or want transactions from before you connected it, its manual-upload process is what to use instead.

  https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US

• For a catch-up, identify the missing dates in the account first: Intuit’s upload guide asks for a source record beginning at least one day before the oldest QuickBooks transaction, while a gap within an existing history requires selecting the missing transactions within that gap.

  https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US

Checked 2026-09-28.

Catching up years of statements at once

1. 1If your firm chooses the Arkrel conversion route, convert the statements needed for each account and keep the original files with the output. Select the history to add before importing it into QuickBooks.
2. 2Arkrel totals every row against the opening and closing balance printed on each statement before export, and shows any mismatch in our reading. The results identify the affected transaction numbers when running-balance checks locate them.
3. 3Import the QuickBooks CSV one account at a time, selecting the transactions needed for the missing period after comparing them with pending bank activity and existing account records, then match, categorize and reconcile in QuickBooks Online.

Prepare a client backlog for QuickBooks review

A client’s folder may contain records for a period that is already partly entered in QuickBooks. Before bringing in the missing history, decide which account and transactions each file is meant to add. Keep that decision with the import file so the next person can see what happened.

Separate source coverage from the import range

Keep the original statement intact. Its full period helps you check the extracted activity, even when only part of that activity belongs in the next import. Compare the proposed rows with the client’s QuickBooks account, including bank activity still waiting for review and entries already recorded.

For a gap in the middle of a year, identify the missing interval rather than treating everything before the latest transaction as absent. A client who resumed bookkeeping in July may still need March through May reviewed. Your firm decides which rows are missing and which need attention in the existing books.

Check QuickBooks rules before importing older activity

Review the destination account’s bank rules before uploading the backlog. QuickBooks auto-post rules can run when a file is uploaded and add matching transactions to the books. Check whether the rules fit the older activity and agree on any needed changes through your firm’s normal review process. After import, inspect rule-applied and automatically posted transactions as well as items still awaiting review.

Keep a record for each import batch

Use your firm’s own workpaper to record the destination account, original statement filename and period, import filename, selected date range, and import date. Add the rows you deliberately left out and the reason, such as activity already present from a bank feed or an earlier import.

Use a separate entry when a revised file arrives. Identify what changed before trying it again. Keeping the original source and the submitted file together makes it easier to investigate a later discrepancy without repeating the whole batch.

Review existing records before adding new ones

After import, check whether an incoming bank transaction relates to something already recorded, such as an invoice payment or a card payment. QuickBooks matching links bank activity to existing records; categorizing an unmatched item creates a new record. Review the underlying activity before choosing the action.

An absent match suggestion still needs investigation when you know the transaction was recorded. Older dates, combined deposits or an already reconciled entry can affect the available suggestion. Use the client’s supporting records and the existing account history to decide what should happen.

Finish the accounting review in QuickBooks

Check the imported range against the source, resolve the remaining questions, and reconcile the account in QuickBooks as part of the agreed work. Record which period your firm completed and which items remain open. A later file or client answer should have a named next action.

Use the QuickBooks import instructions for the file format and upload steps. Keep your client’s Arkrel statement review and your firm’s QuickBooks accounting work clearly assigned throughout the process.

Every statement checked before you download

Arkrel reads the transaction table in any bank's PDF, not a specific bank's template, the same way whether you're converting one statement or a hundred: the opening balance, plus every credit, minus every debit, must equal the closing balance, and on a statement that prints a running balance, each row must follow from the one before it. A statement that fails either check is still exported when you ask for it, but the download is marked, and the dashboard or free tool shows any reconciliation mismatch. The results identify the affected transaction numbers when running-balance checks locate them.