Free preview before you pay

Convert a bank statement to OFX

Upload a bank CSV, QIF or OFX export. The preview shows your transactions and states plainly how it read the dates and the decimal point, so you can check both before you pay.

Select your bank export A CSV, QIF or OFX file from your bank, exported from online banking or another finance app.

The finished OFX file, made from an invented example

This is the real output of this tool, made from an invented example by the same code that makes yours. The people and details in it are fictional.

Transactions 16From 2 Jan 2026To 31 Jan 2026Money in USD 2,884.11Money out USD 1,427.43Price $9

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:UTF-8
CHARSET:NONE
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20260912210815
<LANGUAGE>ENG
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>0
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<STMTRS>
<CURDEF>USD
<BANKACCTFROM>
<BANKID>000000000
<ACCTID>IMPORTED
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20260102
<DTEND>20260131
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260102
<TRNAMT>-950.00
<FITID>E18378E563884BD86A2F8B39
<NAME>RENT ALDER COURT
<MEMO>RENT ALDER COURT
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260105
<TRNAMT>-6.40
<FITID>858A76B0E7FF042290336270
<NAME>CORNER LOAF BAKERY
<MEMO>CORNER LOAF BAKERY
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260105
<TRNAMT>-84.20
<FITID>C026A1A39EC6C8B6FFC50262
<NAME>FRESHMART GROCERY 0412

... 116 more lines in the sample file

Download the sample OFX file (3 KB)

How are the dates written in this fileLeave this on auto unless the preview gets it wrong. Change it and the preview updates with the new reading, without uploading the file again.

What currency is this statement inLeave this on auto unless the preview says it guessed. Whatever is set here is written into the file you download. Change it and the preview updates.

How it works.

A statement converter fails quietly, not loudly. It never crashes on a wrong date, it just writes the wrong one. Two things get decided from evidence in your file rather than assumed: which way round the dates go, and which character is the decimal point. The preview states both, with the row that settled it, before you spend anything.

Step 1

Upload your export

A CSV from your online banking, a QIF from Quicken or similar, or an OFX file. One file at a time.

Step 2

Check the two assumptions

The preview says how the dates were read and how the decimal point was read, and shows the row that settled each one. If the dates look wrong, set the date order below and preview again before you pay.

Step 3

Download the OFX file

Every transaction, not just the preview's first 20, with a stable transaction ID on each one so importing it twice by accident does not double your ledger.

People also use this for

Guides on this

Trust, with receipts.

No invented review scores, no badges, no “trusted by thousands”. Here is what is actually true, and you can check every line of it.

You see the result before you payUpload, look at your own parsed file, then decide. No account, no card, no email required to get that far.
Files are deleted within 7 daysYour upload, anything extracted from it, and the finished download. Automatically, on a schedule.
A person answers the emailOne Time Tool is a small independent studio in Johannesburg, South Africa. Questions go to hello@onetimetool.com and a person replies, not a bot.
Your card never touches this siteCheckout is hosted by Dodo Payments. We never see your card number.
One payment, for this one jobThere is no subscription, no plan and nothing to cancel. Depending on where you are, checkout may show the price in your currency and add local VAT or sales tax.
7-day money backIf the output is not what you needed, email us and we refund it. No form to fill in.

Questions, answered.

Why OFX and not QFX?

QFX is the same OFX file plus one extra field, INTU.BID, which is a lookup key into Intuit's own list of banks registered for Quicken Web Connect. We have no registration and no right to invent one. A made-up value either gets rejected on import or, worse, matches some unrelated real bank in that directory and mislabels your file as coming from them. So this writes plain OFX, which is the correct file for a lot of software and the wrong file for two well known pieces of it. The next answer says which.

Will this work with Quicken, or with QuickBooks Desktop?

No, and we would rather tell you that here than take your money first. Quicken imports QFX rather than plain .ofx, and QuickBooks Desktop wants .qbo, which is OFX with an Intuit header block on it. Both of those headers are the registration problem in the answer above, so neither is something we can produce honestly. Plain OFX is the right file for QuickBooks Online, GnuCash, and most software that is not made by Intuit. If you are on Quicken or QuickBooks Desktop, the free routes are a QIF or a CSV import depending on your version, and the guides on this site walk through both.

What file do I get from my bank?

Look for an export option in online banking, usually called Download, Export or Statement, and pick CSV, QIF or OFX if it is offered. A PDF statement will not work here, since a PDF has no real columns to read, only printed text laid out to look like a table.

What happens with dates like 03/04/2024?

On their own, dates like that are genuinely ambiguous. The whole file is checked for a row where one reading is impossible, such as a day past 12, and that settles it for every row. If nothing in the file settles it, the preview says so plainly and lets you set the order yourself before paying, rather than guessing and staying quiet about it.

It read my amounts wrong, thousands as decimals or the other way round.

The whole column is checked for a value that can only be read one way, the same approach as the date check. If your bank writes 1.234,56 for one thousand two hundred and thirty four, that is read correctly automatically. If a file is genuinely too small or too clean to settle it, the totals in the preview will not match your real statement, which is exactly what to check before paying.

Does the FITID survive if my transactions already have one, from an OFX I uploaded?

No, every FITID is recomputed from the transaction's own date, amount, description and currency, the same way every time, so importing the same file twice does not create duplicates in whatever you import it into even if the original file's IDs were unreliable.

Can it read a scanned or PDF statement?

No. This reads real columns of data, not printed text. If your bank only offers a PDF, look for a CSV, QIF or OFX export option instead, usually under a different download link on the same page.

What happens to my file?

It is deleted within 7 days, along with the finished OFX file. It is used to make your file and nothing else. Nobody reads it.

Do I need an account?

No. There is no signup, no subscription and no password. You upload, you see the result, you pay once if you want it.