HomeTallyPrimeTaxation ComplianceIndia VATSalesVAT Based on Quantity for Petrol & Diesel

 

Explore Categories

 

 PDF

Sales with VAT Based on Quantity for Petrol and Diesel (VAT)

In TallyPrime, you can record sales with VAT based on quantity of petrol and diesel by charging VAT on the basis of quantity.

Ledger for VAT on quantity

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name for ledger.
  3. Group it under Duties & Taxes, with Type of duty/tax as Others.
    Ledger for VAT on Quantity in TallyPrime
  4. Press Enter to save. You can create separate ledgers of VAT on quantity for petrol and diesel, and use them while creating the voucher class.

Ledger for Surcharge

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name for ledger.
  3. Group it under Duties & Taxes, with Type of duty/tax as Others.
  4. Enter the Percentage of calculation.
  5. Select the Method of calculation as Surcharge on Tax.
    Surcharge on Tax in TallyPrime
  6. Press Enter to save.

Voucher Class for Sales with VAT Based on Quantity for Petrol and Diesel

  1. Gateway of Tally > Alter > type or select Voucher Type > and press Enter.
    Alternatively, press Alt+G (Go To) > Alter Master > Voucher Type > and press Enter.
  2. Select Sales from List of Voucher Types.
  3. Enter a voucher Class for VAT on quantity for petrol.
    Voucher Class for Sales with VAT Based on Quantity for Petrol and Diesel in TallyPrime
  4. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
  5. Select VAT on quantity and surcharge ledgers
    Class - VAT on Quantity - Diesel
  6. Press Enter to return to Voucher Type Alteration screen.
  7. Create another voucher Class for VAT on quantity or value (for example, diesel at Rs. 8.15 per unit or 13.24%).
    Voucher Class for Sales with VAT Based on Quantity in TallyPrime
  8. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
  9. Select the ledgers created for VAT on quantity (Rs. 8.15 per unit), VAT rate (as defined in stock item) and surcharge.
    Class: VAT on Quantity or Value in TallyPrime
  10. Press Enter to return to Voucher Type Alteration screen.
  11. Create another voucher Class only for VAT on quantity for diesel.
    Voucher Class Only for VAT on Quantity for Diesel in TallyPrime
  12. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
  13. Select the ledgers created for VAT on quantity and surcharge.
    Class - VAT on Quantity - Diesel
  14. Press Enter to return to Voucher Type Alteration screen.
  15. Save the sales voucher type.
    You can create voucher class in delivery note voucher type by following the procedure shown above.Delivery Note Voucher Type in TallyPrime

Sales Invoice with Voucher Class

You can record sales using voucher class created for:

  • VAT on quantity, to calculate VAT based only on quantity.
  • VAT on quantity or value, to view the auto-calculated values for VAT on quantity and VAT rate, and remove the value which is lower of the two.

Note: These transactions will appear under Incomplete/mismatch in information (to be resolved). You can retain these as exceptions as there is no provision to capture it in the department’s VAT return format.

VAT on Quantity

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
  2. Select the voucher class VAT on Quantity – Petrol.
  3. Select the Party A/c Name.
  4. Select the stock item predefined with VAT rate.
  5. Enter the Quantity and Rate per unit.
    The ledgers created for VAT on Quantity and surcharge, appear as defined in the voucher class.
    Sales Invoice with Voucher Class in TallyPrime
  6. Press Enter to save.
    The printed invoice displays details of stock item and tax ledgers as shown:
    Invoice Printed Displays Details of Stock Item and Tax Ledgers Using TallyPrime

VAT on Quantity or Value

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).lick F8: Sales >
  2. Select the voucher class VAT on Quantity or Value.
  3. Select the Party A/c Name.
  4. Select the stock item predefined with VAT rate.
  5. Enter the Quantity and Rate per unit.
    The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
    Sales Invoice for VAT on Quantity or Value in TallyPrime
    Surcharge gets calculated as Rs. 1,257.90 (5% on 25,157.99) on VAT ledger (with Type of duty/tax set to VAT).
  6. Press Enter to save.
  7. Press Page Up and remove the ledger used for VAT on quantity or VAT on value, based on whichever is lower.
    Sales Invoice with VAT on Quantity in TallyPrimeIf VAT on quantity ledger is retained, the surcharge gets re-calculated to 1,426.25 (5% on Rs. 28,525).
  8. Press Enter to save.
    The printed invoice displays details of stock item and tax ledgers as shown:
    Printed Invoice Displaying Details of Stock Item and Tax Ledgers in TallyPrime

