PDF to QBO converter for QuickBooks
Turn a bank or credit card statement PDF, scan or photo into a .qbo Web Connect file that QuickBooks Online and QuickBooks Desktop import without a column mapping step, with every row checked against the balances printed on the statement.
Last updated September 17, 2026
A QBO file is how QuickBooks takes in bank transactions as a file. Many banks offer a QBO download for recent activity only, and for older months, a closed account or a bank that only hands out PDFs, the statement is what exists. Converting it gives you a QBO file for any period the bank printed, and the review workbook in the middle means the rows are right before QuickBooks sees them.
Convert a statement3 free pages a day, no account needed
How it works
Step 1: Convert your statement
Upload the PDF, scan or photos on the converter page. Every row is read, then the running balance is rebuilt from the rows and compared with each balance the bank printed. Rows that do not add up are marked. This is the step that uses pages.
Step 2: Check it in Excel
Download the review workbook and correct any row marked Review this row. On the Statement details sheet, type the Account number and check Account type and Currency: those three are what a QBO file needs beyond the opening balance.
Step 3: Upload it, get your files
Upload the saved workbook on the same page and press QuickBooks (.qbo). Excel and CSV copies come from the same workbook, and none of these downloads uses pages.
What is inside a QBO file
QBO is OFX 1.02, the bank data standard, with a QuickBooks header on top. QuickBooks calls it a Web Connect file. Instead of columns for you to map, it carries named fields, which is why the import has no mapping screen and no date format prompt.
| Field | What it holds | Where the value comes from |
|---|---|---|
INTU.BID | The bank identifier QuickBooks reads first | 3000, the code manual Web Connect imports accept, unless you enter another |
ACCTID | The account number | Account number on the Statement details sheet |
ACCTTYPE | Checking, savings, money market or line of credit, or a credit card block for a card | Account type |
CURDEF | The currency, as three letters | Currency |
STMTTRN | One transaction: type, date, signed amount, identifier and payee | The rows you confirmed in the workbook |
LEDGERBAL | The closing balance | The statement |
Each transaction identifier is derived from the row itself, so the same statement converted twice produces the same identifiers, which is what QuickBooks uses to recognize a transaction it already has. The payee field holds 32 characters under the format's rules; a longer description continues in the memo field, so no text is dropped.
What the QBO file needs from you
| Statement details field | Why the QBO file needs it | What to enter |
|---|---|---|
| Account number | QuickBooks tells accounts apart by the number inside the file | The number from the statement, digits only. The same number every month, and a different one for each account |
| Account type | It decides whether the file is a bank or a card statement, which fixes the signs | Current / checking, Savings, Money market, Credit card or Line of credit, from the drop-down list |
| Currency | It is written into the file and has to match the QuickBooks account | Three letters, such as USD or CAD |
| Opening balance | Every file needs it; the balance check starts from it | Already filled in from the statement; check it |
Leave QuickBooks / Quicken bank code (INTU.BID) at 3000 unless your accountant gives you another code.
Import the QBO file into QuickBooks Online
- Go to Transactions, then Bank transactions.
- Open the Link account drop-down and choose Upload from file.
- Drag the .qbo file in, or browse to it, and continue.
- Pick the QuickBooks account the transactions belong to. If it is not in the list, create it with the right type: Bank for a bank statement, Credit Card for a card statement.
- Confirm the import. The rows arrive under For review, and nothing reaches the books until you categorize or match them.
The bank balance QuickBooks shows for the account comes from the closing balance in the file, so read it against the last page of the statement. Menu names move between QuickBooks layouts; this is the generic route. The error messages QuickBooks can show, and what each one means, are in upload bank statements to QuickBooks Online.
Import the QBO file into QuickBooks Desktop
- Open File, then Utilities, then Import, then Web Connect Files.
- Pick the .qbo file.
- Choose the bank account to import into, or create one, then review the transactions in the Bank Feeds Center.
Desktop matches a file to an account by the account number inside it. When you convert a business and a personal statement on the same day, give each one its own Account number on the Statement details sheet, and the two files are never offered to the same Desktop account.
Before you import
- Transactions older than the bank feed. A bank feed usually reaches back about 90 days, and the statements cover the rest. Convert one statement period per file so each import has a clean start and end. Import older transactions into QuickBooks.
- A long run of statements. QuickBooks Online takes up to 1,000 transactions in one upload, so a busy year goes in as several statement periods.
- Card statements. Set Account type to Credit card before you upload the workbook. The QBO file is then written as a card statement and belongs in a Credit Card account. Credit card statements to Excel.
- Accented descriptions. A QBO file declares plain ASCII text, so accented letters are written without their accents: é becomes e. When the exact spelling matters, download the CSV for import from the same workbook too.
- Statements without a running balance are checked against their printed totals instead, and the workbook says which check ran.
- Large files. A PDF of up to 100 pages and 50 MB converts in one go, with up to 80 transactions on a page. Split anything larger into statement periods.
- A refused file. When QuickBooks refuses a QBO file, the cause is usually the bank identifier rather than the rows. Send us the bank name and the message and we tell you which code to enter. The CSV for import from the same workbook carries the same rows in the meantime.
Questions
Does QuickBooks Online accept a QBO file made from a PDF statement?
Yes. Upload from file on the Bank transactions screen accepts .qbo files, and a QBO file made here imports the way one downloaded from a bank does: the rows land under For review with their dates, amounts and signs, and the account shows the closing balance carried in the file.
Do I need the account number to make a QBO file?
Yes. QBO, OFX and QFX files carry the account number, and QuickBooks uses it to tell accounts apart, so the QuickBooks (.qbo) download is available once Account number is filled in on the Statement details sheet. Excel, CSV and QIF files are produced without it.
Can I convert a credit card statement to QBO?
Yes. Set Account type to Credit card on the Statement details sheet and the file is written as a card statement, with purchases as charges and payments as credits. Import it into a Credit Card account in QuickBooks, not a Bank account, or every sign lands reversed.
What happens if I import the same statement twice?
Every transaction in the file carries an identifier derived from the row itself, so the same statement converted twice produces the same identifiers, and QuickBooks uses those identifiers to recognize transactions it has already imported.
Does the QBO file cost extra pages?
No. Pages are counted once, when the statement is converted in Step 1. Uploading the review workbook and downloading QBO, Excel, CSV or any other format uses no pages, as often as you need.
Which versions of QuickBooks read a QBO file?
QuickBooks Online reads it through Upload from file, in the United States and in the other regions Intuit documents, and QuickBooks Desktop reads it through Web Connect. If you would rather map columns yourself, the same workbook gives a three-column CSV for import.
Other formats from the same workbook
One conversion gives every format: CSV for a spreadsheet or a mapped import, OFX for Xero and MYOB, QIF for Quicken for Windows, and Excel for a person to read. Import bank statements into QuickBooks covers the CSV route, QuickBooks outside the United States and what QuickBooks does with a PDF of its own.
Format compatibility only. We are not affiliated with Intuit.
Convert one and see
Three pages a day are free, and you don't need an account to run your own statement through it.