Updated on 29 April 2022

 

Guide how to use this template

In the United Kingdom and Northern Ireland are certain rules for how payments to subcontractors for construction work must be handled by contractors in the construction industry. It is called Construction Industry Scheme and you will find more information here.

This template will help contractors in United Kingdom to keep proper records of payments to subcontractors.

If you input all information about a contractor, a subcontractor and a payment, the Payment and deduction statement will pop up automatically for each payment when you choose the payment number. You will find also automated subcontractor’s statement and monthly return reports in the template.

You can buy and download the template here. The price for the template is €6.

1. Tab – Business information

Input name, address and employer PAYE reference of the contractor. Those information are used for other tabs in the template.

1. Tab – Business information
1. Tab – Business information

2. Tab – Subcontractors

Input name, address, UTR, CIS verification number, date when lastly verified and CIS deduction rate for your subcontractors. This information is used in the spreadsheet but mainly for Payment and deduction statement printout.

The table is set up for up to 100 subcontractors, but you are free to add more rows, if you need to.

2. Tab - Subcontractors
2. Tab – Subcontractors

3. Tab – Payments

The Payments table is the main table for producing deduction statements and running pivot table reports. Each payment is in the one row. Input all details relevant to the payment for the subcontractor. A lot of fields are calculating totals or have data validation list to pick up correct information.

The table is for up to 100 payments. If you need more, you are free to add rows yourself in the table or you can contact us by email and we will customise it for you.

3. Tab - Payments
3. Tab – Payments

4. Tab – Payment and deduction statement

Information in this tab is automated. You need to choose payment number you want to print. All other fields will pop up automatically based on the payment number.

Payment number is an unique number for each payment.

General business information are automated from Business information in 1. tab and Subcontractor information are automated from Subcontractor table in 2. tab.

The CIS contractor must complete and give a statement of CIS deduction to a subcontractor by the 19th each month (for previous month). The statement is made according HM Revenue recommendations.

4. Tab - Payment and deduction statement
4. Tab – Payment and deduction statement

5. Tab – Summary statement

If you want to check all payments for certain subcontractor, you can use this report.

You need to choose your subcontractor’s name and the rest will be populated automatically.

5. Tab - Summary statement
5. Tab – Summary statement

How to refresh pivot table reports

This statement is based on Excel Pivot tables, which means, that if you input new records into payments table, you need to refresh Statement pivot table to see new records there. If you want to refresh statement pivot table then press left mouse button in the pivot table and press Alt + F5. If for some reason it doesn’t work for you then in the upper excel menu, you can see PivotTable Tools, press left mouse button on this option -> in the Options, there is Data section, press left mouse button on the Refresh.

How to refresh pivot tables in Excel
How to refresh pivot tables in Excel

6. Tab – Monthly return

If you are preparing monthly return to file with HMRC, this report will help you to summarise subcontractors payments with relevant information.

Choose CIS period and the rest will be populated automatically.

6. Tab - Monthly return
6. Tab – Monthly return

How to refresh pivot table reports

This statement is based on Excel Pivot tables, which means, that if you input new records into payments table, you need to refresh Monthly Return pivot table to see new records there. If you want to refresh Monthly Return pivot table then press left mouse button in the pivot table and press Alt + F5. If for some reason it doesn’t work for you then in the upper excel menu, you can see PivotTable Tools, press left mouse button on this option -> in the Options, there is Data section, press left mouse button on the Refresh.

You can buy and download this template here.