Service Tax

Hi

In India, Service tax is charged for various services. However, the service tax credit can be taken in excise utilization only when the payment for the vendor invoice has been done. The service tax that can be utilized is only the amount of service tax paid. We have two Gl Accounts, Service Tax on Hold and Service Tax payable. When the vendor invoice has been raised, system debits the on hold a/c. At month end, the user manually tallies the amount for which service tax has been paid and tranfers the amount to service tax payable amount. This amount is then taken in excise utilization. However, there are huge number of line items and it is not practcial to do the reconciliation. How can we automate the scenario?

regards

Vaibhav