How to get older bank transactions into QuickBooks
When you connect a bank to QuickBooks, the feed often brings in only recent history, commonly around 90 days, depending on the bank. Catching up on earlier months, a closed account or a new client's backlog means importing the transactions yourself. This is the order that keeps the books clean.
Columns (only if we guess wrong)
Column numbers in your CSV or Excel file, counting the first column as 1.
No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.
1. Decide where the books start
Pick the first month you need in QuickBooks and find that month's opening balance on the bank statement. Set it as the account's opening balance, or check that it matches what is already there. Every later step reconciles against it.
2. Collect the statements
- Months your bank still lets you download: get them as CSV (or QBO) from online banking.
- Older months and closed accounts: download the monthly PDF statements. Most banks keep several years of them online.
3. Convert one file per statement month
Upload the CSVs and PDFs to the converter above, together if you like. Each becomes its own QBO file covering exactly that statement's dates, with the balances checked for PDFs. Keep the file names in month order.
4. Import oldest first, then reconcile each month
Upload the QBO files one month at a time, starting with the oldest. After each month, review and accept the transactions, then reconcile against that statement's closing balance before moving on. A difference is much easier to find in one month than in a year.
5. Stop where the bank feed begins
When you reach the first date the live bank feed already covers, stop importing files. Overlapping dates are where duplicates come from; if a few slip through, exclude them in the For review tab.
Pricing
Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.
1 file
$9 per file
$9
10 filesBest value
$2.90 per file
$29
Unlimited files every month
$0.08 per file, billed monthly, cancel any time, fair use 500 files a month
$39/mo
Deleted after 24 hours
Your upload and the result are removed automatically.
Never used for training
Files are processed only to make your result.
Refund if it is wrong
If a result is unusable, we fix it or refund you.
Questions
How far back can QuickBooks download bank transactions?
It depends on the bank. Many feeds bring in about 90 days when you first connect; some go further. Anything older has to be imported from files.
Can I import several years at once?
You can, but import and reconcile month by month. QuickBooks Online also limits each upload to roughly 350 KB.
What if the bank only has PDFs for old months?
Convert the PDFs to QBO. Each statement is read, the balances are checked, and you get one QBO file per statement.