OFX - Open financial exchange transactions import filter (*.ofx *.ofc *.xml)

Import extension (*.ofx *.ofc *.xml). Install this filter via the menu command Extensions → Manage Extensions.

The file is an import extension for Banana Accounting 8 and following.

It allows the software to:

• Read OFX (Open Financial Exchange) files

• Extract financial transactions

• Convert them into Banana’s Transactions table

What Is OFX?

OFX (Open Financial Exchange) is a structured financial data format used by banks and software such as:

• Quicken

• Microsoft Money

It is more reliable than QIF because it includes:

• Unique transaction IDs (FITID)

• Structured account information

• Statement balances

• Currency data

What the Script Does

The OFX import extension:

1. Parses the OFX file structure

2. Extracts transaction blocks (<STMTTRN>)

3. Reads key fields:

   • Date (<DTPOSTED>)

   • Amount (<TRNAMT>)

   • Description (<NAME>)

   • Memo (<MEMO>)

   • Transaction ID (<FITID>)

4. Converts them into Banana transaction rows

5. Prevents duplicate imports using FITID

Typical OFX Transaction Structure

<STMTTRN>
  <TRNTYPE>DEBIT
  <DTPOSTED>20260301
  <TRNAMT>-125.50
  <FITID>20260301001
  <NAME>Vendor Payment
  <MEMO>Invoice 4587
</STMTTRN>