[GNC] Australian Foreign Investments Taxation

[Christopher Lam]

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