It looks like you are missing the Fee JPY split.
What you are showing in the splits is that PHP4282.49 = JPY10000, but
that's not what you listed in 'facts'. That shows PHP4282.29 = JPY10110.
I'm guessing your Fee expenses account is in PHP. If so, you have a few
choices:
1. Create a Fee JPY account.
2. Use a separate transaction for the Fee
3. Enter the initial withdrawal split in JPY first, let GnuCash add the
trading splits, then enter the fee split in JPY and let it either adjust
the trading splits or add new ones. (which you might be able to combine
afterwards)
#1 is probably acceptable, because you did indeed pay the fee in a
foreign currency.
#2 isn't ideal because it artificially breaks up a real world event, but
if #3 doesn't work, or #1 isn't amenable to you, it might be the only way.
As your current transaction stands, you could leave the Fee as PHP even
though that isn't quite correct, but then you have to reduce the PHP
Trading split by PHP311.28, which is also incorrect because it would
mean a different exchange rate. (if that is important to you)
Others may have better suggestions.
Regards,
Adrien
On 1/14/24 10:04 AM, Gio Bacareza wrote:
when withdrawing at a foreign location, most of the time you get charged a
fee. So, for example, your bank is in PHP, then when you're in Japan, you
withdraw in JPY.
Here are the facts:
1. You receive JPY10,000.00
2. ATM charges JPY110.00
3. Your local bank shows a withdrawal of PHP4282.49
4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928
or PHP1 = JPY2.5456
in GNUCASH, the splits I have are:
Account Deposit Withdrawal
JPYCash JPY10000 0
Fee PHP PHP43.21 0
Imbalance PHP PHP311.28 0
Trading:CURRENCY:PHP PHP3928 0
Local Bank PHP 0 PHP4282.49
Trading:CURRENCY:JPY 0 JPY10000
Questions:
1. What is the easiest way to do this? I find this one transaction to be of
so many steps. Perhaps there's a way that I don't know of?
2. Is there an easier way to specify the 110JPY fee if my base currency is
PHP? I had to manually convert it using the date's exchange rate to come up
with the equivalent PHP43.21.
3. The imbalance-PHP was automatically calculated by GNUCASH. Is this
considered to be my loss from the difference between the bank's exchange
rates and the one I used which I got from
https://www.exchange-rates.org/exchange-rate-history/jpy-php?
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.