Follow Us:

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.

Download Macro for West Bengal WCT Certificates in Form 18

Click here to read Other Articles of CA Srikant Agarwal

Author Bio

I am a working professional having more than 13 years of experience in field of Income Tax, TDS, VAT, Sales tax, GST and accounting. Can be contacted at srikant.agarwal@gmail.com View Full Profile

My Published Posts

Board Meeting vs Circular Resolution under Companies Act, 2013 DA Calculation for PSU Employees – Q2 2026–27 (July 2026 to Sep 2026) RBI Forex Swap Facility for PSU Borrowings: ECB Cost and FX Impact Mandatory Dematerialisation of Securities for Public & Private Companies: Legal Framework Dearness Allowance (DA) Calculation for PSU Employees – Q1 2026–27 (April 2026 to June 2026) View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Post by Date
July 2026
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031