Cumulative Translation Adjustment (CTA) is a special type of account that is required for consolidated balance sheets in NetSuite OneWorld accounts with multi-currency enabled. The CTA is used on the consolidated balance sheet to make it balance despite differing consolidated exchange rate types.
The CTA Balance Audit report shows the contribution from individual accounts to the CTA during the selected period. The report does not include manual entries to CTA accounts. The total of all accounts’ contributions during the selected period equals the net change in the CTA balance during the period.
The rows in the CTA Balance Audit report follow the same order as the rows of the Balance Sheet. Each account includes rows for each subsidiary selected in the Subsidiary Any Of filter. The default is all subsidiaries.
This report is available only for OneWorld accounts with the Multiple Currencies and Accounting features enabled. The Financial Statements permission is required to access the report.
The CTA Balance Audit report includes the following columns by default in addition to the account and subsidiary names in the Financial Row column:
Starting Balance Sheet (As of <period>) – The period is the one before the period selected in the From field in the footer.
Local Balance – Subsidiary account balance
General Rate – Consolidated exchange rate type shown on the account record
Consolidated Balance – For each account line, this is equal to the Local Balance multiplied by the General Rate. The total in this column ties to the CTA amount in the Balance Sheet for the previous period.
Net Posting (<period>) – The period is the period or range of periods set in the From and To fields in the footer.
Local Balance – Subsidiary account balance
Cash Flow Rate – Consolidated exchange rate type shown on the account record
General Rate – Consolidated exchange rate type shown on the account record
Consolidated Balance – For each account line, this is equal to the Local Balance multiplied by the General Rate.
Ending Balance Sheet (As of <period>) – The period is the one set in the To field in the footer.
Local Balance – Subsidiary account balance
General Rate – Consolidated exchange rate type shown on the account record
Consolidated Balance – For each account line, this is equal to the Local Balance multiplied by the General Rate. The total in this column ties to the CTA amount in the Balance Sheet for the ending period in the range of periods.
CTA Analysis
Beginning Balance Rate Difference Contribution – This equals the Beginning Balance Translated at Ending Implied Rate minus Starting Balance Sheet Consolidated Balance. You can customize the report to add a column for Beginning Balance Translated at Ending Implied Rate. See the description below.
Net Posting Rate Difference Contribution – This equals Net Posting Consolidated Balance minus Net Posting Consolidated Balance at Cash Flow Rate Contribution.
Net Posting Consolidated Balance at Cash Flow Rate Contribution – This equals Net Posting Local Balance multiplied by the Net Posting Cash Flow Rate.
Total CTA Contribution – Beginning Balance Rate Difference Contribution plus Net Posting Rate Difference Contribution plus Net Posting Consolidated Balance at Cash Flow Rate Contribution