How to turn a bank statement into a QBO file
Go from a CSV, Excel, or text PDF bank statement to a QuickBooks Web Connect file.
- 1
Start with a statement you can read as data
CSV and Excel work when they have a date, a description, and an amount or a debit and credit pair. A text PDF works when those same fields are text on the page. A scanned statement does not.
- 2
Confirm the rows
Check the date order, which column is the amount, and whether a positive number is money in or a charge. Bank presets cover the common Chase, Bank of America, Wells Fargo, Capital One, Amex, and Citi exports.
- 3
Check the totals
When the statement has a running balance or printed opening and closing totals, the page reports whether the rows add up. Download after that check passes, or after you understand why it does not.
- 4
Download QBO and import it
The QBO file is for QuickBooks Desktop Web Connect. Import it with File, Utilities, Import, Web Connect Files. For QuickBooks Online, download the CSV instead.
- The account number and institution id in the file are whatever you set on the page. They tell Desktop which register to offer. They do not contact the bank.
Questions
Can I make a QBO file from a PDF?
Yes, when the PDF has a text layer. Use the PDF to QBO page. A scan is not supported.