Guide how to use this template

This template will help you to keep proper records of payments to subcontractors.

This template is for Contractors dealing with subcontractors.

The main feature of the template is that you record (input all information) into Payments table and the printout of the Payment and deduction statement is automated in the next tab, where you choose the payment number and you will automatically get all the details from Payments table.

1. Tab – Business information

Input all information relevant to you. Those information are used for other tabs in the template.

 

2. Tab – Subcontractors

Input information for your subcontractors. Those are used within spreadsheet but mainly for Payment and deduction statement printout.

The table is for up to 100 subcontractors.

3. Tab – Payments

The Payments table is the main table for producing deduction statements and running pivot table reports. Each payment is in an one row. Input all details relevant to the payment for your 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 can adjust it yourself or you can contact me by email and I will customise it for you.

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.

5. Tab – Summary statement

If you want to check all payments for certain subcontractor, you can use this tab. You need to choose (pick up) your subcontractor name and the rest will be populated automatically.

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. If you want to refresh statement pivot table then use mouse left-click on the client name field 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, mouse left-click on this option -> in the Options, there is Data section, mouse left-click on the Refresh.

 

6. Tab – Monthly return

If you are preparing montly return to Revenue, this tab will help you to summarize subcontractors payments with relevant information.

Choose (pick up) CIS period and the rest will be populated automatically.

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. If you want to refresh statement pivot table then use mouse left-click on the client name field 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, mouse left-click on this option -> in the Options, there is Data section, mouse left-click on the Refresh.

You can buy and download this template here.