How to Import a Bank Statement PDF into QuickBooks (QBO Format)

QuickBooks can import transactions from QBO files (QuickBooks Web Connect format), but most banks only provide statements as PDFs. The bank's online download option might offer CSV or OFX, but many smaller banks and international banks only give you PDF.

This creates a gap: you have transaction data locked in a PDF that QuickBooks can't read. Converting manually means retyping every transaction — tedious and risky for errors.

Download your statement from your bank's website. Most banks provide monthly statements under a "Statements" or "Documents" section. Make sure to download the full statement (not a transaction summary or mini-statement).

ConvertStatement supports 15 banks including Chase, Bank of America, Wells Fargo, Citi, Capital One, Revolut, Barclays, HSBC, and more.

Go to convertstatement.com and upload your PDF. The tool automatically detects your bank and extracts all transactions. Click the QBO button to download the file in QuickBooks Web Connect format.

The QBO file includes all transaction details: dates, descriptions, amounts, and transaction types (debit/credit). It's formatted exactly the way QuickBooks expects.

QuickBooks Online: Go to Banking > Upload Transactions. Select the bank account, choose the QBO file, and click Import. QuickBooks will show you the transactions for review before adding them.

QuickBooks Desktop: Go to File > Utilities > Import > Web Connect Files. Select your QBO file. QuickBooks will prompt you to map it to an existing account or create a new one.

After import, review the transactions in the For Review tab and categorize them as needed.

Match the date range: Don't import overlapping periods. If you already have January transactions in QuickBooks, start your import from February to avoid duplicates.

Check your bank account mapping: Make sure QuickBooks maps the imported transactions to the correct bank account.

Review before accepting: QuickBooks puts imported transactions in a "For Review" queue. Go through each one to verify the categorization is correct.

ConvertStatement generates valid QBO files for all supported banks: Chase, Bank of America, Wells Fargo, Citibank, Capital One, US Bank, PNC, TD Bank, Revolut, Barclays, HSBC, N26, Deutsche Bank, ING, and Santander.

The QBO format includes proper FITID transaction identifiers, which helps QuickBooks avoid importing duplicate transactions. Currency is set automatically based on the bank (USD for US banks, GBP for UK banks, EUR for European banks).