Purchase Horizontal Tax Rate with Common SGST/CGST/IGST (Duties & Taxes)

Learn how to handle purchase Excel sheets with GST tax rates listed horizontally, including sheet modifications, field mapping, GST mapping, and ledger mapping for seamless integration with Suvit.

Folow the steps below:

2 excel sample.png 1. If you have purchase excel sheet which looks like above image. In which GST TAX Rate given in horizontal or in row.

1 sample main.png

With such data you want purchase entries like above image

Sheet Modification

A. Pick the smallest GST Tax Rate Number and add one row with name Purchase Ledger

Enter the Purchase account Ledger Name

Some other data should have in Excel Sheet

1. Supplier Invoice Number

2. Invoice Date

3. GST number ( Not Mandatory )

4. Party Name

5. Place of Supply (Not Mandatory )

6. Taxable Amount

7. Particulars-Purchase Ledger ( Smallest Sales account GST rate name )

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

Note: In this sheet you have to map **Smallest Taxable amount** in **Amount**
- As per this sheet we have mapped the GST Tax Rate 5

3 mapping.png

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).

Mapped Fields: These are fields that the system has matched automatically from your uploaded data.
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.)
Your Sheet Header: The headings from your Excel sheet will appear here. This helps you understand the data easily.
Tally Fields: These are fields matched with Tally filed. You can change them if needed.
Your Sheet Data: Shows the top 3 values from your Excel sheet to help you cross-check the data.
Press Next to go to the GST Mapping step.

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

Here we will mapp the Duties & Taxes and its details

GST Ledger from Excel Sheet & GST Auto Calculation settings will remain same(no changes).
Select SGST Ledger name in front of SGST, similarly for CGST & IGST as given in above image
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

Select remaining TAXABLE AMOUNT in increasing Order (small to big).
Click Save & Proceed to move to the process screen.
This action will also save the particular format within SUVIT for future uploads.