Overview

This is a VB macro in Excel that allows for the generation of financial transaction files in the Open Financial Exchange (OFX) format, a unified specification created jointly by Intuit, Microsoft, and CheckFree in early 1997, to enable the exchange of financial data over the Internet.

The "XLS2OFX" worksheet collects statement level information such as financial institution id, account number, statement date, currency, previous balance, etc. in the colored section of the worksheet, one can enter transactions by simply indicating a date, a description, and a  debit or credit amount. The VB macro will also need an output filename.

Please note that if you don't have a previous balance, you will still be able to import the generated file, although your financial software (for instance, MS Money) will complain about an unreconciled balance.

Sample application: Palm Expense

An example of how to transfer Palm Expense information into MS Money is provided. An spreadsheet based on the XLS2OFX worksheet is included in this package. You can see how one can organize Palm Expense transaction data into MS Money statements.

Of course, one can be much simpler by just copying into the XLS2OFX colored section the transactions to be included in the OFX file. The financial institution id (or bank id) and account number can be obtained from your financial software (for instance, account details in MS Money).

Terms and Conditions

This is a shareware program but has no functional limitations. Therefore, you'll be able to use it as long as you want for free. However, if you feel graceful enough and would like to contribute to its maintenance and support, please send a $10 check to:

Josep Bori

120 East 87th Street, Apt. P4J

New York, NY 10128

US