In this guide 6 sections
Export the item master to a sheet, flag blank, duplicate and doubtful HSN entries, then agree the corrected mapping with your CA before changing a single row. Lock HSN and rate at creation. Re-run three months of real invoices through the cleaned list and have the CA review every line whose tax changed before the new master goes live.
Export the master and read it as a stranger would
Pull the full item list into a spreadsheet with code, name, HSN, tax rate, unit, group and creation date, including inactive items that old invoices still reference.
Read it slowly. You will find one bolt entered as M10 Bolt, Bolt M10 and BOLT-10MM, each carrying its own stock balance and its own sales history.
Give each row a verdict. Keep, merge, fix or retire.
Find the three kinds of bad rows
Blank entries come first. An item with no HSN or a rate of zero will either block the IRN call or go out at the wrong tax.
Duplicates need a rule. Two rows for one product mean two stock balances and two sales histories, so pick the survivor and move the history across before anything else is touched.
Doubtful entries are harder to see. Look for an HSN with the wrong digit count, a code from the wrong chapter, or a rate that disagrees with its own code. Sort by HSN to expose outliers.
- HSN blank or shorter than your turnover requires
- Rate missing or different from sister items
- Same name with spelling or spacing variants
- Unit of measure mixed within one product family
- Services entered as goods, or the reverse
Agree the mapping with your CA
Send the flagged rows to your CA as a clean table rather than a screenshot, and ask for the correct HSN or SAC on each. Ask for the rate too.
Ask for a written note on any item where classification is a matter of opinion, so the next auditor sees the reasoning behind the choice.
Units need the same care. Nos, pcs and each mean one thing to you and three to a validator, so keep one approved list with a carton-to-piece conversion. Log date and approver for every change.
Lock the gate so it stays clean
Cleaning is wasted unless the entry screen changes, so make HSN, rate, unit and group mandatory at creation and let only a named role add or edit items.
Add a format check that rejects a seven-digit code on the spot, and a warning when a new name looks close to an existing one. New items wait for approval.
- HSN and rate required, format checked
- One approved unit list, with case-to-piece conversion
- Creation limited to a named role
- Near-duplicate warning on save
Re-test on three months of real invoices
Run three months of invoice lines against the cleaned master on a test copy, then count the lines that now carry a different tax from what was billed. Each is an error or a slip.
Review that list with your CA before the new master goes live, then lock the old one as read-only and keep the step-one export in a shared folder.
Item master cleanup sheet
Each item gets a row holding code, name, current HSN, current rate and unit, plus the issue found, whether blank, duplicate or doubtful, and the proposed HSN and rate. Final columns hold the CA’s approval date and the verdict, and a side block lists the approved unit list and the mandatory fields for new items.
Open a blank worksheet to printQuestions owners ask
How many HSN digits do I need on an invoice?
It depends on turnover. Ask your CA which digit count applies to you, and set the entry screen to require at least that many digits so no shorter code can be saved.
What do I do with duplicate items that have stock?
Choose one survivor. Transfer the stock and history to it, mark the other row inactive, and do the move on a test copy, because merged stock balances are hard to unpick.
Should I delete old items?
No. Old invoices refer to them, so mark them inactive and they cannot be used on new bills while the history stays intact.
Who should own the item master after cleanup?
Give it to one named person in accounts or stores, with an approval step for every new item, because shared edit rights are how the mess started.