[GNC] how to encode ATM withdrawals with fees

[Adrien Monteleone]

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?