FrontierERP
Sign inTalk to Frontier
Applied guide

Why the consolidated TB isn't the sum of the subs

NetSuite's consolidated trial balance translates each account at its own rate and adds a CTA line. Three subsidiary TBs reconciled to it, to zero.

Frontier · November 16, 2026

An applied guide for the controller or FP&A lead who has to tie the consolidated trial balance back to its subsidiaries.

The short answer. Each subsidiary's trial balance is in its own base currency. The consolidated one is in the parent's, with every child subsidiary translated through the consolidated exchange rates (Oracle). NetSuite translates each account at its own rate type, by default: current for assets and liabilities, historical for equity, and each period's average for income and expenses, which also builds retained earnings (Oracle). The translated accounts then don't balance, so the consolidated trial balance adds a Cumulative Translation Adjustment line (Oracle), calculated for the report and not posted (Oracle). The consolidated node also includes the elimination subsidiary (Oracle), and where no consolidated rate is set, NetSuite uses 1 (Oracle). Add the subsidiaries' trial balances as they come and you have added euros to dollars. Below, one constructed group's three trial balances are summed and reconciled to NetSuite's consolidated trial balance, account by account, to zero.

This is the fourth tie-out on this site, on the same Harbor group at 31 October 2026. Why a saved search won't match NetSuite's P&L, Why a saved search won't match the balance sheet and Why A/R aging won't tie to the balance sheet each reconcile a pull to one statement. This one starts where a consolidation worksheet does, from the subsidiaries' trial balances, as in Intercompany eliminations: a worked example, and ends at NetSuite's own consolidated figure.

The five reasons, in Oracle's words.

  • Each trial balance has its own currency. "When the data displayed is for a single subsidiary, NetSuite uses the base currency of that subsidiary for amounts. When the data displayed is consolidated for multiple related subsidiaries, NetSuite uses the base currency of the parent subsidiary for amounts." And: "Consolidated reports use the Consolidated Exchange Rates table to translate child subsidiaries' amounts to roll up into consolidated parent subsidiary amounts" (Consolidated Reporting in OneWorld). Oracle draws the conclusion itself: "Because consolidated exchange rates are different from currency exchange rates, amounts from subsidiary-level reports often don't match consolidated reports" (Consolidated Exchange Rates on Reports).
  • Each account has its own rate type. "Each accounting period, accounting book (when Multi-Book Accounting is enabled) and subsidiary pair has its own set of three consolidated exchange rate types", and "The value of a subsidiary account multiplied by its consolidated exchange rate provides the account value in consolidated financial statements." By default the General Rate Type is Current "for all balance sheet accounts other than equity accounts", Average "for all income statement accounts" and Historical "for all equity accounts". The Average rate "is used to translate accounts in the income statement and to build retained earnings" (Consolidated Exchange Rate Types).
  • Only the consolidated trial balance has the calculated CTA line. "When the Subsidiary Context is a consolidated subsidiary, a line Cumulative Translation Adjustment (CTA) account may appear at the end of the account listing" (Trial Balance Report). "The difference between values of consolidated exchange rates types results in a balance in the line for Cumulative Translation Adjustment (CTA) on some financial statements. This account line is used in consolidated balance sheet and trial balance reports" (Consolidated Exchange Rate Types). And "The amount you see in consolidated reports for CTA is calculated dynamically, not posted to the account" (CTA Overview).
  • The consolidated node includes the elimination subsidiary. "When you select a consolidated node, the data returned is a summary of all transactions associated with the node's child subsidiaries, including elimination subsidiaries" (Subsidiary Context for Reports). On its own it is one more option in the list: "Elimination subsidiaries are available as options" (Subsidiary Context for a Financial Statement), and "Only journal entries post to elimination subsidiaries" (Elimination Subsidiaries).
  • A rate that was never set is 1. "If you haven't set consolidated rates, NetSuite uses an exchange rate of 1" (Subsidiary Context for a Financial Statement). For an elimination subsidiary, 1 is the rule: it "must use a consolidated exchange rate of 1 to its direct parent subsidiary" (Elimination Subsidiaries). Oracle's pages disagree on whether that rate can ever change. The page on editing rates says "You can't edit the rates for elimination subsidiaries, even if the currencies differ" (Editing Consolidated Exchange Rates). The record reference lets accounts that "already have a non-1 consolidated exchange rate" there edit it by script (Consolidated Exchange Rate).

