Services · Streamline & Outsource

Chart of accounts audit

Take an evidence-based look at your NetSuite chart of accounts. We read the chart against what has actually been posted to it, map where it has grown untidy – unused accounts, near-duplicates and accounts used for the wrong things – and give your finance team a tidy-up plan they can sign off without disrupting reporting.

Sprawl mapped with evidenceRationalised under sign-off
The problem

Accounts are added to the chart when needed but rarely removed

Every chart of accounts grows the same way: an account gets added for an urgent need, and nobody ever removes it. A few years on, three freight accounts collect the same cost in different ways, reports need regrouping in a spreadsheet every month and new starters guess which account to use. The chart of accounts audit reads the chart against its postings to establish what’s used, what’s duplicated and what’s misused, then proposes a smaller, more accurate chart that finance can sign off with confidence.

What we run

How we audit your chart of accounts in NetSuite

Senior consultants oversee the work, and you can see progress as it happens. Approvals and decisions stay with your team.

  • Evidence of real useFor every account we gather how often it’s posted to, how recently and from where, separating the accounts in active use from the ones that aren’t.
  • Duplicates foundAccounts collecting the same cost, such as three freight accounts or parallel professional-fees codes, are identified along with their posting patterns.
  • Misuse spottedPostings that don’t match an account’s purpose, such as an expense sitting in an asset account or a catch-all bucket, are shown with the evidence.
  • Structure reviewedNumbering, parent accounts and how the chart works with segments are reviewed against reporting needs, so the structure is examined as well as the individual accounts.
  • A clear proposalRecommendations to merge, retire or re-map accounts are presented with the reporting impact of each one stated, so finance has everything needed to decide.
  • Careful executionApproved changes are made with the mappings recorded, so last year’s comparisons still work and saved searches and reports are updated at the same time.

Chart of accounts grown wild?

We audit the chart of accounts and map the clean-up. Talk it through with a senior consultant. It’s free, it takes 30 minutes and there’s no sales pitch.

The payoff

What handing it over buys you

The chart becomes easier to read

The accounts in active use become visible, turning a 900-account list into a clear structure.

Similar costs are posted together

Merging overlapping accounts brings the three freight accounts together.

Reports stop needing manual regrouping

A structure that supports reporting removes the month-end spreadsheet regrouping.

Comparatives are kept through the cleanup

Recorded mappings keep this year comparable to last throughout the chart of accounts cleanup.

How handover works

From posting evidence to a signed rationalisation

  1. Extract the evidence – usage, sources and patterns are gathered per account.

  2. Map the findings – duplication, misuse and structural problems are documented.

  3. Propose to finance – the decision pack states the impact of every change.

  4. Make the changes – approved changes are made and everything that references each account is updated.

Good to know

What to know before you hand it over

  • !The chart belongs to finance – the audit advises it. Account structure is accounting policy, so every merge and inactivation is finance’s call, made on our evidence. We make the proposals and your team makes the decisions.
  • !Keeping reporting intact comes first. A tidy-up that breaks year-on-year comparisons or statutory mappings costs more than the untidiness, so the proposal states the impact of each change, and some untidy accounts are worth keeping.
  • !We check what uses each account before it moves. Saved searches, reports, allocations and integrations all reference accounts, so the impact check comes before each change is made.
Straight answers

Chart of Accounts Audit FAQs

How many accounts should a chart have?
Most general ledgers hold far more accounts than they actually need. Data usually reveals a clean pattern: a compact core set of accounts in daily use, surrounded by a long tail of dormant ones that can be safely retired. While we often inherit bloated, 900-line charts of accounts, mid-market businesses typically operate best with a streamlined list in the low hundreds.
Can accounts be merged in NetSuite?
Not with a simple ‘merge’ button – consolidation happens through clean re-mapping and inactivation. New transactions flow to the surviving account starting on an agreed date, while the old account is inactivated to block future postings. Historical records stay untouched exactly where they were originally posted, keeping your audits, period comparisons and historical reporting completely intact.
What about segment overlap – departments doing account work?
That is a classic finding. Departments, locations and product lines belong in segments rather than in account names, so you don’t need a freight account per region – one freight account plus the location segment does the job better. The structural review covers this alongside the custom segment setup work.

Last reviewed: 21 October 2026 · Written by the Suite Generation team

Ready to hand this one over?

Tell us about your chart and the problems you are seeing. We will scope the work and give you a straight answer on effort.

Scoping Call — Sitewide

We reply within 24 hours.

or email hello@suitegeneration.net

Suite Generation is an independent, senior-led NetSuite consultancy. Every project is designed and delivered by consultants at or close to solution-architect level. We don’t resell licences or carry partner targets. Our advice is ours, whether you’re implementing NetSuite, rescuing a stalled project or fixing a system that never delivered.

Independent – no licence resellingSenior-led – solution-architect levelTrusted to fix failed implementations
Talk to a solution architect