Import layout
QuickBooks Online bank upload CSV format
QuickBooks Online bank transaction CSV: Date, Description, Amount (negative = payment).
The QuickBooks Online bank import (3-column) layout has 3 columns; the required columns are Date, Description, Amount.
QuickBooks Online can import bank transactions from a file when a bank isn't connected through a live feed. For CSV, it accepts two shapes: three columns (Date, Description, Amount, where negative amounts are money out) or four columns (Date, Description, Credit, Debit). Fileshape supports both as separate output layouts.
The upload wizard asks you to point at the date, description and amount columns and to confirm the date format, so clean headers and a consistent date format make the process a few clicks. Every row becomes a transaction in the For Review list, where bank rules and matching work just like with a live feed.
Import rules to know
- Use one date format for the whole file (Intuit recommends dd/mm/yyyy; you confirm the format during upload).
- Leave zero amounts blank, and name the 4-column headers exactly Credit and Debit, without the word “amount”.
- Each upload is limited to 350 KB and 1,000 transactions.
- No header rows above the column names and no summary rows below the data.
- Upload each bank account separately, into the matching QuickBooks account.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| Date | Yes | 01/31/2026 | |
| Description | Yes | ||
| Amount | Yes | -100.00 |