03 August 2025
I can help you create a simple **Works Contract Tax (WCT) calculation sheet** for Maharashtra VAT (MVAT) that you can use in Excel. Here's a basic outline of what it should include:
---
### MVAT Works Contract Tax Calculation Sheet (Sample Structure)
| **Particulars** | **Amount (₹)** | **Remarks** | | ----------------------------------------------- | -------------- | ------------------------------- | | 1. Total Contract Value | | Gross value including materials | | 2. Less: VAT on Materials (if shown separately) | | If VAT is charged separately | | 3. Net Contract Value | | 1 - 2 | | 4. Labour & Service portion (e.g., 40% or 70%) | | Based on abatement percentage | | 5. Taxable Value for WCT | | Usually after abatement | | 6. WCT Rate (%) | | 2% or 4% as applicable | | 7. WCT Amount Payable | | 5 x 6 / 100 |
---
### Sample Formulae:
* **Net Contract Value = Total Contract Value - VAT on Materials** (if applicable) * **Taxable Value for WCT = Net Contract Value × Labour %** (e.g., 40%) * **WCT Amount = Taxable Value × WCT Rate**
---
### If you want, I can prepare this in Excel format and share the download link. Would you like me to do that?
CAclubindia
