QuickBooks Online Bank Transaction CSV Cleaner

What it does

Upload a bank statement export in any format. Download a CSV that imports directly into QuickBooks Online via Banking > File Upload > Upload from file — no manual reformatting, no formula gymnastics.

The problem it solves

Bank exports are inconsistent. Chase formats dates as 01/15/2024. Starling Bank uses 15 Jan 2024. Some exports use $1,234.56 with symbols and commas. Some have separate Debit and Credit columns; QBO expects a single signed Amount. You end up spending 20 minutes per statement cleaning data that should take 20 seconds.

What it handles automatically

• Date reformatting — Detects your source format (MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, and more) and converts to the MM/DD/YYYY QBO requires
• Currency cleaning — Strips $, €, commas, and parenthetical negatives like (50.00) → -50.00
• Debit/Credit merging — If your export has separate Debit and Credit columns, combines them into QBO's single signed Amount
• Encoding fix — Converts Windows-1252/ANSI to UTF-8 so accented characters import correctly
• Column mapping — Auto-detects which of your columns is the date, which is the description, which is the amount — even when they're named differently

How it works

1. Upload your bank export (CSV, XLSX, or TSV)
2. Review the auto-detected column mapping — correct any mismatches
3. Preview the first 5 rows to confirm everything looks right (free)
4. Export the full cleaned file — one-time $7

QBO import instructions

After downloading your cleaned CSV:

1. In QBO, go to Banking (left sidebar)
2. Click Upload transactions (or File Upload on older versions)
3. Select your bank account
4. Upload the cleaned CSV
5. QBO's mapping wizard will recognize the Date, Description, and Amount columns automatically

File requirements

• Input: CSV, XLSX, or TSV from any bank or accounting tool
• File size: Keep source files under 350KB (QBO's import limit)
• Rows: Up to 1,000 transactions per file (QBO limit)
• Minimum columns required: A date column, a description column, and an amount column (or separate debit/credit columns)

FAQ

Does the preview show the full output? The preview shows the first 5 rows transformed. The $7 export gives you the complete file.

What if my date format is ambiguous? If your dates could be either MM/DD or DD/MM (all day values ≤ 12), the tool will ask you to confirm. Better to ask than to silently flip January 3 into March 1.

Can I use this for multiple accounts? Yes — process each account's export separately. Each $7 export is one file. Buy the 10-pack ($19) if you're cleaning multiple statements regularly.

Does it store my data? No. All processing happens in your browser. Your financial data never touches a server. The $7 unlocks the export; it doesn't upload your file anywhere.