Re: [GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread rsbrux via gnucash-user
Thanks for your responses, David and Fred. In fact, I used to just duplicate the last transaction and adjust the CHF amount using "Edit Exchange rate", as Fred suggests. This invokes the conversion rate dialog which, as David points out, *does* allow me to specify the target amount and let

Re: [GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread Fred Bone
On 04 September 2024 at 13:19, rsbrux said: > We have monthly transactions where a payment in USD is credited to a CHF > bank account. The USD amount is fixed, but the CHF amount varies depending > on the conversion rate. As has been recommended on this list, I have > configured these as scheduled

Re: [GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread sunfish62--- via gnucash-user
In my (limited) experience, the conversion rate dialog allows you to enter a rate *or a destination amount*. I always use the destination amount in this dialog, since I know how many CHF (to use your example) I received, but never the rate to 34 decimal places, which is what GnuCash seems to wan

Re: [GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread Stan Brown (using GC 4.14)
On 2024-09-04 04:19, rsbrux via gnucash-user wrote: > We have monthly transactions where a payment in USD is credited to a > CHF bank account. The USD amount is fixed, but the CHF amount varies > depending on the conversion rate. As has been recommended on this > list, I have configured these as

[GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread rsbrux via gnucash-user
We have monthly transactions where a payment in USD is credited to a CHF bank account. The USD amount is fixed, but the CHF amount varies depending on the conversion rate. As has been recommended on this list, I have configured these as scheduled transactions with a variable in place of the CHF

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-04 Thread Michael or Penny Novack
On 7/3/2024 5:14 PM, R Losey wrote: Just to keep them separate, I would use usd_amount and chf_amount for the variables. I kind of ignore the currency exchange rate... I enter everything as USD because I live in America, and my bank accounts and credit cards are in USD. So, if I have a euro tra

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread William Prescott
; previously paid out in U.S. dollars (USD) but are now paid out in Swiss > > Francs (CHF). > > > > I previously handled these with a scheduled transaction, since the amounts > > remained the same over at least a year, but this doesn't work anymore. > > > > S

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread R Losey
> gnucash-user@gnucash.org> > > wrote: > > > > We receive monthly payments from U.S. Social Security. These werre > > previously paid out in U.S. dollars (USD) but are now paid out in Swiss > > Francs (CHF). > > > > I previously handled these with a scheduled

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread Ronald Solomon
id out in U.S. dollars (USD) but are now paid out in Swiss > > Francs (CHF). > > > > I previously handled these with a scheduled transaction, since the > amounts > > remained the same over at least a year, but this doesn't work anymore. > > > > Since th

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread Tommy Trussell
SD) but are now paid out in Swiss > Francs (CHF). > > I previously handled these with a scheduled transaction, since the amounts > remained the same over at least a year, but this doesn't work anymore. > > Since the income account is in USD, each deposit (to a CHF account) is now

Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread William Prescott
this doesn't work anymore. Since the income account is in USD, each deposit (to a CHF account) is now associated with a currency conversion rate determined ad hoc by the U.S. Social Security Administration. Is there an elegant way to handle this, perhaps with a scheduled transaction

[GNC] How to handle recurring transactions with currency conversion

2024-07-03 Thread rsbrux via gnucash-user
work anymore. Since the income account is in USD, each deposit (to a CHF account) is now associated with a currency conversion rate determined ad hoc by the U.S. Social Security Administration. Is there an elegant way to handle this, perhaps with a scheduled transaction having a constant USD a

Re: [GNC] Currency conversion

2023-12-14 Thread Ze'ev Ionis
ndam Sent: Thursday, December 14, 2023 3:16 PM To: Ze'ev Ionis ; gnucash-user@gnucash.org Subject: Re: Currency conversion can you attach the screen shot of the pop up and also the account details of both accounts Saludos Cordiales Murugan From: Ze'

Re: [GNC] Currency conversion

2023-12-14 Thread Murugan Muruganandam
andam Sent: Thursday, December 14, 2023 3:04:33 PM To: Ze'ev Ionis ; gnucash-user@gnucash.org Subject: Re: Currency conversion Did you create the US Visa Card in USD currency under liabilities? if so when you entered the transaction you should have got a pop up to enter the conversion ra

Re: [GNC] Currency conversion

2023-12-14 Thread Ze'ev Ionis
Sent: Thursday, December 14, 2023 3:04:33 PM To: Ze'ev Ionis ; gnucash-user@gnucash.org Subject: Re: Currency conversion Did you create the US Visa Card in USD currency under liabilities? if so when you entered the transaction you should have got a pop up to enter the conversion rate and the

Re: [GNC] Currency conversion

2023-12-14 Thread Murugan Muruganandam
behalf of Ze'ev Ionis Sent: Thursday, December 14, 2023 3:52 PM To: gnucash-user@gnucash.org Subject: [GNC] Currency conversion I have a checking account in CDN $. I have a credit card in US $. I made a transfer of C$ from Checking into US Visa. The notes show the correct values, includin

[GNC] Currency conversion

2023-12-14 Thread Ze'ev Ionis
I have a checking account in CDN $. I have a credit card in US $. I made a transfer of C$ from Checking into US Visa. The notes show the correct values, including the conversion rate. But the actual entries show the values entered in C$ (e.g. 1,300) in both accounts - where it should be aroun

Re: [GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions

2023-09-15 Thread Bjoern
Hi, I have submitted it under https://bugs.gnucash.org/show_bug.cgi?id=799082 . Kind regards Bjoern Am 11.09.2023 um 21:24 schrieb Geert Janssens: Hi, That looks like a bug indeed. To make sure this doesn't get lost on the mailing list, can you file a bug report for this in bugzilla pleas

Re: [GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions

2023-09-11 Thread Geert Janssens
Hi, That looks like a bug indeed. To make sure this doesn't get lost on the mailing list, can you file a bug report for this in bugzilla please ? Regards, Geert Op zaterdag 9 september 2023 13:51:39 CEST schreef Bjoern: > Hi! > > I came across a potential issue with the use of the correct ra

[GNC] Potential issue with inversion of currency conversion rate during CSV import of transactions

2023-09-09 Thread Bjoern
Hi! I came across a potential issue with the use of the correct rate for cross-currency transactions during CSV imports where I hope others here could reproduce the issue or tell me where I took a wrong turn during thinking. use case: As a German national I live and work abroad in Sweden temp

Re: [GNC] Currency conversion

2023-07-30 Thread john
Not really. That happens because sometimes you make or request prices in one direction and sometimes the other. The only case where it would matter is if one of them hadn't been updated in a while. The price-retrieval code looks first in the direction it wants, then in the other direction, then

[GNC] Currency conversion

2023-07-30 Thread Fred Tydeman
I have noticed that my Price Database has both COP -> USD and USD -> COP conversion rates. Does it matter? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailma

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 2:43 PM, Dr. David Kirkby wrote: Unless I am mistaken, it is not easy to delete transactions when using the business features. I don't think one can simply delete a transaction and it goes away. You can't delete invoices, but you can remove their entries in your books by un-posting.

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Dr. David Kirkby
On Tue, 3 Jan 2023 at 17:00, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > On 1/3/23 7:08 AM, Dr. David Kirkby wrote: > > I have the following situation > > > > I'm in the UK, where the currency is GBP > > A customer in Poland paid $540 for consultancy via Zoom. He paid in > > adv

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Adrien Monteleone
On 1/3/23 7:08 AM, Dr. David Kirkby wrote: I have the following situation I'm in the UK, where the currency is GBP A customer in Poland paid $540 for consultancy via Zoom. He paid in advance, so I've not added him as a customer under the business features. Murugan answered the main question on

Re: [GNC] Problem adding a split to a currency conversion.

2023-01-03 Thread Murugan Muruganandam
. Saludos Cordiales Murugan From: gnucash-user on behalf of Dr. David Kirkby Sent: Tuesday, January 3, 2023 10:08 AM To: GNU Cash User Subject: [GNC] Problem adding a split to a currency conversion. I have the following situation I'm in the UK, wher

[GNC] www.alphavantage.co suffering currency conversion failure from Gold (XAU) & Silver (XAG) to any resulting currency other than USD since the 14th Aug

2019-08-17 Thread gnucash @ oijn
Seems that www.alphavantage.co has suffered a regression regarding currency conversion from from Gold (XAU) & Silver (XAG) to any resulting currency other than USD since approx. the 14th Aug. This has worked for the last 8+ months and the last successful lookup transaction for me was on

Re: [GNC] Balance Sheet - Currency Conversion

2019-08-03 Thread Danilo Freitas da Costa
Hi John, The fact is the transaction in the specific date was already done. It means I already have the money in my account in my currency. Thus, right price is that registered on transaction. On Sat, Aug 3, 2019, 12:38 John Ralls wrote: > > > > On Aug 2, 2019, at 5:48 PM, Danilo Freitas da C

Re: [GNC] Balance Sheet - Currency Conversion

2019-08-03 Thread Adrien Monteleone
I would think the ‘Most Recent’ or ’Nearest in Time’ options would not look at the price db past the closing date of the report. And if it does look past the date, Average/Weighted Average wouldn’t work either because transactions (and prices) entered post 6/30/19 shouldn’t be part of the repor

Re: [GNC] Balance Sheet - Currency Conversion

2019-08-03 Thread John Ralls
> On Aug 2, 2019, at 5:48 PM, Danilo Freitas da Costa > wrote: > > Hi, @ll! > > I'm facing a strange issue or misunderstanding, using different currencies. > > For simplification, I have an account tree like this: > > Asset > Asset : Account-1 (BRL) > Income > Income : Income-1 (USD) > >

Re: [GNC] Balance Sheet - Currency Conversion

2019-08-03 Thread Christopher Lam
Simple answer, unfortunately no. Running balance sheet (or multicolumn balance sheet) on date 30/06/19 will try the nearest pricedb entry by default, which is dated 05/07/19. If you wish to run balance-sheet using prices dated 05/06/19, you will have to duplicate the 05/06/19 prices to the new date

[GNC] Balance Sheet - Currency Conversion

2019-08-03 Thread Danilo Freitas da Costa
Hi, @ll! I'm facing a strange issue or misunderstanding, using different currencies. For simplification, I have an account tree like this: Asset Asset : Account-1 (BRL) Income Income : Income-1 (USD) My default currency is BRL. Steps (example): 1. Add an income on 07/Jun/2019 and provide the

Currency conversion

2017-11-30 Thread Carlos A. Garcia
Dear All, I faced the problem, during november, that can not obtain the USD to ARS conversion (Argentina). I use Linux Mint 18.3 Sylvia I have the version 2.6.18 compiled in October (in that moment, works perfect) + Finance::Quote is up to date (1.47). I try to follow the proce