Intercompany Residual in a Locked April Consolidation
You are the financial systems lead at a US parent (USD) with UK (GBP) and German (EUR) subsidiaries in NetSuite OneWorld. On the April consolidated balance sheet, the elimination subsidiary shows an $18,450 residual in Due to/Due from, and consolidated net income is off by the same amount. The UK sub recorded a £40,000 payable to the parent on April 30; the parent recorded the receivable on May 1 for $52,100. The German sub recorded a €15,000 payable to the UK sub, but the UK sub's receivable was entered as a manual intercompany journal in GBP using a rate typed by the accountant. April is locked for all subsidiaries; May is open. The close checklist shows the intercompany elimination task as complete, and the group uses intercompany journal entries rather than Automated Intercompany Management. The CFO wants the April consolidation reissued tomorrow.
1. Diagnose the likely causes of the $18,450 residual and identify the NetSuite records and reports you would inspect to prove each cause.
Read the worked answer
Start by decomposing the $18,450; do not treat it as one error. Pull the Intercompany Reconciliation report for April by subsidiary pair, then a transaction saved search on intercompany journals with columns Subsidiary, Counterparty Subsidiary, Accounting Period, Transaction Currency, Exchange Rate, Amount, and base-currency amount. Reconcile each pair to the due-to/due-from accounts in the trial balance.
Three causes are visible in the facts: (1) cut-off - the UK payable is April 30 and the parent receivable is May 1 for $52,100, so April elimination cannot match them; (2) manual rate - the UK-Germany entry was keyed in GBP at a typed rate rather than translated from EUR, so the two sides differ by the rate variance; (3) the elimination task may have run before the last intercompany journal posted. Use System Notes on the manual journal to see who typed the rate and when. Also check the currency exchange rate table for April 30. The $18,450 is likely the net of the unmatched parent/UK timing item and the UK/Germany rate difference, but prove each component rather than plugging the residual.
2. April is locked. Describe the correction path that preserves an audit trail, including the entries and NetSuite steps, and state when you would reopen April.
Read the worked answer
Because April is locked, first quantify materiality. If $18,450 is material to the consolidated statements, reopen April through an administrator, post a balanced intercompany journal in April with the correct counterparty subsidiary and the April 30 consolidated rate, rerun the elimination, and relock. If it is immaterial, post a correcting intercompany journal in May, reversed in June if needed, and disclose the cut-off error.
Do not delete the original manual journal; post a reversing entry and a corrected entry so System Notes retains the trail. For the parent/UK timing item, either accrue the parent receivable in April if the service was delivered by April 30, or accept it as a May transaction and ensure the UK payable is also May - the key is symmetrical period treatment. Re-run the consolidated balance sheet and income statement and attach the reconciliation to the close file.
3. What preventive controls and NetSuite configuration changes would stop a repeat?
Read the worked answer
Set an intercompany cut-off calendar; require all intercompany journals for a period to be posted before the elimination checklist task can be completed; use the Intercompany Reconciliation report as a hard gate; restrict manual exchange rate overrides on intercompany journals; and, if licensed, use Automated Intercompany Management to generate matched entries and eliminations. Lock the intercompany balancing accounts after elimination. Add a close-checklist task that requires sign-off on a zero residual by subsidiary pair, with any residual explained.