OFX file example

Derek Atkins warlord at MIT.EDU
Wed Aug 1 11:25:39 EDT 2012


Hi,

Richard Thomas <richdthomas at gmail.com> writes:

> Hi Derek,
>
> My choice of file format to import is down to the way I use Gnucash and my
> online banking.
>
> I hand enter my transactions and then import from my online banking data.
>
> I have now written a script to convert my bank's CSV file format to OFX file
> format.
>
> It's producing OFX files that Gnucash is understanding, which I'm really
> pleased with.

What is your source of FITID for the OFX?

> Thanks,
>
> Richard.

-derek

> On 30 July 2012 23:00, Derek Atkins <warlord at mit.edu> wrote:
>
>     Hi,
>    
>     Richard Thomas <richdthomas at gmail.com> writes:
>    
>     > Hi
>     >
>     > Would anybody be able to point me in the direction of a really simple
>     OFX
>     > file example please.
>     >
>     > Below is an example of a QIF file, to show the type of transaction I
>     want
>     > to import as OFX:
>     >
>     > !Type:Bank
>     > D19/07/2012
>     > NTST PRICHARD ENTERPRISES
>     > Cc
>     > T-12.34
>     > ^
>    
>     There is no such thing as a "really simple OFX file".  OFX is a fairly
>     complicated SGML protocol.  Why do you want to convert a nice, simple
>     QIF transaction to the complicated OFX format?  The only benefits of
>     OFX, IMHO, are the ability to do automated duplicate-import detection
>     (using the account-unique OFX FITID) and the Bayesian account mapping.
>     OTOH QIF lets you do mass assignment of transactions with the same Payee
>     or Memo.
>    
>     > Thanks in advance.
>     >
>     > Richard.
>    
>     > Please remember to CC this list on all your replies.
>     > You can do this by using Reply-To-List or Reply-All.
>    
>     -derek
>    
>     --
>            Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>            Member, MIT Student Information Processing Board  (SIPB)
>            URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>            warlord at MIT.EDU                        PGP key available
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-user mailing list