CIS / RCT Monthly Returns - UK, IE Only

In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:

Reports

To view the report:

1. Go to Reports > View Reports > Contractors > CIS Monthly Returns.
2. Use the date picker to select a Contractor Invoice Date Range.
3. Select whether you want to view the report Type as a Summary or a Breakdown.
4. Select options from the other filters as required.
5. Click Search.

Use report filters

Use the report filters to make your report as specific as you require. The filters include:

Date Based On	Select whether you want to view results by the Date Paid or Date Created. The Date Paid option is only useful if you record contractor invoice payments in simPRO.
Contractor Invoice Date Range	Use the date picker in this filter to select the invoice date range. This filter is mandatory.
Paid / Unpaid	Select whether you want to view Paid Invoices or Unpaid Invoices. This filter is only useful if you record contractor invoice payments in simPRO. This is important to record, as CIS is only due after invoices have been paid and not when they are raised.
Type	Select whether you want to view the report as a Summary or a Breakdown. If you view the report as a Breakdown, invoices for the selected date range are grouped by contractor. For each invoice you see an Invoice Date, Paid Date (if applicable), Total Payment (Ex VAT), Materials Paid, Amount Liable, Amount Deducted, Amount Payable (Inc VAT) and Amount Payable (Ex VAT). The Total of these figures appears at the bottom of each contractor's table. If you view the report as a Summary, a summary of information for each contractor is displayed, including UTR Number, Verification Number, Total Payments (Ex VAT), Materials Paid, Amount Liable, Amount Deducted and Amount Payable (Ex VAT).
Breakdown Results by	Select Contractor to view results grouped by contractors, or select Contractor Contact to view results grouped by contractor contacts.
Contractor / Contractor Contact	Select the contractor(s) or contractor contact(s) whose information you want included in the report.

The following columns are displayed in the report:

Summary

The following columns are displayed when Summary is selected:

Contractor Name	The name of the contractor.
UTR Number	The contractor's UTR number entered in their card file.
Verification Number	The contractor's Verification Number entered in their card file.
Total Payments (Ex VAT)	The total amount paid to the contractor across all invoices within the date range, excluding tax.
Materials Paid	The amount of materials on the contractor invoice.
Amount Liable	The amount of labour on the contractor invoices, liable for CIS deductions.
Amount Deducted	The amount deducted from invoices for CIS.
Amount Payable (Ex VAT)	The Total Payments (Ex VAT) minus the Amount Deducted.

Breakdown

The following columns are displayed when Breakdown is selected:

Invoice No.	The invoice number generated in simPRO. Click to open the invoice.
Contractor Invoice No.	The actual contractor invoice number as mentioned in the Details tab in the contractor invoice.
Invoice Date	The invoice date selected on the contractor invoice.
Paid Date	The Date Paid selected on the contractor invoice.
Total Payment (Ex VAT)	The total value of the invoice, excluding tax.
Materials Paid	The amount of materials on the contractor invoice.
Amount Liable	The amount of labour on the contractor invoice, liable for CIS deductions.
Amount Deducted	The amount deducted for CIS.
Amount Payable (Inc VAT)	The sum of Materials Paid, Amount Liable, and VAT, minus Amount Deducted.
Amount Payable (Ex VAT)	The Total Payment (Ex VAT) minus Amount Deducted.

To print a CIS Payment and Deduction Statement:

1. Generate the CIS Monthly Returns report as required.
2. Select the check boxes of the information you wish to print, or click Select All at the bottom of the page.
3. At the bottom of the page, click Print.
4. Save or print as required.

You can download the information in the report as a spreadsheet in CSV format, viewable in Microsoft Excel and other spreadsheet software.

To download the report:

1. Generate the report as required.
2. Click the icon in the top right, then click CSV.
3. View, print or save the CSV, as required.

To download a CSV of specific report results, select the result check boxes when viewing the report as a Breakdown, then click Download CSV at the bottom of the screen.