Bank Statement to CSV
Paste the text copied from your statement PDF and get a table and a CSV with date, description, money out, money in and balance. The page checks the running balance and marks lines it is unsure about.
- Free, no sign-up
- Nothing is sent to a server
- Worldwide
How to use Bank Statement to CSV online
- Copy the text from the PDF. The transaction lines.
- Paste it here. Add the opening balance if you have it.
- Check the table. Look at marked lines and totals.
- Copy the CSV. Open it in a spreadsheet.
Why use this free Bank Statement to CSV
- Date, description, debit, credit and balance
- Running balance check
- Marks uncertain lines
- Totals to compare
- Safe against formula injection
From statement text to a table
Open your statement PDF, select the text of the transactions, copy it and paste it here. The page looks for lines that start with a date and end with amounts, works out the description in between, and decides for each line whether the money went out or came in. The result is a table you can copy as a CSV for a spreadsheet.
How it tells money out from money in
Some statements have separate debit and credit columns, some mark amounts with Dr and Cr, some use brackets or a minus sign, and many show one amount and a running balance. In that last case the page compares each balance with the one before: if the balance went up by the amount, it was money in. An opening balance line, or the opening balance you type in, gives the starting point.
The checks
The page recomputes the running balance line by line. If the balance before, plus the money in, minus the money out, does not equal the balance shown, that line is counted as a mismatch, which usually means a line is missing or misread. Lines whose direction cannot be told are marked so that you can fix them. Totals of money out and in are shown so you can compare them with your statement.
Dates
Dates are written to the CSV as year, month, day. Day-first dates are the default; switch to month-first if your statement uses it. Dates such as 12 Mar 2024, 12-Mar-24 and 2024-03-12 are understood. Lines without a date are treated as the continuation of the line above, such as a long description.
Honest limits
Statements from different banks look very different, and copying text from a PDF can scramble the columns. This page reads the common line-based layouts and will miss others, so treat the result as a first draft and always compare the totals with the statement. It cannot read a scanned statement, and it works only on the text you paste. Nothing leaves your browser.
Using the tool
The result shows under the boxes and refreshes as you edit. Press Try a sample to see how it behaves.
Bank Statement to CSV: frequently asked questions
Does it read the PDF directly?
Why are some lines marked check?
What does a balance mismatch mean?
Will it work for every bank?
Does the statement text go to a server?
Is the text I paste into the Bank Statement to CSV uploaded?
Is there a way to reuse the Bank Statement to CSV result?
Related searches for Bank Statement to CSV
- Bank Statement to CSV online
- free Bank Statement to CSV
- Bank Statement to CSV online free
- Bank Statement to CSV for mobile
- Bank Statement to CSV without sign up
- convert bank statement to csv
- bank statement to csv converter
- Bank Statement to CSV – Loans & Investing
Bank Statement to CSV is a free online tool on MAITBOX, in the Loans & Investing group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.