Bank files · Runs in your browser
Clean a bank statement CSV before you import it.
Banks export CSVs with summary lines on top, separate debit and credit columns, dollar signs and dates in odd formats. This page reshapes one into a clean 3-column or 4-column file. It stays on your device.
What the cleaner does, step by step
- Reads the CSV the way RFC 4180 describes: quoted fields, doubled quotes and line breaks inside quotes are kept intact. The separator (comma, semicolon, tab or pipe) is detected, and a byte order mark is ignored.
- Finds the header row, even below a block of account-summary lines, and guesses which column is which from the column names. You can override every choice.
- Converts each row: the date by the order you pick, the amount from a single column or from debit and credit columns, and the description trimmed of stray spaces.
- Lists every row it cannot read with the file row number: an empty date, an impossible date, an amount that is not a number, a row with both a debit and a credit.
- Writes the cleaned CSV with a header, optional extras and a byte order mark that lets Excel show accents.
Before and after: a worked example
This is a typical bank export, with an account summary above the header, dollar signs, thousands separators and a totals row at the end:
Account Summary,,,
Account: 5550123,,,
Statement period,03/01/2024 - 03/31/2024,,
,,,
Posted,Details,Withdrawals,Deposits,Balance
03/04/2024,"CORNER CAFE",$4.50,,"$2,450.91"
03/05/2024,ACME PAYROLL,,"$2,500.00","$4,950.91"
Totals,,$4.50,"$2,500.00",
With “Drop rows I cannot read” ticked, month-first dates and the Balance column added, the cleaned result is:
Date,Description,Amount,Balance
2024-03-04,CORNER CAFE,-4.50,2450.91
2024-03-05,ACME PAYROLL,2500.00,4950.91
The four lines above the header and the totals row (which has no date) are gone, the dollar signs and thousands separators are removed, debit and credit have become one signed amount, and the dates are unambiguous. The page reported 1 unreadable row (the totals line).
How the rules of an importer map to the options
- One date format. Always applied: every output date is written in the style you choose.
- Blank, not zero. In the 4-column layout a zero amount is written as an empty cell.
- No weekday text. A weekday before or after a date, such as Tue 20/11/2018, is removed while reading the date.
- Descriptions that are only numbers. Intuit asks users to fix these. The optional prefix turns “12345” into “Ref 12345”.
- Credit card order and sign. Intuit notes credit card files can arrive in reverse order and with payments negative. Use the reverse option, and the amount layout “positive = money out” where the card shows purchases as positive.
Common mistakes
- Leaving the date order on detect for a file where every date is ambiguous, then guessing. The page stops you; choose using your statement period as the check.
- Mapping the Balance column as Amount. The status line shows net totals, so a wildly large figure is the clue.
- Combining several statements into one file with different layouts. Clean each separately, then join them.
- Deleting duplicates that were real.
What this tool does not do
- It does not categorise transactions, convert currencies or match payees.
- It cannot read PDF or image statements.
- It does not guarantee a given importer will accept the result. It follows the layout rules Intuit publishes for CSV uploads, which can change.
What happens to your statement
The conversion is done by JavaScript running inside this page’s tool frame. The frame is sandboxed and its content security policy forbids network requests, so even a bug in the code could not send your file anywhere. The page that holds the advertising is a separate document and cannot read the frame. The file is read with the browser’s own file reader, the result is built in memory, and the download link points at a temporary address that exists only in your tab. Close the tab and it is gone. You can confirm it yourself: open your browser’s network panel, convert a file, and watch for requests. There are none.
When the importer wants a bank file rather than a CSV, continue with the CSV to QBO converter or the CSV to OFX converter. For general CSV structure checks, try the CSV validator.
Frequently asked questions
How do I clean a bank statement CSV?
Load the CSV, check that the date, description and amount (or debit and credit) columns are right, pick the output layout and date style, and press Clean the CSV. Lines above the header are dropped, debit and credit are merged into one signed amount or kept as two columns, and currency symbols and thousands separators are removed.
What does QuickBooks Online expect from a CSV?
Intuit documents a 3-column layout (Date, Description, Amount) and a 4-column layout (Date, Description, Credit, Debit). It asks for one date format throughout, blank cells in place of zeros, headers named just Credit and Debit, no weekday text in dates and a Windows-style CSV on a Mac. Check Intuit’s current article before uploading.
What happens to the header lines at the top?
The page looks in the first 40 lines for a row that names a date column and at least one more known field, such as Description or Amount, and treats it as the header. Everything above it is dropped and counted. If it picks the wrong row, change the number of lines to skip.
How are debit and credit merged?
Credit minus debit, in whole cents. A row with a value in both columns is reported as an error rather than silently netted. Debits written as negative numbers, which some banks do, are handled too.
Why will it not guess my date order?
Because 03/04/2024 is two different days. The page analyses every date: a first number above 12 proves day-first, a second above 12 proves month-first. With neither, it refuses to continue until you choose, since a silent guess would produce a file that looks perfect and is wrong.
Is removing duplicate rows safe?
Only if you know the file contains true repeats. Two identical purchases on one day are legitimate, and so the option is off by default and the page reports how many rows it removed. Exact means the same date, amount, description, memo and check number.
What is the apostrophe in front of some descriptions?
A text cell that begins with =, +, - or @ can be executed as a formula by a spreadsheet. The page prefixes it with an apostrophe so it stays text. Tick the raw text option to turn this off.
Is my statement uploaded anywhere?
No. It is read and cleaned in your browser, the frame cannot make network requests, and the download is built on your device.
Sources
Checked
- Intuit: Format CSV files in Excel to get bank transactions into QuickBooks — the 3-column and 4-column CSV layouts, one date format, no zeroes, and the advice to try a QFX, QBO or OFX file if a CSV will not import (retrieved 2026-10)
- Intuit Community: trouble importing bank statements in QuickBooks Online — an Intuit reply that CSV imports are sensitive to extra rows and non-transaction text, and the Upload from file path (retrieved 2026-10)
- RFC 4180, Common Format and MIME Type for CSV Files — quoted fields, doubled quotes and line breaks inside fields, which the CSV reader here follows (retrieved 2026-10)
Runs entirely in your browser. Nothing you load or type is sent or stored. This page is not affiliated with Intuit, Quicken, any bank or the OFX standards body.
Common mix-ups
-
Often assumedQuickBooks accepts any column order and any mix of columns.
What the source saysIntuit lists two accepted layouts: Date, Description and Amount, or Date, Description, Credit and Debit. In the four-column layout the headers must read exactly Credit and Debit. [1]
-
Often assumedA zero in the Credit or Debit column should be written as 0.00.
What the source saysIntuit says to remove zeroes and leave those cells blank, to keep numbers out of the Description column, and to use one date format throughout. [1]
-
Often assumedA date with the weekday in it, such as Tue 20/11/2018, imports fine.
What the source saysIntuit says to split off or remove a day of the week the bank adds to the date. It also says Mac users must save the file as a Windows CSV. [1]
Checked against these sources on .