In Tally.ERP 9, you can record sales of petrol and diesel by charging VAT on quantity.
On this page
● Ledgers for
● Voucher Class for Sales and Delivery Note
● Sales Invoice with Voucher Class for one stock item
● Track Delivery Notes of different consignments to one sales invoice
● Record sales by calculating and entering the amount of VAT on quantity
Gateway of Tally > Accounts Info. > Ledgers > Create .
1. Enter the Name for ledger.
2. Group it under Duties & Taxes , with Type of duty/tax as Others .
3. 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.
Gateway of Tally > Accounts Info. > Ledgers > Create .
1. Enter the Name for ledger.
2. Group it under Duties & Taxes , with Type of duty/tax as Others .
3. Enter the Percentage of calculation .
4. Select the Method of calculation as Surcharge on Tax .
5. Press Enter to save.
Gateway of Tally > Accounts Info. > Voucher Types > Alter > Sales .
1. Enter a voucher Class for VAT on quantity for petrol .
2. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
3. Select VAT on quantity and surcharge ledgers.
4. Press Enter to return to Voucher Type Alteration screen.
5. Create another voucher Class for VAT on quantity or value (for example, diesel at Rs. 8.15 per unit or 13.24%).
6. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
7. Select the ledgers created for VAT on quantity (Rs. 8.15 per unit), VAT rate (as defined in stock item) and surcharge.
8. Press Enter to return to Voucher Type Alteration screen.
9. Create another voucher Class only for VAT on quantity for diesel.
10. Select the sales ledger enabled for VAT. Ensure you have not provided VAT details in the ledger.
11. Select the ledgers created for VAT on quantity and surcharge.
12. Press Enter to return to Voucher Type Alteration screen.
13. Save the sales voucher type.
You can create voucher class in delivery note voucher type by following the procedure shown above.
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.
Gateway of Tally > Accounting Vouchers > F8: Sales > select the voucher class VAT on Quantity - Petrol .
1. Select the Party A/c Name .
2. Select the stock item predefined with VAT rate.
3. Enter the Quantity and Rate per unit.
The ledgers created for VAT on Quantity and surcharge, appear as defined in the voucher class.
4. Press Enter to save.
The printed invoice displays details of stock item and tax ledgers as shown:
Click F8: Sales > select the voucher class VAT on Quantity or Value .
1. Select the Party A/c Name .
2. Select the stock item predefined with VAT rate.
3. 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 ).
4. Press Enter to save.
5. 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).
6. Press Enter to save.
The printed invoice displays details of stock item and tax ledgers as shown:
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 .
Gateway of Tally > Inventory Vouchers > F8 : Delivery Note > select the voucher class VAT on Quantity .
1. Select the Party A/c Name .
2. Select the stock item predefined with VAT rate.
3. Enter the Tracking No. , Quantity and Rate per unit.
4. The ledgers created for VAT on Quantity, VAT and surcharge, appear as defined in the voucher class.
5. Press Enter to save.
The printed invoice displays details of stock item and tax ledgers as shown:
Click F8 : Delivery Note > select the voucher class VAT on Quantity or Value .
1. Select the Party A/c Name .
2. Select the stock item predefined with VAT rate.
3. Enter the Tracking No. , Quantity and Rate per unit.
4. 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 ).
5. Press Enter to save.
6. 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).
7. 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. Click 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.
1. Click 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
o VAT = 4,250*14.25 = 60,562.50
o Surcharge = 60,562.50*5% = 3,028.13
Diesel
o VAT = 3,150*8.15 = 25,672.50
o 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. Click A : Accept as is .
8. Press Enter to accept.
The transaction will appear in the VAT return.
