[GNC] Split transaction on invoices in foreign currencies

D. sunfish62 at yahoo.com
Thu Jul 2 13:11:05 EDT 2020


Antonio, 

I think the point that John and Frank were making is that if you *entered* the transaction in the EUR account, then it will have EUR as its currency, and you will be asked to provide an exchange rate for every GBP split that is subsequently entered, regardless of your current register. When I read your original post, it looks like you created the transaction while in the EUR account (you stated "transferred the EUR into my GBP Bank", which strongly implies this). If this is in fact what you did, then you can either enter the same exchange rate as John suggested, or enter the transaction from the GBP account and avoid the subsequent request.

David


-------- Original Message --------
From: Antonio Roberts <antonio at hellocatfood.com>
Sent: Thu Jul 02 12:44:26 EDT 2020
To: Adrien Monteleone <adrien.monteleone at lusfiber.net>
Cc: GnuCash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

> Unless I read the original post wrong, and the OP could clarify, but it looks like they were entering this split in a GBP based account (the GBP bank account) and adding a GBP split for the bank charge.

Yes, that is correct. I transferred the funds from EUR to GBP account
and in that transaction line in the GBP account I'm attempting to do a
split and it's prompting me about currency conversion.

As suggested above I could just do a separate line in the GBP Bank
Charges expense account but my preference is to split as it shows
where the charge is inherited from.

Kind regards,

Antonio

On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone
<adrien.monteleone at lusfiber.net> wrote:
>
> Unless I read the original post wrong, and the OP could clarify, but it looks like they were entering this split in a GBP based account (the GBP bank account) and adding a GBP split for the bank charge.
>
> Regards,
> Adrien
>
>
>
>
> > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls <jralls at ceridwen.us> wrote:
> >
> >
> >
> >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts <antonio at hellocatfood.com> wrote:
> >>
> >> I'm in the UK doing most of my accounting in GBP (£) but in this case
> >> I invoiced someone in EUR (€). Following the advice from here I sent
> >> up a Bank in EUR, invoiced them in EUR and then transferred the EUR
> >> into my GBP Bank with the current exchange rate (my bank supplies the
> >> rate at the time of transaction).
> >>
> >> However, this conversion incurred a bank charge in GBP. In GNUcash
> >> I've gone to my GBP Bank balance to the transaction line to split it
> >> to deduct the bank transfer. When I do this it's asking me to do a
> >> currency conversion from EUR to GBP.
> >>
> >> The funds are already in the GBP bank so why am I being asked to do
> >> conversion again? Is there something I've done wrong?
> >
> > No, you haven't done anything wrong. Every transaction has a transaction currency that's used to balance the transaction. That currency is determined by the account from which the transaction is created, and in this case it's EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use the same exchange rate that you used to convert the EUR payment to GBP.
> >
> > Regards,
> > John Ralls
>
>
> _______________________________________________
> 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
> 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.



-- 
============================
antonio at hellocatfood.com
http://www.hellocatfood.com
============================
_______________________________________________
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
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.



More information about the gnucash-user mailing list