How to fix bank statement csv formatting
- Step 1Export from your online banking — Download the CSV from your bank's statement download page. Pick the date range you need.
- Step 2Drop the CSV onto the cleaner — Drag the file in. Cleaning runs entirely in your browser — the statement never leaves your device.
- Step 3Verify the transaction count — Compare the rows-out count against your statement total to confirm nothing was over-trimmed.
- Step 4Import into your accounting tool — Download the cleaned CSV and import it into QuickBooks, Xero, FreeAgent, or Excel.
Frequently asked questions
Is it safe to clean a bank statement online?+
Yes — because the file never leaves your browser. JAD Apps does not upload, store, or transmit your statement. All processing runs locally in your browser.
Will this change transaction amounts or dates?+
No. Numeric and date fields are preserved exactly. Only whitespace, blank rows, and duplicate rows are touched.
Why are pending transactions duplicated in my export?+
Many banks include both pending and posted versions of the same transaction. The deduplicate option collapses identical rows into one.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.