Thanks John. That's really weird because I swear the csv contains a 2nd transaction that is 1678 to 56286.85. I've been copy pasting from a set of csvs for the tests.
I tried it with some other accounts since then because I had to get the transactions in. In some imports it worked. In some I noticed a pattern where gnucash for some weird reason takes the AUD of the preceding transaction, uses that as an entry into the next one. Hence I think that's causing the exchange rates conflicts. I should have collected the screenshots. I will try the experiment on another computer and share results and figure it out. I will continue to try this out on the next batch of statement imports next month. I will also test if doing it in OFX will be more predictable. Will just have to do pre-processing to translate csv to to ofx. Does anyone in the community have any leads for csv->ofx tools? thanks On Sat, Aug 15, 2020 at 12:07 AM John Ralls <jra...@ceridwen.us> wrote: > > > > On Aug 13, 2020, at 10:07 PM, Gio Bacareza <gbacar...@gmail.com> wrote: > > > > Test 1: > > Import: > > Withdraw Deposit > > 02/21/2020,test first transaction,Account 1 in AUD,1486,0,, > > ,,Account 2 in AUD,0,1486,, > > 02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,, > > ,,Account 3 in PHP,56286.85,0,,note- conversion price stored in gnucash > is is 33.54241157. That is the same price I use to pre-convert. So > 1678.08*33.54241157 = 56286.85 > > > > BZZZT! That's not what your first screen shot says. It says the second > transaction is Account 1 DR AUD 1468.00, Account3 CR 56286.85. > > Regards, > John Ralls -- 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.
