NETSUITETEXTILE2024

Case study

One ledger for three entities, closed in four days

A spinning, weaving and garment group running three disconnected accounting systems consolidated onto a single NetSuite ledger — with a governed item master and export documentation generated from order data.

Client
Vertically integrated textile group
Profile
Three legal entities · 1,400 staff · export-led
Duration
26 weeks
Services
Oracle NetSuite · Master Data Governance · Power BI
11→4Working days to close the group
11→1Item master variants consolidated
96%Export docs generated from order data

01 — CHALLENGE

What was actually broken

Each of the three entities had bought its own accounting software as it grew. Nothing reconciled without a spreadsheet, and nobody could state group inventory with confidence.

  • Group consolidation took eleven working days and depended on one analyst's workbook.
  • The same yarn count existed under eleven different codes across the three companies, making inter-company transfers a manual reconciliation each time.
  • Export documentation — packing lists, commercial invoices, certificates — was rebuilt in Excel per shipment, and keying errors were delaying containers at the port.
  • Buyer-level profitability was unknown once freight, commission and claims were included, so pricing decisions were made on gross margin alone.

02 — APPROACH

The sequence we used

We treated it as a finance and master-data programme that happened to involve software, not the reverse.

01

Chart of accounts and segment design

A single group COA with subsidiary, class, department and location segments, plus custom segments for count, shade and buyer — designed once so no reporting dimension had to be retrofitted later.

02

Item master rationalisation

Eleven code variants profiled, matched and merged into one governed standard with mandatory attributes for count, blend, width and GSM. Survivorship rules were agreed with the business and every merge kept a reversible audit record.

03

Three-pass migration

Masters and balances migrated in a trial load, a dry run and the cutover, each reconciled line-by-line to the closing trial balance and signed off by the group controller before the next pass.

04

Export documentation from order data

Document templates driven directly from sales-order and shipment records, so a packing list and invoice are generated rather than assembled, with buyer-specific formats held as configuration.

05

Reporting and hypercare

A Power BI model over the NetSuite data with documented definitions for gross margin, net buyer margin and yield, followed by six weeks of hypercare with named owners per module.

03 — RESULT

Where it landed

The group closes in four days, on one ledger, with inter-company transfers posting automatically.

  • Month-end close reduced from eleven working days to four, without additional finance headcount.
  • One item master across all three entities; duplicate creation now blocked at entry by validation rules.
  • Export documentation generated from order data for 96% of shipments, removing the keying step that had been delaying containers.
  • Buyer-level net margin — including freight, commission and claims — now reported monthly and used in price negotiation.
  • Inter-company transfers reconcile automatically instead of consuming two days of the close.
The blueprint stage was uncomfortable in the best way. They made us settle arguments about our own process before a single screen was configured — which is why the go-live was boring.
Group Chief Financial Officer · Vertically integrated textile group

Next step

We would rather show you the working than the summary

Ask for the blueprint structure, the migration reconciliation approach, or a reference call with a client in your sector.

WhatsApp