CA Srikant Agarwal
We know TDS need to be deducted at the time of making payment or accrual of bill whichever is earlier in respect of certain transactions.
Two types of TDS need to be deducted.
1) TDS u/s 194C, 194J, 194I etc under the Income Tax Act 1961 and
2) TDS (WCT i.e works Contract Tax) under the respective state VAT Act.
The TDS certificate under Income Tax Act is being issued in Form 16A which is downloaded from NSDL site. W.e.f 01.04.2012 such Form 16A from NSDL site is compulsory for all types of deductor.
However WCT certificate need to be issued as per the requirement of respective state VAT Act.
In the state of west Bengal WCT certificate need to be issued on monthly basis as per rule 47 of West Bengal VAT Rules 2005.
We have prepared a Marco in excel which makes the task of preparing WCT certificate in form 18 much easier. Generally it takes around 5-8 minutes to prepare one certificate and need a lot of concentration to avoid any error.
Now by using this macro the time taken for preparing each certificates can be reduced to fraction of seconds (approx 10 seconds).
The macro file is attached along with this mail and I believe it will be of immense use for WCT deductors of West Bengal State.