Discount Percentage and/or Amount on Item Rates during Purchase using TallyPrime 4

TallyPrime 4 offers multiple ways to handle discounts on purchases, depending on the nature of the discount and your business requirements.

Types of Discounts

Before we dive into the steps, let’s clarify the different types of discounts you might encounter:

·         Trade Discount: A reduction in the list price of a product or service.

·         Cash Discount: A reduction in the invoice amount offered for early payment.

·         Discount Based on Quantity: A discount offered for purchasing a specific quantity.

Would you like to see a step-by-step example with screenshots ? as discussed below :

1.  Enter the Discount Percentage against each item – without using the Ledger Account

You can enter the discount percentage against each item and the Amount will be calculated automatically.

1.   Press F11 (Features) > set Use Discount column in invoices to Yes.

If you do not see this option, set Show more features to Yes.

Henceforth, you will see the Disc % column in every purchase invoice.

[44-Inventory Management using TallyPrime]

[Item Wise Discount Feature in TallyPrime]

2.   In the purchase invoice, after you have provided the Quantity and Rate, enter Disc % for the selected item.

The Amount for the given quantity of the stock item is displayed after deducting the discount, without showing any change in the Rate.

[45-Inventory Management using TallyPrime]

3.   Enter the remaining details and accept the screen. As always, you can press Ctrl+A to save.

The discounted item amount appears against each item.

[Practical Assignment]
[Purchase of Items & Goods with Discount Percentage (%) against each items]

1.   22/4/2024            Purchase (against Bill No-SE/15)  the following Items from Intel Solutions

See also  Purchase of ‘Nil-Rated’, ‘Exempted’, Items & Goods using TallyPrime 4
ITEMS Qty. Unit Rate Disc. Value
Lenovo Idea Centre 3 Desktop 2 Nos. 30,000 5% 57,000
Dell OPTIPLEX 3060 Tiny Desktop 1 Nos. 28,000 3% 27,160
Dell 14 Laptop 2 Nos. 31,000 8% 57,040
Apple iPhone 13 (128GB) 1 Nos. 45,000 2% 44,100

[Bill Value – Rs. 2,18,654 with CGST & SGST Rs. 16,677 each]

2.  25/5/2024            Purchase the following Items from Sony India Limited (IGST) against Bill No-SIL/17

ITEMS Qty. Unit Rate Disc. Value
Lenovo Idea Centre 3 Desktop 2 Nos. 30,000 5% 57,000
Dell OPTIPLEX 3060 Tiny Desktop 1 Nos. 28,000 3% 27,160
Whirlpool 184 L  S/Door Refrigerator 2 Nos. 12,000 8% 22,080
Xiaomi 138 cm (55 inches) Smart TV 1 Nos. 45,000 2% 44,100

[Bill Value – Rs. 1,76,076.40 with IGST Rs. 25,736.40]

3.   5/6/2024              Purchase (against Bill No-SE/18) the following Items from Shree Enterprises.

ITEMS Qty. Unit Rate Disc. Value
Coca-Cola Diet Soft Drink, 300ml 20 Pcs. 30 5% 570
Tropicana Litchi  1000 ml 20 Pcs. 90 3% 1,746
Fortune Sunflower Oil 1L 20 Pcs. 100 8% 1,840
Suffola Active Pro Rice Bran Oil 1L 5 Pcs. 100 2% 490
Patanjali Kachi Ghani Mustard Oil 1L 8 Pcs. 150 5% 1,140
Tata Sampan Gota Urad Dal 1Kg. 10 Pcs. 210 4% 2,016
Good Life Chana Dal 500 gm. 10 Pcs. 50 3% 485
Organic Moong Dal 1 Kg. 15 Pcs. 150 6% 2,115

[Bill Value – Rs. 11,084.24 with CGST & SGST of Rs. 341.12 each]

2.  Enter Discount Percentage and/or Amount on Item Rates – using the Ledger Account

You can enter the discount percentage or the discount amount directly after entering the quantity and rate of the stock items. Once the stock details are entered, you can select the discount ledger for the discount to be applied to the invoice amount.

