IFRS 18 CP and Bank balances

To support IFRS 18 the customers needs to classify the accounting into more categories such as Investment and Financing.

Today Revaluation of bank accounts FX gain loss is done on Treasury accounts where we have all the daily cash flows. It is not possible to book FX gain loss on the bank account unless we have all cash flows. It is possible if you have a zero balancing cash pool to book the daily sweeps and use TS revaluation of FX gain loss.  

Otherwise TS can only support reevaluating the entire balance with the month-end FX rate. Your ERP needs to book the FX gain loss on the bank accounts accoring to IFRS 18.

If you have all your daily transactions in TS, we can book the FX gain or loss and also book it on different accounts if the outstanding bank balance is positive Investment or Negative Financing on the month-end.

To set this up use the following steps:

1. Add 2 custom measures

AssetAmount(Iif(ToDecimal([BaseAmount])>0,ToDecimal([FxGainLoss]) , ?),[AccountingCurrency])

AssetAmount(Iif(ToDecimal([BaseAmount])<=1, ToDecimal([FxGainLoss]),? ),[AccountingCurrency])

2. Add 4 columns into Accounting report 1

3. Add Amount Types

4. Update the accounting rules with new GL accounts

5. Add the new columns into a PL report

6. Run unrealised and verify the accounting