This template is for Construction Industry Scheme Contractors in United Kingdom to keep proper records regarding payments to subcontractors. The template includes Payment and deduction statements for subcontractors.
The template consist of 6 tabs:
- Business information,
- Subcontractors table,
- Payments table,
- Automated Payment and deduction statement,
- Automated report – Summary statement of payments to each subcontractor (pivot table),
- Automated report – Monthly return (pivot table).
To achieve as much automation as possible, we used various formulas, data validation and pivot tables in the template.
The template was lastly updated in April 2022.
The template is available in Excel format as follows:
MS Excel 2007 Onward – size: 65 KB.