- Home
- Tools
- Bank Statement to Excel
- CSV to OFX
CSV to OFX Converter
Convert a bank CSV or a bank statement PDF into an OFX file with the account number you choose. Map the columns, check the preview and the balance check, and download. Nothing is uploaded.
- OFX file
- Column mapping
- Balance check
- Bank or credit card
- No upload
Drop your bank statement here
PDF with selectable text, or a CSV from your bank. Up to 50 files at a time
QBO is a beta. QuickBooks Desktop only accepts bank IDs that Intuit lists, so it can refuse this file. The QuickBooks CSV is the more reliable route.
More options: dates, number style, columns, credit cards
Columns of your CSV. Check that each one is matched to the right column.
Check the first and last rows against your statement before you use the file. A flag in the Check column means the running balance does not add up at that row.
Preview. Click a cell to correct it.
| Check | Date | Description | Debit | Credit | Balance | Remove |
|---|
Done on your device. Your statement is never uploaded to FileXL or anyone else.
Found an error, or something was hard to use?
Something did not work?
- 0 bytesuploaded, ever
- Balance checkflags rows that do not add up
- Up to 50statements in one file
- Excel, CSV, QuickBooksreal dates and numbers
By FileXL Team | Last reviewed | Report a problem
How do I convert a CSV to OFX?
Drop the CSV (or a statement PDF) in the box, check that Date, Description and the amount columns are matched, choose OFX, type the last digits of the account number and the currency, and press Download. Import the file in an app that reads OFX.
How to convert a CSV to OFX in 3 steps
No app, no account and no waiting. The statement is read in your browser, so you see the rows and the balance check straight away.
-
Add the CSV
Drop the CSV from your bank. The columns are guessed from the header row.
-
Match the columns
Check Date, Description and the amount columns in the preview and change them if needed.
-
Download the OFX
OFX is selected. Set account type and currency, then press Download.
Tips for CSV to OFX
- The OFX file has no bank ID that is tied to a specific bank, so some apps may ask you to pick the account when you import.
- Every transaction gets a unique ID made from its date and amount, so a repeated import is usually recognised as a duplicate.
- For QuickBooks Desktop use the QBO export or the QuickBooks CSV instead.
- Import into a test account first.
Other ways to convert a bank statement
- Bank statement to Excel converter
- Bank statement analyzer
- Bank statement converter
- PDF bank statement to Excel
- Bank statement to CSV
- CSV to QBO
- Bank statement to QuickBooks
- Combine bank statements
- Bank statement to Xero
- Bank statement to YNAB
- Bank statement to Wave
- Bank statement to Zoho Books
- Bank statement to QIF
Private by design: your statement never leaves your device
Most online bank statement converters upload your PDF to a server. This one does not. The statement is read by your own browser, so your name, account number and every payment stay on your device. The PDF reader (PDF.js, an open source library) is loaded from FileXL when you add a PDF, and your file is never sent anywhere. You can watch the network tab of your browser to check, or turn off your internet once the reader has loaded.
Need to send a file to someone? Upload it with FileXL and share a link. The limit of this tool is scanned statements: a photo of a page has no text to read, and reading it needs OCR on a server, which would mean uploading it.
CSV to OFX questions, answered
What is the difference between OFX and QBO here?
Both use the same OFX structure. The QBO export adds the Intuit bank ID that QuickBooks Desktop looks for. The OFX export leaves it out, which suits Wave, GnuCash, Zoho Books and other apps that read plain OFX.
Which apps read the OFX file?
Many accounting and finance apps read OFX, for example GnuCash, Zoho Books and Wave. This file was checked for structure and not imported into each app, so test with a short period first.
Is my bank statement uploaded to a server?
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.
How accurate is the conversion?
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.
Can it convert a scanned or photographed statement?
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.
What does the balance check mean?
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.
Is this bank statement to Excel converter really free?
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.
Sources and further reading
The facts on this page about QuickBooks files come from Intuit and its tool vendors, and the PDF reader is an open source project. Read them for the full detail.
- QuickBooks Help: Format CSV files in Excel to get bank transactions into QuickBooksIntuit describes the 3-column (Date, Description, Amount) and 4-column (Date, Description, Credit, Debit) CSV layouts.
- ProperSoft FAQ: INTU.BID in QBO and QFX filesA third-party explanation of the bank ID in QBO files and why it has to be one that QuickBooks allows.
- Mozilla PDF.jsThe open source PDF reader (Apache 2.0) that this tool loads in your browser to read the text of a statement.
- YNAB Help: File-Based ImportYNAB describes the CSV file import and the Date, Payee, Memo, Outflow and Inflow columns.
- Wave Help: Upload a bank or credit card statement in CSV formatWave explains the CSV upload and recommends OFX, QBO or QFX when your bank offers them.
- Zoho Books Help: Add transactions and import statementsZoho lists the statement formats it imports, including CSV, OFX and QIF, and where to start the import.
- ProperSoft: Import a CSV file into XeroA third-party guide to the Date, Amount, Payee, Description and Reference columns that Xero maps on import.
- QuickBooks Help: Manually upload transactions into QuickBooks OnlineShows how a CSV, QBO, QFX or OFX file is uploaded in QuickBooks Online.
Made and checked by the FileXL Team
This bank statement converter is built and maintained by the FileXL Team, the people behind the FileXL file sharing service. We test it on many statement layouts, we check the Excel, CSV and QuickBooks files with standard spreadsheet and OFX tools, and we review this page and update it when browsers or the QuickBooks formats change. Layouts differ between banks, so always compare the result with your statement. Last reviewed 13 November 2026. Read more on the about page.
- Found a problem or have an idea? Open the feedback form
- Author: FileXL Team
Need to send a file to someone?
Upload it to FileXL and share a link, a short code or a QR code. Large files, no account needed.
Send files with FileXL I have a codeMore from FileXL
- All free tools
- AI Background Remover
- Video to Reels and Shorts Maker
- Free Online Video Editor
- PDF to Word Converter
- Word to PDF Converter
- HEIC to JPG Converter
- WebP to PNG Converter
- PDF Compressor
- Merge PDF
- Urdu OCR
- Passport Photo Maker
- CNIC Copy Maker
- Document Scanner
- Greeting Card Maker
- Zakat Calculator
- Image Compressor
- JPG to PDF
- Bank Statement Analyzer
- Photo Resizer
- Free AEO Checker
- QR Code Generator
- Send large files free
- Receive a file with a code
- FileXL blog