Tally.ERP 9 produces the VAT Analysis Report in the British VAT Return Form 100 format with Boxes 1 to 9. It is automatically produced for a quarter ending the last date of voucher entry and is picked from the sales and purchase voucher entries.
To view the VAT Analysis Report
Go to Gateway of Tally > Display > Statutory Reports
In the Statutory Reports menu, select VAT Analysis to view the Value Added Tax Return screen. Change the period as per requirement by using F2: Period button. The Value Added Tax Return screen displays as shown:
The explanation on the VAT Analysis is given below:
Gives VAT due calculated from the sales vouchers.
Double click on the row or press Enter and the screen displays as shown:
The sales entries are displayed in columns with a break-up of net sale value on which VAT is applicable and also details of non-taxable sale value. The VAT charged on each invoice is shown in a column. VAT calculated but not applied is shown for EC Sales information for items on which VAT is charged only in UK. This is directly relevant to Box 2. The amount displayed in VAT Charged column is captured in VAT Analysis.
The Box is not relevant if there are no inputs from EEC.
The EC VAT calculated but not applied is brought in. It is also included in Box 4, which is the total VAT Charged and EC VAT Calculated (but not applied).
Double click on the row or press Enter and the following screen displays:
This prints the total of the sum of Box 1 and Box 2.
It is the VAT dues calculated from Purchase Voucher entries. It includes the value captured in Box 2.
Double click on the row or press Enter and the following screen displays:
The purchase entries are displayed in columns showing break-up of net value of purchases on which VAT is applicable or not. The VAT charged on each invoice is shown in a column. VAT calculated but not applied is shown for EC purchases information for items on which VAT is charged in the UK. The amount shaded green is brought to the VAT box.
Net VAT due to be paid or refunded which will be the difference between the Box 3 & Box 4.
Total Net Value of sales and other outputs as obtained from the sales voucher entries.
Double click on the row or press Enter to view Output Details. The following screen displays:
Total Net Value of purchases and other inputs as obtained from the purchase voucher entries.
Double click on the row or press Enter to view Output Details. The following screen displays.
This shows the sale of goods to EEC customers. The figure depends upon correct classification of EEC customers and activation of percentage of calculation in sales ledger accounts. It is the total of the amounts in the Nett Value (VAT Applicable) column in the Output Details for EC Member Countries.
Note: Those items that although have a VAT Rate specified, but whose sale account allocation do not have a percentage of calculation will not be included. Hence, it is important to allocate EC Sales to a separate Sales Account for which percentage of Calculation has not been set to 0.
On the other hand, services supplied to EC Customers are not to be considered and hence should be allocated to a sales account for which the percentage of calculation is 0.
The following screen displays Output Details for EC Member Countries.
This reflects the purchase of goods from EC Suppliers.
Note: The same note of caution as for Box 8 applies to Box 9 as well.
'VAT Analysis (United Kingdom)' has been shared with
