If you maintain the accounts in Tally soft, and properly enter the input & output vat at the time of sale & purchase entry then you go to display then statutory report ------> vat report-------->vat computation then u see the all input & output calculation and payable amount. after that you just export the data in excel format and workings on them.
calculation of vat % vary state to state.
CAclubindia
