Convert a bank statement to QuickBooks (CSV import)

Import a bank-statement PDF into QuickBooks Online: convert it to a 3-column QuickBooks CSV (Date, Description, Amount) and upload it under Transactions → Bank.

Convert a statement now — free

QuickBooks Online imports bank transactions from a CSV with a specific shape — but only if you can get your statement into that shape first. When the bank feed is unavailable (old months, a closed account, a bank without a connection), a PDF-to-QuickBooks-CSV conversion fills the gap.

The QuickBooks CSV format

QuickBooks Online accepts a 3-column CSV: Date, Description, Amount (a single signed amount, negative for money out). bankpdf's QuickBooks export produces exactly this layout, with ISO dates so the import wizard maps them cleanly.

Import steps

1. Convert the PDF on bankpdf and choose the QuickBooks export.
2. In QuickBooks Online: Transactions → Bank transactions → Upload from file.
3. Map the columns (Date, Description, Amount), pick the account, and import.

Then categorize and reconcile in QuickBooks as usual. For Xero, use the Xero export instead.

FAQ

Does QuickBooks need debit/credit or a single amount?

QuickBooks Online accepts a single signed Amount column (negative = money out), which is what the bankpdf QuickBooks export uses.

Will this work for old statements not in the bank feed?

Yes — that is the main use case. Convert the PDF and upload the CSV for any period.

Other formats

Looking for a specific bank? See supported banks, or the accountant exports.