[GNC] Australian Foreign Investments Taxation

[David H]

Hi Ben,

Isn't Libre Office able to highlight a column and change the date format
from dd/mmm/ccyy to dd/mm/ccyy for instance ??

Cheers David H.

On Wed, 8 Apr 2020 at 00:54, Ben Stanley <ben.stanley at gmail.com> wrote:

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