[GNC] Australian Foreign Investments Taxation

Christopher Lam christopher.lck at gmail.com
Tue Apr 7 05:28:21 EDT 2020


Yes, you can do that. File import prices from CSV.

On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, <ben.stanley at gmail.com> wrote:

> I can get a CSV file of daily exchange rate data. Is there a way of
> importing it into the price database?
>
> On 7 April 2020 7:17:54 pm Christopher Lam <christopher.lck at gmail.com>
> wrote:
>
>> The only report which is capable of using closest-to-date conversion is
>> the Transaction Report from the Income:Dividends(USD) and
>> Income:CapGains(USD) accounts, using a Report Currency of AUD. It will
>> choose the USD/AUD price from the price editor list closest to each
>> transaction's posting date.
>>
>> You'll have to ensure the price list has prices at your desired dates
>> manually.
>>
>> On Tue, 7 Apr 2020 at 09:13, Ben Stanley <ben.stanley at gmail.com> wrote:
>>
>>> Hello Gnucash people,
>>>
>>> This question may be more suited to Gnucash developers, but lets try it
>>> here first.
>>>
>>> I need to perform a tax calculation in accordance with instructions from
>>> the Australian Taxation Office. All foreign income, deductions and
>>> foreign tax paid must be converted to Australian Dollars for tax
>>> purposes.
>>>
>>>
>>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>>>
>>> The conversion used must correspond to the transaction date.
>>>
>>> In Gnucash, it would appear that the price editor could be used to enter
>>> the necessary conversion data, if it were easy to see all of the dates
>>> where conversions are required. However, this is tedious.
>>>
>>> Far better would be to use Finance::Quote to fetch the necessary
>>> conversion data for the dates it is required for. However, it seems that
>>> Finance::Quote is only capable of fetching "recent" data. (The
>>> documentation that I looked at seemed to be very old.)
>>>
>>> http://finance-quote.sourceforge.net/documentation.html
>>>
>>> What is needed is the ability to pass a date, or a range of dates, and
>>> request Finance::Quote to fetch prices for that date or date interval.
>>> This would make Finance::Quote far more useful than just fetching the
>>> most recent price data.
>>>
>>> Is there some feature in Gnucash that I have missed that would allow me
>>> to generate a report, with dividends and Capital Gains converted from
>>> USD -> AUD using the currency conversion as at the transaction dates?
>>>
>>> Thanks,
>>> Ben Stanley.
>>>
>>>
>>> _______________________________________________
>>> 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