None of this is a defect. A consolidated statement needs every one of them. The problem is only that a plain sum of the subsidiaries' trial balances translates nothing, and it still balances. Every trial balance balances in its own currency, so a sum of balanced trial balances balances too, whatever the currencies. Nothing about the summed column tells you it is wrong.

Harbor's three trial balances at 31 October.

This is the group from the earlier pages, ten months into its second year. Every amount and rate below is constructed for the example and labelled as such; nothing comes from a live account. A script committed beside this page generates the figures and re-foots them.

Harbor Inc. is a US parent reporting in US dollars. Harbor GmbH is its German subsidiary and keeps its books in euros. Harbor Elimination is the elimination subsidiary. The group began trading in January 2025 on a calendar fiscal year, and FY2025 closed under NetSuite's automatic close, so nothing was posted to Retained Earnings. Each trial balance below is NetSuite's Trial Balance as of October 2026, accounting book Primary, with the Total column, which displays "one column with balance of debits and credits for each account" (Trial Balance Report). It is run three times, with the Subsidiary Context set to each subsidiary in turn, not to a consolidated node: Harbor Inc., Harbor GmbH and Harbor Elimination. Debits are plain and credits are in brackets.

Account Inc. (USD) GmbH (EUR) Elimination (USD) Sum of the three
Cash and other assets 1,150,000 478,000 — 1,628,000
Accounts receivable 212,000 64,000 — 276,000
Investment in Harbor GmbH 208,000 — (208,000) —
Liabilities (310,000) (140,000) — (450,000)
Share capital (500,000) (200,000) 208,000 (492,000)
Retained Earnings (240,000) (96,000) — (336,000)
Revenue (1,200,000) (455,000) — (1,655,000)
Intercompany fee income (11,000) — 11,000 —
Expenses 691,000 339,000 — 1,030,000
Intercompany fee expense — 10,000 (11,000) (1,000)
Total 0 0 0 0

Constructed figures, each subsidiary in its own currency. The balance-sheet lines are the balance-sheet and A/R pages' figures. Retained Earnings in each operating company is its FY2025 net income: the Trial Balance reports retained earnings "as the sum of cumulative net income and amounts posted directly to the retained earnings account through journal entries", and "The cumulative net income is a calculated reporting value" (Trial Balance Report). Revenue and expenses are 2026 to date; October's are the P&L page's. Before October, Harbor GmbH booked EUR 45,000 of revenue and 35,000 of expenses a month. Harbor Inc. holds the USD 208,000 it paid for Harbor GmbH's EUR 200,000 of share capital on 6 January 2025, at 1.0400. Harbor Elimination holds two journals: the controller's own investment against share capital, and October's elimination of the EUR 10,000 management fee, booked at USD 11,000 on both sides. The fee is the group's only intercompany charge this year.

Three things in the summed column are worth a second look. It balances, as every sum of trial balances does. The fee doesn't eliminate: Harbor Elimination reverses USD 11,000 of expense, and Harbor GmbH's side is EUR 10,000, so the sum leaves (1,000) of expense in a line that should be empty. And it needs Harbor Elimination. Leave the elimination subsidiary out, as a list of the operating companies would, and the sum carries Harbor Inc.'s 208,000 investment, Harbor GmbH's share capital beside the parent's, and both sides of the fee. The consolidated report has none of them.

From the sum to the consolidated trial balance.

The report to match is the Trial Balance for Harbor Inc. (Consolidated), as of October 2026, primary book. Three lines take the summed column to it, account by account.

1 · Currency. Restate Harbor GmbH's euros in dollars at one rate: October's current consolidated rate, 1.1000, the rate in effect at the end of the period (Calculating Consolidated Exchange Rates Automatically). Every Harbor GmbH line moves by a tenth. The sum still balances, because one rate times a balanced trial balance is still balanced. The fee line now nets to zero: EUR 10,000 is USD 11,000, and the elimination's 11,000 takes it out. The summed column plus this one is what Oracle's Amount (Current Rate) field shows, "the values as calculated with only the current exchange rate across all transactions" (Consolidated Exchange Rates on Reports).

