Import Bank Statements Into QuickBooks for Taxes and Year-End Close

Tax time? Import a full year of bank statements into QuickBooks. Convert each PDF to a .qbo file, reconcile every month, and hand clean books to your CPA.

Totals reconcile to the original QuickBooks Online and Desktop Free to try, no card needed
Loved by bookkeepers and accountants 50K+ pages converted

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

At tax time you need every business bank transaction for the year inside QuickBooks, reconciled and categorized, before your accountant can file an accurate return. The live bank feed only reaches back about 90 days, so the rest of the year has to come in by file. The fastest way to do that is to convert each monthly bank statement PDF into a .qbo file and upload it, so all twelve months post with their real dates and amounts and reconcile to the statement.

Last updated July 2026. QuickBooks import paths and IRS retention rules can change; confirm the current guidance for your situation before you file.

Most small businesses hit the same wall in January or April. The books are months behind, the bank feed in QuickBooks only shows recent activity, and the return is due. Catching up means getting the whole tax year of checking and credit card activity into QuickBooks so income and expenses are complete, not estimated. Bank statements are the source record the IRS expects you to keep, and they are also the cleanest way to rebuild a year you never categorized.

The converter at the top of this page turns the statements you already have into .qbo Web Connect files QuickBooks imports the same way it imports a live feed. A full year is twelve uploads, a few minutes each, instead of typing hundreds of lines or fighting a half-mapped CSV. Below is how long to keep these records, how to bring a year in without creating duplicates, and the specific questions that come up at tax time.

Records to keepHow longWhy
Bank and credit card statementsAt least 7 yearsAccountant best practice; covers extended audit windows
Records supporting a filed return3 years minimumThe standard IRS audit period after you file
All records6 yearsIf you under-reported income by more than 25%
All recordsIndefinitelyIf you never filed, or filed a fraudulent return
Records for a bad debt deduction or worthless securities claim7 yearsThe only records the IRS specifically ties to seven years
Employment tax recordsAt least 4 yearsAfter the tax becomes due or is paid, whichever is later
Property and depreciable asset recordsUntil the limitations period ends for the year you dispose of the assetNeeded to figure depreciation, and gain or loss on the sale

Two habits keep a tax-season catch-up clean. Import statements oldest to newest so the running balance in QuickBooks builds in the right order, and never import a period you have also pulled through the live feed, or the same transactions land twice. Reconcile each month as you go so the year ties out before it reaches your accountant.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

Do you need bank statements for taxes?

Yes. Bank statements are the primary record that proves the income and expenses on your return, and the IRS expects you to keep the documents that support what you filed. For a business, that means having every account's full-year activity recorded in your books. Importing the statements into QuickBooks is how you turn them into usable, categorized records.

Can you file taxes with bank statements?

Bank statements are not a tax return, but they are the source you build one from. Your accountant works from categorized income and expenses, not raw PDFs, so the statements need to be entered and reconciled in QuickBooks first. Convert each statement to a .qbo file, import it, categorize the transactions, then file from the finished books.

How many years of bank statements do you need for taxes?

Keep business bank and credit card statements for at least seven years. The basic IRS audit window is three years after you file, but it stretches to six years if you under-reported income by more than 25%, and there is no limit if you never filed or filed a fraudulent return. Seven years is the common accountant standard, but it is worth knowing the IRS itself ties seven years only to a claim for a loss from worthless securities or a bad debt deduction, not to bank statements generally. The full breakdown is in our guide to how long to keep business bank statements.

How do I import a full year of bank statements into QuickBooks?

Download each month's statement from your bank, convert each PDF to a .qbo file with the converter above, then in QuickBooks Online go to Transactions, Bank transactions, Upload from file and import them oldest to newest. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Reconcile each month against the statement as you import it.

How do I import previous year transactions into QuickBooks Online?

