FrontierERP
Sign inTalk to Frontier
Applied guide

Why a saved search won't match the balance sheet

NetSuite's balance sheet shows three equity lines it computes but doesn't post. Why a saved search or SuiteQL pull misses them, reconciled to zero.

Frontier · November 11, 2026

An applied guide for the controller or FP&A lead who has to make the pull tie.

The short answer. A saved search, SuiteQL query or AI-built pull that sums posted balances at the period-end rate gets NetSuite's assets and liabilities right on the default rate types. It misses three equity lines that NetSuite computes for the consolidated balance sheet and, by default, does not post. Retained Earnings shows prior years' net income. The Net Income row is the current year's, taken from the income statement. The Cumulative Translation Adjustment (CTA) is the figure that balances a multi-currency consolidation. NetSuite also translates each account at its own rate type, by default: current for assets and liabilities, historical for equity, and average to build retained earnings. Differ on any of the four that applies to your account and the pull won't tie. A summed pull doesn't even balance. The rest of this page shows each line, in Oracle's words, on a constructed group that reconciles to zero.

This is the second half of a question asked in a recent r/Netsuite thread. Its author wanted both consolidated statements, income statement and balance sheet, by accounting period from an AI assistant connected to NetSuite. One reply proposed summing the accounting lines by period in SuiteQL. NetSuite's own AI Connector report tools note that "Accounting periods are not supported" and that they "ignore the Report by Period user preference" (Report Tools). Why a saved search won't match NetSuite's P&L covers the income statement half. A balance sheet built from the accounting lines runs into four more rules.

The four lines, in Oracle's words.

  • Retained Earnings is computed from prior years' income. With NetSuite financials, "you're not required to make journal entries to close out the income statement to retained earnings". Under the automatic close, "your general ledger ties to financials for the same periods run for all accounts, with the exception of the retained earnings account", because "NetSuite doesn't post the balance to retained earnings". Instead: "Net income from prior fiscal year is displayed in the retained earnings account." (Year-End Closing). Oracle calls the figure "a placeholder entry to the retained earnings account on the balance sheet", shown "for reporting purposes"; no journal carries it, so the account's own balance holds only the journals you post to it.
  • Net Income is a row from the income statement. The standard Balance Sheet lists "Net Income (referenced row from Income Statement)" in its equity section (Balance Sheet Report). Oracle's year-end page puts the two rows together: "the retained earnings account and the net income account together make up your cumulative retained earnings balance at any point in time."
  • CTA is calculated, not posted. Consolidated balance sheets "use a special account called Cumulative Translation Adjustment (CTA) to achieve balance when there is more than one currency" (Balance Sheet Report), and, in Oracle's words, "The amount you see in consolidated reports for CTA is calculated dynamically, not posted to the account." (CTA Overview).
  • Each account translates at its own rate type. By default it 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". And: "The difference between values of consolidated exchange rates types results in a balance in the line for Cumulative Translation Adjustment (CTA)" (Consolidated Exchange Rate Types).

None of this is a defect. Oracle gives the reason for the first: posting the balance "would zero the past income statements and prevent them from being viewed." The other three are what a consolidated statement needs. The problem for a pull is only that, by default, three of the four lines never exist as postings for a search to find.

Harbor at 31 October.

This is the group from the P&L page, 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. FY2025 closed under NetSuite's automatic close, so nothing was posted to Retained Earnings. FY2026 has run from January to October. The report to match is the Balance Sheet for Harbor Inc. (Consolidated), as of 31 October 2026, accounting book Primary.

Subsidiary Assets Liabilities Share capital Net income, FY2025 Net income, FY2026 to date
Harbor Inc. (USD) 1,570,000 310,000 500,000 240,000 520,000
Harbor GmbH (EUR) 542,000 140,000 200,000 96,000 106,000
Harbor Elimination (USD) (208,000) — (208,000) — —

Constructed figures, each subsidiary in its own currency. The net income columns sit in income and expense accounts; none of it was posted to Retained Earnings. Harbor Inc.'s assets include 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 the controller's own journal against it: Dr share capital, Cr investment. October's figures are the P&L page's: 61,000 for Harbor Inc. and EUR 16,000 for Harbor GmbH, 78,600 consolidated. The intercompany fee was settled the same day, so no intercompany balance is open at month end.

