Re: [GNC] importing csv multisplit multicurrency problems
Not your fault at all but mine. I was looking at all possible causes for the faulty import. Thanks On Wed, Mar 11, 2020, 1:40 PM wrote: > Sorry Gio, I don’t have any experience with the import or multi-currency > transactions in GnuCash. > > I only responded to your query because you wanted a better way to load a > price database rather than entering them manually. > > Cheers. > > On 11-Mar-2020, at 10:32 AM, Gio Bacareza wrote: > > Hi Pobox.Deva, > > Thank you for the suggestion. I'll try that out. However my problem, I > think though I may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the > currency conversions using just 1 exchange rate. I thought that by doing > this I avoid having to maintain a price database that could change on a > daily basis. Because this would mean the calculating the conversions prior > to import will require me to have a different conversion rate depending on > the day. It's possible but I thought it will take more work. > > But I may be wrong. So do you think that fixing the price database will > fix the multi-currency import problem I am having? > > Thanks. > > > On Fri, Mar 6, 2020 at 1:37 PM wrote: > >> Gio, >> >> If you are using the 3.x series, there’s a convenient CSV price importer >> that works well. You can even save the CSV price file template for future >> use, so you’d have to set it up only once. >> >> That should alleviate a lot of burden in entering prices in price >> database manually. >> >> Cheers. >> >> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: >> > >> > Date: Fri, 6 Mar 2020 12:23:17 +0800 >> > From: Gio Bacareza mailto:gbacar...@gmail.com>> >> > To: GnuCash Users > gnucash-user@gnucash.org>> >> > Subject: Re: [GNC] importing csv multisplit multicurrency problems >> > Message-ID: >> > < >> caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com >> > caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com>> >> > Content-Type: text/plain; charset="UTF-8" >> > >> > As mentioned I did some follow through tests with empty and >> pre-populated >> > currency price databases. Sharing it here: >> > >> > Conclusions: >> > When doing multi-currency csv imports, it works when the price database >> is >> > pre-populated with exchange rates consistent with exchange rates used in >> > the import. >> > The issue I have with this is that pre-populating the price DB is >> > cumbersome. >> > There has to be a better way. >> > >> > More details of test here >> > >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> < >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > cheers, > > Gio > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Sorry Gio, I don’t have any experience with the import or multi-currency transactions in GnuCash. I only responded to your query because you wanted a better way to load a price database rather than entering them manually. Cheers. > On 11-Mar-2020, at 10:32 AM, Gio Bacareza wrote: > > Hi Pobox.Deva, > > Thank you for the suggestion. I'll try that out. However my problem, I think > though I may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the currency > conversions using just 1 exchange rate. I thought that by doing this I avoid > having to maintain a price database that could change on a daily basis. > Because this would mean the calculating the conversions prior to import will > require me to have a different conversion rate depending on the day. It's > possible but I thought it will take more work. > > But I may be wrong. So do you think that fixing the price database will fix > the multi-currency import problem I am having? > > Thanks. > > > On Fri, Mar 6, 2020 at 1:37 PM <mailto:pobox.d...@outlook.in>> wrote: > Gio, > > If you are using the 3.x series, there’s a convenient CSV price importer that > works well. You can even save the CSV price file template for future use, so > you’d have to set it up only once. > > That should alleviate a lot of burden in entering prices in price database > manually. > > Cheers. > > > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org > > <mailto:gnucash-user-requ...@gnucash.org> wrote: > > > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > > From: Gio Bacareza mailto:gbacar...@gmail.com> > > <mailto:gbacar...@gmail.com <mailto:gbacar...@gmail.com>>> > > To: GnuCash Users > <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org > > <mailto:gnucash-user@gnucash.org>>> > > Subject: Re: [GNC] importing csv multisplit multicurrency problems > > Message-ID: > >> <mailto:caec3bmq5irklc0ew79ra3ktvb%2bxejkou72r9pv0a9v7bxi_...@mail.gmail.com> > > <mailto:caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > > <mailto:caec3bmq5irklc0ew79ra3ktvb%2bxejkou72r9pv0a9v7bxi_...@mail.gmail.com>>> > > Content-Type: text/plain; charset="UTF-8" > > > > As mentioned I did some follow through tests with empty and pre-populated > > currency price databases. Sharing it here: > > > > Conclusions: > > When doing multi-currency csv imports, it works when the price database is > > pre-populated with exchange rates consistent with exchange rates used in > > the import. > > The issue I have with this is that pre-populating the price DB is > > cumbersome. > > There has to be a better way. > > > > More details of test here > > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > > <https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing> > > > > <https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > > <https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing>> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > -- > cheers, > > Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Hi Pobox.Deva, Thank you for the suggestion. I'll try that out. However my problem, I think though I may be wrong, is not the price database but the importing multicurrency transactions. I even made it simpler. Pre-import, I calculated and populated the currency conversions using just 1 exchange rate. I thought that by doing this I avoid having to maintain a price database that could change on a daily basis. Because this would mean the calculating the conversions prior to import will require me to have a different conversion rate depending on the day. It's possible but I thought it will take more work. But I may be wrong. So do you think that fixing the price database will fix the multi-currency import problem I am having? Thanks. On Fri, Mar 6, 2020 at 1:37 PM wrote: > Gio, > > If you are using the 3.x series, there’s a convenient CSV price importer > that works well. You can even save the CSV price file template for future > use, so you’d have to set it up only once. > > That should alleviate a lot of burden in entering prices in price database > manually. > > Cheers. > > > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: > > > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > > From: Gio Bacareza mailto:gbacar...@gmail.com>> > > To: GnuCash Users gnucash-user@gnucash.org>> > > Subject: Re: [GNC] importing csv multisplit multicurrency problems > > Message-ID: > > < > caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > <mailto:caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > >> > > Content-Type: text/plain; charset="UTF-8" > > > > As mentioned I did some follow through tests with empty and pre-populated > > currency price databases. Sharing it here: > > > > Conclusions: > > When doing multi-currency csv imports, it works when the price database > is > > pre-populated with exchange rates consistent with exchange rates used in > > the import. > > The issue I have with this is that pre-populating the price DB is > > cumbersome. > > There has to be a better way. > > > > More details of test here > > > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > < > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Thanks, I had seen that link, but hadn’t looked it over carefully enough. I realize now you had 2 transactions with 2 splits each. (I first thought it was one with 4) I tried a similar test import without a price in the db. Indeed it imported as imbalanced, and would not let me fix it no matter what I tried. (which I would think, is another bug as you should be able to properly manually edit a transaction, imported or not.) Regards, Adrien > On Mar 6, 2020 w10d66, at 1:23 AM, Gio Bacareza wrote: > > Adrien, results here > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
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 > > 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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Adrien, results here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I might have misunderstood your earlier reply, but what if you leave off > the Trading accounts from the import entirely and don’t have a price > defined in the database? (that is, only 2 splits, not 4) > > What does GnuCash do then? I should think it should add the Trading > account splits as exact based on the entered splits just as if you had done > the transaction manually and enter the resulting exchange rate in the price > db. But I could be mistaken. Perhaps that was one of the bugs Geert was > referring to. > > Regards, > Adrien > > > On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza > wrote: > > > > As mentioned I did some follow through tests with empty and pre-populated > > currency price databases. Sharing it here: > > > > Conclusions: > > When doing multi-currency csv imports, it works when the price database > is > > pre-populated with exchange rates consistent with exchange rates used in > > the import. > > The issue I have with this is that pre-populating the price DB is > > cumbersome. > > There has to be a better way. > > > > More details of test here > > > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
I might have misunderstood your earlier reply, but what if you leave off the Trading accounts from the import entirely and don’t have a price defined in the database? (that is, only 2 splits, not 4) What does GnuCash do then? I should think it should add the Trading account splits as exact based on the entered splits just as if you had done the transaction manually and enter the resulting exchange rate in the price db. But I could be mistaken. Perhaps that was one of the bugs Geert was referring to. Regards, Adrien > On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza wrote: > > As mentioned I did some follow through tests with empty and pre-populated > currency price databases. Sharing it here: > > Conclusions: > When doing multi-currency csv imports, it works when the price database is > pre-populated with exchange rates consistent with exchange rates used in > the import. > The issue I have with this is that pre-populating the price DB is > cumbersome. > There has to be a better way. > > More details of test here > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Gio, If you are using the 3.x series, there’s a convenient CSV price importer that works well. You can even save the CSV price file template for future use, so you’d have to set it up only once. That should alleviate a lot of burden in entering prices in price database manually. Cheers. > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > From: Gio Bacareza mailto:gbacar...@gmail.com>> > To: GnuCash Users mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] importing csv multisplit multicurrency problems > Message-ID: ><mailto:caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com>> > Content-Type: text/plain; charset="UTF-8" > > As mentioned I did some follow through tests with empty and pre-populated > currency price databases. Sharing it here: > > Conclusions: > When doing multi-currency csv imports, it works when the price database is > pre-populated with exchange rates consistent with exchange rates used in > the import. > The issue I have with this is that pre-populating the price DB is > cumbersome. > There has to be a better way. > > More details of test here > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > <https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
As mentioned I did some follow through tests with empty and pre-populated currency price databases. Sharing it here: Conclusions: When doing multi-currency csv imports, it works when the price database is pre-populated with exchange rates consistent with exchange rates used in the import. The issue I have with this is that pre-populating the price DB is cumbersome. There has to be a better way. More details of test here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 11:48 AM Gio Bacareza wrote: > Thank you Adrien. Inspired by your answers I did a few more tests. > 1. I got rid of the lines with the trading accounts assuming from past > behavior that gnucash will autopopulate with trading currency accounts > based on price database: > Date Description Account Deposit Withdrawal > 3/6/2020 Description test_foreign 200 > test_local 10013 > > it was a success! gnucash added trading currency accounts automatically > and there was no imbalance line. > > 2. So I applied it to the actual transaction data using the same method. > FAILED. gnucash added the imbalances again :( > > 3. So I changed the price database for USD then made it all the same > value. Then I deleted and re-created the account. Then I reimported the > transactions. > SUCCESS!!! > > So conclusion: As long as price is consistent, you can import > multi-currency transactions using multiplit with 1 side currency 1 and the > other side converted currency 2. > > i'll do some test with a blank price database and let everyone know. > > > On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> >> >> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza >> wrote: >> > >> > 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? >> >> Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in >> the database that is conflicting and GnuCash is trying to use that rather >> than set a new price based on the transaction. (I’m not intimately familiar >> with multi-currency import) >> >> See below about manual entries, as I’d suspect either some step is >> missing for the import, or there is a bug. >> >> > 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. >> >> I’m not certain if this will work with editing an existing imported >> transaction, but doing a manual version of your test I was able to get it >> to behave properly. >> >> > 3. How do I solve this? >> >> I entered these splits first: (Dr/Cr. reversed for my book which is in >> USD) >> >> Dr. test_local 200 >> Cr. test_foreign 10013 >> >> When I tabbed off the last one, the exchange rate dialog popped up. It >> defaulted to having me enter or fetch the rate, instead I chose Debit >> Amount (credit in your case) and entered the amount in the test_local >> account that I wanted to debit and committed the dialog. >> >> This created 2 more splits in their respective trading accounts that were >> exact @ 200 and 10013 respectively as they should be. >> >> Your post reminded me of an issue I had a few months ago that I couldn’t >> get rid of a similar Imbalance split involving trading accounts. I solved >> it by switching to using the debit/credit amount field instead of the >> exchange rate field. This makes sense because if you know the exact >> amounts, you are defining a new price, you don’t need to fetch or employ an >> existing one. I find that fetching or using price db figures are good for >> current-value reports of my foreign currency and commodity assets. They >> aren’t as useful (to me) for transaction entry. >> >> Regards, >> Adrien >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >>
Re: [GNC] importing csv multisplit multicurrency problems
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 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 > > > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
Thank you Adrien. Inspired by your answers I did a few more tests. 1. I got rid of the lines with the trading accounts assuming from past behavior that gnucash will autopopulate with trading currency accounts based on price database: Date Description Account Deposit Withdrawal 3/6/2020 Description test_foreign 200 test_local 10013 it was a success! gnucash added trading currency accounts automatically and there was no imbalance line. 2. So I applied it to the actual transaction data using the same method. FAILED. gnucash added the imbalances again :( 3. So I changed the price database for USD then made it all the same value. Then I deleted and re-created the account. Then I reimported the transactions. SUCCESS!!! So conclusion: As long as price is consistent, you can import multi-currency transactions using multiplit with 1 side currency 1 and the other side converted currency 2. i'll do some test with a blank price database and let everyone know. On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza > wrote: > > > > 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? > > Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in > the database that is conflicting and GnuCash is trying to use that rather > than set a new price based on the transaction. (I’m not intimately familiar > with multi-currency import) > > See below about manual entries, as I’d suspect either some step is missing > for the import, or there is a bug. > > > 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. > > I’m not certain if this will work with editing an existing imported > transaction, but doing a manual version of your test I was able to get it > to behave properly. > > > 3. How do I solve this? > > I entered these splits first: (Dr/Cr. reversed for my book which is in USD) > > Dr. test_local 200 > Cr. test_foreign 10013 > > When I tabbed off the last one, the exchange rate dialog popped up. It > defaulted to having me enter or fetch the rate, instead I chose Debit > Amount (credit in your case) and entered the amount in the test_local > account that I wanted to debit and committed the dialog. > > This created 2 more splits in their respective trading accounts that were > exact @ 200 and 10013 respectively as they should be. > > Your post reminded me of an issue I had a few months ago that I couldn’t > get rid of a similar Imbalance split involving trading accounts. I solved > it by switching to using the debit/credit amount field instead of the > exchange rate field. This makes sense because if you know the exact > amounts, you are defining a new price, you don’t need to fetch or employ an > existing one. I find that fetching or using price db figures are good for > current-value reports of my foreign currency and commodity assets. They > aren’t as useful (to me) for transaction entry. > > Regards, > Adrien > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing csv multisplit multicurrency problems
> On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza wrote: > > 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? Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in the database that is conflicting and GnuCash is trying to use that rather than set a new price based on the transaction. (I’m not intimately familiar with multi-currency import) See below about manual entries, as I’d suspect either some step is missing for the import, or there is a bug. > 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. I’m not certain if this will work with editing an existing imported transaction, but doing a manual version of your test I was able to get it to behave properly. > 3. How do I solve this? I entered these splits first: (Dr/Cr. reversed for my book which is in USD) Dr. test_local 200 Cr. test_foreign 10013 When I tabbed off the last one, the exchange rate dialog popped up. It defaulted to having me enter or fetch the rate, instead I chose Debit Amount (credit in your case) and entered the amount in the test_local account that I wanted to debit and committed the dialog. This created 2 more splits in their respective trading accounts that were exact @ 200 and 10013 respectively as they should be. Your post reminded me of an issue I had a few months ago that I couldn’t get rid of a similar Imbalance split involving trading accounts. I solved it by switching to using the debit/credit amount field instead of the exchange rate field. This makes sense because if you know the exact amounts, you are defining a new price, you don’t need to fetch or employ an existing one. I find that fetching or using price db figures are good for current-value reports of my foreign currency and commodity assets. They aren’t as useful (to me) for transaction entry. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.