How to apply discount on sales voucher for only one sales ledger in accounting invoice mode.
Suppose I have 3 sales ledgers (Room, Room Service, Extra charges). I want to enter all 3 sales ledger and apply discount on only one ledger i.e. Room Service, then calculates GST. If I add discount, it calculate GST for all sales ledger, not only one sales ledger (i.e. Room Service).
Calculation must be :
- "Room" (5,000) → 12% GST = 600
- "Room Service" (2,000 - 500 = 1,500) → 5% GST = 75
- "Extra Charges" (3,000) → 12% GST = 360
Calculation happens now :
- "Room" (5,000), Discount (-500/10,000)*5,000 = 250, 12% GST = 570
- "Room Service" (2,000), Discount (-500/10,000)*2,000 = 100, 5% GST = 95
- "Extra Charges" (3,000), Discount (-500/10,000)*3,000 = 150, 12% GST = 342
It equally distributes the discount amount among all sales ledgers.
This is bit tricky but possible....refer below snapshots and sample data attached herewith to understand how you can achieve this in TallyPrime.
Make sure you have set GST Rate @ 12% in your Room Charges and Extra Charges sales ledgers, No GST Applicability on your Discount ledger and 5% on your Room Service Charges ledger
Now, while recording sales bill you will need to enable GST option from F12: configuration i.e. Override Taxable Value = Yes
Once you enable above option, you will get option to modify your taxable value to make it inclusive of discount i.e. Rs. 1500 but your ledger value will remain same Rs. 2000
Now you select your respective GST ledgers and GST amount will be calculated based on the taxable value and GST rate applicable only;
On tax invoice it will show the breakup of how GST has been calculated;
Above scenario will greatly help users generating hotel billing from TallyPrime.
Regards,
Dhaval Goradia