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
> of
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 i
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 Income:C
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.
Y
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 Australi
