Tally Ledger Master XML Creator — Bulk Create Ledgers with GST Auto-Fill
Before importing Purchase or Sales vouchers into Tally Prime, the Party Ledger must already exist. This tool solves that prerequisite — bulk-create all your party ledgers (customers, suppliers) with full GST details, address, and opening balance in one XML import. Just enter the GSTIN and State, PAN & Registration Type fill automatically.
1 Download the Excel Template
Download the smart template — type a GSTIN and State, Country, PAN & GST Type fill in automatically via Excel formula.
2 Upload Your Filled Excel File
Supports .xlsx and .xls files. Your file never leaves your browser.
📋 Key Features of this Tool:
- • GSTIN Auto-Fill: Type the GSTIN — State, Country, PAN & GST Registration Type fill automatically in Excel and again on upload.
- • Alias Support: Enter multiple aliases comma-separated — each becomes a separate
<NAME>in Tally. - • Duplicate Detection: Same ledger name appears twice? Only the first one is included.
- • Masters XML: Generates
REPORTNAME=All Mastersstructure — import via Gateway of Tally → Import of Data → Masters. - • Opening Balance: Debit balances are stored as negative in Tally XML — this is handled automatically.
3 Preview & Validate
Showing first 10 rows. All rows will be processed.
4 Generate & Download XML
Review the summary above, then click to generate your Tally-ready Ledger Master XML file.
How to Use the Ledger Master XML Creator
Follow these steps to bulk-create Tally ledgers from Excel:
-
1
Download and fill the Excel template
Click "Download Ledger Template" above. Open it in Excel or Google Sheets. Each row = one ledger to create in Tally. The template has 12 columns — only Ledger Name and Under Group are required.
-
2
Type or paste the GSTIN — fields auto-fill instantly
Just type or paste the GSTIN in the GSTIN column (column L). The Excel template uses built-in formulas: State, Country, PAN, and GST Registration Type fill in automatically, both in the Excel template (via formula) and again as a safety check when you upload.
Example: Type27ABCDE1234F1Z5→ State fills as "Maharashtra", Country as "India", PAN as "ABCDE1234F", GST Reg Type as "Regular" — all automatically. -
3
Choose the correct "Under Group" for each ledger
The Under Group determines where Tally places the ledger in your Chart of Accounts. Common values: Sundry Debtors (customers), Sundry Creditors (suppliers), Bank Accounts, Cash-in-Hand. Type the exact name as it appears in your Tally.
-
4
Upload, preview, and download
Upload the filled Excel file. Review the first 10 rows in the preview table. Check the validation summary for any skipped rows. Then click "Generate Ledger XML" to download your XML file.
How to Import This XML into Tally Prime
Important: This tool generates a Masters XML file, not a Vouchers XML. The import path in Tally Prime is different — use Gateway of Tally → Import of Data → Masters, not the Vouchers/Transactions path. Using the wrong import path will result in an error.
Once you've downloaded the XML file, follow these steps inside Tally Prime:
-
1
Open Tally Prime and select your Company.
-
2
Go to Gateway of Tally → Import of Data → Masters. (This is different from the Vouchers/Transactions path used for Purchase and Sales XML imports.)
-
3
In the file path field, browse to the downloaded XML file (e.g.,
Tally_Ledgers_1234567890.xml) and press Enter. -
4
Tally will show an import progress screen. On success, it displays "Masters Created: X". If you see errors, check that the Under Group names match exactly what's in your Tally company.
-
5
Verify: Go to Accounts Info → Ledgers → Display to confirm all ledgers appear with the correct Group, GST details, and opening balance.
Excel Template Column Guide
All 12 columns in the Ledger template explained:
| Column | Required? | Example | Notes |
|---|---|---|---|
| Ledger Name | Required | Ramesh Traders | Exact name of the ledger as it should appear in Tally. Must be unique. |
| Alias | Optional | RT, Ramesh Bhai | Comma-separated alternate names. Each becomes a separate <NAME> entry in Tally for faster lookup. |
| Under Group | Required | Sundry Debtors | Parent group in Tally. Common values: Sundry Debtors, Sundry Creditors, Bank Accounts, Cash-in-Hand, Capital Account. |
| Opening Balance | Optional | 15000 | Numeric value only. Leave blank for zero opening balance. Use Dr/Cr column to specify direction. |
| Dr/Cr | Optional | Dr | Enter Dr or Cr. Defaults to Dr if blank. In Tally XML, Dr = negative value, Cr = positive value. |
| Address | Optional | 123 Market Road | Comma-separated or newline-separated address lines are each stored as a separate address line in Tally. |
| State | Auto-filled | Maharashtra | Auto-filled from GSTIN digits 1–2 via Excel formula. If GSTIN is blank, enter manually. |
| Country | Auto-filled | India | Auto-filled as "India" when GSTIN is present. |
| Pin Code | Optional | 400001 | 6-digit postal code. Stored as text in Tally. |
| PAN Number | Auto-filled | ABCDE1234F | Auto-extracted from GSTIN characters 3–12 via Excel formula. PAN is always embedded in a valid GSTIN. |
| GST Registration Type | Auto-filled | Regular | Auto-filled as "Regular" when GSTIN is present. Override manually for Unregistered, Composition, etc. |
| GSTIN | Optional | 27ABCDE1234F1Z5 | 15-character GST Identification Number. Entering this triggers auto-fill of State, Country, PAN, and GST Reg Type. |
✅ Ledgers created? Now import your vouchers:
Once your ledgers are in Tally, import your Purchase or Sales transactions using these tools:
Ledger Master Tool — FAQ
What is "Under Group" and what values are valid?
Under Group is the parent group in Tally's Chart of Accounts — it determines how the ledger is classified for accounting purposes. Common valid values include: Sundry Debtors (customers on credit), Sundry Creditors (suppliers on credit), Bank Accounts (bank ledgers), Cash-in-Hand (cash ledgers), Capital Account, Loans (Liability), Loans & Advances (Asset), Duties & Taxes (GST/TDS ledgers), Direct Expenses, Indirect Expenses. Type the name exactly as it appears in your Tally company — the spelling must match.
Do I need to fill State, Country, PAN, and GST Registration Type manually?
No — if you enter a valid 15-character GSTIN, all four fields fill automatically. In the Excel template, Excel formulas extract State (from digits 1–2), Country (always "India"), PAN (characters 3–12), and GST Registration Type (defaults to "Regular"). When you upload the file, the tool also runs the same auto-fill as a safety net, so it works even if you pasted data over the formulas. For parties without a GSTIN (e.g., Unregistered dealers), you'll need to fill these fields manually.
Can one ledger have multiple aliases?
Yes. Enter all aliases in the Alias column, separated by commas (e.g., RT, Ramesh Bhai, R Traders). Each alias becomes a separate <NAME> entry inside Tally's LANGUAGENAME.LIST, which means users can find the ledger by any of those names in Tally's ledger lookup.
What if a ledger name already exists in Tally?
If a ledger with the same name already exists in Tally, importing with ACTION="Create" will typically update the existing ledger rather than create a duplicate — Tally matches by ledger name. However, be cautious: if the existing ledger has different group assignments, the import may alter them. It's safest to only import ledgers that don't already exist in Tally. The tool detects duplicate rows within your Excel file and skips them, but it cannot check whether a ledger already exists in Tally.
Is this different from the Purchase/Sales XML tools? Can I use the same XML file?
Yes, this is structurally different. This tool generates a Masters XML with REPORTNAME=All Masters and creates LEDGER master records — it is imported via Gateway of Tally → Import of Data → Masters. The Purchase and Sales tools generate Vouchers XML with REPORTNAME=Vouchers and are imported via Import (Alt+O) → Transactions. The two XML types are not interchangeable — using a Ledger XML through the Vouchers import path will result in an error.
What GST Registration Types are supported?
The template auto-fills "Regular" when a GSTIN is present. For parties with different registration types, override this manually. Valid values in Tally include: Regular (most GST-registered businesses), Unregistered (parties without GSTIN), Composition (composition scheme dealers), Consumer (end consumers). Type the value exactly as Tally expects it in your version — these labels can vary slightly between Tally Prime versions.