See also  Ledger to Round-off the Invoice Value Automatically in Sale Invoice in TallyPrime 4

1.   In the purchase invoice, press F12 (Configure) > set Provide Cash/Trade Discount to Yes.

[46-Inventory Management using TallyPrime]

If you do not see this option, set Show more configurations to Yes.

[If the option does not appear, press F11 (Features) > enable the statutory options (GST or VAT) applicable to your business.]

2.   After you have entered the Amount of the stock item, in the Discount field, enter the discount percentage that you have received for that item.

This automatically calculates the discount and displays the amount in the next field.

[47-Inventory Management using TallyPrime]

Alternatively, press Enter to leave the first field blank and enter the discount amount in the next field.

[48-Inventory Management using TallyPrime-4]

3.   Select the discount ledger created under Indirect Incomes.

Ensure that in the discount ledger, the option Type of ledger is set to Discount.

[49-Inventory Management using TallyPrime-4]

[50-Inventory Management using TallyPrime-4]

Enter the remaining details and accept the screen. As always, you can press Ctrl+A to save.

The total discount amount appears against the selected discount ledger. This amount is the sum of the discounts displayed under each stock item.

[Practical Assignment]
[Purchase of Items & Goods with Discount Amount and / Or Percentage (%) against each items using Discount Ledger]

1.   20/4/2024            Purchase the following Items from Amazon Retail Pvt. Ltd. against Bill No-ARPL/25 with Discount Amount as well as Dist. % against each items with Trade Discount Ledger after GST.

ITEMS QTY. Unit RATE DISC. Value DISC. %
Lenovo Idea Centre 3 Desktop 2 Nos. 30,000 500  
Dell 14 Laptop 2 Nos. 31,000   2%
Xiaomi 138 cm (55 inches) Smart TV 1 Nos. 45,000 1200  
See also  Creating GST Ledger ( CGST / SGST / IGST) in TallyPrime 4

 [Bill Value – Rs. 1,93,590.80  with IGST Rs. 29,530 and Trade Discount of Rs. 2,940 ]

2.  28/6/2024            Purchase the following Items from Sony India Limited (IGST) against Bill No-SIL/27

ITEMS QTY. Unit RATE DISC. Value DISC. %
Dell OPTIPLEX 3060 Tiny Desktop 1 Nos. 28,000   5%
Panasonic 1.5 Ton Split AC 1 Nos. 40,000   4%
HP Laptop 15s 1 Nos. 48,000 2000  
           

[Bill Value – Rs. 1,30,980 with IGST Rs. 19,980 and Trade Discount of Rs. 5,000 ]

3.   15/8/2024            Purchase (against Bill No-SE/28) the following Items from Gayatri Sales Point. (IGST) against Bill No- GSP/35  with Product Discount as given.

ITEMS QTY. Unit RATE DISC. Value DISC. %
Samsung 256 L  D/Door Refrigerator 3 Nos. 26,000 800  
Samsung Galaxy M55 5G 2 Nos. 24,500   5%
Whirlpool 184 L  S/Door Refrigerator 2 Nos. 12,000 750  
HP T630 High Performance Mini PC 1 Nos. 25,000   5%
Godrej 7 Kg  T/Load Washing Machine 5 Nos. 9,000 1000  
Realme NARZO 70 Pro 5G 2 Nos. 16,000 1750  

[Bill Value – Rs. 2,87,705 with IGST Rs. 42,705 and Trade Discount of Rs. 8,000 ]

Shopping Cart
error: Content is protected !!
Scroll to Top

Printing Book (Paperback)

Original price was: ₹800.00.Current price is: ₹775.00.Add to cart

e-Book (PDF)-Download

Original price was: ₹800.00.Current price is: ₹750.00.Add to cart

Paperback Printing Book

TallyPrime Book (Advanced Usage)-Rel-4 and 5-Front Cover Page

Original price was: ₹800.00.Current price is: ₹775.00.Add to cart

e-Book (PDF)-Download

Original price was: ₹800.00.Current price is: ₹750.00.Add to cart