Import Party GSTIN in TallyPrime: 2 Easy Methods + 2 Examples

Importing Party GSTIN in TallyPrime helps businesses maintain accurate records for GST compliance.

Instead of manually entering GSTIN details for each party, you can bulk import them using Excel or XML files, saving time and minimizing errors.

---

1. Why Import Party GSTIN in TallyPrime?

• Avoid manual data entry errors.
• Save time when updating multiple party ledgers.
• Ensure compliance with GST return filings (GSTR-1, GSTR-3B, etc.).
• Maintain accurate records for Input Tax Credit (ITC) claims.

---

2. Methods to Import Party GSTIN in TallyPrime

TallyPrime provides two primary methods to import GSTIN details for parties:

Method 1: Importing GSTIN via Excel (Spreadsheet)

1. Prepare an Excel File with Party GSTIN Details
   • Open Microsoft Excel or Google Sheets.
   • Create a table with the following columns:

Party Name	GSTIN	State	Type of Registration
ABC Traders	27AABCT1234A1Z5	Maharashtra	Regular
XYZ Enterprises	29XYZE5678L1Z2	Karnataka	Composition

2. Save the File in CSV or Excel Format
   • Go to File > Save As > CSV (Comma Delimited) or Excel (.xls/.xlsx).
3. Import Data into TallyPrime
   • Open TallyPrime.
   • Go to Gateway of Tally > Import Data > Masters.
   • Select Excel or CSV File as the source.
   • Locate the saved file and import it.
   • Verify that all party GSTINs are updated in Ledgers.

---

Method 2: Importing GSTIN via XML File

Tally also allows importing party GSTIN details using XML format, which is useful for bulk data migration.

1. Prepare an XML File with GSTIN Data
   • The XML file should follow Tally’s import format:

<TALLYMESSAGE xmlns:UDF="TallyUDF"> <LEDGER NAME="ABC Traders" RESERVEDNAME=""> <ADDRESS.LIST TYPE="String"> <ADDRESS>123, Business Street</ADDRESS> </ADDRESS.LIST> <GSTIN>27AABCT1234A1Z5</GSTIN> <STATENAME>Maharashtra</STATENAME> <GSTREGISTRATIONTYPE>Regular</GSTREGISTRATIONTYPE> </LEDGER> </TALLYMESSAGE>

2. Import XML File into TallyPrime

• Go to Gateway of Tally > Import Data > Masters.
• Select XML File as the source.
• Locate the XML file and import it.
• Verify that all party GSTINs are updated in Ledgers.

---

3. Verify Imported GSTIN in TallyPrime

After importing, check whether the GSTIN details are correctly updated in party ledgers:

1. Go to Gateway of Tally > Alter > Ledger.
2. Select any party whose GSTIN was imported.
3. Check the GSTIN/UIN field and ensure the correct details are displayed.

---

4. Impact of Imported GSTIN on GST Returns in TallyPrime

• GSTR-1 → Accurate party GSTIN ensures proper invoice reporting.
• GSTR-3B → Ensures correct Input Tax Credit (ITC) claim.
• GST Annual Return → Helps in reconciling ITC with supplier records.

---

5. Conclusion

• Importing Party GSTIN in TallyPrime improves accuracy and efficiency.
• Both Excel (CSV) and XML methods allow bulk data updates.
• After import, always verify GSTIN details in party ledgers.