[GNC] Split transaction on invoices in foreign currencies

D. sunfish62 at yahoo.com
Thu Jul 2 13:50:10 EDT 2020


Antonio, 

Your original description of the situation was clear, and the scenario John and Frank and I outlined was accurate. 

The point is this: if you enter the transaction from the GBP account, you can add the bank fee split without invoking the second exchange rate dialog. 


-------- Original Message --------
From: Antonio Roberts <antonio at hellocatfood.com>
Sent: Thu Jul 02 13:24:00 EDT 2020
To: "D." <sunfish62 at yahoo.com>
Cc: Adrien Monteleone <adrien.monteleone at lusfiber.net>, Vinayak Vatsal via gnucash-user <gnucash-user at gnucash.org>
Subject: Re: [GNC] Split transaction on invoices in foreign currencies

Hi David,

Yes, I think I confused you a bit with my description. Just so we're
on the same page I'll try.

I've transferred (as an example) €200 to my GBP account and it's now
£177. I had a £10 bank charge and so I'm trying to split the £177 but
when I do this it's asking me to do a currency conversion.

I guess 'cause the transaction I'm splitting originated from a EUR
transaction it's asking for a conversion.

On Thu, 2 Jul 2020 at 18:11, D. <sunfish62 at yahoo.com> wrote:
>
> 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.
>


-- 
============================
antonio at hellocatfood.com
http://www.hellocatfood.com
============================



More information about the gnucash-user mailing list