Why the output is simple
QuickBooks bank import CSVs work best with Date, Description, and Amount. The import screen lets you map these columns to the destination account.
Use positive amounts for money in and negative amounts for money out.
Example output
See a sample QuickBooks-compatible CSV created from bank statement transactions.
| Date | Description | Amount |
|---|---|---|
| 2026-06-02 | Direct Deposit ACME Payroll | 4200.00 |
| 2026-06-04 | Office Depot | -86.43 |
| 2026-06-07 | Stripe Payout | 912.18 |
QuickBooks bank import CSVs work best with Date, Description, and Amount. The import screen lets you map these columns to the destination account.
Use positive amounts for money in and negative amounts for money out.
No. This is the CSV import format. Use QBO when you want QuickBooks Web Connect instead.
Yes. Use QuickBooks Banking or Transactions upload from file, then map the columns.
Upload the original PDF, statement, or accounting file and create your own export.