2 · Rate type. Now give each account its own rate. Share capital takes the historical rate for January 2025, 1.0400, so it is 12,000 smaller than at 1.1000, and the elimination journal nets it to zero. Retained Earnings is built from each month of FY2025's income at that month's average rate. Revenue and expenses take each 2026 month's average. The fee, all in October, takes October's average, which equals the current rate here, so it moves nothing. After line 2 every account line matches NetSuite's, and the trial balance is out of balance by 5,750. This column is Oracle's Translation Adjustment, "the amount resulting from the difference between the consolidated exchange rate that is used on each account and the current exchange rate" (CTA Overview).

3 · CTA. The rest is the Cumulative Translation Adjustment, a 5,750 credit on its own line at the end of the account listing, the figure that balances the report. It is the same 5,750 that the balance-sheet page derives for the same group on the same date.

Account Sum 1 · Currency 2 · Rate type 3 · CTA NetSuite Difference
Cash and other assets 1,628,000 47,800 — — 1,675,800 0
Accounts receivable 276,000 6,400 — — 282,400 0
Investment in Harbor GmbH — — — — — 0
Liabilities (450,000) (14,000) — — (464,000) 0
Share capital (492,000) (20,000) 12,000 — (500,000) 0
Retained Earnings (336,000) (9,600) (2,800) — (348,400) 0
Revenue (1,655,000) (45,500) (15,525) — (1,716,025) 0
Intercompany fee income — — — — — 0
Expenses 1,030,000 33,900 12,075 — 1,075,975 0
Intercompany fee expense (1,000) 1,000 — — — 0
Cumulative Translation Adjustment — — — (5,750) (5,750) 0
Total 0 0 5,750 (5,750) 0 0

USD. NetSuite is the Trial Balance for Harbor Inc. (Consolidated). Constructed figures; generated and re-footed by the packet script. The consolidated trial balance's debits and credits are 3,034,175 each. Its Retained Earnings, net income (640,050) and CTA are the balance-sheet page's; its receivables are the A/R page's; October inside it is the P&L page's.

Line 2 is the one to check by hand, so here it is for Harbor GmbH, account by account. NetSuite "dynamically calculates CTA for each account and then displays the total in the CTA account line" (CTA Overview), and the last column is each account's part: together they leave the 5,750 debit that the CTA's 5,750 credit offsets.

Harbor GmbH EUR Rate type EUR→USD USD At 1.1000 Line 2
Cash and other assets 478,000 Current 1.1000 525,800 525,800 —
Accounts receivable 64,000 Current 1.1000 70,400 70,400 —
Liabilities (140,000) Current 1.1000 (154,000) (154,000) —
Share capital (200,000) Historical 1.0400 (208,000) (220,000) 12,000
Retained Earnings (96,000) Average, month by month 1.1292 implied (108,400) (105,600) (2,800)
Revenue (455,000) Average, month by month 1.1341 implied (516,025) (500,500) (15,525)
Expenses 339,000 Average, month by month 1.1356 implied 384,975 372,900 12,075
Intercompany fee expense 10,000 Average, month by month 1.1000 implied 11,000 11,000 —
Total, before CTA 0 5,750 0 5,750

Constructed figures. The current and historical rates are derived by Oracle's calculation from the example's own exchange rates and transactions; the monthly average rates are set by hand on the Consolidated Exchange Rates page, which Oracle allows "for periods that aren't closed" (Editing Consolidated Exchange Rates), each while its period was open. 2026's run from 1.1650 in January down to 1.1000 in October; all of them are in the packet script. Implied rates are rounded; the contributions are computed month by month.

In the example's rates the euro gained against the dollar between January 2025 and October 2026. So the share capital Harbor GmbH was given is worth 12,000 more at today's rate than at the historical one. Its income was earned at higher rates than 31 October's, which takes back 6,250. The 5,750 net is the CTA. On the consolidated Trial Balance, clicking the CTA amount opens the CTA Balance Audit report, which "shows the contribution from individual accounts to the CTA during the selected period". Its total for a period "equals the net change in the CTA balance during the period", so set the From period to the group's first and its total is the 5,750.

One more thing changes the arithmetic. A rate that was never set. Had no consolidated rate been set for Harbor GmbH, NetSuite would use 1, and lines 1 to 3 would all be zero. The consolidated trial balance would equal the summed column, euros and dollars added together, CTA zero. On a multi-currency group, a consolidated trial balance that equals the plain sum is the one to question.

Check before you trust the number.

