[GNC] importing csv multisplit multicurrency problems
Geert Janssens
geert.gnucash at kobaltwit.be
Fri Mar 6 03:43:27 EST 2020
Hi,
Unfortunately I don't know what the other importers are capable of. I have not used those
before.
Regards,
Geert
Op vrijdag 6 maart 2020 04:50:06 CET schreef Gio Bacareza:
> Hi Geert, thanks for the feedback.
>
> Questions:
> Is it advisable then to convert csvs to another format?
> What is the preferred format for multicurency imports?
> Any other tips on doing multicurrency imports?
>
> Thanks!
>
> On Fri, Mar 6, 2020 at 1:01 AM Geert Janssens <geert.gnucash at kobaltwit.be>
>
> wrote:
> > There are several bugs with multi-currency csv imports. I don't think it's
> > currently possible to do such imports. Sorry.
> >
> > Geert
> >
> > Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> > > I'm encountering problems with importing transactions in csv when
> >
> > accounts
> >
> > > have different currencies.
> > >
> > > I've been reading the debates. So this is not about definitions of
> > > multi-split or terminology.
> > >
> > > I did a test with a sample csv with the following contents:
> > >
> > > Date,Description,Account,Deposit,Withdrawal
> > > 1/3/2019,Description,test_foreign,,200
> > > ,,Trading:CURRENCY:PHP,,10013
> > > ,,Trading:CURRENCY:USD,200,
> > > ,,test_local,10013,
> > >
> > > gnucash imported successfully but it created an extra line
> > > Imbalance-USD.
> > > See results below:
> > > Date Description Account Deposit Withdrawal
> > > 1/3/2019 Description 200
> > >
> > > Trading:CURRENCY:USD 197.78
> > > test_local 10013
> > > Imbalance-USD 2.22
> > > test_foreign 200
> > > Trading:CURRENCY:PHP 10013
> > >
> > > 1. Why does it do that when imported transactions is already balanced in
> > > the first place?
> > > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> > > allow me. It keeps the imbalance no matter what I do.
> > > 3. How do I solve this?
> > >
> > > Thanks,
> > >
> > > gio
More information about the gnucash-user
mailing list