How to use it
- Choose a CSV, TXT, or XLSX bank export.
- Confirm the date, description, and amount columns.
- Select the 3-column or 4-column CSV layout, review the preview, and download.
QuickBooks CSV formatter
Format a bank CSV for QuickBooks Online.
Map CSV, TXT, or XLSX bank rows into a 3-column or 4-column QuickBooks CSV. Preview and export stay in your browser.
Free to use. No signup. Source files stay in this browser.
QuickBooks CSV Formatter
Turn a bank export into the 3-column or 4-column CSV format QuickBooks Online accepts.
Drop a bank file here
Supports csv, txt, xlsx. Your file stays in this browser.
Supported files and limits
CSV, TXT, and XLSX input; 3-column or 4-column QuickBooks CSV output. One file at a time, up to 20 MB and 50,000 transaction rows. The current release is for US English and USD workflows.
Fictional example
Date,Description,Amount → 07/01/2026,Fictional Coffee Shop,-12.50
Common problems to check
- Mixed or ambiguous date formats
- Credit and Debit both filled on one row
- An amount column stored as non-numeric text
Import boundary
Review dates, descriptions, amounts, row counts, and warnings before using the downloaded CSV. Formatting does not verify accounting categorization or tax treatment.
Local processing and evidence
The source file is read, parsed, previewed, and exported in this browser. It is not sent to BankFileKit, an AI service, or an analytics provider.
Read the privacy boundary, validation method, and compatibility status.