The naive pull already obeys the P&L page's five rules. It reads posting periods ending on or before 31 October, posting lines only, the consolidated node with its elimination subsidiary (Oracle) and one accounting book (Oracle). It sums every balance-sheet account's posting lines and translates Harbor GmbH's at one rate: October's current consolidated rate, 1.1000. That is the rate in effect at the end of the period, which is how NetSuite calculates it (Calculating Consolidated Exchange Rates Automatically).

Assets and liabilities come out exactly right. Every one of them is posted, and NetSuite translates them at the same current rate. Equity does not. The pull reports 512,000 of equity against 1,958,200 of assets and 464,000 of liabilities, and it is out of balance by 982,200. That is the group's entire net income since it began trading, at 1.1000, sitting in income and expense accounts the pull never read. Here is each line that closes the gap.

1 · Retained Earnings. The Retained Earnings account holds no posting at all. The balance sheet shows FY2025's net income there anyway: Harbor Inc.'s 240,000 and Harbor GmbH's EUR 96,000, or 345,600 at the pull's rate.

2 · Net Income. The Net Income row is the income statement's FY2026 to date: 520,000 and EUR 106,000, October included, or 636,600 at the pull's rate. With lines 1 and 2 the pull balances, and its total equity of 1,494,200 is right. All three of its equity lines are still wrong, and the fourth, CTA, is missing.

3 · Share capital at the historical rate. NetSuite translates Harbor GmbH's EUR 200,000 of share capital at the historical rate. For January 2025 that is 1.0400, because the share capital was the only posting that month to an account with the Historical rate type, and the historical rate is the weighted average of such postings (Consolidated Exchange Rate Automatic Calculation Example). At 1.0400 the share capital is USD 208,000, and the elimination journal nets it to zero. At 1.1000 the pull leaves 12,000 of share capital that the consolidated report doesn't have. Intercompany eliminations: a worked example explains why the investment-against-equity journal is yours to post.

4 · Average rates for Retained Earnings and Net Income. NetSuite builds both from each month's income at that month's average rate, not at one period-end rate: each "accounting period, accounting book (when Multi-Book Accounting is enabled) and subsidiary pair has its own set of three consolidated exchange rate types" (Consolidated Exchange Rate Types). Harbor GmbH's FY2025 income comes to 108,400 instead of 105,600, and its 2026 income to 120,050 instead of 116,600: 6,250 more between them.

5 · CTA. The rest is the Cumulative Translation Adjustment, 5,750, the figure that makes the consolidated balance sheet balance. Lines 3 to 5 net to zero. They move equity between lines without changing the total.

Assets Liabilities Equity Assets − (liabilities + equity)
The naive pull 1,958,200 464,000 512,000 982,200
1 · Retained Earnings: FY2025 net income, at the pull's 1.1000 — — 345,600 (345,600)
2 · Net Income: FY2026 to date, at the pull's 1.1000 — — 636,600 (636,600)
3 · Rate: Harbor GmbH's share capital at the historical 1.0400, not 1.1000 — — (12,000) 12,000
4 · Rate: Retained Earnings and Net Income built at each month's average rate — — 6,250 (6,250)
5 · CTA: the balancing figure — — 5,750 (5,750)
Reconciled 1,958,200 464,000 1,494,200 0
NetSuite, Harbor Inc. (Consolidated), 31 Oct 2026, primary book 1,958,200 464,000 1,494,200 0
Difference 0 0 0 0

USD. Constructed figures; generated and re-footed by the packet script.

The CTA can be derived a second way, account by account. NetSuite "dynamically calculates CTA for each account and then displays the total in the CTA account line", and a Translation Adjustment column on a customised balance sheet "shows the amount resulting from the difference between the consolidated exchange rate that is used on each account and the current exchange rate" (CTA Overview). Oracle's own example there translates a UK subsidiary's assets and liabilities at Current, its retained earnings at Average and its equity at Historical, and the CTA "equals the amount that is required to balance the consolidated balance sheet." Here is Harbor GmbH the same way.

Harbor GmbH EUR Rate type EUR→USD USD CTA contribution
Assets 542,000 Current 1.1000 596,200 —
Liabilities 140,000 Current 1.1000 154,000 —
Share capital 200,000 Historical 1.0400 208,000 12,000
Retained Earnings: FY2025 net income 96,000 Average, month by month 1.1292 implied 108,400 (2,800)
Net Income: FY2026 to date 106,000 Average, month by month 1.1325 implied 120,050 (3,450)
Cumulative Translation Adjustment 5,750 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 direct rates "for periods that aren't closed" (Editing Consolidated Exchange Rates), each while its period was open. They are listed in the packet script, with October 2026 at the P&L page's 1.1000. The implied rates are rounded, and the contributions are computed month by month. Harbor GmbH's income was 8,000 a month in 2025, then 10,000 a month from January to September 2026 and 16,000 in October.

