QUICKBOOKS 3-COLUMN CSV
Convert a bank CSV to the QuickBooks three-column format
The three-column layout uses Date, Description and one signed Amount column. Money out is normally negative and money in positive; always verify the signs against the destination account.
Work on a copy, map the required columns, normalize one date and amount format, then review every flagged row before importing.
What usually causes it
- The source separates withdrawals and deposits
- The Amount column contains currency formatting
- Balances are mistaken for transaction amounts
- Payments and deposits use reversed signs
- Extra columns confuse the mapping step
- Descriptions contain delimiters or line breaks
The repair sequence
- 01
Map the transaction fields
Choose the real transaction date and description, not posting metadata or running balance.
- 02
Create one signed amount
Combine Credit and Debit carefully so money in and money out have opposite signs.
- 03
Remove formatting
Export plain numeric values with a period as the decimal separator.
- 04
Compare totals
Reconcile transaction counts and totals with the source before importing.
Important limits
This checker validates common file-format conditions. It does not select an accounting account, determine transaction purpose or guarantee that QuickBooks will accept a file. Back up the source and reconcile totals before importing.