Tally Data Health Checker
The ERPPlugs Tally Data Health Checker scans a ledger list exported from TallyPrime or Tally.ERP 9, and optionally a stock item list, inside your browser. It flags duplicate ledgers, invalid or mismatched GSTINs, Regular parties without a GSTIN, opening balances that do not tally and stock items missing HSN, GST rate or unit, then scores your data out of 100 with a fix for each finding.
Use the free tool
Your files stay on your device. Everything is processed in your browser. Nothing is uploaded to ERPPlugs or anyone else, and no account is needed.
Ledger list (required)
Export your ledger masters from TallyPrime or Tally.ERP 9 to Excel or CSV with name, group, GSTIN/UIN, registration type, state, PAN and opening balance.
Stock item list (optional)
Add your stock item masters with name, part no, group, unit, HSN/SAC, GST rate and closing quantity to score the stock master too.
Add your ledger list, or click "Use sample data", to see the health score.
How the Tally Data Health Checker Works
- 1
Export your masters
Export the ledger list from TallyPrime or Tally.ERP 9 to Excel or CSV with name, group, GSTIN/UIN, registration type, state, PAN and opening balance. Add the stock item list if you want the stock master checked too.
- 2
Drop the files in
The tool finds the header row and matches your columns automatically, and you can change any match. Files are read in your browser and never uploaded.
- 3
Review the score and fix list
Get an overall score out of 100, a score for each area and a list of findings marked critical, warning or info, each with a suggested fix. Download the list as Excel or CSV for whoever corrects the data.
How Your Tally Health Score Is Calculated
Four areas, one weighted score
The checker groups its findings into four areas. Ledger hygiene covers every ledger and looks for duplicate names. GST readiness covers party ledgers under Sundry Debtors and Sundry Creditors plus any ledger with a GSTIN. Opening balances covers ledgers with a non-zero opening balance. Stock master covers every stock item, when you add a stock item list.
In each area, a record carries the penalty of its worst finding: critical 1, warning 0.5, info 0. Area score = 100 × (1 − total penalty ÷ records checked), rounded and never below 0. If opening debits and credits differ by more than ₹1, the opening balances score is capped at 40.
The overall score is the weighted average of the areas that could be scored: ledger hygiene 25, GST readiness 40, opening balances 20 and stock master 15. 85 and above is Healthy, 65 to 84 Needs attention and below 65 At risk.
Worked example: the sample files
The built-in sample has 38 ledgers and 16 stock items. Ledger hygiene finds one exact duplicate pair (critical for both) and one near-duplicate pair (warning for both): penalty 3 over 38 ledgers gives 92. GST readiness checks 21 party ledgers and finds penalty 9 (six records with a critical finding and six with a warning), giving 57. Opening debits and credits differ by ₹4,055, so opening balances is capped at 40. The stock master has penalty 6.5 over 16 items, giving 59.
Overall: (92 × 25 + 57 × 40 + 40 × 20 + 59 × 15) ÷ 100 = 62.65, which rounds to 63, At risk.
What to fix first
Start with critical findings in GST readiness, because invalid GSTINs, Regular parties without a GSTIN and a State that does not match the GSTIN change what is reported in your returns. Then make the opening balances tally, then merge duplicate ledgers and stock items, and finally fill in missing HSN codes, GST rates and units.
- Critical: wrong data that affects returns, balances or stock, such as an invalid GSTIN or negative closing stock.
- Warning: likely errors or gaps to review, such as a near-duplicate name or a missing HSN code.
- Info: worth a look but often correct, such as a customer with an advance (credit) balance.
Frequently Asked Questions
For ledgers: duplicate and near-duplicate names in the same group, invalid GSTINs, the same GSTIN on several ledgers, Regular party ledgers with no GSTIN, a State that does not match the GSTIN state code, a PAN that does not match the GSTIN, missing state on party ledgers, unequal opening debit and credit totals, and cash ledgers with a credit balance. For stock items: missing or wrong-length HSN/SAC, missing GST rate, missing unit, duplicate names or part numbers and negative closing stock.
Each record checked in an area carries the penalty of its worst finding there: critical 1, warning 0.5, info 0. Area score = 100 × (1 − total penalty ÷ records checked). Opening balances are capped at 40 if debits and credits differ by more than ₹1. The overall score weights ledger hygiene 25, GST readiness 40, opening balances 20 and stock master 15, using only the areas your files allow.
It checks that the GSTIN has 15 characters in the state code, PAN, entity number and check digit pattern, that the state code exists, and that the last character matches the check digit calculated from the first 14. It cannot tell whether a GSTIN is active or cancelled; confirm that on the GST portal.
No. The files are read and checked by your browser on your own computer. Nothing is sent to ERPPlugs or anyone else, and no account or email is needed.
When exactly one ledger is under Sundry Debtors and the other under Sundry Creditors, the party usually both buys from and sells to you, which is a common and valid setup. Any other repeat of a GSTIN is a warning, because it often means a duplicate party ledger.
Excel .xlsx or CSV. Old .xls files need to be saved as .xlsx first. Column names are matched automatically, for example Name, Under, GSTIN/UIN and Opening Balance, and you can map them by hand. Opening balances can carry Dr or Cr, sit in separate debit and credit columns, or be signed numbers.
Ready to eliminate manual data entry?
- Free consultation
- No commitment
- Tailored to your team
All product names, logos, and brands mentioned on this site are the property of their respective owners. ERPPlugs is not affiliated with, endorsed by, or sponsored by any of the third-party companies referenced. Use of these names is for identification purposes only and does not imply any association or endorsement.