Statement → QuickBooks

Convert a bank statement to QuickBooks

QuickBooks Online imports bank data from CSV — but not from PDF. Convert your statement to a categorized CSV first, then upload it under Transactions → Bank transactions → Upload from file.

 

How to import a statement into QuickBooks Online

  1. 1. Convert the statement. Upload your bank statement PDF and download the categorized CSV.
  2. 2. Open the bank upload. In QuickBooks Online: Transactions → Bank transactions → Upload from file.
  3. 3. Map & import. Map Date, Description, and Amount to the CSV columns and import.

Frequently asked questions

Can QuickBooks read a PDF statement directly?
No — QuickBooks imports CSV, QBO, QFX, or OFX. Convert the PDF to CSV first, then upload.

Export to other tools

Convert a statement from your bank

Related guides