Add to Favourites

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.
   
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.
   
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.
   
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
   
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%).
   
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.
   
10. Press Enter to return to Voucher Type Alteration screen.
11. Create another voucher Class only for VAT on quantity for diesel.
    
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.
    
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.

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.
   
6. Press Enter to save.
   The printed invoice displays details of stock item and tax ledgers as shown:
   

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.
   
   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.
   If 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:
   

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.
   
6. The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
   
7. Press Enter to save.

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

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.
   
6. The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
   Surcharge 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.
   If 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:
   

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.
   
   The stock items appear based on the tracking numbers, with quantity, rate, VAT on quantity and surcharge, as shown:
   
4. Press Enter to save.
   The printed invoice displays details of stock items and tax ledgers as shown:
   

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
     
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.
   
7. Press Alt+J (Accept as is).
8. Press Enter to accept.
   The transaction will appear in the VAT return.