Re: [GNC] Split transaction on invoices in foreign currencies

[Jim DeLaHunt]

On 2020-07-02 10:24, Antonio Roberts wrote:


…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.…


Antonio:

I feel your pain. I do multi-currency transactions frequently, and it 
took me a while to understand GnuCash's model of a "transaction 
currency", determined by the currency of the account from which you 
create the transaction, but not displayed in the UI. I think you 
understand it now.


I created bug 797664 - /Per-split exchange rates confusing, and UI 
doesn't explain well/  
- as a place to describe what is confusing about the present design, and 
to gather ideas for what improved design might make multi-currency 
transactions easier. If you are interested in participating in bug 
reports, you might want to read that, and add your thoughts.


In the meantime, congratulations on being able to issue an invoice. 
Those are a bit too rare in these pandemic times.


Best regards,
 —Jim DeLaHunt, software engineer, Vancouver, Canada


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[D. via gnucash-user]

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 
Sent: Thu Jul 02 13:24:00 EDT 2020
To: "D." 
Cc: Adrien Monteleone , Vinayak Vatsal via 
gnucash-user 
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.  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 
> Sent: Thu Jul 02 12:44:26 EDT 2020
> To: Adrien Monteleone 
> Cc: GnuCash Users 
> 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
>  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  
> > > wrote:
> > >
> > >
> > >
> > >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> > >> 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@gnucash.org
> > To update your subscription preferences or to unsubscribe:

Re: [GNC] Split transaction on invoices in foreign currencies

[John Ralls]

> On Jul 2, 2020, at 10:24 AM, Antonio Roberts  wrote:
> 
> 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.

Yes, exactly. The important point for you to understand is what made it an EUR 
transaction: It was that you created it in an EUR register or if you used the 
Transfer Dialog it was that of the From Account (the one on the left unless 
you're have "use formal accounting labels" in which case it's the one on the 
right).

Regards,
John Ralls

> 
> On Thu, 2 Jul 2020 at 18:11, D.  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 
>> Sent: Thu Jul 02 12:44:26 EDT 2020
>> To: Adrien Monteleone 
>> Cc: GnuCash Users 
>> 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
>>  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  wrote:
>>>> 
>>>> 
>>>> 
>>>>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
>>>>> 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,
>>

Re: [GNC] Split transaction on invoices in foreign currencies

[Adrien Monteleone]

Got it, thanks.

Regards,
Adrien

> On Jul 2, 2020 w27d184, at 12:13 PM, John Ralls  wrote:
> 
> 
> Read it again: "That currency is determined by the account from which the 
> TRANSACTION IS CREATED." Once the transaction is created its currency is 
> immutable. It matters not a whit in what account one modifies it from.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[Antonio Roberts]

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.  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 
> Sent: Thu Jul 02 12:44:26 EDT 2020
> To: Adrien Monteleone 
> Cc: GnuCash Users 
> 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
>  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  
> > > wrote:
> > >
> > >
> > >
> > >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> > >> 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@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.
>
>
>
> --
> 
> anto...@hellocatfood.com
> http://www.hellocatfood.com
> 
> ___

Re: [GNC] Split transaction on invoices in foreign currencies

[John Ralls]

Read 

> On Jul 2, 2020, at 9:39 AM, Adrien Monteleone 
>  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  wrote:
>> 
>> 
>> 
>>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
>>> 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.


Read it again: "That currency is determined by the account from which the 
TRANSACTION IS CREATED." Once the transaction is created its currency is 
immutable. It matters not a whit in what account one modifies it from.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[D. via gnucash-user]

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 
Sent: Thu Jul 02 12:44:26 EDT 2020
To: Adrien Monteleone 
Cc: GnuCash Users 
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
 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  wrote:
> >
> >
> >
> >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> >> 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@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.



-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[Antonio Roberts]

> 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
 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  wrote:
> >
> >
> >
> >> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  
> >> 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@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.



-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[Adrien Monteleone]

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  wrote:
> 
> 
> 
>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  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@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[John Ralls]

> On Jul 2, 2020, at 9:08 AM, Antonio Roberts  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@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[Frank H. Ellenberger]

Hi,

Am 02.07.20 um 18:25 schrieb w...@theprescotts.com:
> I don't remember the circumstances, but it seems like I have had the same 
> issue on transactions that are half in one currency and half in the other. It 
> will sometimes ask for the exchange rate, when it doesn't need it.

Each transaction has a (base) currency, which is inherited from the
account, where you start to enter the transaction.

So, if you know you need to adjust the GBP part, enter the transaction
from one of the GBP accounts.

HTH
Frank
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[Adrien Monteleone]

If you are adding another split to the same transaction that contains an EUR 
split, it will need to balance that bank charge split as well. It may be trying 
to balance all GBP splits with all EUR splits. That might be considered a bug, 
but you can work around it.

Either adjust the EUR split, add an EUR split for balancing, or make a separate 
transaction just for the bank charge. (probably the simplest approach, which 
would keep it all in GBP and not trigger the rate request)

Regards,
Adrien

> On Jul 2, 2020 w27d184, at 11:08 AM, Antonio Roberts 
>  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?

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Split transaction on invoices in foreign currencies

[w...@theprescotts.com]

I do a lot of that since I live in Mexico and have bank accounts in both the US 
and Mexico.

I don't remember the circumstances, but it seems like I have had the same issue 
on transactions that are half in one currency and half in the other. It will 
sometimes ask for the exchange rate, when it doesn't need it. I think if you 
just give it the exchange rate (which it already has), it works fine. It is 
just that when you tab out of a field it wants the exchange rate even though it 
doesn't do anything with it.

Will

On 2020 Jul 2, at 07-02 11:08:50, Antonio Roberts  
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?

-- 

anto...@hellocatfood.com
http://www.hellocatfood.com

___
gnucash-user mailing list
gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.