Processing Purchase Excel with Horizontal GST Rates and Duties & Taxes

Learn how to process purchase Excel sheets with horizontally aligned GST rates and map the fields for SGST, CGST, and IGST tax ledgers for seamless data upload into Suvit for Tally integration.


Follow the steps below:

2 excel sample.png A. If you have a purchase excel sheet which looks like the image above, in which GST TAX Rate is given horizontally or in a row.

1 sample main.png

  • With such data, you want purchase entries like the image above.
Sheet Modification

sheet modification.png
  • A. In excel sheet along with the different Taxable amount there should be Individual Duties & Taxes
  • B. Pick the smallest GST Tax Rate Number and add one row with the name Purchase Ledger(Enter the Purchase account Ledger Name)

Some other data should be in the 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)

How to upload Excel sheet Click Here

Mapping

  • Click on file to open Mapping Process

1sales4.png

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

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.

6 gst calculation of.png

8. Change GST Auto Calculation settings to No 9. Select SGST Ledger name in front of SGST, similarly for CGST & IGST as shown in the above image.

  • For example: here we have selected Sgst 2.5, Cgst 2.5 & Igst 5 Ledger as we have selected Purchase 5 in Particulars.

10. Duties & Taxes: You can select common Duties & Taxes ledger.

  • This option is available after you click No in Step 8. You can pick the Duties & taxes (SGST/CGST/IGST) Amount from the Excel Sheet.
  • For example: here we have selected Sgst 2.5, Cgst 2.5 & Igst 5 amount as we have selected Purchase 5 in Particulars.
**Note**: SGST, CGST, and IGST Tax Ledgers are mandatory fields that must be mapped. You can also map the round-off ledger from the below option.

  • Go to Next

Step 3: Ledger Mapping

7.png

11. Select remaining TAXABLE AMOUNT in increasing order (small to big).

  • First select the remaining Taxable amount and then its duties and taxes as shown in the above image.
  • Maintain the same order for all other tax rates.

12. Click Save & Proceed to move to the process screen.

  • This action will also save the particular format within SUVIT for future uploads.

For Next Step Click Here