TallyPrime allows you to include or exclude additional charges and discounts like…Delivery Charges, Insurance Charges, Installation Charges, Rounded Off, Discount on Purchase etc.. etc.. from the assessable value for GST calculation. By configuring the ledgers appropriately, you can control whether additional charges or discounts are included or excluded from the assessable value for accurate GST calculation in TallyPrime 4
This can be done by configuring the relevant ledgers in TallyPrime 4 as described below :
1. Creation of Additional Charges Ledger included in Assessable Value for GST Calculation in Purchase Bill
The main situation is that whether all those additional charges are charged before GST or after GST. If those Expenses charged before GST, then all those Expenses should be created under Purchase Group without affecting Inventory value, GST Not Applicable, but it must be include in assessable value calculation for GST with Appropriation to Goods & Method of valuation should be Based on Value.. as given below screen :
[40-Inventory Management using TallyPrime]
2. Creation of Additional Charges Ledger without Inclusion in Assessable Value for GST Calculation in Purchase Bill
Ledger creation will be as below ( with Not applicable in all cases and should be under Direct Expenses Account Group)
[41-Inventory Management using TallyPrime]
Ledger Creation: ‘Insurance on Purchase’ & ‘Discount on Purchase’
Ledger Creation : ‘Rounded Off (+/-)’
3. Purchase Bill Voucher with Additional Charges / Discount
Here we have one sample of Purchase Bill with Additional Charges or Discount on Purchase both Before and After GST :
Transactions:
Purchase the following Items from Acer India Ltd. with Delivery Charges of Rs.500 charged before GST and Insurance Charges on Purchase of Rs.150 charged and with a Discount on Purchase @2% received after charging GST .
| Laptop ACER 4720Z | 2 Nos. | 32,500 |
| Laptop Compaq A901TU | 1 Nos. | 38,500 |
| Laptop HCL MiLeap | 1 Nos. | 35,000 |
[42-Inventory Management using TallyPrime]
Note :
>> In above case, value of Delivery Charges on Purchase of Rs.500 charged before GST and thus this value has included with Item Rate proportionally on the basis of item value and included in Assessable Value for GST Calculation.
>> But the expenses Insurance Charges on Purchase as well as Discount on Purchase are included in Bill after GST and thus these expenses or Incomes are charged independently in their ledger without affecting item rate or value.
>> Discount on Purchase Value or % should be given with (-) symbol, to deduct from the Bill value.
>> These can be viewed in Tax Analysis in Purchase voucher with Detailed (Alt+F1) as below:
GST Details :
Press Alt + A for GST – Tax Analysis Details…you will see the GST Analysis as below by default.
Press Alt+F1 for Details
[43-Inventory Management using TallyPrime]
[Practical Assignment]
[Purchase of Items & Goods with Additional Charges/ Discount etc. both Local and Outside State]
Swayam Sales Purchase the following items and goods from different Suppliers both within State as well as Outside State with all GST Compliance.
Please record all the following Purchase Transactions with GST ( with CGST / SGST & IGST )
PURCHASE TRANSACTION [F9]
Sl. No. Date Transactions
1. 20/4/2024 Purchase the following Items from Acer India Ltd. against Bill No- AIL/12 with Delivery Charges on Purchase of Rs.500 before charging GST and Insurance Charges on Purchase of Rs.200 and Discount on Purchase @ (-)2% after Charing GST
| ITEMS | Qty. | Unit | Rate | Value |
| Lenovo Idea Centre 3 Desktop | 2 | Nos. | 30,000 | 60,000 |
| Dell OPTIPLEX 3060 Tiny Desktop | 1 | Nos. | 28,000 | 28,000 |
| Dell 14 Laptop | 2 | Nos. | 31,000 | 62,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 1 | Nos. | 45,000 | 45,000 |
[Bill Value – Rs. 2,26,990 with CGST & SGST Rs. 17,595 each]
2. 3/5/2024 Purchase the following from Amazon Retail Pvt. Ltd. (IGST) against Bill No- ARPL-10 with 2% Discount on Purchase after GST.
| ITEMS | Qty. | Unit | Rate | Value |
| Panasonic 1.5 Ton Split AC | 1 | Nos. | 40,000 | 40,000 |
| Whirlpool 184 L S/Door Refrigerator | 1 | Nos. | 12,000 | 12,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 1 | Nos. | 45,000 | 45,000 |
| Samsung 256 L D/Door Refrigerator | 2 | Nos. | 26,000 | 52,000 |
[Bill Value – Rs. 1,72,120 with IGST Rs. 26,100 each]
3. 12/6/2024 Purchase the following Items from HCL Limited against Bill No- HL/12 with Delivery Charges on Purchase before GST of Rs. 500.
| ITEMS | Qty. | Unit | Rate | Value |
| HP Laptop 15s | 1 | Nos. | 48,000 | 48,000 |
| Haier 273 L D/Door Refrigerator | 1 | Nos. | 22,000 | 22,000 |
| Godrej 7 Kg T/Load Washing Machine | 5 | Nos. | 9,000 | 45,000 |
| Realme NARZO 70 Pro 5G | 2 | Nos. | 16,000 | 32,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 2 | Nos. | 45,000 | 90,000 |
[Bill Value – Rs. 2,80,250 with CGST & SGST Rs. 21,375 each
4. 18/7/2024 Purchase the following Items from Intel Solutions against Bill No- IS/15 with Insurance Charges on Purchase of Rs.200 and Discount on Purchase for Rs. 500 after GST.
| ITEMS | Qty. | Unit | Rate | Value |
| HP T630 High Performance Mini PC | 1 | Nos. | 25,000 | 25,000 |
| HP Laptop 15s | 1 | Nos. | 48,000 | 48,000 |
| Realme NARZO 70 Pro 5G | 2 | Nos. | 16,000 | 32,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 2 | Nos. | 45,000 | 90,000 |
| Dell OPTIPLEX 3060 Tiny Desktop | 1 | Nos. | 28,000 | 28,000 |
[Bill Value – Rs. 2,92,340 with CGST & SGST Rs. 22,320 each]
5. 25/8/2024 Purchase the following Items from Gayatri Sales Point. (IGST) against Bill No- GSP/25 with Discount on Purchase of Rs. 1000 after GST
| ITEMS | Qty. | Unit | Rate | Value |
| Whirlpool 7 Kg F/Load Washing Machine | 1 | Nos. | 22,000 | 22,000 |
| Lenovo Idea Centre 3 Desktop | 2 | Nos. | 30,000 | 60,000 |
| Dell OPTIPLEX 3060 Tiny Desktop | 1 | Nos. | 28,000 | 28,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 2 | Nos. | 45,000 | 90,000 |
[Bill Value – Rs. 2,35,000 with IGST Rs. 36,000 ]
6. 3/9/2024 Purchase the following Items from Thakral Infotech Ltd. (IGST) against Bill No- TIL/28 with Delivery Charges on Purchase of Rs.4000 before GST and Discount on Purchase @3% after GST.
| ITEMS | Qty. | Unit | Rate | Value |
| Panasonic 1.5 Ton Split AC | 1 | Nos. | 40,000 | 40,000 |
| Samsung 256 L D/Door Refrigerator | 3 | Nos. | 26,000 | 78,000 |
| Samsung Galaxy M55 5G | 2 | Nos. | 24,500 | 49,000 |
| Whirlpool 184 L S/Door Refrigerator | 2 | Nos. | 12,000 | 24,000 |
| Xiaomi 138 cm (55 inches) Smart TV | 1 | Nos. | 45,000 | 45,000 |
[Bill Value – Rs. 2,74,655.59 with IGST Rs. 41,735.59 each]
7. 14/10/2024 Purchase the following Items from Shree Enterprises against Bill No- SE/30 with Insurance Charges of Rs.100 & Discount on Purchase Rs.750 after GST.
| ITEMS | Qty. | Unit | Rate | Value |
| Coca-Cola Diet Soft Drink, 300ml | 10 | Pcs. | 30 | 300 |
| Tropicana Litchi 1000 ml | 20 | Pcs. | 100 | 2000 |
| Fortune Sunflower Oil 1L | 15 | Pcs. | 100 | 1500 |
| Suffola Active Pro Rice Bran Oil 1L | 25 | Pcs. | 100 | 2500 |
| Patanjali Kachi Ghani Mustard Oil 1L | 10 | Pcs. | 150 | 1500 |
| Tata Sampan Gota Urad Dal 1Kg. | 10 | Pcs. | 210 | 2100 |
| Good Life Chana Dal 500 gm. | 10 | Pcs. | 50 | 500 |
| Organic Moong Dal 1 Kg. | 10 | Pcs. | 150 | 1500 |
[Bill Value – Rs. 12,006 with CGST & SGST Rs. 378 each]
