Multi-Entity Consolidation & Close Manager

The problem

A multi-subsidiary NetSuite close usually runs on a spreadsheet and a group chat. Someone maintains a tab of tasks with owners and due dates. Someone else emails the local controllers asking whether the intercompany balances agree. A third person exports the trial balance, checks the cumulative translation adjustment, and tries to work out why the consolidated balance sheet is out by a few thousand. None of that lives in NetSuite, so none of it is evidence.

The pain concentrates in three places. Intercompany balances that do not agree between the two sides. Currency translation that nobody can explain line by line. And a close checklist where the true status is whatever the last person to update the spreadsheet believed. Every one of those is solvable with records and scripts sitting on top of the data NetSuite already holds.

What ECOSIRE builds

We build this as custom records, saved searches, and SuiteScript 2.1 scripts deployed into your account as an unmanaged bundle or SDF project. You own the source.

Intercompany matching and elimination

A Map/Reduce script reads transactions and GL impact across your subsidiary hierarchy, pairs them by intercompany counterparty, document reference, and amount, and writes a match record for each pair. Anything unmatched lands on an exception record with the reason — no counterparty entry, amount mismatch beyond tolerance, wrong period, wrong currency, or missing intercompany account mapping.

Matched pairs feed an elimination run. The script generates the elimination journal entries against your elimination subsidiary and mapped elimination accounts, handling intercompany receivables and payables, intercompany revenue and cost, intercompany loans and interest, and unrealised profit on inventory transferred between entities where you provide the margin basis. Every posted elimination line carries a link back to the source pair, so a reviewer can click from the consolidated adjustment to the two original transactions.

A reconciliation dashboard shows each subsidiary pair, the balance each side reports, the difference, and the ageing of any unresolved exception.

Currency translation review

NetSuite performs consolidation using its own rate types. What teams lack is a readable explanation of the result. We build a translation workpaper: per account, the local currency balance, the rate type applied, the rate used, the translated amount, and the movement in the cumulative translation adjustment for the period, with the prior period alongside. Historical-rate accounts — share capital, pre-acquisition reserves, and any account you designate — are held at their fixed rates on a dedicated record rather than in someone's memory.

A validation script flags the classic causes of an out-of-balance consolidation: a balance sheet account translated at an average rate, a missing rate for a period, a subsidiary whose functional currency changed, or an elimination posted in the wrong currency.

Close checklist and task control

A close task record models each step: name, owner role, subsidiary, dependency on other tasks, due offset from period end, expected duration, and the evidence required to complete it. A Scheduled script instantiates the whole checklist for each accounting period from a template, so nobody rebuilds it every month.

Tasks support attachments, sign-off with the user and timestamp captured, reopening with a reason, and a hard dependency rule — a task cannot be signed off while its predecessors are open. Reviewer sign-off is separate from preparer sign-off where you want segregation of duties, enforced by roles and permissions.

A close status dashboard shows, per subsidiary and per workstream, what is complete, what is late, what is blocked, and who owns it. Overdue tasks trigger notification to the owner and escalation to the workstream lead. A period-lock action refuses to run until every mandatory task in that period is signed off, which turns the checklist into a control rather than a tracker.

Consolidated reporting

Saved searches and datasets deliver the consolidated trial balance with an elimination column, the intercompany matrix, the translation workpaper, the close status report, and a period-over-period bridge. Where you want the checklist visible outside NetSuite, a RESTlet exposes read-only close status for a reporting tool or an internal portal, secured by role.

Who this is for

Groups running NetSuite OneWorld with more than one subsidiary, particularly where those subsidiaries transact with each other, report in different functional currencies, or sit under a controller who has to certify the group numbers on a deadline. It fits shared service centres, private-equity-backed groups with frequent acquisitions, and any finance team whose close is measured in days rather than hours.

How delivery works

This is a build-to-order application. It is not a finished product waiting to be downloaded; we build your instance of it.

1. Scoping call. We map your subsidiary hierarchy, functional currencies, elimination subsidiary and accounts, intercompany transaction types, close calendar, workstreams, and who signs off what. 2. Fixed quote. You get a written scope, an object list, and a fixed price before any build begins. 3. Build. Typical lead time is one working week, longer for deep hierarchies with many intercompany transaction types or unrealised profit elimination. 4. Install in your sandbox. We deploy to your sandbox, run a real historic period end to end, and reconcile our elimination and translation output against the close you already completed for that period. 5. Production. After sandbox sign-off we deploy to production and run the first live close in parallel with your existing spreadsheet, retiring it only once the two agree. 6. Support. A defined post-go-live support window covers defect fixes and configuration questions, extendable if you add subsidiaries later.

Source, SDF project, and object definitions are handed over. Adding a subsidiary or a new elimination account later is configuration you can do yourself.