How to import a CSV bank statement into QuickBooks Online

QuickBooks Online can import transactions from a CSV file when your bank isn't connected by a direct feed. The catch: the CSV has to be in a format QuickBooks accepts. Here's how.

Steps

1. In QuickBooks Online, open Transactions → Bank transactions (older accounts: Banking).
2. Choose Upload from file (or the drop-down next to Link account).
3. Select your CSV and the account it belongs to.
4. Map the columns. QuickBooks accepts either a 3-column layout (Date, Description, Amount) or a 4-column layout with separate Credit and Debit columns.
5. Review the parsed transactions, then accept the import.

The formatting rules that trip people up

• Dates must be consistent and in a format QuickBooks recognizes (e.g. DD/MM/YYYY or MM/DD/YYYY — match your region settings).
• Amounts: use one signed Amount column (negatives for money out) or two columns, not both.
• Remove extra header rows, running balances, and blank lines your bank adds.
• Strip currency symbols and thousands separators from amounts.

When a QBO/OFX file is the better route

CSV import makes QuickBooks guess at your columns, so date and sign errors are common. A .qbo/OFX file carries the data in a structured form and usually imports more cleanly — especially for large or multi-page statements.