BankToRows

PDF statement → QBO

PDF Bank Statement to QBO

Get transactions from a PDF statement into QuickBooks, checked first: every row is compared with the statement’s balances, you fix anything that’s off, then download a .qbo Web Connect file for QuickBooks Desktop or Online, or the CSV layout QuickBooks Online uploads. Handy for closed accounts, missing months and banks that only give you PDFs.

Converted in your browser. Your file is never uploaded.

No file handy?

Nothing uploaded

Files are read and converted in your browser, on your device.

Amounts checked to the cent

Opening + transactions = closing, and each running balance. Dates and currency are confirmed with you.

Fix before you export

Edit any date, description or amount, flip a sign, drop a line.

How to convert a bank statement to QBO

  1. 1

    Drop the PDF statement

    Download it from online banking first. Checking, savings and credit card statements all work; password-protected PDFs too.

  2. 2

    Check the balance

    Every transaction is listed with the result of the balance check. Fix anything that’s off right in the table.

  3. 3

    Download the QBO

    Add the Intuit bank ID in Export settings if your QuickBooks or Quicken asks for one, then import it as a Web Connect file.

QuickBooks Online reads PDFs. Why convert first?

QuickBooks Online can take some PDF statements in its Upload transactions screen. Converting first is worth it when you want the rows checked against the statement’s printed balances before they reach your books, when you want to fix a date or an amount before importing, when you work in QuickBooks Desktop (its bank import takes Web Connect .qbo files), or when the statement shouldn’t be uploaded anywhere. Here it never leaves your browser.

The Intuit bank ID (INTU.BID)

A .qbo file names the bank it came from with Intuit’s bank ID. QuickBooks Desktop checks that ID against Intuit’s list of banks and may refuse a file whose ID it doesn’t recognise. If you have any older .qbo or .qfx file from the same bank, open it in a text editor and copy the number after <INTU.BID> into the export settings. When the file you convert already has an ID, it’s kept. QuickBooks Online is less strict, and its CSV upload needs no ID at all.

No duplicate transactions on re-import

Every transaction gets a stable ID (FITID) built from its date, amount and description, unless the source already had one. Import the same file twice, or two statements that overlap, and QuickBooks can recognise the repeats instead of doubling them.

The formats

PDF statement
The statement your bank lets you download from online banking. It looks like a table but is really text placed at positions on a page, which is why copying it into a spreadsheet goes wrong. Scanned paper statements are pictures of text and need OCR, which BankToRows doesn’t do yet.
QBO
QuickBooks Web Connect. A .qbo file is an OFX bank download that also carries Intuit’s ID for the bank (INTU.BID). QuickBooks Desktop imports it under File › Utilities › Import › Web Connect Files; QuickBooks Online takes it in its Upload transactions screen.

Related converters

Bank statement converterBank statement to ExcelBank statement to CSVPDF statement to QIFCSV to QBOQFX to QBOOFX to QBO

PDF Bank Statement to QBO: FAQ

Does QuickBooks Online accept .qbo files?

Yes. Its Upload transactions screen takes .qbo, .qfx, .ofx and .csv files. QuickBooks Desktop takes .qbo through File › Utilities › Import › Web Connect Files.

Does it work with credit card statements?

Yes. Purchases become charges and payments become credits, and the file is written as a credit card statement so QuickBooks puts it in a credit card account.

Why are accents missing in the .qbo file?

QuickBooks Online shows any accented or non-English letter in a Web Connect file as “?”, so .qbo, .qfx and .ofx files spell them plainly (Café becomes Cafe). Excel and CSV downloads keep the original text.

What does the balance check mean?

Statements print an opening balance, a closing balance and often a running balance. After reading the transactions, the converter adds them up and compares: opening + money in − money out must equal closing, and each printed running balance must follow from the one before. A green check means everything adds up to the cent; anything else is shown with the rows to look at. It’s a check of the totals, not a guarantee: two mistakes that cancel out (a missed +100 and a missed −100) still add up, which is less likely when the statement prints a running balance on every line.

Is my file uploaded anywhere?

No. The conversion runs in your browser: the file is read on your device and the download is built there too. It never reaches our server, so we can’t see it, keep it or lose it.

Is it free?

Yes, while BankToRows is in beta: no sign-up and no page limits.

Last updated October 2026