PDF to QBO Converter for QuickBooks Online and Desktop
Convert PDF or scanned bank and credit card statements into QBO files, the QuickBooks Web Connect format, so missing months, closed accounts and banks without a feed load into QuickBooks the same way a bank download does.
A Web Connect file QuickBooks treats like a bank download
A QBO file is a structured financial data file that QuickBooks reads natively. Unlike a CSV, it carries the account details and a unique identifier for every transaction, which is what lets QuickBooks match, skip duplicates and post to the right register.
- FITID, a unique transaction ID generated for every row and kept stable if you export the same statement again
- Posted date for each transaction
- Signed amount, deposits positive and withdrawals negative
- Payee name, cleaned from the bank description, with the full description kept in the memo field
- Check number on check transactions
- Transaction type such as debit, credit, check, fee or interest
- Account type set to checking, savings or credit card, with the closing balance and statement end date
Bank identifier and account setup
QuickBooks expects a bank identifier inside the file. You pick a bank identifier from the list in the export screen or keep the one already linked to the client account, and set the last digits of the account number so the file attaches to the correct register every month.
From PDF to QBO in four steps
- Upload statements for one account or a whole client batch, PDFs, scans or photos
- Review the extracted rows, with payee names and the balance check result on every statement
- Select QBO, then confirm the account type, bank identifier and account number ending
- Download one QBO file per statement, or one file per account covering the full period
Why a balanced QBO file saves a reconciliation
Once transactions are accepted in QuickBooks, a missing deposit shows up only as an unexplained difference at reconciliation, often weeks later.
Every statement is tested before the QBO file is written: the printed opening balance, plus credits, minus debits, must land on the printed closing balance.
The closing balance placed inside the QBO file comes from that verified figure, so the ending balance QuickBooks shows after the import agrees with the paper statement.
A failed check stops nothing silently. The page and row range are flagged, you correct the row in the editor, and the file you download is the corrected one.
Importing a QBO file into QuickBooks Online
In QuickBooks Online, open the banking area, choose to upload transactions from a file, select the QBO file and pick the account it belongs to. The transactions then wait in the review list, where you categorize or match them and add them to the register.
Importing a QBO file into QuickBooks Desktop
In QuickBooks Desktop, use the import option for Web Connect files under the file utilities menu, select the QBO file and link it to an existing account or create a new one. The transactions appear in the bank feeds center for matching and adding.
Because each row carries a FITID, importing an overlapping file does not create duplicates for rows QuickBooks has already seen.
Readers who prefer screenshots of every click can follow the guide on how to import bank transactions into QuickBooks Desktop.
When CSV is the better route
For a quick one-off upload to QuickBooks Online, the bank statement to CSV export also works. QBO is the stronger choice for Desktop users and for recurring work, because the file keeps account identity and duplicate protection. Firms whose whole practice runs on QuickBooks can read the PDF bank statement to QuickBooks workflow for monthly close.
QBO export on Professional and Business
QBO files are included from Professional at 149 USD a month, or 74 USD a month billed yearly, with 1,500 pages a month, 3 seats, batches of up to 100 files and categorization rules.
Business adds the API, unlimited client workspaces and SSO. Starter covers Excel and CSV only. Details are on the pricing page.
Does the QBO file work in QuickBooks Online and Desktop
Yes, the same Web Connect file imports into both QuickBooks Online and QuickBooks Desktop.
What is a FITID and why does it matter
It is the unique ID of each transaction, and QuickBooks uses it to recognize rows it has already imported.
Can I convert credit card statements to QBO
Yes, set the account type to credit card and charges and payments are signed the way QuickBooks expects.
Will re-exporting create duplicate transactions
No, the FITID of each row stays the same when you export the same statement again.
Can I convert scanned statements to QBO
Yes, scans and phone photos are read and balance checked before the QBO file is created.
Convert a statement
Turn the PDF statement your client emailed into a file QuickBooks accepts in one upload.