Convert a PDF bank statement to CSV for QuickBooks

Why the check matters more for an import than for a spreadsheet

If a converted spreadsheet is wrong, you are looking straight at it. If the same rows are already in QuickBooks, you are not looking at them any more. The error waits, and it usually reappears as a bank reconciliation that will not close, on a day you had set aside for something else.

"I converted mass amounts of data and was happy until I went to import it into QBP and noticed the errors. Didn't really save me much time overall."

Elaine M., review of DocuClipper, Capterra, 29 June 2023 — capterra.com

The order matters: the file looked fine, it went in, and the errors were found afterwards. The time the tool saved came back out again.

How much of it comes back depends entirely on how far the rows have travelled. Caught in the review queue, a bad batch is a bulk delete and a re-import, and both QuickBooks and Xero have one. Caught after the rows are categorised and reconciled, or once the period is filed, the cheap routes are shut: the reconciliation has to be unwound first, and people have described paying an accountant to do it. That is the trap, and it is a matter of timing rather than difficulty.

So the arithmetic runs before the file exists. Opening balance plus every transaction has to equal the closing balance the statement itself prints. You get the answer on this page, while the only thing at stake is a download.

That is what a failure looks like here, shown on purpose. A tool that only ever displays its successes gives you nothing to judge it by, and the case you need warning about is exactly the one it would be hiding.

A PASS is a narrow claim, and worth stating narrowly: on this file, the money adds up. It does not certify every date and description, and you can re-add the column yourself in a minute to check the claim rather than take it.

What the file contains

Three columns, in this order.

Amounts carry no currency symbol and no thousands separator, because Intuit's own troubleshooting page tells people to strip that formatting before uploading. Money in is positive and money out is negative, which is what Intuit's worked example shows.

Three columns leave no room for the Flags column that the full Tickvouch CSV carries. If the reconciliation check flagged a row, download the plain CSV as well and keep it beside the import file.

Why we do not give you a .qbo file

Several converters offer a .qbo download. We do not, and the reason is worth stating plainly, because it is not a limitation of our parser.

.qbo is Web Connect, and Web Connect is a contracted channel between Intuit and a financial institution. Intuit's own partner documentation says a contract with Intuit or an online-banking provider is required, and getting an institution listed runs through Intuit's commercial process. Intuit's Web Connect specification is no longer available for public download: the old link now redirects to a partner marketing page.

The practical consequence is easiest to see in the documentation of tools that do produce these files. MoneyThumb's help page for its own converter explains the mechanism plainly: "The FID is a four or five digit number that QuickBooks uses to identify the financial institution", and "QuickBooks will validate the FID over the Internet when reading in the .qbo file, and it must be correct and valid, or QuickBooks will abort the file import." It adds that if your bank is not on the list, "QuickBooks will not import .qbo files (Web Connect files) that are identified as being from that financial institution."

So the file has to name a bank, and QuickBooks checks the name. Which raises the obvious question of what a tool puts there when your bank has no identifier it can use. DocuClipper's support page for that exact error answers it, for an unlisted United States bank: "Choose Chase Web Download. It works as a generic option and resolves most cases where the specific bank is missing or still triggers the error." For an unlisted Canadian bank: "Choose BMO and switch the currency to CAD."

Both companies publish this openly in their own documentation, and we are not suggesting otherwise about either of them. We are pointing at what the format requires. A Web Connect file states which institution it came from, and a tool that is not your bank cannot state that truthfully.

We are not willing to put one bank's name on a file that came from another, or to ask you to. That is the whole reason this feature is missing, and we would rather say so on the page than leave you wondering why a competitor's list is longer than ours. A CSV that imports is worth more than a .qbo that has to be labelled as somebody else's.

Quotations read 14 August 2026 at moneythumb.com and docuclipper.com, and recorded with their context in our vendor research file.

QuickBooks Desktop is a harder case, and we will not pretend otherwise. Its Web Connect import accepts .qbo files only, and Intuit states that QIF and QFX files will not work with it. If you are on Desktop and need bank transactions, the CSV route on this page is not open to you: Desktop's CSV import is for lists such as customers and vendors, not for bank transactions.

Sources, read 14 August 2026: Intuit Financial Data Platform, connectivity types · Download Bank Feed transactions in QuickBooks Desktop · Import and export data in QuickBooks Desktop.

Why we do not offer Intuit's four-column layout

Intuit documents a second CSV shape: Date, Description, Credit, Debit. We read its published example and did not ship it.

In that example, a payment sits under Credit and a deposit sits under Debit. That is the reverse of how a bookkeeper normally uses those two words. We have no QuickBooks account to settle which way the importer actually reads them, and guessing wrong would reverse the sign of every row in your books while looking perfectly tidy.

The three-column layout carries the sign inside the number, so it cannot be misread that way. That is the one we write.

If QuickBooks rejects the file

Intuit publishes the rules its importer applies. The ones that bite most often:

• The file must be 350 KB or smaller, and at most 1,000 lines. A long statement needs splitting into shorter date ranges.
• A cell in the Amount column that would contain zero and nothing else must be blank.
• Numbers in the Description column can stop the import.
• Special characters in the description can stop the import.
• Amounts of twelve digits or more cannot be uploaded.
• All dates must use one consistent format. At the mapping step you tell QuickBooks which format the file uses, and your answer must match the file.

QuickBooks asks you to match the file's columns to its own fields while uploading, so the header spelling is not the thing that breaks an import. The shape of the data is.

From Common errors when importing bank transactions and Fix bank upload errors, read 14 August 2026.

What Tickvouch cannot do

Text-based PDF e-statements only, the kind you download from online banking. A scan or a phone photo has no text layer, and Tickvouch says so instead of guessing at the numbers.

Amounts must carry two decimal places. That rule is deliberate: it keeps reference numbers out of the amount column.

A PASS means the arithmetic agrees. It does not certify that every description or date is right, and the page says so on the result itself.

Questions