How to Run the CTA Detailed Report?

To run the CTA detailed report, follow the steps below:

1. Navigate to Maintenance > Multi-Currency > CTA Sets.
2. Click New (Add button).
3. Enter a title and description.
4. Specify a Base Rate. Typically this base rate has to be the closing rate of the period such as End of the Month rate (EOM).
5. Click Add Accounts and select the accounts that contribute to the CTA balance. Typically these are historical accounts such as Common Stock, Retained Earnings, and PPE accounts.
6. Under Target CTA Setup, specify the segment combination of the CTA account. This might be the same CTA account specified in the Consolidation Setup.
7. Click Save. The user can create as many sets as required.
8. Navigate to Maintenance > Hierarchy Management. Select the Reporting Dimension from the drop-down and click Show.
9. Create a new Reporting Currency (See documentation on how to create Reporting Currency in the Currency Admin Guide).
10. Select a leaf-level member of the Reporting Currency in Hierarchy Management. The Properties pane appears. Under Segment Properties, select Account Based for Calculation Type. Select other properties as required.
11. Select Overwrite default CTA.
12. Under CTA Sets, select the sets created earlier (steps 1 - 6) based on which accounts for FX gains\losses, and click Ok.
13. Click Save.
14. To run the Consolidation process for the Reporting Currency, navigate to Report Administration > Standard Reports and open\run the CTA Detailed Report (which must be deployed by an Admin user).
15. Select a Scenario, Period Range, Account rollup, Company, Reporting currency and the CTA set and click Run.
    
    Notes:

    • For the accounts selected in the CTA set, the report provides the difference between the local currency balances converted using the currency type specified against the account versus the currency type specified in the CTA set definition