Bank Statement to Excel Converter

1. Download the statement as a PDF from your online banking. Choose the PDF that you can select text in, not a photo or a scan.
2. Drop the PDF in the box above. If it is password protected, type the password when asked. It stays in your browser.
3. Look at the preview. Check the first and last rows against the statement and read the balance check.
4. Fix anything that is wrong: click a cell to edit it, remove a row, or change the date order or number style under More options.
5. Choose Excel and press Download. The file has a Transactions sheet and a Summary sheet.

1. Drop all the PDFs or CSV files at once, for example twelve monthly statements.
2. Leave the order on Oldest first. The rows are sorted by date across all files.
3. Tick Add a Source file column if you want to see which statement each row came from.
4. Check the balance check. It runs on each statement separately.
5. Download the Excel file.

1. Add the statement PDF or your bank CSV.
2. Choose QuickBooks CSV (3 columns) as the export.
3. Check the dates. QuickBooks wants one date format in the whole file, and the file uses month/day/year unless you change it.
4. Download the CSV, then upload it in QuickBooks Online under Banking, Upload transactions.
5. For a credit card statement, choose the credit card account in QuickBooks when you upload.

1. Drop the CSV from your bank in the box. The columns are guessed from the header row, and you can change each one.
2. Check that the preview shows the right dates and amounts.
3. Choose QBO (beta), type the last digits of the account number and pick checking, savings or credit card.
4. Download the QBO file and import it with File, Utilities, Import, Web Connect Files in QuickBooks Desktop.
5. If QuickBooks refuses the file, use the QuickBooks CSV export instead.

1. Add the statement PDF. Card statements often show purchases as positive numbers.
2. Look for the note that says the statement was read as a credit card. If it is wrong, change it under More options.
3. Check that purchases are in the Debit column and payments in the Credit column.
4. Download the Excel file.

1. If you see No text found, the PDF is a scan or a photo. Download the statement again from online banking, or ask your bank for a digital copy or a CSV.
2. If rows are missing or merged, try the CSV export from your bank if it has one.
3. If the numbers look wrong, open More options and change the number style or the date order.
4. You can still fix single cells by clicking them in the preview.

Yes. You can convert as many statements as you like without paying, without an account and without a watermark. A small advertisement may be shown on the page. Premium members of FileXL do not see it.

Drop the statement PDF in the box, check the preview and the balance check, choose Excel and press Download. Use a PDF you downloaded from online banking, because it has real text. A scan or a photo has no text to read.

No. The statement is read by your own browser. The PDF reader is loaded to your device when you add a PDF, and after that nothing about your statement is sent anywhere. Account numbers, names and transactions never reach FileXL. You can check this in your browser tools: after the PDF reader has loaded, you can turn off your internet and the conversion still works.

Bank statements are laid out in many different ways, so no converter can promise a perfect result for every bank. That is why this tool shows the rows before you download them and checks each balance. A row that does not add up is flagged. Compare the first and last rows with the statement, fix any cell by clicking it, and keep the original PDF.

Yes. Bank statement converter, convert bank statement into Excel, bank statement to CSV and PDF bank statement to Excel all mean taking the transactions out of a statement into a file you can use. This tool does all of them, and the CSV to QBO and QuickBooks jobs as well.

No. A scan is a picture of a page and has no text to read. This tool does not do OCR. Download the statement again from online banking as a PDF, or ask your bank for a CSV or a digital copy.

Yes. The tool asks for the password and uses it in your browser only. Many banks protect statements with a password such as the date of birth or the last digits of the account. The password is not stored or sent.

It is not built for one bank. It looks for a table with a date, a description and amount columns, in English, German, Spanish and French headings, and it reads the common layouts: separate money in and money out columns, one signed amount column, Dr and Cr, and credit card statements. Layouts that are very unusual may need a few corrections in the preview.

Yes. Add all the PDFs or CSV files together. The rows are put in one table and sorted by date, and you can add a column with the name of the source file. The balance check runs on each statement on its own.

When a statement prints a running balance, the tool adds each amount to the previous balance and compares the result with the printed one. A tick means they match. A warning means that row, or one just before it, was read wrongly or is missing. It is the quickest way to find a mistake.

Date, Description, Debit, Credit and Balance, and optionally Reference, Amount (money in minus money out) and Source file. Dates are real Excel dates and amounts are real numbers, so sorting and sums work. A second sheet called Summary has totals and the balance check.

A date such as 03/04/2024 can mean 3 April or 4 March. The tool works it out from the other dates and the order of the rows. If it cannot be sure it says so. Open More options and choose Day first or Month first, and everything updates.

Both are handled. The tool detects a decimal comma or a decimal point, and Indian digit grouping. If the amounts look wrong, choose the number style yourself under More options.

Yes. Card statements often show purchases as positive numbers and payments as negative. The tool detects a card statement from its wording and puts purchases in Debit and payments in Credit. If it guessed wrong, change it with the tick box under More options.

Choose QuickBooks CSV and download the file, then upload it under Banking in QuickBooks Online. Intuit accepts a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit). Use one date format in the whole file. Check the preview first, because QuickBooks will import what the file says.

It can make a QBO file, but this is a beta. QuickBooks Desktop checks a bank ID called INTU.BID inside the file and may refuse a bank ID that Intuit does not list. If it is refused, use the QuickBooks CSV, or a QBO from your own bank. Test with a copy of your company file before importing for real.

Yes. Choose the file you need under Make. Xero, YNAB, Wave and Zoho Books each get a CSV with the column names that app documents. QIF and OFX are for apps that read those formats, such as GnuCash and Zoho Books. These files were checked for structure and not imported into every app, so import a short period first and use the feedback box if an app refuses a file.

Yes. Drop the CSV in the box. The tool guesses the columns from the header row and you can change them. It handles commas, semicolons and tabs, quoted text, and amounts with currency signs or brackets. Then export Excel, a clean CSV, the QuickBooks CSV, a QBO, or a file for Xero, YNAB, Wave, Zoho Books, QIF or OFX.

Yes. Click a date, description or amount in the preview to edit it, or press the cross to remove a row. The totals and the balance check update straight away.

You can add up to 50 files of up to 50 MB each. Large statements take a few seconds longer because your own device does the work.

The rows are sorted from oldest to newest, which is how accounts and balance checks are read. Under More options you can turn the order around to newest first.

Yes, in a current browser. Statement PDFs are read on your phone, so a long statement may take a little longer than on a computer. Downloads go to your Files or Downloads folder.

Mostly. The PDF reader is downloaded once, when you point at the box or add a PDF. After that, converting needs no connection, because nothing is uploaded. If you are offline before the reader has loaded, load the page again with a connection first.

A bank statement holds your name, account number and every payment you made. Uploading it means trusting another company with it. This tool never uploads it. The trade-off is that it cannot read scans, because that needs a server with OCR.

Sometimes, but it often puts a whole line in one cell, merges the description with the amounts and gives dates as text. This tool splits the columns, makes real dates and numbers, joins wrapped lines and checks the balance.

No watermark and no row limit other than your device memory. The Excel file is yours to use for work, tax and accounting.