Prior-year transactions come in by file, not the bank feed. The feed only pulls about the last 90 days, so it cannot reach last year. Convert each prior-year statement to a .qbo, or export a CSV your bank provides, and use Transactions, Bank transactions, Upload from file. The transactions post with their original dates so the year is complete.

Why does QuickBooks only download the last 90 days?

The 90-day limit comes from the bank, not QuickBooks. When you connect an account, most US banks only release roughly the last 90 days of transactions to the feed; a few reach back up to 24 months. Anything older has to be added by uploading a file. See how far back QuickBooks can import for the details.

How far back can I import bank transactions for taxes?

There is no date limit on uploaded files. The bank feed stops at about 90 days, but a .qbo or CSV you upload from file can cover any period, including several years back. That is what makes file upload the right tool for taxes: you can rebuild a complete prior tax year, or several, one statement at a time.

Can I upload a PDF bank statement to QuickBooks for taxes?

Not as a PDF. QuickBooks does not read a raw PDF bank statement; it imports .qbo, .qfx, .ofx, or CSV files. Convert the PDF to a .qbo first with the tool above, then upload that. The converter reads every transaction, checks the total against the statement, and outputs a file QuickBooks accepts as a standard bank feed.

How do I avoid duplicate transactions when importing old statements?

Import in date order and never overlap a period twice. Check your oldest existing transaction under the Gear icon, Chart of Accounts, View register, then upload statements that end just before it. Keep the live bank feed limited to dates your file imports do not cover. QuickBooks also flags likely duplicates in the For Review tab before you accept them.

Should I reconcile every month before filing taxes?

Yes. Reconciling each month against the statement is what proves your books match the bank, which is the whole point of importing the statements. Unreconciled or missing transactions are how income gets understated and deductions get missed. Reconcile month by month as you import, so by the time the year is loaded it already ties out to every statement.

What do I send my accountant from QuickBooks at tax time?

Once the year is imported, reconciled, and categorized, give your accountant access to the QuickBooks file or export the profit and loss, balance sheet, and general ledger for the tax year. Clean, reconciled books mean they can file directly instead of billing you to sort out missing or duplicated transactions first.

Does QuickBooks Self-Employed import old transactions for taxes?

Yes, but only by CSV, not .qbo. QuickBooks Self-Employed lets you upload older transactions from a CSV file in its settings, then categorize them as business or personal for your Schedule C. If your bank only gives you PDFs, convert them and export the CSV from the same tool so QuickBooks Self-Employed can read it.

How do I categorize a year of imported transactions for taxes?

After the statements are imported, QuickBooks lists every transaction in the For Review tab. Assign each one to the right income or expense account, set up bank rules to auto-categorize repeating vendors, and confirm anything ambiguous. Accurate categories are what turn raw bank activity into the deduction and income figures your return is built from.

Is it too late to fix last year's books before I file?

No. As long as you have the statements, you can rebuild a prior year in QuickBooks at any point before you file or amend. Convert each month to a .qbo, upload oldest to newest, reconcile, and categorize. Many businesses do exactly this catch-up in the weeks before a deadline, which is what the converter above is built for.

Convert your first statement free.

Upload a PDF, see every transaction extracted in seconds. No card to try it.

Still comparing tools? See our bank statement to QuickBooks converter comparison.

Related guides

For more on the mechanics, see how to import old bank statements into QuickBooks past the feed limit, the year-end close steps in QuickBooks, and what to do if QuickBooks won't import your .qbo file. Switching software this year? Follow importing bank transaction history when you switch to QuickBooks. Bookkeepers handling several clients at tax time should read bank statement to QuickBooks for accountants, and don't forget your credit card statements. While you catch up, a receipt scanning tool turns the year's receipts into deduction records, invoice data extraction to Excel handles vendor bills, and a CSV to QBO converter covers any account that only exports CSV.

More bank statements we convert to QuickBooks

Same converter, tuned for the layout each bank uses. Find yours: