To view the VAT Analysis Report
Go to Gateway of Tally > Display > VAT Analysis
The following screen displays.
Box 1
Gives VAT due calculated from the sales vouchers.
Double click on the row or press Enter and the following screen displays.
The sales entries are displayed in columns showing break-up of net value of sales 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 Sales information for items on which VAT is charged only in the UK. This is directly relevant for Box 2 purposes. The amount shaded green is brought to the VAT box.
Box 2
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 (not applied).
Double click on the row or press Enter and the following screen displays.
Box 3
This prints the total of the sum of Box 1 and Box 2.
Box 4
It is the VAT dues calculated from Purchase Voucher entries. It includes the Box 2 figure.
Double click on the row or press Enter to view input details.
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.
Box 5
Net VAT due to be paid or refunded which will be the difference between the Box 3 & Box 4.
Box 6
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.
Box 7
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.
Box 8
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.
Box 9
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.
