Import a PDF bank statement into QuickBooks

Quick answer

A bank PDF is a document, not a transaction file. QuickBankConvert turns it into a QBO file (Web Connect, on the Plus plan) or a CSV (free with a free account), and you check every row before it reaches your books. QuickBooks Online's transaction upload takes either, so the free CSV is a real option. QuickBooks Desktop's Web Connect reads only .qbo. QIF is for Quicken and similar programs, not QuickBooks.

QBO, CSV or QIF: which file for which QuickBooks

The accepted types come from Intuit's own instructions: Manually upload transactions into QuickBooks Online lists QBO, QFX and CSV, and Fix Web Connect import errors calls .qbo "the only type Web Connect can read" on Desktop.

The practical difference between QBO and CSV is the transaction ID. A QBO file gives every transaction a FITID, which is how an importing program recognises a transaction it already has. A CSV has no IDs, and you tell QuickBooks which column is which.

Step 1: turn the PDF into a file QuickBooks reads

1. Download the statement PDF from your bank's website. Use the PDF the bank generates, not a scan or a photo of paper: a native PDF contains real text and converts more accurately.
2. Upload it to the converter. The file goes to our servers over HTTPS and is parsed there. If the PDF is password-protected you are asked for the password.
3. Check the preview. Compare the first and last transactions and the closing balance with the statement. A wrong row is far easier to fix before it is in your books.
4. Download the file. CSV and Excel need a free account. QBO and QIF need Plus.

Page limits per statement: 10 on Free, 50 on Plus, 100 on Pro and Business. Files up to 4.4 MB.

Import into QuickBooks Online

These are Intuit's steps for a transaction file, from Manually upload transactions into QuickBooks Online (read on 4 October 2026):

1. Go to All apps, then Accounting, then Bank transactions.
2. Select the Link account dropdown, then Upload from file.
3. Select Drag and drop or select files and choose the .qbo or .csv file.
4. In the QuickBooks account dropdown, select the account the transactions belong to, then Continue.
5. For a CSV: match the columns in the file with the fields in QuickBooks, then Continue.
6. Select the transactions to import, then Continue.
7. Select Yes, then Done.

The transactions land in the bank feed for review. They are not in your books until you match or categorise them there.

Two limits from the same article: the file must be 350 KB or less, and it must be in English. A long statement can exceed 350 KB as QBO; if it does, convert the months separately and upload them one after another. Our file checker tells you the size and flags this.

Import into QuickBooks Desktop

Intuit's steps, from Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop (read on 4 October 2026):

1. In QuickBooks, go to Banking, select Bank Feeds, then Import Web Connect Files.
2. Select the .qbo file and select Open.
3. When asked for the bank account, choose Use an existing account if it is already in QuickBooks, or Create a new QuickBooks account.
4. Select Continue, then OK when QuickBooks confirms the data has been read.
5. Go to the Bank Feeds Center to review the transactions.

Read this before buying Plus for QuickBooks Desktop. Web Connect was designed for files that come from a bank, and Desktop has to recognise the bank identifier inside the file. Our QBO is built from your statement, not issued by your bank, and it carries a generic identifier. If Desktop answers "QuickBooks is unable to verify the Financial Institution information for this download", the unrecognised identifier is the likely reason. Intuit's upload instructions for QuickBooks Online describe no such check, but we cannot promise how either product treats a converted file. If Desktop is your only target, convert one statement and try the import inside the 7-day refund window described in the refund policy, and tell us what Desktop said.

The free route: CSV into QuickBooks Online

You do not need a paid plan to get a statement into QuickBooks Online. The CSV download is included with a free account (3 statements a month, up to 10 pages each), and QuickBooks Online imports CSV through the same Upload from file screen.

Our CSV has five columns: Date, Description, Category, Amount, Balance. Intuit asks for either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), so before uploading:

• Delete the Category and Balance columns in a spreadsheet, leaving Date, Description and Amount.
• Keep one date format. Ours are written YYYY-MM-DD throughout. If the matching step does not offer that format, change the column's format in the spreadsheet; Intuit recommends dd/mm/yyyy.
• Leave zero amounts blank. Intuit: "Leave any cells in Amount, Credit, or Debit that only contain zero (0) blank."
• Check the sign. Money out is negative and money in is positive in our file. For a credit card account, confirm on the first few rows that purchases arrive as spending.

What CSV costs you is the transaction IDs. If you upload the same period twice, there are no IDs for QuickBooks to recognise the repeats by, so check the bank feed for duplicates.

What is in the QBO file

The QBO export is an OFX 1.02 file with one record per transaction: posting date (YYYYMMDD, so there is no day/month ambiguity), signed amount, a payee name of up to 32 characters, the category as a memo, and a FITID. The ID is derived from the date, amount and description, so exporting the same statement again produces the same IDs. Two identical transactions on one statement (same day, amount and description) get different IDs, so neither is skipped as a repeat of the other.

Limits you should know about, because they affect the import:

• The account type is written as checking and the currency as USD. You choose the real account during the import, so this does not decide where transactions go, but a non-USD statement is still labelled USD inside the file.
• The bank identifier is generic, as described under QuickBooks Desktop above.

The full field list is on the PDF to QBO page.

Common import errors and how to fix them

Intuit lists the Desktop messages and its four troubleshooting steps in Fix Web Connect import errors. To see what is inside a .qbo file that will not import, drop it on the QBO file checker: it runs in your browser and reports missing IDs, bad dates, bad amounts and header problems.

QIF and the date-format option

QIF is offered on Plus for programs that still use it, such as Quicken and GnuCash. It is not a QuickBooks format. A QIF file does not say whether 03/04/2026 means 4 March or 3 April; the importing program applies its own regional setting. That is why the download has a date order option, MM/DD/YYYY or DD/MM/YYYY, which starts on your browser's regional order and applies to the QIF and Xero exports. QBO is unaffected: its dates are always YYYYMMDD. See PDF to QIF.

What it costs

• No account: preview the parsed transactions for one statement every 24 hours, up to 10 pages. No download.
• Free account: CSV and Excel downloads, 3 statements per calendar month, 10 pages each.
• Plus, $29 a month: adds QBO, QIF, Xero CSV, TSV and JSON, 50 statements a month, 50 pages per statement.
• Pro, $59 a month: adds batch upload and client labels, 200 statements a month, 100 pages per statement.
• Business, $99 a month: everything in Pro, 600 statements a month, 100 pages per statement.

Annual billing is available on all three paid plans. Current prices are on the pricing page.

Privacy

The statement is uploaded over an encrypted (HTTPS) connection and parsed on our servers, and a copy is stored. You can ask us to delete it through the contact page. We never ask for a bank login. The Privacy Policy says what is stored and who processes it.

This page describes file formats and import steps. It is not accounting or tax advice.

Related guides

• PDF bank statement to QBO
• PDF bank statement to QIF
• PDF bank statement to CSV
• Import a PDF bank statement into Xero
• QBO, OFX and QIF file checker
• For bookkeepers and accountants
• Statement guides by bank