Skip to content

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.

Privacy policy · Refund policy

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.