Skip to content

CSV template

QuickBooks bank import CSV template

Download a QuickBooks bank import CSV template with Date, Description, and Amount columns, plus notes for mapping statement transactions.

Download QuickBooks CSV templateConvert a statement to QuickBooks CSV

QuickBooks 3-column bank import CSV

DateDescriptionAmount
2026-06-02Direct Deposit ACME Payroll4200.00
2026-06-04Office Depot-86.43
2026-06-07Stripe Payout912.18

How to use this template

QuickBooks accepts a simple 3-column bank import CSV with Date, Description, and Amount. Deposits should be positive and withdrawals should be negative.

After upload, QuickBooks asks you to map each column. Match Date to Date, Description to Description, and Amount to Amount.

When to use Statemently

Use the template if you are preparing rows manually. If your source is a bank statement PDF, convert it first so the transaction rows are extracted before you import them.

Frequently asked questions

Does QuickBooks accept PDF bank statements?

No. Convert the PDF to QuickBooks CSV or QBO first, then upload that file.

Should withdrawals be negative?

Yes. In the single Amount column format, deposits are positive and withdrawals are negative.

Related converters and guides

Bank statement to QuickBooksQBO to CSV converterQuickBooks import guide

Need this from your own file?

Upload the original PDF, statement, or accounting file and create your own export.

Convert a statement to QuickBooks CSV