Explore Categories

 

 PDF

Calculate VAT After Discount

You can calculate VAT after discount by creating a discount ledger and configuring it to form a part of the assessable value. You can create a discount ledger, select it in the sales invoice and view the appropriated discount value in the triangulation report.

Creating a discount ledger

Recording a sales invoice with discount ledger

Viewing Appropriated Discount Value in the Triangulation Report

Creating a Discount Ledger

  1. Gateway of Tally > Create > type or select Ledger.
    Alternatively, press Alt+G (Go To) > Create Master > type or select Ledger.
  2. Select Indirect Expenses or Indirect Incomes in the option Under.
  3. Enable the Set/Alter Statutory details to Yes.
    • Set the option Is VAT/CST applicable? to Not Applicable.
    • Set the option Include in assessable value calculation for? to VAT.
    • Set the option Method of Calculation to Based on Value.
      The Ledger Creation screen appears as shown below:Discount Ledger in TallyPrime
  4. Accept the screen. As always, you can press Ctrl+A to save.

Recording a Sales Invoice with Discount Ledger

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
  2. Select the Party’s A/c Name.
  3. Select the Sales Ledger.
  4. Select the stock item and enter the Quantity and Rate. The Amount appears automatically.
  5. Select the discount ledger and enter the discount percentage. You can enter the amount even without entering the percentage.
  6. Select the VAT ledger.
    The sales invoice appears as shown below:Sales Invoice with Discount Ledger to Calculate VAT After Discount
  7. To Display the Tax Analysis screen, press Ctrl+O (Related Reports) > select Voucher under Details of > type or select VAT Tax Analysis.

Note: If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
To Display the Tax Analysis screen, press Ctrl+I (More Details) > select Voucher under Details of > type or select VAT Tax Analysis.

The Tax Analysis screen displays the discount value considered for VAT calculation, as shown below:

VAT - Tax Analysis in TallyPrime

8.Press Esc to return to sales invoice.

9.Accept the screen. As always, you can press Ctrl+A to save.

Viewing Appropriated Discount Value in the Triangulation Report

  1. Gateway of Tally > Display More Reports > Statutory Reports > VAT Reports > and press Enter.
    Alternatively, press Alt+G (Go To) > type or select VAT Reports > and press Enter.
  2. Select the VAT or CST form to view the triangulation report.
  3. Select Sales Taxable @ 14.5%, as shown below:Form VAT 100 in TallyPrime
  4. Press Enter to view the Voucher Register. The discount amount appropriated to assessable value for VAT calculation appears as shown below:Voucher Register in TallyPrime

For a few states, the discount amount has to be captured in specific fields of the return forms. Hence, the option Type of Ledger? which can be set to Discount, is provided for the following states:

  • Bihar
  • Chandigarh
  • Chhattisgarh
  • Goa
  • Karnataka
  • Kerala
  • Maharashtra
  • Odisha
  • Punjab
  • West Bengal

For the states of Haryana and Punjab, you can select Freight as the Type of Ledger? to capture the value of freight charges in the relevant fields of forms and annexures.

Post a Comment

Is this information useful?
YesNo
Helpful?