The CSV layouts
| Layout | Columns | Use it for |
|---|---|---|
| All columns | Date, Description, Memo, Amount, Balance, Check Number, Transaction ID | Spreadsheets, databases, scripts |
| QuickBooks, 3 columns | Date, Description, Amount | QuickBooks Online bank upload |
| QuickBooks, 4 columns | Date, Description, Credit, Debit | QuickBooks Online bank upload |
| Xero | Date, Amount, Payee, Description, Reference, Check Number | Xero statement import |
| Wave | Date, Description, Amount | Wave bank statement upload |
All layouts use US dates (MM/DD/YYYY) and plain amounts without dollar signs or thousands separators, which every importer reads the same way.
Uploading the CSV to QuickBooks Online
- Go to Transactions > Bank transactions and choose Link account > Upload from file.
- Select the CSV and the account.
- Map the columns: Date, Description, and either Amount (3 columns) or Credit and Debit (4 columns). Choose the MM/dd/yyyy date format.
- Review and accept the transactions.
If you'd rather skip the mapping, download a QBO file from the same screen instead. QuickBooks reads it without any column questions.
Uploading to Xero or Wave
In Xero, open the bank account and choose Manage Account > Import a Statement, then confirm the column assignments. In Wave, use Transactions > More > Upload a bank statement. Both accept the layouts above as is.
Several statements?
Convert them one at a time, or, on Pro and Business, drop them together to get one CSV per statement or a single combined CSV. To combine CSVs you already have, use Merge CSV files.