[GNC] Australian Foreign Investments Taxation

[Ben Stanley]

Hello Gnucash Users,

I have now downloaded the foreign exchange rates from the Reserve Bank 
of Australia:
https://rba.gov.au/statistics/historical-data.html#exchange-rates

Note that the exchange rate data is published in an Excel .xls file. I 
used LibreOffice to save it as a .csv for import into GnuCash.

In this file, the dates are formatted as DD-Mon-YYYY. For example:
18-May-2019

GnuCash cannot understand dates formatted this way. (I tested against 
git 3.9-19 on branch maint.)

I made some modifications to gnucash/libgnucash/engine/gnc-datetime.cpp 
that allow GnuCash to import the RBA data with word date months. The 
changes are very rough, and do not include any internationalisation. I 
would appreciate constructive feedback. Flames -> /dev/null.

I note here that I have not tested this patch with dates of format 
DD-MM-YYYY.

Perhaps I should sign up to the gnucash-devel mailing list...

Ben.

On 7/4/20 7:28 pm, Christopher Lam wrote:
> 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 
> <mailto: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 <mailto: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
>>     <mailto: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 <mailto: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.
>>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 20200407_GncDate_with_named_month.patch
Type: text/x-patch
Size: 5826 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200408/cebdddd9/attachment.bin>