How to Enter Sales Data with Common Duties & Taxes

Single Taxable Rate with Common SGST/CGST/IGST (Duties & Taxes)

If your entry looks like the image below, or if you want to enter a similar type of entry, where each sales bill has the same DUTIES & TAXES ledger, you can do so. This can be for either a single bill with a single entry or a single bill with multiple entries, all having the same TAX RATES.

Data requirement for excel sheet

• 1. Reference number

• 2. Invoice Date

• 3. GST number ( Not Mandatory )

• 4. Party Name

• 5. Place of Supply (Not Mandatory )

• 6. Particulars ( Sales Ledger Account Name )

• 7. Taxable Amount

• 8. SGST/CGST/IGST amount (Only required for Manual Calculation)

• Total amount (only required for cross verification)

• Other things to keep in mind Click Here

How to upload Excel sheet Click Here

Mapping

• Click on file to open Mapping Process*

Step 1: Field Mapping

1. Choose your data type: Decide if your data has items or no items. For this example, we will choose Without Item (see the image above).
2. Mapped Fields: These are fields that the system has matched automatically from your uploaded data.
3. Unmapped Fields: These are fields not matched yet. You need to select the right Tally fields for them. (Not all fields need to be matched.)
4. Your Sheet Header: The headings from your Excel sheet will appear here. This helps you understand the data easily.
5. Tally Fields: These are fields matched with Tally filed. You can change them if needed.
6. Your Sheet Data: Shows the top 3 values from your Excel sheet to help you cross-check the data.
7. Press Next to go to the GST Mapping step.

Step 2: GST Mapping (Map Your Tax Ledger).

• Here we will map the Duties & Taxes and its details

8. GST Ledger from Excel Sheet : It will remain as it is
9. Gst Auto Calculation: If you have Defined GST TAX Rate in Tally. Keep this setting as it is.
10. Duties & Taxes: You can select common Duties & Taxes ledger

• For Example: If entire sheet belongs to 18 GST Rate You can choose SGST, CGST, IGST or else SGST 9, CGST 9, IGST 18
• A. Manual Calculation If You click NO. You can pick the Duties & taxes(SGST/CGST/IGST) Amount from the Excel Sheet
• B. You will have the option to tick mark the SGST, CGST & IGST tax amount from the excel sheet.

**Note**: SGST, CGST, and IGST Tax Ledgers are mandatory fields that must be mapped. You can also map the round-off ledger from below option.

Step 3: Ledger Mapping

• In this step, you can map additional fields such as, discount, freight amount, etc., by selecting the appropriate file header and ledger.

Click Save & Proceed to move to the process screen.
This action will also save the particular format within SUVIT for future uploads.