In the example's rates the euro gained against the dollar between January 2025 and October 2026, so the capital Harbor GmbH was given is worth 12,000 more today. Its income was earned at higher rates than 31 October's, which takes back 6,250. The net is the CTA. In NetSuite, clicking the CTA amount on the Balance Sheet opens the CTA Balance Audit report, which "shows the contribution from individual accounts to the CTA during the selected period", subsidiary by subsidiary. It "does not include manual entries to CTA accounts." Its account rows split the CTA by period movement, so they won't match the table above line for line; set the From period to the group's first period and its total ties to the 5,750.

For reference, this is the equity section NetSuite prints:

Harbor Inc. (Consolidated), 31 Oct 2026 USD In the ledger?
Share capital 500,000 posted; Harbor GmbH's eliminated at the historical rate
Retained Earnings 348,400 computed: FY2025 net income
Net Income 640,050 computed: the income statement's FY2026 to date
Cumulative Translation Adjustment 5,750 computed: the balancing figure
Total equity 1,494,200

Two more things change the arithmetic. Period End Journal Entries. By default NetSuite is "calculating, but not posting, consolidation adjustments and income statement closing". A subsidiary with the Period End Journal Entries feature enabled also posts them: an income statement closing journal that "moves net income into retained earnings", and a consolidation journal that posts each child account's translated amount to the parent and "includes the cumulative translation adjustment" (Period End Journal Entries). There, lines 1 and 5 are already in the ledger, and each child's translated balances sit on the parent as well. NetSuite's standard Balance Sheet ignores them: period end journals "have no impact on standard reports" (Financial Reports with Period End Journals). So leave them out of a pull you compare with it. A consolidated pull that reads them counts lines 1 and 5, and each child subsidiary, twice. A transaction search shows period end journals only when Include Period End Transactions is checked on its Results subtab. Timing. On 1 January 2027, FY2026's income moves from the Net Income row into Retained Earnings on the report, and nothing is posted. Suppose a pull ties in December 2026 by taking Net Income from the year's income statement and Retained Earnings as the account plus FY2025's income. In January 2027 it stops tying, by the whole of FY2026's income.

Check before you trust the number.

First, check that the pull balances. If assets minus liabilities minus equity isn't zero, a computed line is missing, and the size of the gap shows how much of it is lines 1 and 2. Then run five checks, one per line, each naming the setting, row or report that decides it.

  1. Retained Earnings. Where does the pull get it? Under the automatic close, the account's own balance holds only journals posted to it, and the report adds every prior year's income. Check how the year was closed (Setup > Accounting > Manage G/L > Manage Accounting Periods, per Year-End Closing) and whether any subsidiary has Period End Journal Entries enabled. Then add the prior years' income-statement lines from the first year on.
  2. Net Income. Is it a row of its own, starting from the first period of the fiscal year? Compare it with the Income Statement for the same fiscal year to date, subsidiary context and book. The P&L page's five rules apply to it unchanged.
  3. Rate. Which rate did each account get? On a saved search, read the Consolidated Exchange Rate field on the Results subtab. Per-Account is the default, and it "Uses the general rate type selected for each transaction's account". Current puts equity at the period-end rate (Consolidated Exchange Rate Types for Transaction Searches). On Per-Account, share capital already gets its historical rate, so line 3 is zero; Current is what produces it. On a query, compare each account's general rate type with the rates for each period under Lists > Accounting > Consolidated Exchange Rates.
  4. CTA. Is there a CTA line at all? By default no search returns it, because the amount is calculated, not posted; period end journals (row 5) and manual journals to the CTA account are the exceptions. Derive it as the balancing figure, then compare it with the CTA on the Balance Sheet and click through to the CTA Balance Audit report for each account's contribution.
  5. Period end journals. Is Period End Journal Entries enabled for any subsidiary? If so, the closing and consolidation journals are in the ledger, and the standard Balance Sheet ignores them. Leave them out of the pull, or it counts lines 1 and 5, and each child subsidiary, twice.

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