First, run every trial balance for the same period and accounting book, with an unrestricted role. Oracle warns that a location-restricted role can see an imbalance on the Trial Balance, and "Any resulting credit/debit imbalance is reported in the Cumulative Translation Adjustment line" (Trial Balance Report). Then run six checks, the five reasons and period end journals, each naming the setting, report or field that decides it.

  1. Which subsidiaries are in the sum? Every child of the consolidated node, the elimination subsidiary included. The Subsidiary Context list "includes active subsidiaries and inactive subsidiaries with posted transactions" (Trial Balance Report, above), so look there for an inactive company with postings before you add.
  2. Currency. Are the figures in one currency before you add them? A subsidiary's trial balance is in its base currency, and the report converts each transaction to it at "the transaction exchange rate", not a consolidated rate (Trial Balance Report, above). Line 1 restates each foreign subsidiary at the current consolidated rate.
  3. Rate type. Which rate did each account get? Check the General Rate Type on each account record and the rates for each period at Lists > Accounting > Consolidated Exchange Rates. On a saved search, read the Consolidated Exchange Rate field on the Results subtab. None: "Uses the transaction subsidiary's base currency. No consolidation occurs." That is the summed column. Per-Account, the default: "Uses the general rate type selected for each transaction's account". That is lines 1 and 2 (Consolidated Exchange Rate Types for Transaction Searches), except Retained Earnings under the automatic close. NetSuite doesn't post the year's balance to it, so a search finds the prior years' income on the income lines, not on Retained Earnings; the balance-sheet page above rebuilds it. In SuiteQL, Oracle documents BUILTIN.CONSOLIDATE, which "converts the currency amount in a field to a target currency" and takes a subsidiary rate type (DEFAULT, CURRENT, HISTORICAL or AVERAGE), a target subsidiary, a period and a book (BUILTIN.CONSOLIDATE). Frontier's own trial balance, below, sums the accounting lines without it.
  4. A rate of 1. Does any period show 1 for a foreign subsidiary? Oracle's rule is that a rate not set is 1. The elimination subsidiary's 1 to its parent is correct.
  5. CTA. Is there a CTA line, and only one in the total? By default no subsidiary's trial balance carries it and no search finds it, because the amount is calculated, not posted; period end journals (check 6) and manual journals to the CTA account are the exceptions. Derive it as the balancing figure and compare. If journals were posted to the CTA account, "a separate Cumulative Translation Adjustment account line displays the balance from manual journal entries" among the equity lines. The primary CTA line at the end already includes them, and "Only the primary CTA line is counted in the total" (Trial Balance Report, above). Add both and the manual part counts twice. A CTA-E line is another account: "The CTA account is separate from the Cumulative Translation Adjustment-Elimination (CTA-E) that NetSuite adds to your account when you enable the Automated Intercompany Management feature" (CTA Overview, above).
  6. Period end journals. Is the Period End Journal Entries feature enabled for the parent? Then a consolidation journal "posts translated amounts for each child subsidiary account to the parent using the consolidated exchange rate type for the account" and "includes the cumulative translation adjustment" (Period End Journal Entries). The standard Trial Balance ignores them: "Period end journals have no impact on standard reports" (Financial Reports with Period End Journals). The Post Closing Trial Balance, which "shows the balance of each account, including period end journals", reads them, and so does a transaction search with Include Period End Transactions checked. Take the parent's figures from either, add its children, and every child is counted twice. Check a query over the ledger for them the same way.

A sum that passes all six and still differs has a cause this page doesn't cover, and that one is worth a ticket. A sum that fails one of them has its answer.

What this means for an AI-built trial balance.

The same five reasons apply to a trial balance that an assistant builds from your account, whatever the tool. Frontier's trial balance is one of nine standard statements: per-account debit, credit and net, with income-statement accounts for the year to date and balance-sheet accounts cumulatively, an optional subsidiary and one accounting book. The query and the rows come attached.

Its limit is the subject of this page. Run without a subsidiary, it adds each subsidiary's base-currency balances together without translating them: the summed column's arithmetic, euros and dollars in one total. It has no CTA line. Its Retained Earnings is what was posted to that account. Under NetSuite's automatic close, "NetSuite doesn't post the balance to retained earnings" (Year-End Closing), so the statement leaves out the prior years' income that NetSuite's report computes, and its debits and credits differ by that income. On a multi-currency group, run it one subsidiary at a time. Each run comes back in that subsidiary's own currency, and the translation is the worksheet above: line 1 at the current rate, line 2 by account, the CTA as the balancing figure. The income statement, another of the nine, run for the prior years, gives the Retained Earnings figure; the balance-sheet page shows how.

