Importing many transfers between accounts in different currencies

[Tim Hume]

Thanks Sébastien and Geert for your replies,

In the end I entered the transactions manually - there were only 183
- now I'll have to check I didn't make any mistakes. I never fully got
to the bottom of the question of whether OFX could be used to import
the data or not - OFX is pretty complex.

I'll definitely have a look at piecash.

Cheers,

Tim.

On Sun, 22 Jan 2017 21:36:54 +0100
Sébastien de Menten <sdementen at gmail.com> wrote:

> Hi Tim
> 
> As you have some programming experience, you may be interested by
> https://github.com/sdementen/piecash to automate your task of introducing
> transactions in gnucash.
> 
> Kr
> 
> Sebastien
> 
> On Jan 22, 2017 03:27, "Tim Hume" <tim at nomuka.com> wrote:
> 
> > Hi everyone,
> >
> > I'm using GnuCash to do the accounts for a small money transfer
> > business. Customers in Australia send Australian dollars (AUD) to be
> > collected by their family in the form of Tongan Pa'anga (TOP).
> >
> > I'm using version 2.6.11 and have trading accounts enabled.
> >
> > I've worked out how to manually enter transfers between an Australian
> > bank account and a Tongan bank account, along with the exchange rate.
> > This seems to work correctly. Now I want to know how/if I can
> > automatically import hundreds of such transfers from data I have in a
> > spreadsheet (Google Sheets). It's easy enough to import transfers which
> > go between accounts with the same currency - I wrote some Google
> > scripts which exported the relevant information in QIF format. I even
> > manually created some OFX files to try this format for importing.
> >
> > What I can't work out how to do is create QIF or OFX files which
> > describe a transfer from my Australian bank account to my Tongan
> > account (or vice versa). I don't think QIF can handle multiple
> > currencies - OFX can, but I'm not sure if GnuCash's importer can deal
> > with such transactions or not?
> >
> > I'm starting to think I'm going to have to bite the bullet and type all
> > these transactions in manually. But if anyone knows if international
> > transfers can be automatically imported, this would  save me much time,
> > and probably errors too.
> >
> > Thanks,
> >
> > Tim.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >


-- 
Tim Hume <tim at nomuka.com>