Purchase Bill With Item-Multiple Tax-Common GST (Duties & Taxes)

---

If your bill includes **items with multiple tax rates** but uses the same **GST ledger (Duties & Taxes)**, you can enter it as follows:

• A bill with a single or multiple items.
• A bill with a single or multiple tax rates, using the common GST ledger (Duties & Taxes).

**Data requirement for excel sheet**


⇒ **You need at least 7 types of data in your Excel sheet for mapping:**

• 1. **SUPPLIER INVO:** A unique bill number for each purchase.

• 2. **INVOICE DATE:** The date the purchase happened.

• 3. **PARTY NAME:** Name of the client (as entered in Tally).

• 4. **PURCHASE LEDGER:** The purchase account name (GST Ledger).

• 5. **NAME OF ITEM:** Product name (e.g., Mobile, Laptop).

• 6. **QUANTITY** or **Rate** (both cannot be mapped together).

• 7. **AMOUNT:** Total price before tax (Quantity × Rate = Taxable Amount).

⇒ **Not Mandatory list**

• 8. **GST NO:** Client's GST number.

• 9. **PLACE OF SUPPLY:** State or city where the item was delivered.

• 10. **SGST, CGST, IGST:** Duties & Taxes amounts (required only for **Manual Calculation**).

• 11. **TOTAL AMOUNT:** Grand total including taxes (for verification).

• Other things to keep in mind: Click Here

How to upload an Excel sheet:Click Here

Mapping

• Click on your file to open the Mapping Process.

Step 1: Field Mapping

1. Choose your data type: Select Item invoice.
2. Mapped Fields: These are matched fields from your uploaded data.
3. Unmapped Fields: Fields not yet matched. Choose the correct Tally fields for them.
4. Your Sheet Header: Shows headings from your Excel sheet.
5. Tally Fields: Fields matched with Tally. You can change them if needed.
6. Your Sheet Data: Shows sample data for cross-checking.
7. Tally Fields Selection: Choose the correct field from the dropdown.
8. Press Next to move to GST Mapping.

Step 2: GST Mapping (Map Your Tax Ledger)

9. GST Ledger from Excel Sheet: Keep this as it is.
10. GST Auto Calculation: If GST rates are already defined in Tally, leave this setting as it is.
11. Duties & Taxes: Choose a common Duties & Taxes ledger.

• Example: For an 18% GST rate, select SGST 9, CGST 9, IGST 18.

12. Press Next to move to Other Ledger Mapping.

How to pick Duties & Taxes amounts from the Excel sheet:

• A. Manual Calculation: If you click NO, pick the Duties & Taxes amounts (SGST, CGST, IGST) from your sheet.
• B. Tick-mark the tax amounts: Use the tick option to assign Duties & Taxes amounts.
• C. Verify amounts for SGST, CGST, IGST from the sheet.

Press Next to move to Other Mapping.

**Note:** SGST, CGST, and IGST Tax Ledgers are mandatory. You can also map the round-off ledger.

Step 3: Ledger Mapping

• In this step, map additional fields such as Discount or Freight Amount by selecting the appropriate Excel header and Tally ledger.

• Click Save & Proceed to finalize the process.

• This format will be saved for future uploads in Suvit.