Re: [GNC] ASX quotes not working
Strawberry Perl 5.18.2.2-32bit
On 15/10/2020 4:21 pm, Geoff wrote:
Hmmm. I can't reproduce your problem. What version of perl are you
running please John?
> perl -v
Thanks
Geoff
=
On 15/10/2020 4:09 pm, John Bonnett wrote:
Hi Geoff,
I had an error in naming the file. I had a space between the "X" and
the "."! After fixing that I have a different error, so we are making
progress.
It complains about line 138.
$info{$stock,$label} =
%$decoded_json{$label_map{$label}};
I am not familiar with Perl syntax but I guess it does not like the
"%$". It seems to me from the rest of the code that you have one or
the other but not both as a prefix.
I tried just "%" and got lots of errors and then I noticed on line
116 it looked like "$" was right, so I tried that and got this:
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
Global symbol "%decoded_json" requires explicit package name at
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.
Compilation failed in require at (eval 20) line 1.
BEGIN failed--compilation aborted at (eval 20) line 1.
at gnc-fq-dump line 166.
Undefined subroutine &Finance::Quote::ASX::asx called at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.
PS C:\Program Files (x86)\gnucash\bin>
It is curious that, although I have "$decoded_json", it is referring
to "%decoded_json".
Any thoughts?
John
___
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] ASX quotes not working
Hi,
Fyi the fixed ASX.pm is working here for me (Strawberry perl v5.32.0)
PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
Finance::Quote fields Gnucash uses:
symbol: BHP <=== required
date: 10/15/2020 <=== recommended
currency: AUD <=== required
last: 36.77<=\
nav: <=== one of these
price: 36.77<=/
timezone: <=== optional
Regards,
Bill
-Original Message-
From: gnucash-user On
Behalf Of John Bonnett
Sent: Thursday, 15 October 2020 6:04 PM
To: Geoff ; gnucash-user@gnucash.org
Subject: Re: [GNC] ASX quotes not working
Strawberry Perl 5.18.2.2-32bit
On 15/10/2020 4:21 pm, Geoff wrote:
> Hmmm. I can't reproduce your problem. What version of perl are you
> running please John?
>
> > perl -v
>
> Thanks
>
> Geoff
> =
>
> On 15/10/2020 4:09 pm, John Bonnett wrote:
>> Hi Geoff,
>>
>> I had an error in naming the file. I had a space between the "X" and
>> the "."! After fixing that I have a different error, so we are making
>> progress.
>>
>> It complains about line 138.
>>
>> $info{$stock,$label} =
>> %$decoded_json{$label_map{$label}};
>>
>> I am not familiar with Perl syntax but I guess it does not like the
>> "%$". It seems to me from the rest of the code that you have one or
>> the other but not both as a prefix.
>>
>> I tried just "%" and got lots of errors and then I noticed on line
>> 116 it looked like "$" was right, so I tried that and got this:
>>
>> PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP
>> Global symbol "%decoded_json" requires explicit package name at
>> C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.
>> Compilation failed in require at (eval 20) line 1.
>> BEGIN failed--compilation aborted at (eval 20) line 1.
>> at gnc-fq-dump line 166.
>> Undefined subroutine &Finance::Quote::ASX::asx called at
>> C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.
>> PS C:\Program Files (x86)\gnucash\bin>
>>
>> It is curious that, although I have "$decoded_json", it is referring
>> to "%decoded_json".
>>
>> Any thoughts?
>>
>> John
>>
___
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] ASX quotes not working
--
Peter West
p...@pbw.id.au
“Woe to you lawyers also! For you load people with burdens hard to bear, and
you yourselves do not touch the burdens with one of your fingers.”
It’s not strange, because %decoded_json is the name of a hash, a structure of
key=>value pairs. A single “value” is a scalar, so to refer to that you must
use a $, as in $decoded_json{key_value}. All scalars are referred to by $ It is curious that, although I have "$decoded_json", it is referring to
> "%decoded_json".
I assume that this
Undefined subroutine &Finance::Quote::ASX::asx called at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.
is happening because the module failed to compile.
This is happening
Global symbol "%decoded_json" requires explicit package name at
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.
I think because the declaration at line 116 should be
my @decoded_json = eval{decode_json( $json )};
rather than
my $decoded_json = eval{decode_json( $json )};
peter
___
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.
[GNC] Exchange rate of income statement report
I have expense accounts in several currencies, for example: Expenses:Food:USD Expenses:Food:ILS I run the income statement report for 2013 for example, select only Expenses:Food account (and its sub accounts) and select ILS as the currency report. The Price source chosen is Nearest in time. While I expected each Expenses:Food:USD transaction to be translated to ILS based on the transaction date exchange rate (the price database is populated with that data), what I actually observed is that all Expenses:Food:USD transactions are translated to ILS based only on a single fixed exchange rate, in this case - the exchange rate as of the report end date 31/12/2013. Is this the expected behavior? Is there a way to achieve the behavior I was expecting? ___ 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] Exchange rate of income statement report
The only report with ability to exchange currency amounts using price on posting date is the Transaction Report. On Thu, 15 Oct 2020, 5:40 pm Gal Bar Mashiah, wrote: > I have expense accounts in several currencies, for example: > Expenses:Food:USD > Expenses:Food:ILS > > I run the income statement report for 2013 for example, select only > Expenses:Food account (and its sub accounts) and select ILS as the currency > report. > The Price source chosen is Nearest in time. > > While I expected each Expenses:Food:USD transaction to be translated to ILS > based on the transaction date exchange rate (the price database is > populated with that data), what I actually observed is that all > Expenses:Food:USD transactions are translated to ILS based only on a single > fixed exchange rate, in this case - the exchange rate as of the report end > date 31/12/2013. > > Is this the expected behavior? > Is there a way to achieve the behavior I was expecting? > ___ > 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] Exchange rate of income statement report
On 10/15/2020 5:37 AM, Gal Bar Mashiah wrote: I have expense accounts in several currencies, for example: Expenses:Food:USD Expenses:Food:ILS I run the income statement report for 2013 for example, select only Expenses:Food account (and its sub accounts) and select ILS as the currency report. The Price source chosen is Nearest in time. While I expected each Expenses:Food:USD transaction to be translated to ILS based on the transaction date exchange rate (the price database is populated with that data), what I actually observed is that all Expenses:Food:USD transactions are translated to ILS based only on a single fixed exchange rate, in this case - the exchange rate as of the report end date 31/12/2013. Is this the expected behavior? Is there a way to achieve the behavior I was expecting? I have been waiting for somebody to raise this as a problem so we could begin a discussion about THIS problem with multi-currency books. I didn't want to raise what I saw as an obvious "when evaluated" issue when it didn't seem to worry anybody else. The point isn't so much that this person wanted the conversion frozen as of the date of the transaction itself (though in that case, maybe want to revisit whether multi-currency books apply). The point is that the date matters. And there is no "proper date" to use because that will depend on the rules of jurisdictions and/or organizations rules/procedures. Let that discussion begin Meanwhile, Gal, please explain something to me. If you wanted dollar amounts converted to shekels as of the date of the initial transaction (frozen as of that date) why entered in dollars rather than shekels? The normal purpose of having multi-currency books is that amounts are being kept in more than one currency precisely because exchange rates DO vary over time. In other words, you couldn't just convert as of the date of the transaction to a common currency because it is the conversion rate at some other date that should be used << at the end of each quarter, at year end, etc. >> Michael ___ 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] Exchange rate of income statement report
Michael or Penny Novack wrote > Meanwhile, Gal, please explain something to me. If you wanted dollar > amounts converted to shekels as of the date of the initial transaction > (frozen as of that date) why entered in dollars rather than shekels? Actually, I'm in the middle of my evaluation of whether I should use a single main currency for all expense accounts, or split them per currency as I demonstrated in the original post, and I'll by happy to expand the discussion to this subject as well. The benefit I see of splitting expense accounts to their respective currencies, is that it's easier to document and fill transactions at the currency they took place at (for example by copying numbers from a receipt), instead of manually performing exchange rate translation each time a transaction is entered. Obviously, for reports, I still have to provide the rates to the price database, but doing so as a separate independent process seems more methodological. Another advantage is to become currency agnostic all the way (in case I want to change to a different main currency in the future), but I'm not actually sure if translating expenses to a different currency than the one they took place at, eliminates this agnostic-ness. The obvious drawback is the cumbersomeness of managing so many accounts, and the not obvious drawback is the issue I just raised with the income statement report. I was expecting the report system to handle the translation of each transaction separately, or at least have such an option in the price source, and was surprised to see it didn't. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Exchange rate of income statement report
On 10/15/2020 7:23 AM, Gal wrote: Michael or Penny Novack wrote Meanwhile, Gal, please explain something to me. If you wanted dollar amounts converted to shekels as of the date of the initial transaction (frozen as of that date) why entered in dollars rather than shekels? Actually, I'm in the middle of my evaluation of whether I should use a single main currency for all expense accounts, or split them per currency as I demonstrated in the original post, and I'll by happy to expand the discussion to this subject as well. Well, this was the P&L report, one of the uses being when filing out tax forms (this is a case where the name usually used for the report depends on the form of the entity for which the books being kept) So what do the tax codes of the US and Israel have to say about currency conversion dates? For example, suppose you had a dollar expense that was deductible on Israeli taxes. As of what date must the conversion to shekels be done. Now vice versa. How about if the two jurisdictions don't agree? For the more general situation, consider any other pair of countries. Michael D Novack ___ 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] Exchange rate of income statement report
Michael or Penny Novack wrote > Well, this was the P&L report, one of the uses being when filing out tax > forms (this is a case where the name usually used for the report depends > on the form of the entity for which the books being kept) > > So what do the tax codes of the US and Israel have to say about > currency conversion dates? For example, suppose you had a dollar expense > that was deductible on Israeli taxes. As of what date must the > conversion to shekels be done. Now vice versa. How about if the two > jurisdictions don't agree? For the more general situation, consider any > other pair of countries. > > Michael D Novack I don't keep track of expenses for tax reports. I do so purely for expense and income tracking. For several years now I've used YNAB4 and implemented SSAP20 method for tracking foreign currency accounts: https://www.mscs.dal.ca/~selinger/accounting/tutorial.html#3 But now I'm making the transition to GnuCash and one of the reasons was to take advantage of the better multi currency support is has. So I'm mainly trying to figure out how to setup the accounts, and whether if having expense account per currency is the right way for me. The thing I had in mind, in addition to what I wrote before, is that it seems like a good practice to have a separation between the data and the translation+reports. The expense was done in USD? document it in USD, and the report system should deal with the translation for you. If a country has specific tax codes, but a common one, I expect that the report system will provide me with that option. Doing the translation during data entry means you stick with a single predetermined rule/tax code that cannot be changed without modifying all of the transactions. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
[GNC] Payment initiation; was: FreeBSD and GNUCash
Hi Maf., I found this accidently while googling for another theme and think, I should correct you. Am 01.04.16 um 13:00 schrieb Maf. King: > GnuCash, AFAIK, can not initiate transactions with your banking institutions. > The mostly american used [direct]OFX can only download CAsh Management (CAMT) information, but the european protocolls EBICS and FinTS have the ability to upload PAyment INitiation (PAIN). Regards 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] Payment initiation; was: FreeBSD and GNUCash
On Thu, October 15, 2020 2:18 pm, Frank H. Ellenberger wrote: > the european protocolls EBICS and FinTS have the > ability to upload PAyment INitiation (PAIN). And BOY does it hurt!!! LOL. > Regards > Frank > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Exchange rate of income statement report
As I understand, for personal tax most would offer the original currency income statements to the accountant; the latter would convert to local currency using an exchange rate from legislated sources. To achieve this using the formal reports you'd ensure there is price data USD/ILS on the report date corresponding to the legislated exchange rate rather than the daily rate. IMHO this is too complex; I'd rather the reports use the original currency amounts instead. On Thu, 15 Oct 2020, 8:22 pm Gal, wrote: > Michael or Penny Novack wrote > > Well, this was the P&L report, one of the uses being when filing out tax > > forms (this is a case where the name usually used for the report depends > > on the form of the entity for which the books being kept) > > > > So what do the tax codes of the US and Israel have to say about > > currency conversion dates? For example, suppose you had a dollar expense > > that was deductible on Israeli taxes. As of what date must the > > conversion to shekels be done. Now vice versa. How about if the two > > jurisdictions don't agree? For the more general situation, consider any > > other pair of countries. > > > > Michael D Novack > > I don't keep track of expenses for tax reports. > I do so purely for expense and income tracking. > For several years now I've used YNAB4 and implemented SSAP20 method for > tracking foreign currency accounts: > https://www.mscs.dal.ca/~selinger/accounting/tutorial.html#3 > > But now I'm making the transition to GnuCash and one of the reasons was to > take advantage of the better multi currency support is has. > So I'm mainly trying to figure out how to setup the accounts, and whether > if > having expense account per currency is the right way for me. > > The thing I had in mind, in addition to what I wrote before, is that it > seems like a good practice to have a separation between the data and the > translation+reports. > The expense was done in USD? document it in USD, and the report system > should deal with the translation for you. > If a country has specific tax codes, but a common one, I expect that the > report system will provide me with that option. > Doing the translation during data entry means you stick with a single > predetermined rule/tax code that cannot be changed without modifying all of > the transactions. > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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] ASX quotes not working
Hi Geoff, I seem to have partly solved my problem. Following up on a comment from Bill and your interest in the version of Perl I was running, I chased up a recent version of Strawberry Perl. I got v5.32.0 64bit and installed that. It still thought I had the older 32bit installed so I tried uninstalling that. This broke the 64bit install, so I repaired it and then ran the "Install Online Price Retrieval for GnuCash" option on the Windows GnuCash menu. This got the standard installation back. I then followed your original instructions about replacing ASX.pm and ran your check as follows: PS C:\WINDOWS\system32> cd "C:\Program Files (x86)\gnucash\bin" PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 10/15/2020 <=== recommended currency: AUD <=== required last: 36.77 <=\ nav: <=== one of these price: 36.77 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> I then tried running "Get Quotes" from inside GnuCash and it seems to have partly worked. Some of my ASX stocks are still not retrieving but others are. I will investigate using gnc-fq-dump and report back. Thanks for your help, John Bonnett ___ 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] ASX quotes not working
Hi Geoff, I am still not getting all my stocks retrieved inside GnuCash but I may have made some progress. I checked the stocks not working using gnc-fq-dump and they all retrieved except for one I still had that had been de-listed, so that is as expected, but does not explain why they don't work inside GnuCash. I retrieved them all in one call to gnc-fq-dump and I noticed there was an error message at the start. After a little more digging I found just one stock was causing that problem as follows: PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX 14D Use of uninitialized value in transliteration (tr///) at C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 141. Finance::Quote fields Gnucash uses: symbol: 14D <=== required date: 10/16/2020 <=== recommended currency: AUD <=== required last: 0.145 <=\ nav: <=== one of these price: 0.145 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> It may be that having a stock symbol starting with a number is causing the problem, but it still retrieves OK. It did occur to me that, depending on the order that GnuCash does the retrieving internally, that error may make the program think there are no valid values after that message and explain why some of the stocks are missing in the results. Best regards, John Bonnett On 16/10/2020 9:05 am, John Bonnett wrote: Hi Geoff, I seem to have partly solved my problem. Following up on a comment from Bill and your interest in the version of Perl I was running, I chased up a recent version of Strawberry Perl. I got v5.32.0 64bit and installed that. It still thought I had the older 32bit installed so I tried uninstalling that. This broke the 64bit install, so I repaired it and then ran the "Install Online Price Retrieval for GnuCash" option on the Windows GnuCash menu. This got the standard installation back. I then followed your original instructions about replacing ASX.pm and ran your check as follows: PS C:\WINDOWS\system32> cd "C:\Program Files (x86)\gnucash\bin" PS C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 10/15/2020 <=== recommended currency: AUD <=== required last: 36.77 <=\ nav: <=== one of these price: 36.77 <=/ timezone: <=== optional PS C:\Program Files (x86)\gnucash\bin> I then tried running "Get Quotes" from inside GnuCash and it seems to have partly worked. Some of my ASX stocks are still not retrieving but others are. I will investigate using gnc-fq-dump and report back. Thanks for your help, John Bonnett ___ 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] Exchange rate of income statement report
Found it. Both methods are acceptable: 1) reach foreign currency converted to local according to Forex on date. Transaction report will do this. 2) average rate is allowed under GAAP. Not doable easily unless price data is carefully scrutinised. https://www.accaglobal.com/us/en/technical-activities/technical-resources-search/2015/march/frs102-foreign-currency-translation.html On Fri, 16 Oct 2020, 4:10 am Christopher Lam, wrote: > As I understand, for personal tax most would offer the original currency > income statements to the accountant; the latter would convert to local > currency using an exchange rate from legislated sources. > > To achieve this using the formal reports you'd ensure there is price data > USD/ILS on the report date corresponding to the legislated exchange rate > rather than the daily rate. IMHO this is too complex; I'd rather the > reports use the original currency amounts instead. > > On Thu, 15 Oct 2020, 8:22 pm Gal, wrote: > >> Michael or Penny Novack wrote >> > Well, this was the P&L report, one of the uses being when filing out >> tax >> > forms (this is a case where the name usually used for the report >> depends >> > on the form of the entity for which the books being kept) >> > >> > So what do the tax codes of the US and Israel have to say >> about >> > currency conversion dates? For example, suppose you had a dollar >> expense >> > that was deductible on Israeli taxes. As of what date must the >> > conversion to shekels be done. Now vice versa. How about if the two >> > jurisdictions don't agree? For the more general situation, consider >> any >> > other pair of countries. >> > >> > Michael D Novack >> >> I don't keep track of expenses for tax reports. >> I do so purely for expense and income tracking. >> For several years now I've used YNAB4 and implemented SSAP20 method for >> tracking foreign currency accounts: >> https://www.mscs.dal.ca/~selinger/accounting/tutorial.html#3 >> >> But now I'm making the transition to GnuCash and one of the reasons was to >> take advantage of the better multi currency support is has. >> So I'm mainly trying to figure out how to setup the accounts, and whether >> if >> having expense account per currency is the right way for me. >> >> The thing I had in mind, in addition to what I wrote before, is that it >> seems like a good practice to have a separation between the data and the >> translation+reports. >> The expense was done in USD? document it in USD, and the report system >> should deal with the translation for you. >> If a country has specific tax codes, but a common one, I expect that the >> report system will provide me with that option. >> Doing the translation during data entry means you stick with a single >> predetermined rule/tax code that cannot be changed without modifying all >> of >> the transactions. >> >> >> >> >> -- >> Sent from: >> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html >> ___ >> 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.
