I need to construct financial statements in a “functional currency” (NZD) and then translate into another currency (AUD).
The balance sheet end of month balances need to be translated at the End of Month Rate and the Profit and Loss transactions need to be translated at the Average Rate of the month.
I am able to translate the P&L data but I am having difficulty in calculating the running total per month for each balance GL-account and then translate that to the AUD currency.
I have attached a sample file of the data.
Any help please?