Purchase Common Taxable Amount with different Duties & Taxes in Horizontal Row

---

Instructions

• A. If you have Purchase excel sheet which looks like below image. In which Taxable amount is common for (B) different Duties & Taxes amount.

• 1 & 2 Sample entry in Tally with such data

Steps to follow

Sheet Modification Click Below

--> Excel Sheet Modification

• A. Common Taxable Amount for each Bill

• B. In excel sheet bifurcated (separates) duties & taxes amount should be there.

• C. Add one row with name Purchase Ledger and enter Common Sales account name also known as GST Ledger which will goes to particular.

Some other data should hvae in Excel Sheet

• 1. Reference number

• 2. Invoice Date

• 3. GST number ( Not Mandatory )

• 4. Party Name

• 5. Place of Supply (Not Mandatory )

• 6. Particulars ( Smallest Sales account GST rate name )

• 7. Taxable Amount

• 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

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 Matching step

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

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

8. Change GST Auto Calculation to NO
9. Select Duties & Taxes ledger name ( If you have taken Purchase 5 then select SGST 2.5 , CGST 2.5 and IGST 5 respectively )
10. Select Duties & Taxes amount of which you have selected in Step 9
11. Click Next for 3rd Stage mapping.

**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

12. Select remaining TAXABLE AMOUNT and its DUTIES & TAXES amount in decreasing Order (small to big).
13. Click Save & Proceed to move to the process screen.