Import PDF into QuickBooks: Import PDF Bank Statements to QuickBooks Online and Desktop

Q: Will importing the same PDF twice create duplicates?

Not with a .qbo file. Each transaction carries a unique ID and QuickBooks skips IDs it has already downloaded into that account.

Drag the PDF bank or credit card statement into the converter, check the transactions it read against the statement's closing balance, and download a .qbo Web Connect file. QuickBooks Online and QuickBooks Desktop both import that file as a normal bank download, with no column mapping, and the original PDF can be up to 10 MB.

Quick answer

To import a PDF into QuickBooks as bank transactions, convert the PDF statement to a .qbo file and upload it. In QuickBooks Online go to Transactions, Bank transactions, Link account, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Online can also read a PDF statement itself, but only files of 350 KB or less in English, and Desktop has no PDF statement import at all.

Drag and drop several PDFs at once Up to 10 MB per file QBO, IIF and CSV output

Import a PDF statement into QuickBooks

Drop the PDF here, review the rows, then download a .qbo file QuickBooks imports directly.

No credit card required to try your first statement.

350 KB

Largest PDF statement QuickBooks Online reads on its own, per Intuit's help

1,000

Transaction lines QuickBooks Online accepts in a single upload

PDF statement import options in QuickBooks Desktop, any edition

10 MB

Per PDF in this converter, room for long and scanned statements

Where each kind of PDF goes in QuickBooks

"Import a PDF into QuickBooks" means four different jobs depending on what the PDF is, and QuickBooks sends each one to a different screen. Getting the destination right first saves the afternoon people lose dragging a statement into the Receipts tab and wondering why it became one expense.

The PDF you have	QuickBooks Online	QuickBooks Desktop	What you end up with
Bank statement, one month or more	Link account, then Upload from file. Reads the PDF itself only at 350 KB or less; otherwise upload a .qbo file converted from it.	No PDF import. Convert to .qbo and use File, Utilities, Import, Web Connect Files, or to IIF on older versions.	Every transaction in the For review tab, ready to match and reconcile.
Credit card statement	Same Upload from file screen, into the credit card account.	Same Web Connect route, into the credit card account.	Charges and payments with the right signs, so the card balance ties out.
Single receipt	Receipts tab: drag and drop the PDF or image, then match or add it as an expense.	Receipt upload exists in Desktop Plus, Accountant and Enterprise.	One expense record with the PDF attached. Not a list of bank transactions.
Vendor bill or invoice	Add bill, then Upload from computer, and drag the PDF in.	Enter the bill and attach the PDF to it.	One bill with the document attached, one PDF at a time.

Sources: Intuit help articles "Manually upload transactions into QuickBooks Online" and "Upload your receipts to QuickBooks". This converter handles the first two rows: statements that need to become bank transactions.

Why dragging a PDF statement into QuickBooks rarely works

QuickBooks Online does accept a dragged PDF in three places, and the one people find first is the wrong one for a statement. These are the three things that go wrong, in the order bookkeepers usually hit them.

It lands in Receipts

The Receipts tab has the most visible drop zone in QuickBooks Online, so a statement dragged there gets read as a single receipt: one vendor, one date, one total. Forty transactions become one expense to delete. Bank statements belong on the bank account's Upload from file screen instead.

The file is over 350 KB

On the right screen, Intuit's published limit is 350 KB per statement, in English. A two page statement downloaded from online banking often fits. A scanned statement, a quarter of activity, or a PDF with the bank's logo pages usually does not, and gets refused before it is read.

It sits in review

When Online does read a PDF, Intuit says some statements are held for review by its team before the transactions post. A .qbo file skips that queue: it goes straight to For review in your own account, because the transactions are already structured.

How to import a PDF bank statement into QuickBooks

Step 1

Drop the PDF in

Drag one statement or a whole month of client statements into the converter above. Text PDFs from online banking and scanned or photographed statements are both read.

Step 2

Check the rows

Dates, payees and amounts appear on screen, withdrawals negative and deposits positive. Compare the total with the closing balance on the statement and fix any row that disagrees.

Step 3

Download the .qbo

Choose QBO for QuickBooks Online and current Desktop versions, or IIF for Desktop versions Intuit no longer supports. The QBO file carries the bank identifier Desktop checks before it reads anything.

Step 4

Import and match

Online: Transactions, Bank transactions, Link account, Upload from file, then pick the account. Desktop: File, Utilities, Import, Web Connect Files. Match or add each line in For review.

