THE IMPORT RESCUE GUIDE

Prepare a bank CSV format for QuickBooks Online

Understand three-column and four-column bank CSV layouts and review formatting without losing transactions.

Start with the right fields

Intuit documents bank CSV layouts with Date, Description, and Amount, or Date, Description, Credit, and Debit. Map your source columns in the import screen and confirm their meaning rather than relying on their position alone.

Keep values separate from presentation

Currency symbols, grouping separators, and spreadsheet formatting can obscure how a value is stored. Confirm decimal conventions and preserve signs. A display format in a spreadsheet is not necessarily the same as the saved CSV text.

Protect descriptions and row boundaries

Descriptions with commas need valid CSV quoting. An embedded quote must be escaped appropriately. Do not split records using simple line breaks when quoted fields can span multiple lines.

Validate the saved copy

Reopen the exported CSV and compare row counts, transaction dates, and amounts with the original file. Do not assume that a successful save proves compatibility. The tool on this website is currently a sample demo, not a file converter.

Reference: Intuit’s bank CSV formatting guidance. Check the current guidance for your account and workflow.

Explore a careful review

See how the planned tool approaches uncertain values with our synthetic example.

Try the sample demo →