Tax Reports does not use historical currency rates

  • 1
  • Question
  • Updated 4 years ago

I am using Reckon Accounts Personal Plus 1015 Release R 1. I have created a “Tax Schedule” and a “Income Tax Summary” reports.

The report brings through the correct transactions. However, any transaction that uses currency is brought in based on the current currency rate instead of the currency rate at the time of transaction.

For example: I have a investment transaction (Dividend) of A$ 800.00. When I entered this transaction Reckon asked me for exchange rate information (lets assume 0.8) which equates NZ$1,000. NZ$1,000  is correctly displayed in my reckon NZ bank account. However, when I run the NZ tax report and todays exchange rate is 1:1, Reckon says this transaction is now NZ$ 800. However, for tax purposes I need to show $1,000.

How can I create last’s tax report if the report will keep changing every time the currency is updated?

FYI - I did try to add historical currency information but that did not work either

Photo of Duncan Turnbull

Duncan Turnbull

  • 70 Points

Posted 4 years ago

  • 1
Photo of Narky One

Narky One

  • 1,252 Points 1k badge 2x thumb
I gave up on ever getting a proper solution years ago.
I export RAPP reports into Excel spreadsheets, add in my own (ATO or USA IRS) list of daily or monthly xrates, then use Excel's table lookup to massage the desired converted currencies. A real pain, tedious, easy to stuff up, but it does work. Have to take care to report [filter] the transactions for each currency in RAPP into their own separate reports.

Also, see this thread https://community.reckon.com/reckon/topics/converting-foreign-currency-into-australian-dollars re end of year reporting - for some purposes, reports will suffice provided they use the xrate as at 30 June, and there is a simple-ish way to do that.