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.
You may find this useful