QuickBooks' own PDF upload or a converter: an honest comparison

If you run QuickBooks Online and your statements are small, English and one account per file, the built-in upload costs nothing extra and is worth trying first. The converter earns its price when any of the other rows below apply.

Situation	QuickBooks Online PDF upload	PDF to QBO converter
Small text PDF, QuickBooks Online	Works, included in your subscription	Works; faster when you have many
PDF over 350 KB or scanned	Refused	Up to 10 MB, scans read with OCR
QuickBooks Desktop or Enterprise	Not available	QBO for Web Connect, IIF for older versions
Twenty client statements this week	One file at a time, each into its own company	Drop them together, download one file per statement
Balance check before import	Side by side view, then Save	Closing balance shown against the extracted total
Waiting on a review queue	Some statements are held by Intuit's team	None; the file posts to For review immediately

Who imports PDFs into QuickBooks every month

Bookkeepers with statement-only clients

Some clients will never connect a bank feed. They email a PDF on the fifth of the month and expect the books closed by the fifteenth. On the Starter plan, 50 documents a month cost $49, which is under a dollar a statement against the half hour each one takes to key in by hand.

Desktop and Enterprise shops

Firms that stayed on QuickBooks Desktop have no PDF reader at all, and older versions lose Web Connect when Intuit ends support. The converter writes the .qbo file Desktop expects, or IIF for the versions where Web Connect has been switched off.

Owners catching up before a tax deadline

A bank feed only reaches back so far, so the months before it was connected exist only as PDF statements. Converting twelve of them to .qbo and importing oldest first rebuilds the register in an evening instead of a week of data entry.

Questions about importing PDFs into QuickBooks

How do I import a PDF into QuickBooks?

For a bank or credit card statement, convert the PDF to a .qbo file and upload it: Link account, then Upload from file in QuickBooks Online, or File, Utilities, Import, Web Connect Files in Desktop. For a receipt or bill, drag the PDF into the Receipts tab or the Add bill upload window instead.

Can you import a PDF into QuickBooks Desktop?

Not as bank transactions. QuickBooks Desktop has no PDF statement import in any edition, including Enterprise. You can attach a PDF to a transaction for reference, and Plus, Accountant and Enterprise can upload receipts, but a statement has to be converted to a .qbo or IIF file before Desktop will import its transactions.

How do I convert a PDF document to a QBO document to upload into QuickBooks Online?

Upload the PDF statement to a PDF to QBO converter, check the extracted transactions against the closing balance, and download the .qbo file. Then in QuickBooks Online choose Transactions, Bank transactions, Link account, Upload from file, select the .qbo, and pick the account it belongs to.

Can I drag and drop a PDF into QuickBooks Online?

Yes, in the Receipts tab, the Add bill upload window and the bank Upload from file screen. Only the last one turns a statement into bank transactions, and only for PDFs of 350 KB or less. Drag a larger statement into this converter instead, then drag the resulting .qbo file into Upload from file.

Why won't QuickBooks accept my PDF bank statement?

The usual reasons are size, language and edition. QuickBooks Online reads PDF statements of 350 KB or less in English, and QuickBooks Desktop reads none. Scanned statements, multi-month PDFs and statements with image-heavy pages exceed the limit. A .qbo file converted from the same PDF is a few kilobytes and imports in both.

Can QuickBooks import a credit card statement from a PDF?

The same rules apply as for bank statements. Online can read a small PDF card statement on the Upload from file screen; Desktop cannot. Converting the card statement to .qbo keeps charges as negative amounts and payments as positive, so the credit card account balances after import.

Will importing the same PDF twice create duplicates?

Not with a .qbo file. Each transaction carries a unique ID, and QuickBooks Online and Desktop skip IDs they have already downloaded into that account. That makes it safe to re-import a corrected file. A CSV has no such ID, which is one reason QBO is the safer format for statements.

How much does it cost to import PDF bank statements into QuickBooks?

Here, Starter is $49 a month for 50 documents, Plus is $149 for 200 and Pro is $499 for unlimited, with yearly billing at half the monthly rate. You can try a statement without an account first. For comparison, entering a 60 line statement by hand commonly takes half an hour or more.

Get the PDF into QuickBooks this afternoon

Drop the statement in, check it against the closing balance, and download a .qbo or IIF file that imports into QuickBooks Online or Desktop on the first try.

Convert a PDF statement now