---

Common GST Amount with Different Tax Ledgers

In this guide, we will show you how to map a common GST amount with different tax ledgers. For example, if the total taxable amount is 1000, and the GST amounts are as follows:

• SGST 2.5% = 12.5
• CGST 2.5% = 12.5
• SGST 9% = 45
• CGST 9% = 45

Sample Entry:

Below is the sample data you might have in your Excel sheet:

Step 1: Add Sales/Purchase Account Ledger Name

While preparing the Excel sheet, you need to add a row for the Sales Account or Purchase Account ledger name as shown below:

Step 2: Map the Sales/Purchase Account Ledger as Particulars

Map the Sales Account or Purchase Account ledger as Particulars in the mapping section, as shown below:

Step 3: Select "No" for GST Auto Calculation

In the GST Mapping section, select "NO" for GST auto calculation:

Step 4: Select Duties and Tax Ledgers

Select the appropriate Duties and Tax ledgers as shown in the image below:

Step 5: Select Amounts for the Respective Duties and Tax Ledgers

Then, select the amounts for the respective Duties and Tax ledgers that correspond to the values provided in your Excel sheet:

Step 6-a: Go to Ledger Mapping

Now, press "Next" from the bottom right to go to "Ledger Mapping", where the remaining column headers from your Excel sheet will appear. Simply select the respective ledgers for the headers, so the amounts will reflect correctly in your Tally account.

After successfully assigning the correct ledgers, your screen will look like this:

Step 9-a: Click on "Save & Proceed"

Once you have mapped the GST amounts and ledgers correctly, click on "Save & Proceed".

Step 9-b: Transfer Data to Tally

After transferring the data to Tally successfully, your entry will appear in Tally as shown below:

Note: Click on the image to Zoom.