Anyone know if GnuCash can import ofx bank transactions from Australian ING Direct bank?

Chris Good chris.good at ozemail.com.au
Sun Jul 10 03:41:44 EDT 2016


> -----Original Message-----
> From: Liz [mailto:edodd at billiau.net]
> Sent: Sunday, 10 July 2016 9:25 AM
> To: Chris Good <chris.good at ozemail.com.au>
> Subject: Re: Anyone know if GnuCash can import ofx bank transactions from
> Australian ING Direct bank?
>
> >
> > I'll have a look and see if there is some GnuCash option for getting
> > log messages that may explain what's wrong with my data. It would be
> > very helpful if some-one could supply a sample .ofx file that works
> > with GnuCash.
> >
> > [1] http://www.ofx.org/downloads.html
> >
> > BTW (2) Does anyone know if it is possible to set MS Outlook so that
> > every line in an email I send to the GnuCash mailing lists, isn't
> > followed by a blank line in the replies?
> >
> > Regards, Chris Good
>
> sample, unedited, 4 transactions only, tested to see that it works
>
> Liz

Hi Liz,

Thanks very much for supplying the sample .ofx file. It enabled me to
quickly 
identify the problem with my file which was that the xml entity BANKACCTFROM

and its content elements was missing. I.e. before <BANKTRANLIST> should be:
<BANKACCTFROM>
<BANKID>1234
<ACCTID>12345678
<ACCTTYPE>SAVINGS
</BANKACCTFROM>

Without the bank account identifying info, GnuCash doesn't find any 
transactions to import.
After I manually added them to my file, the .ofx transactions imported fine.
I'll write a script to add the missing BANKACCTFROM info and also ensure the

FITID is unique for every transaction within an account.

I have emailed these problems to ING Direct Australia bank and they seem
very 
helpful, so hopefully they will be fixed.
I've no idea if ING Direct Australia uses the same software as other ING 
Direct banks around the world.

Just to document, I noticed the file Liz supplied also had after
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>1234.56
<DTASOF>20160701
</LEDGERBAL>
but this doesn't seem to be needed for importing into GnuCash.

Thanks again Liz and David,

Regards, Chris Good
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4817 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20160710/bbdd0dd7/attachment.p7s>


More information about the gnucash-user mailing list