CIS Monthly Returns - UK Only

Overview

If you do business with sub-contractors in the UK, you can generate the CISClosedUK only: Construction Industry Scheme - contractors register and apply tax deduction rates to customer and / or sub-contractor invoices. Monthly Returns report for information you need to file your monthly returns with HM Revenue and Customs (HMRC). You can also print and save a CIS Payment and Deduction Statement to provide each sub-contractor with a summary of the money you deducted and paid to HMRC.

The report can include information on total payments, amounts liable, amounts deducted, and amounts payable (including and excluding VAT). You may wish to regularly generate the report to reconcile CIS amounts with those in your accounting package.

This article only provides instructions for using the CIS features in simPRO, and should not be interpreted as legal or financial advice. Learn more about CIS in How to Manage CIS with simPRO - UK Only, or read about your CIS obligations on the UK Government's CIS website.

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

A screenshot of the CIS Monthly Returns report filters.

To view the report:

  1. Go to Reports A screenshot of a schedule icon with a grey calendar icon and an arrow. > 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 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:

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.

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 A grey arrow pointing downwards towards a CPM pictogram. 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.