How to reorder csv columns for a quickbooks import
- Step 1Check QuickBooks expected column order — In QuickBooks Online, go to Banking → Upload file and note the column order it requires: Date, Description, Amount (or Debit/Credit).
- Step 2Drop your bank CSV into Column Reorder — The tool shows your current column order.
- Step 3Drag columns into the QuickBooks order — Move Date, Description, Amount into the first three positions.
- Step 4Import the reordered CSV into QuickBooks — Download the adjusted file and upload it to QuickBooks.
Frequently asked questions
What column order does QuickBooks Online need for bank imports?+
Typically: Date, Description, Amount. Some banks split Amount into Debit and Credit. QuickBooks will map by position if column names differ.
Does this work for QuickBooks Desktop too?+
Yes. Desktop IIF imports are different, but for CSV-based bank imports the column order matters the same way.
Is bank data uploaded?+
No. Reordering runs in your browser. Bank data is not sent to any server.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.