[GNC] how to encode ATM withdrawals with fees
Derek Atkins
derek at ihtfp.com
Sun Jan 14 11:41:37 EST 2024
I just do it simply by taking the amount in the foreign currency and the
TOTAL amount that affects my bank, and roll any fees into the exchange
rate. So in your case, a simple transaction of 10,000 JPY to 4282.49 PHP.
Unless there is really some required reason to keep track of the fees?
-derek
On Sun, January 14, 2024 11: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?
>
> Thanks
>
> gio
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
--
Derek Atkins 617-623-3745
derek at ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
More information about the gnucash-user
mailing list