What this means for an AI-built balance sheet.

The same four lines apply to a balance sheet that an assistant builds from your account, whatever the tool. Frontier's balance sheet is one of nine standard statements: per-account balances through a date, balance-sheet accounts only, with an optional subsidiary and one accounting book. The query and the rows come attached. It is the posted half of this page. It reads posting periods ending on or before the as-of date, posting lines only, in one book. It has no computed Retained Earnings or Net Income row and no CTA. Left without a subsidiary, it adds each subsidiary's base-currency balances together without translating them, so on a multi-currency group run it one subsidiary at a time.

For Harbor GmbH, in euros, the attached rows are the posted half: assets 542,000, liabilities 140,000 and share capital 200,000. The income statement, another of the nine, supplies the two missing rows. Run for FY2025, it gives the 96,000 that belongs in Retained Earnings. Run for 2026 to date, it gives the 106,000 Net Income. Together they make Harbor GmbH's own balance sheet, which balances in euros. The statement does not translate or consolidate it. Rates by account type and the CTA are the worksheet above. The trial balance on the same list reads income-statement accounts for the year to date and balance-sheet accounts cumulatively. Read its attached query the same way, for where prior years' income lands.

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: take the pull you have and NetSuite's balance sheet for the same date, subsidiary context and book. Check that the pull balances, then walk the five rows above in order. Each difference belongs to one of them, 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. Statements about NetSuite's behaviour are quoted or paraphrased from Oracle's documentation, linked where they appear: Year-End Closing, the Balance Sheet report, consolidated exchange rate types, rate types for transaction searches, calculating consolidated exchange rates and its worked example, editing consolidated exchange rates, the CTA overview, the CTA Balance Audit report, Period End Journal Entries, financial reports with period end journals, subsidiary context for reports, reports and saved searches in Multi-Book Accounting and the AI Connector's report tools. The forum thread is paraphrased, not quoted. Your account's close method, rate types and period end settings decide which of the five lines apply to you, and the checklist is how to find out. The A/R line on this balance sheet is a second tie-out of its own, against the aging: Why A/R aging won't tie to the balance sheet reconciles Harbor's receivables at 31 October. The CTA above appears on the consolidated trial balance too, one reason it won't equal the subsidiaries' trial balances added up: Why the consolidated TB isn't the sum of the subs reconciles Harbor's three to it, account by account. Put this balance sheet beside one a month earlier and the cash flow statement sits between them: Why the cash flow won't tie to the balance sheet foots Harbor's October to the change in Bank, line by line.

Questions this raises

Why doesn't my NetSuite saved search match the balance sheet?
Because NetSuite's consolidated balance sheet carries three equity lines that it computes for the report and, by default, does not post: prior years' net income in Retained Earnings, the current year's Net Income row, and the Cumulative Translation Adjustment. It also translates each account at its own rate type, by default: current for assets and liabilities, historical for equity, and average to build retained earnings. A search or query that sums posted balances gets assets and liabilities right on the default rate types but misses the three lines, so it doesn't even balance. The page reconciles one constructed group to zero.
Where does NetSuite's Retained Earnings figure come from?
Under the automatic year-end close, it comes from the income statement. Oracle's documentation says NetSuite doesn't post the balance to retained earnings. It displays net income from prior fiscal years in the retained earnings account and the current year's in the net income account, and the two together make up the cumulative retained earnings balance. Journals you post to the retained earnings account are combined with that figure.
Why is there a CTA line on the balance sheet that no search returns?
The Cumulative Translation Adjustment is the figure that makes a consolidated balance sheet balance when there is more than one currency and accounts translate at different rate types. Oracle's documentation says the amount in consolidated reports is calculated dynamically, not posted to the account, so by default there is no posting for a search to find. The CTA Balance Audit report breaks it down by account and subsidiary.
What changes with Period End Journal Entries?
With the feature enabled for a subsidiary, NetSuite posts what it otherwise only calculates. An income statement closing journal moves net income into retained earnings, and a consolidation journal posts each child subsidiary's translated balances to the parent, including the cumulative translation adjustment. NetSuite's standard balance sheet ignores period end journals and still calculates both, so leave them out of a pull you compare with it; a pull that includes them carries retained earnings, CTA and each child's translated balances a second time. A transaction search shows period end journals only when Include Period End Transactions is checked on its Results subtab.

← 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