The close, consolidation and reports in Oracle NetSuite

At station six the numbers settled. This station gathers them and closes them — and it holds the capability the product gets bought for in the first place.

The close — a task list, not a button

A close here is not one event; it is a sequence of tasks, each with an owner and a status.

And the lock itself sits at two levels, and telling them apart is practical:

The level	What it does
A lock by transaction type	Stops sales and purchases and leaves journal entries open
A full period lock	Nothing is posted into it afterwards

The first is what makes a close workable at all. A company shuts the operational doors at the start of the month and keeps the accountant’s door open for adjusting entries — which is exactly what happens in every company in the world in the first five days.

And in a group, the lock is managed per entity. An entity in one country that has finished its reconciliations may be closed while another is still waiting on a bank statement — nobody waits for the slowest.

Four reconciliations before any statement

A statement is not read before its sources are reconciled. Four are done in order:

The reconciliation	What is compared	What a difference in it means
The bank	The statement against the bank account	An uncashed cheque, or a movement never recorded
Receivables	The ageing against the account balance	Unapplied movements, usually
Payables	Vendor statements against their balances	And the interim account with them
Inventory	The stock report against the stock account	Count differences, or an incomplete transfer

The third row returns you to station four: the balance of what was received and not invoiced is reviewed here monthly, not once a year.

Consolidation — the capability that justifies the product

Here is the heart of what is bought.

Reading a group consolidated goes through three steps, each with a different effect:

1. Currency translation. Every entity keeps its books in its own currency, and its numbers are translated into the consolidated presentation currency — at a closing rate for balances, and at period rates for results.

2. Intercompany elimination. A sale from one entity to another is not revenue for the group, and the balance between them is not a receivable. Both are eliminated face against face.

3. Unrealised profit elimination. If goods sold internally are still sitting in the buyer’s stock, the profit the seller recorded has not yet been realised for the group, and it is deducted from the inventory value.

The third step is the one that gets skipped, and it is the one the auditor asks about.

The translation difference — the third difference you were promised

At station three it was said that currency differences are of three kinds, and that the third is the one people who have never worked in a group get wrong. This is it.

The kind	When it arises	Where it appears
A settlement difference	At actual payment	The income statement
A revaluation difference	At the close, on balances	The income statement
A translation difference	On consolidating an entity in another currency	Equity — not the income statement

The third row is the key: this difference never passes through profit and loss at all.

It is neither a profit nor a loss; it is the effect of translating a foreign entity’s statements into another currency — and it accumulates in a separate line inside equity.

Anybody looking for it in the income statement concludes the balance sheet does not balance. This is one of the clearest signals separating somebody who has worked in a group from somebody who has not.

The skill that makes you useful here

In this product specifically the skill has a name: the saved search.

Most management questions are not answered by a ready-made report. “Which customers have gone more than thirty days past their payment terms, in the northern branch, on second-category items?” is not a report; it is a question.

A saved search answers it in four parts:

Criteria — what enters the result. Results — which columns, in what order, with what grouping. Calculated fields — ratios and formulas derived from the columns. Sharing — who sees it, and when it is sent automatically.

The intersection of the four produces an answer with not one line of code.

The fourth part is the one skipped and the most valuable. A search delivered every Monday morning to somebody who decides changes a company’s behaviour; a search opened on demand is opened by nobody.

This is the fastest skill that makes you useful on a real project on this product, and the most asked for in your first week, and it is entirely functional rather than technical — meaning it is open to you whatever your track.

What you actually do at this station

• Write a complete monthly close task list with an owner for each task, in order.
• Explain when a transaction type is locked and when the whole period is, with an example on a calendar.
• Take the group scenario from station two and add an intercompany sale whose goods stayed in stock, and calculate what is eliminated at consolidation through all three steps.
• Calculate a translation difference for an entity in another currency between two rates, and write where it appears and why it does not appear in the income statement.
• Design a saved search on paper with its four parts answering a real management question, and specify who it goes to and when.

The three commonest errors

One: locking the whole period on the first day. It looks like discipline, and it stops the accountant finishing the adjustments, so it gets opened and closed repeatedly until it means nothing.

Two: consolidating without eliminating unrealised profit. The numbers balance and look sound, and they carry a profit the company sold to itself.

Three: hunting the translation difference in the income statement. A whole day goes into it, and the right place is a line in equity.

What the quality of the close and the consolidation does to this product’s value is set out in the Oracle NetSuite guide, and the general logic of the financial cycle — from the entry to the statement — is in the financial cycle and the close.

The acceptance test for this station

1. Explain the two lock levels and why the narrower one exists.
2. Name the four reconciliations in order, and which account is reviewed with payables.
3. Explain the three consolidation steps, which one gets skipped and why the auditor asks about it.
4. Tell the three kinds of currency difference apart, and where each of them appears.
5. Present a saved search you designed with its four parts, and explain the question it answers.

What comes next

The numbers are right, consolidated and closed. The next station is the most honest station on this path and the hardest: localisation and Arabic — 27 languages on the official list and Arabic is not one of them, and a real difference between Saudi localisation and Emirati localisation read from the developer’s own documentation.