PDF to QBO for QuickBooks
QuickBooks imports bank transactions from Web Connect files, which end in .qbo. When your bank only gives you a PDF, this converter reads it, checks the figures against the running balance, and writes a QBO file that QuickBooks can match against your bank or card account.
No sign-up to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.
5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.
- Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
- Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
- Nothing keptNo statement or download is stored on our servers, and a password only opens the file.
See it before you upload
From PDF lines to rows your books accept
The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.
What the statement prints
- 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
- 08/02CHECK 10451,200.00Withdrawals
- 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
- 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
- 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals
What you download
- Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
- Check 1045Uncategorized−$1,200.00Aug 2
- Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
- Wireless Bill AutopayPhone and internet−$89.99Aug 5
- Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8
Reconciled: every running balance matches
Opens in the software you use
- QuickBooks OnlineQBO or CSV
- QuickBooks DesktopQBO or IIF
- XeroOFX or CSV
- QuickenQFX
- SageCSV
- WaveCSV
- FreeAgentCSV
- MYOBOFX or QIF
- Zoho BooksCSV, OFX or QIF
- GnuCashOFX or QIF
- Excel and Google SheetsXLSX or CSV
- TallyXML
Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.
Insights on every statement
- Average daily balance
- $7,103.26
- Biggest spending category
- Rent and mortgage, $2,000.00
- Recurring payment found
- Blue Door Coffee Seattle, weekly, about $5.45
- Returned, NSF or overdraft rows
- 1
Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.
In the QBO file
- Every transaction with its date, signed amount, payee name and memo
- A transaction ID that stays the same each time the statement is converted
- The statement period and the closing balance
- The bank format for bank accounts, the card format for credit cards
- An Intuit bank ID you can change if QuickBooks asks for another
Importing into QuickBooks Desktop
Choose File, Utilities, Import, Web Connect Files, and select the .qbo file. QuickBooks asks which account to use: pick the existing bank or card account, and the transactions appear in the Bank Feeds centre ready to match or add.
Importing into QuickBooks Online
Open Transactions, then Bank transactions, and choose to upload from a file. Select the .qbo file, pick the account to put it in, and review the rows under For review before adding them.
Want to check what is inside a QBO, QFX or OFX file before you import it? Open it with QBO to PDF
Questions
What is the Intuit bank ID for?
QuickBooks Desktop reads a bank ID from the file and checks it against the banks it works with. The default, 3000, is the one most converters use. If QuickBooks says the bank is not supported, try another ID from Intuit’s list.
Will importing the same statement twice duplicate transactions?
Each transaction gets an ID worked out from the account, date, amount and description, so converting the same statement again gives the same IDs. QuickBooks uses these to recognise transactions it has already downloaded.
Can I convert a credit card statement to QBO?
Yes. Card statements are detected, or you can choose Credit card in the reading settings. The file then uses the credit card format, with purchases as charges and payments as credits to the card.
Should I use QBO or CSV for QuickBooks Online?
Either can be uploaded, but a QBO file needs no column mapping and carries transaction IDs that help QuickBooks spot duplicates. CSV is handy if you want to edit the rows in a spreadsheet first.
Is this PDF to QBO converter free?
Yes for 5 statement pages a day with a free account, and every row and the balance check are free to see before that. A bigger job takes a Statement Pass, paid once with nothing to renew: 400 pages for 7 days, 2,000 for 30 or 6,000 for 90. Downloading the same statement in other formats does not count again.