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
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.
[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.
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 |
[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 ]