Having OFX uploads would enhance interoperability with GnuCASH and KMyMoney.
Erik, I add some more of my notes from my Google diggig on OFX :
Replacing Microsoft Money, Part 5: OFX Scripts
This is the spesification:
Account Informatino Download Scripts
OFX (Open Financial eXchange) and Microsoft Money
MT2OFX is a freeware program to link downloaded banking transactions (in MT940, CSV, QIF, OFC, OFX or other non-binary format) to Microsoft Money or other programs which can work with the QIF, OFC and OFX formats. By means of the complete scripting environment to allow the conversion to be adapted entirely to your preferences.
MT20FX made in VB tested on Linux with Wine in 2005 (Fedora Core 3)
Tried a wine install. Installs ok.
MS VB6 page
Shipping Your Windows Application for Linux using Wine
Monydance - (simmelar to GnuCash)
This is the LibOFX library. It is a parser and an API designed to allow
applications to support the OFX banking standard (mostly used for bank
statement download). To my knowledge, it is the first working OpenSource
implementation on the client side. (C, C++)
Erik, some more info about online banking - and a library to be aware of.
AqBanking CLI (GPL) - http://www.aqbanking.de/
1. What Is AqBanking ?
1.1. Generic Online Banking Interface
1.2. Generic Financial Data Importer/Exporter Framework
1.3. Bank/Account Information
GnuCash and KMyMoney support AqBanking
And this bank protocols (Backends):
OFX Direct Connect
Currently AqBanking provides informations about:
- ca 25,000 US banks
- ca 20,000 German banks
- ca 3,600 Swiss banks
- ca 2,300 Austrian banks
AqBanking uses the library Gwenhywfar (http://www.aqbanking.de/) for
abstraction of the underlying system. So it should work on any system for
which Gwenhywfar is available.
The backend AqHBCI provides support for the German online banking protocol
called "Homebanking Computer Interface". It is a national standard provided
by most German credit institutes.
The following security media are supported:
- DDV chipcard (DES-DES-Verfahren)
- RSA chipcard (RSA-DES-Hybrid mode)
- OpenHBCI keyfile (either OpenHBCI 1 or 2, this medium allows continued use
with OpenHBCI in parallel)
- PIN/TAN (PIN/TAN mode using HTTP over SSL)
This backend supports the HBCI versions 2.01, 2.10, 2.20 and 3.00
3.2. OFX Direct Connect
This backend provides support for an online banking protocol used in the
United States, Canada and maybe in the United Kingdom.
EBICS is the successor of the German banking protocol FTAM. It is used in commercial
environments. The tool AqBanking-CLI comes with optional support for this protocol.
This backend uses Paypal's native API for retrieving transactions.
This is a fallback module which can be used by applications for accounts which
are not managed by any online banking backend.
3.2. OFX Direct Connect
Gwenhywfar is licensed under the GNU LGPL (the AqBanking library)
Creation of transactions from bank account import
<freelock> ehu or metatrontech, I was wondering about posting payments through online banking, do either of you (or anyone else) know if there's a way to initiate electronic payments from LSMB?
<ehu> freelock: we're not using electronic payments to generate payments in LSMB or match the bank transactions to the (required) payments.
<ehu> freelock: at this time.
<freelock> I'm seeing the routing and account numbers on vendors, wondering if this is something that we can arrange with our bank...
<freelock> we're setting up bill pay now, so we can pay vendors by logging into the bank's site, I'm wondering if any banks routinely support a web service post to trigger these transactions
<freelock> I know that Quickbooks supports something like this -- I think Intuit acts as some sort of payment processor, doing ACH deductions from your account and deposits into employee accounts
<ehu> my bank accepts upload files, not web service triggers.
<freelock> oh yeah? are you able to generate the upload file from LSMB?
<ehu> should not be too hard. the bank wants XML ISO 20022 messages.
<ehu> freelock: http://www.ing.nl/Images/Addendum-Sect-v6.x-EN_tcm7-119108.pdf?id=20130215105625
<freelock> ehu: thanks... I've seen something like this before,
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.