For Harbor that is a run per subsidiary: Harbor Inc.'s in dollars, Harbor GmbH's in euros. With no Retained Earnings line, Harbor Inc.'s run is USD 240,000 short on the credit side and Harbor GmbH's EUR 96,000, each one's FY2025 income. The statement does not translate or consolidate.

On access: Frontier reads your NetSuite through one integration role that you create and can revoke at any time: web-services only, view-level record permissions. Every answer carries the query and the rows behind it, so your team can check any figure against the ledger.

One next step: put NetSuite's consolidated Trial Balance beside each child subsidiary's for the same period, book and role, the elimination subsidiary included, as in the first table. Add line 1, then line 2, then the CTA. Each difference that is left belongs to one of the six checks, and the list you end up with is the reconciliation.

Sources and limits.

Every figure in this guide is constructed to show the mechanism. None comes from a customer account, and the page carries no query. Our own demo NetSuite account keeps every subsidiary in US dollars, so it cannot show the effect, and Harbor stands in for it. Statements about NetSuite's behaviour are quoted or paraphrased from Oracle's documentation, linked where they appear: the Trial Balance report, consolidated reporting in OneWorld, consolidated exchange rates on reports, consolidated exchange rate types, calculating consolidated exchange rates, editing consolidated exchange rates, the consolidated exchange rate record, year-end closing, rate types for transaction searches, the CTA overview, the CTA Balance Audit report, subsidiary context for reports, subsidiary context for a financial statement, elimination subsidiaries, Period End Journal Entries, financial reports with period end journals and BUILTIN.CONSOLIDATE. Your account's currencies, rate types, rates, role restrictions and period end settings decide which of the six checks apply to you, and the checklist is how to find out.

Questions this raises

Why doesn't NetSuite's consolidated trial balance equal the sum of the subsidiaries' trial balances?
Because each subsidiary's trial balance is in its own base currency, and the consolidated one is in the parent's, translated with consolidated exchange rates. NetSuite translates each account at its own rate type, by default the current rate for assets and liabilities, the historical rate for equity, and each period's average rate for income, expenses and retained earnings. The difference between those rates is the Cumulative Translation Adjustment, a calculated line only the consolidated trial balance carries. The consolidated node also includes the elimination subsidiary, and where no consolidated rate is set NetSuite uses 1. The page reconciles one constructed group's three trial balances to the consolidated one, account by account, to zero.
What is the CTA line at the end of the consolidated trial balance?
The Cumulative Translation Adjustment. Accounts translated at different consolidated rate types don't balance in the parent's currency, and the CTA is the balancing figure. Oracle's documentation says the amount in consolidated reports is calculated dynamically, not posted to the account, so by default no subsidiary's trial balance and no search returns it; period end journals and manual journals to the CTA account are the exceptions. Clicking it on the Trial Balance opens the CTA Balance Audit report. If manual journals were posted to the CTA account, they show on a separate CTA line among the equity accounts, and only the primary CTA line at the end counts in the total.
Is the elimination subsidiary in the consolidated trial balance?
Yes. A consolidated node returns the transactions of all its child subsidiaries, including elimination subsidiaries. A sum of the operating subsidiaries' trial balances alone still carries the investment in each subsidiary and both sides of every eliminated intercompany item. The elimination subsidiary is an option of its own in the Subsidiary Context list, and only journal entries post to it; add its trial balance to the sum.
What happens if a period has no consolidated exchange rate?
Oracle's documentation says that if you haven't set consolidated rates, NetSuite uses an exchange rate of 1. A subsidiary's amounts then pass into the consolidated report as they stand in its own currency. A consolidated trial balance that equals the plain sum of a multi-currency group's trial balances is the sign to look for. The rates for each period are at Lists > Accounting > Consolidated Exchange Rates; an elimination subsidiary's rate of 1 to its parent is by design.

← All notes

Push the Frontier

Work alongside our team to establish your first operational capabilities, built around the problems that matter most to your business.

Explore the platformTalk to Frontier
FrontierERP

Set a new standard for how businesses operate.

Platform
Solutions
Resources
Company
© 2026 Frontier ERP, Inc.PrivacyTerms