CTA Balance Audit Report
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
-
You can customize this report in the Financial Report Builder. The following additional columns are available:
-
Beginning Balance Translated at Ending Implied Rate is a column for the CTA Analysis column group that is not displayed by default. This column equals the Starting Balance Sheet Local Balance multiplied by the consolidated exchange rate for the account. For Current general rate type accounts, the multiplier is the value in the General Rate column of the Ending Balance Sheet column group. For Average or Historical general rate type accounts, the multiplier is the value in the General Rate column of the Starting Balance Sheet column group.
-
Consolidated Balance at Cash Flow Rate is available for the starting and ending balance sheet and net posting column groups.
For information about consolidated exchange rates, see Consolidated Exchange Rate Types.
For more information about customizing financial reports, see Financial Report Builder.
To see the CTA Balance Audit report:
Go to Reports > Financial > CTA Balance Audit.
You can also click the amount for the Cumulative Translation Adjustment in the Balance Sheet, Comparative Balance Sheet, and Trial Balance to open this report.
-
If you open the report from the menu, be sure a consolidated subsidiary is selected in the Subsidiary Context filter in the report footer.
-
Click More in the footer to display the additional multi-select filter Subsidiary Any Of and change the subsidiaries that are included in the report.