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 wrote:
> Hello Gnucash Users,
>
> I have now downloaded the foreign exchange rates from the Reserve Bank
>
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
om: Ben Stanley mailto:ben.stan...@gmail.com>>
> To: Christopher Lam <mailto:christopher@gmail.com>>
> Cc: GnuCash users group <mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Australian Foreign Investments Taxation
> Message-ID:
> <17153f294f8.2
Yes, you can do that. File import prices from CSV.
On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, 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
> wrote:
>
>> The only report which is
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 wrote:
The only report which is capable of using closest-to-date conversion is the
Transaction Report from the Income:Dividends(USD) and
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.
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