How to Import Old or Historical Bank Statements into QuickBooks
Bank feeds usually only reach back 90 days, so to import old bank statements into QuickBooks you convert the older PDF statements to QBO or CSV and upload them manually. Import in non-overlapping date ranges to avoid duplicates with your existing feed.
Catch-up bookkeeping, a new QuickBooks file, or a tax deadline all create the same need: getting older transactions into QuickBooks. The live bank feed will not help, since most banks only share the last 90 days, so the answer is converting and uploading your historical statements.
Why the bank feed cannot do it
The automatic feed is designed for ongoing bookkeeping, not history. Once you connect an account, QuickBooks pulls roughly 90 days and then keeps it current. Anything older has to come in as a file import.
Step by step for historical statements
- Gather the PDF statements for the months you need to back-fill.
- Convert each one to QBO for the cleanest import, or CSV if you need a spreadsheet.
- Upload them under Transactions, Bank transactions, Upload from file, oldest first.
- Use non-overlapping date ranges so historical uploads do not collide with the live feed.
- Reconcile each period against the statement's opening and closing balances.
Avoiding duplicates with the live feed
The risk when back-filling is overlap. If your feed already imported the last 90 days, stop your historical uploads the day before the feed begins. Documentric's inline review and balance check help you confirm each statement's date range before you export, so the periods line up cleanly. Convert your historical statements to QBO to get started, or read about avoiding the QuickBooks import size limit on large back-fills.
Convert your first bank statement free
No account needed. Upload a PDF and get clean, structured data in under 60 seconds.
Try Documentric FreeFAQ
How far back can QuickBooks import bank transactions?
The live bank feed typically reaches back only about 90 days. To import older transactions, convert the historical PDF statements to QBO or CSV and upload them manually. There is no age limit on file imports.
How do I import several years of statements without duplicates?
Upload historical files in non-overlapping date ranges, oldest first, and stop before the date your live feed begins. Reconcile each period against its statement balances.
What format is best for historical imports?
QBO, because it has no size limit and imports without column mapping, ideal for back-filling many months at once. Convert each PDF statement to QBO before uploading.