Bank statement PDF to QBO for QuickBooks
QuickBooks takes transactions from a QBO (Web Connect) file, not from a PDF. Choose the statement here, check the table and the balances, and download a QBO file to upload.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Statement not read correctly, or something broke? Tell us
Your statement never leaves your device
How to do it
- Download the statement as a PDF from online banking.
- Choose the file here and look at the check line: if the balances add up, no transaction is missing.
- Click "QBO".
- In QuickBooks Online, go to Banking, choose Upload transactions and pick the file. In QuickBooks Desktop, use File › Utilities › Import › Web Connect Files.
Tips
- Each transaction gets an ID made from its date, amount and description. If you upload two statements that overlap, QuickBooks skips the transactions it already has instead of adding them twice.
- A credit card statement is saved as a credit card account: purchases are charges and payments are credits.
- The payee field holds the first 32 characters of the description, which is as long as the format allows; the full description goes into the memo.
- Accents and symbols are written as plain letters (Café becomes Cafe), because QBO files are plain ASCII.
Questions
QuickBooks Desktop says it cannot read the file. What now?
QuickBooks Desktop checks the bank ID inside the file against its own list and may refuse a file it does not expect. QuickBooks Online accepts it. With Desktop, you can also import the CSV download through a bank feed or a spreadsheet import.
QBO or CSV?
QBO if you upload transactions to QuickBooks: the dates, amounts and payees are already in the fields QuickBooks expects. CSV for a spreadsheet or for software that only imports CSV.
Is my statement uploaded anywhere?
No. Your browser reads the PDF and writes the file on your device. Nothing is sent to a server, and there is no account to create and no page limit.
Does it work with a scanned statement?
No. It needs the digital PDF you download from online banking, which has the text inside. A scan or a photo is only a picture.