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
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.
Services used
What this engagement drew on
Oracle NetSuite
Cloud ERP for multi-entity groups that have outgrown local accounting software.
NETSUITEMaster Data Governance
One customer, one item, one vendor — with rules and stewards that keep it that way.
MDMPower BI
A governed semantic model first, then dashboards executives actually open.
POWER_BIMore engagements
Other case studies
Product costing the shop floor actually recognises
Standard costs that had drifted for years rebuilt against real routings and consumption, with shop-floor capture on rugged terminals and variance reported per production order.
Two plants · discrete manufacturing · 600 staffODOO2025One inventory engine behind three sales channels
Wholesale, retail and e-commerce moved onto one Odoo inventory and pricing engine, with integration contracts, batch and expiry control, and margin reported at SKU and customer level.
Six warehouses · wholesale, retail and onlineNext 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.