Track Delivery Notes of different consignments to one sales invoice

You can record delivery notes with tracking numbers, using voucher class created for VAT on quantity and VAT on quantity or value. Track them to a sales invoice.

  1.  Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Delivery Note.
    Alternatively, press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Delivery Note.
  2. Select the voucher class VAT on Quantity.
  3. Select the Party A/c Name.
  4. Select the stock item predefined with VAT rate.
  5. Enter the Tracking No., Quantity and Rate per unit.
    Item Allocations for : Petrol in TallyPrime
  6. The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
    Delivery Note for Petrol with VAT Recorded in TallyPrime
  7. Press Enter to save.

The printed invoice displays details of stock item and tax ledgers as shown:

Printed Invoice Displaying Details of Stock Item and Tax Ledgers

  1.  Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Delivery Note.
    Alternatively, press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Delivery Note.
  2. select the voucher class VAT on Quantity or Value.
  3. Select the Party A/c Name.
  4. Select the stock item predefined with VAT rate.
  5. Enter the Tracking No., Quantity and Rate per unit.
    Item Allocations for : Diesel in TallyPrime
  6. The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
    Delivery Note for Diesel in TallyPrimeSurcharge gets calculated as Rs. 1,545.42 (5% on 30,908.38) on VAT ledger (with Type of duty/tax set to VAT).
  7. Press Enter to save.
  8. Press Page Up and remove the ledger used for VAT on quantity or VAT on value, based on whichever is lower.
    Delivery Note Recorded for Diesel with VAT in TallyPrimeIf VAT on quantity ledger is retained, the surcharge gets re-calculated to 1,752.25 (5% on Rs. 35,045).
  9. Press Enter to save.
    The printed invoice displays details of stock item and tax ledgers as shown:
    Printed Invoice Displaying Delivery of Diesel with Tax Ledgers

 

Record a sales invoice by tracking the delivery notes

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
  2. Select Party A/c Name.
  3. Select the Delivery Note Numbers of both the delivery notes in Party Details screen.
    Delivery Note Numbers in Dispatch Details Screen in TallyPrime
    The stock items appear based on the tracking numbers, with quantity, rate, VAT on quantity and surcharge, as shown:
    Sales of Petrol and Diesel with VAT in TallyPrime
  4. Press Enter to save.
    The printed invoice displays details of stock items and tax ledgers as shown:
    Printed Invoice Displaying Petrol and Diesel with VAT

Note: These transactions will appear under Incomplete/mismatch in information (to be resolved). You can retain these as exceptions as there is no provision to capture it in the department’s VAT return format.

Record sales by calculating and entering the amount of VAT on quantity

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
  2. Select the stock items, enter the quantity and rate per unit.
  3. Select the VAT ledger. The amount appears as per the VAT rate set in the stock item. Calculate the VAT amount based on quantity, and enter it for the VAT ledger.
    Petrol
    • VAT = 4,250*14.25 = 60,562.50
    • Surcharge = 60,562.50*5% = 3,028.13
      Diesel
    • VAT = 3,150*8.15 = 25,672.50
    • Surcharge = 25,672.50*5% = 1,283.63
      Surcharge = 3,028.13 + 1,283.63 = 4,311.76
      Sales for Petrol and Diesel with Surcharge on Tax in TallyPrime
  4. Press Enter to save.
  5. Go to VAT return > select Incomplete/Mismatch in information (to be resolved) > Mismatch due to tax amount modified in voucher.
  6. Press Spacebar to select the voucher.
    Mismatch due to tax amount modified in voucher in TallyPrime
  7. Press Alt+J (Accept as is).
  8. Press Enter to accept.
    The transaction will appear in the VAT return.
    Transaction Appearing in VAT Return in TallyPrime
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?
/* */