Sheet modification for Multiple GST rates & Mapping with Suvit
Here we will guide to prepare an excel data with multiple GST rates to be processed in multiple GST ledgers created in tally. Also, mapping of the same will be discussed hereon.
How to Enter GST Data in Tally
If you want to enter data in Tally for different tax types like SGST, CGST, or IGST (for example, SGST 9%, CGST 9%, SGST 14%, CGST 14% ), follow these easy steps:
Step 1: Prepare Your Excel Sheet
Make a new column with the title Sales or Purchase Ledger. This will be where you write what the data is for (like "Sales").
Create columns for SGST, CGST, and IGST.
Step 2: Apply Filter
Use the filter option in Excel to sort the data by Rate (like 18%).
Step 3: Add Data to the Columns
After filtering the rate (for example, 18%), put the names of the Sales/Purchase ledger, SGST, CGST, and IGST in the right columns based on your Tally names.
Your data should look like above image
Step 4: Upload and Map Your Data
After you finish preparing your data in Excel, upload the document to Suvit.
Click on the Complete button to map your data correctly.
Step 5: Select GST Ledgers
When asked about the GST Ledger, choose Yes for each column.
A new section will open where you can check the boxes for the correct fields.
Step 6: Save and Proceed
After mapping, click on Save & Proceed to move your data to the next step.