Product overview

CIS is designed specifically as an additional module for Sage 200. Fully integrated with the Sage 200 financial ledgers this is a simple module to learn and to use. With on-line subcontractor verification, CIS submissions and production of payment certificates within the Sage report designer this module provides a valuable piece of additional functionality.

When a subcontractor’s (PL Supplier) invoice is paid then, in the case of a CIS subcontractor the tax is paid to HMRC by the invoice payee. To allow this, the subcontractor would need to be verified with the HMRC to ensure they are known to the HMRC and what tax rate those are on.

HMRC will supply information relating to the subcontractor that needs to be stored against the subcontractor supplier account to allow correct submission of CIS returns.

(For full information see https://www.gov.uk/government/publications/construction-industry-scheme-cis-340)

Firewall Note: Please ensure that an outbound rule is added on your firewall to allow processing via sage200desktop.exe application. If this is not set, an error (‘Illegal characters in path’) may be returned when generating HMRC submissions.


1. Capturing Subcontractor Information

To capture subcontractor information against a PL supplier (new or old) there is a check box and selection on the Subcontractor Details tab for all the subcontractor HMRC information.

Sicon CIS Help and User Guide - Capturing Subcontractor Information

Within the Subcontractor Details tab there is all the information that is required for HMRC submission:

  • Subcontractor Scheme: Select from the drop-down CIS to show the available CIS fields. None is used for standard Suppliers and RCT is for Relevant Contract Tax Suppliers (Ireland).
  • Subcontractor: Select from the drop-down menu to set if the subcontractor is Higher Rate of Deduction, Standard Rate of deduction or No Deduction (when the details are saved and HMRC Submission is set to Online you can click the HMRC Verification and this will update the record with the correct current information).
  • Labour Only: Allows the account to be flagged for labour only transactions – no materials, when this is ticked, the Default Labour % will populate with 100%.
  • Trader type: This is the type of business, whether Sole Trader, Company, Trust or Partnership. Selecting an option will show the required information to be entered.
  • Unique tax ref (UTR): used by HMRC.
  • Verification no: used by HMRC and will be sent at time of verification.
  • NI Number (NINO): National insurance number of the subcontractor. National Insurance number if they’re a sole trader – you can’t verify temporary numbers, which start with ‘TN’ or 2 digits
  • CRN (Company Registration Number): If the company operates as a subcontractor then they will be given a CRN.
  • Initial/First name: See Name Fields below for details.
  • Second Name:See Name Fields below for details.
  • Surname:See Name Fields below for details.
  • Contractor verification date: Date verification was last carried out.
  • Date first verified: The first date this subcontractor was first verified.
  • Display response: This button opens a window to display the response sent from the HMRC Sub-contractor Verification (see below).
  • Last return date: The last CIS return that this contractor was included on. The ‘contractor verification date’ and ‘last return date’ is used to establish if the contractor needs to be verified again. The current rule is that if the contractor has appeared on a CIS return in the current tax year, or previous 2 tax years, then they do not need to be re-verified.
  • Public Liability Insurance No:Allows you to store the public liability insurance certificate details.
  • Expiry Date:The date when the public liability expires – this is for reporting.
  • Name fields: For Sole Trader, Company or Trust this is the legal business name (or the trading name they gave when they registered with CIS). The Sage supplier name will be used as a Trading name for verification to HMRC, however, for verification purposes, a person’s name may be required instead of a trading name and these fields allow that information to be entered.  If the name is completed then this will be used in place of a trading name when verifying the supplier with HMRC.  For Partnerships the Partnership namewill be the Sage supplier name, but this allows the entry of an individual’s name for additional information when verifying sub-contractor partnership details with HMRC.

Display response button


2. CIS Menu

(Construction Industry Scheme)

 

This menu is split into three main sections:

CIS functional options

  • Pending Sub-contractor Verifications
  • Sub-contractor Verifications
  • Submit CIS Return
  • Reconciliation

Initial settings

  • Settings
  • Supplier CIS Details Import
  • CIS Transactions Import Form
  • Enable Module (see Construction Enable Module for entering enable String)

Reports

  • CIS Payments Audit
  • CIS Payments Detailed
  • CIS Payments Detailed (E-mail)
  • CIS Return (Summary)
  • Subcontractor Statement
  • Subcontractor Statement (E-mail)
  • CIS Supplier List
  • CIS Return Summary by Supplier
  • Pending CIS Verification
  • Outstanding CIS Subcontractor Invoices
  • Outstanding CIS Subcontractor Credit Notes
  • Public Liability Insurance


2.1. Pending Sub-contractor Verifications

This screen allows the user to see what subcontractor verifications will need renewing.

Current HMRC rules on the verification process: ‘The rule is that a contractor does not have to verify a subcontractor if they last included that subcontractor on a return in the current or two previous tax years.’ (https://www.gov.uk/government/publications/construction-industry-scheme-cis-340/construction-industry-scheme-a-guide-for-contractors-and-subcontractors-cis-340#how-payments-are-made-to-subcontractors, section 3.2).

This window shows the supplier and their last verification date and last CIS return date.

The buttons shown are:

  • Verification: Sends the selected subcontractors to the HMRC for verification. The processed information will be updated to the subcontractor records.
  • Select/Unselect All: Selects/Unselects all the subcontractors in the list.
  • Print: Prints a list of the information provided.
  • Amend Supplier A/c: Links back to the supplier account to enable changes to be made.
  • Close:Closes the screen

Verification Number: The subcontractor’s verification number provided by the HMRC will be displayed here. These numbers are important and must be recorded on subcontractor’s monthly statements. If the subcontractors cannot be matched with the HMRC records, HM Revenue and Customs will give you a special verification number unique to each “unmatched” subcontractor. You also need to provide the subcontractor’s verification number where you have made deductions at a higher rate. “Unmatched” subcontractors will need these verification reference numbers to get refunds later.

Example 1: A standard verification reference number looks like this: V0000543267.

Example 2: An “unmatched” verification reference number looks like this: V0000543267A or V0000543267BB.


2.2. Sub-contractor Verifications (Re-verify)

This window shows the supplier and their last verification date and last CIS return date.

This screen allows the user to re-verify a selection, or all, of the existing subcontractors.  This file will be sent to the HMRC and the information returned will be updated to the subcontractor(s) record(s).

The buttons shown are:

  • Verification: Sends the selected subcontractors to the HMRC for verification. The processed information will be updated to the subcontractor records.
  • Select/Unselect All: Selects/Unselects all the subcontractors in the list.
  • Amend Supplier A/c: Links back to the supplier account to enable changes to be made.
  • Close:Closes the screen

2.3. Submitting the CIS Return

When it is time for the monthly CIS return to be submitted the Submit CIS Return is used from the CIS Menu. Firstly, the transactions that are required within the CIS return are selected; in the case of the transactions shown all entries are selected. (There is a check box to Exclude all ‘materials only’ transactions which when ticked will not display any transactions that are only for materials).

NOTE: For Subcontractors who do not yet have a UTR. You can file CIS returns online though the direct HMRC portal only without a UTR number. You have to enter subcontractor’s name and surname, save the information and you will be able to make a submission. The website will ask you to double check the subcontractor’s details if you haven’t verified them before. You will receive a message on the screen asking you to double check the information, but if you click “next” you will still be able to proceed to submission. You can add or amend the information about your subcontractor at any time as well as verify them later on.

In order to complete the CIS Submission, you will need to take the Subcontractor flag off the supplier(s) that do not have a UTR and treat them separately as above before processing the return from the CIS module.

CIS Returns will load up unallocated payments. This will stop the submission of the CIS return and until these are resolved as the Submit button is not active.

Sicon CIS Help and User Guide - Submitting the CIS Return

When the Submit button is pressed the CIS Return Summary screen is shown.

If you have a subcontractor that has not been verified this will be displayed as shown below.

This screen displays the information that will be sent on the HMRC CIS return.  There will be one line per subcontractor (PL supplier) with the values totalled.  On this screen are a number of options before submitting the return to HMRC. These are:

  • Print Statement: this should be ticked if you wish to print a statement for this subcontractor – linked with the Print Statements button
  • Inactivity Indicator: this should be ticked if you do not anticipate paying any subcontractors in the next six months
  • Employment status & subcontractor included tick boxes: these are defaulted to ‘ticked’ and should only be un-ticked if you cannot confirm the statement shown.

The functions of the buttons are:

  • Submit – Submit this CIS Return to HMRC

Select/Unselect All – Select/Unselect all the suppliers for ‘Print Statement’ column
Sicon CIS Help and User Guide - CIS Return Summary

  • Print Summary – Print the CIS Summary – this is a paper version of the information on this screen

Sicon CIS Help and User Guide - CIS return (summary)

  • Print Statements – Print the CIS Statements for the suppliers ticked in the ‘Print Statement’ column

Sicon CIS Help and User Guide - Statement of payment

  • Cancel – Cancels the CIS Return submission
  • Enable Edit – values may now be manually adjusted using the ‘Enable Edit’ button. Enter the Adjustment amount and a Reason for change before submitting to HMRC.

Sicon CIS Help and User Guide - Return Summary

When the Submit button is pressed the user will be warned that no changes can be made once the return has been submitted. If the user then presses ‘OK’ to continue the automated CIS submission will start (if the ‘HMRC Submission Status’ is set to ‘Online’ in the settings screen – see next section).

If the settings are for an ‘offline’ submission, then the process will treat the return information as successfully submitted and return to the CIS Return screen, but the return will NOT have been processed by HMRC and may result in a fine.


2.4. Automated CIS Submission to HMRC

Once the user presses OK to the continue submitting window then the full automation begins and the following screen is displayed showing the current status:

Once the polling has finished submitting the CIS return to HMRC, either successfully or unsuccessfully, the screen will be populated with the status:

In this case, after several polling’s to HMRC (top window) a response was received from HMRC (bottom window). At this point there are two outcomes:

  • Pass: As shown above.  The Summary report now has this message appended to the summary so that it can be printed out along with the summary information for future reference.  Pressing continue will then poll HMRC once again to clean up the files sent to it.  Once that is done, there will be a final set of submissions in the top window and the Continue button will change to Exit, denoting that it has completed.
  • Fail: This will show similar information to that above, however the bottom window will display the error and the top window will also display that an error has occurred.  This could either be from a problem with the submission or a timeout whereby the submission was submitted 10 times without success.  If the submission fails it is possible to go back through the CIS return steps again to reproduce and resubmit the CIS return.

(To see the XML for this area see Appendix C – XML layouts)


2.5. Reconciliation

This allows generation of CIS details for existing supplier invoices and credit notes with no CIS information held against them. This screen generates ledger CIS credit notes (or invoices) for transactions which should have had a CIS amount applied. Note: The Supplier account must be flagged as a subcontractor to show invoices/credits in the reconciliation screen.

Sicon CIS Help and User Guide - Reconcilliation

Enter From and To dates for the required period (or search for an individual account) and click Search to identify invoices that you want to apply CIS to.

Tick the lines, or Select All as appropriate. Amend any values – the example here shows the Labour figure being changed. As you tab off the field, this updates the CIS Amount.

Click the Generate button, you will then get a confirmation that the CIS audit records have been created.

Sicon CIS Help and User Guide - CIS Reconcilliation

NB: if the invoices are set to require Authorisation, when this has been done you will need to manually allocate the Credit Note to the Invoice prior to payment being made.

Opening Balance invoices are also available in the CIS Reconciliation screen as shown below. You must remember that Opening Balance Invoices are VAT Inclusive and should be dealt with slightly differently.

The Gross and Net amounts for Opening Balance Invoices are the same as they are inclusive of VAT. In order to ensure the CIS calculates correctly you will need to update the Labour and Materials columns.

In the example below, the first line was showing a CIS Amount of £10,104.00 until the Labour value was amended. This in turn updated the Other column which is the amount of VAT on the invoice, if there is a Materials amount for this invoice you would need to enter the value in this column. The CIS is Amount is re-calculated if Materials are entered.

Sicon CIS Help and User Guide - CIS reconcilliation screen

When all values have been updated as required, click Select All (or select the individual ones to be updated), then click Generate to create the CIS Credit notes as described previously.


2.6. Settings

The settings screen has the following tabs:

  • General set up the CIS tax rates
  • Labour Nominal Accounts Set up the CIS nominal accounts
  • Materials Nominal Accounts
  • HMRC Settings HMRC automatic CIS submission information
  • Analysis

The ‘important’ areas here are the GeneralLabour Nominal Accounts, Material Nominal Accounts and HMRC Settings

Sicon CIS Help and User Guide - Subcontractor CIS Settings

Rate applied to all applicable sales ledger account transactions: if this % amount is populated, you will be able to flag sales accounts as being CIS applicable and the deductions will be actioned at the rate set here.

Options

Show public liability warning before expiry: Enter here the number of days to be warned prior to the public liability certificate expiring. This is only a warning and will not prevent the invoice from being entered if the user selects YES to continue with the transaction.

Override credit notes to use tax code: This needs to be set to VAT at 0% so a tax code to show e.g. CIS Outside Scope will need to be available (setup if required) as CIS deductions are not VATable amounts and do not need to be shown on the VAT return. Ensure this code is flagged to not show on VAT return.

Sicon CIS Help and User Guide - VAT Rate Details

Calculating deductions based on the configured nominal accounts will apply CIS deductions based on supplier labour/materials default ‘split’ or manually entered percentages.

Calculate deductions using subcontractor (supplier) account percentages. If this option is enabled the module will no longer identify ‘labour’ values based on configured nominal accounts and will require the user to input the appropriate values as indicated in the screen shot below.

This example shows that a purchase invoice entered for £1000 has been split with £800 for Labour and the remaining £200 for Materials (this % amount was back calculated as the Labour was entered as a value).

Any Retention applicable against the invoice would show here as would any CITB deduction (if CITB is set up against the Supplier Account).

The CIS deduction is based on the Labour only amount and is calculated using the rate set against the supplier account.

The Labour Nominal Accounts are used for the CIS allocation within the Purchase Ledger area.  The percentage rate will be set up against the accounts according to the information from HMRC received during the verification process.

Sicon CIS Help and User Guide - Subcontractor CIS Settings

Material Nominal Accounts are used to identify material costs elements of an invoice that are not applicable for CIS – this area should be used to identify any recruitment costs that are on supplier invoices.

Sicon CIS Help and User Guide - Subcontractor CIS Settings

The Nominal control account allows the user to set a nominal that the CIS credit note Net value gets assigned to.

The HMRC Settings are used for the CIS submission (XML file creation).  The Submission Defaults, including HMRC Credentials, will contain information supplied by HMRC.

Sicon CIS Help and User Guide - HMRC Settings

The Contractor UTR and Accounts Office Reference are issued when the company starts trading and therefore this information, along with the type of company sender, should be known.  This is also true for the Tax Office Number and Tax Office Reference within the HMRC Credentials section. (The Tax office number is the first 3 digits of the accounts office reference number).

The Sender ID and Value within the HMRC Credentials section will be supplied by HMRC when the company registers for Online Services at: https://www.tax.service.gov.uk/gg/sign-in?continue=https%3A%2F%2Fonline.hmrc.gov.uk%2Fhome

The File Location Settings is where the file paths for the sent/received files from HMRC are set.  This will give a traceable backup of files sent and received.

  • CIS Return File Location: Location of the CIS return ‘submission’ file sent to HMRC
  • HMRC Response File Location: Location of HMRC Response to ‘submission’ file – can be used to check if errors are returned
  • Processing Files Location: Location of the polling and deleting files sent to and received from HMRC

NB: All these areas will need to be completed for Online CIS submissions to work.

If PAYE for Employers is not listed under “Your Services” you will need to register for this before you are able to file online.

Not activated for the service

After registering for a service you should receive an activation code. The activation code will be issued within seven days – use it once then throw it away. It will expire if you don’t use it within 28 days of the date on the letter, you will have to request a new one.

You will not be able to file online unless you have registered for PAYE for Employers and activated this service.”

Source: http://www.iris.co.uk/support/other-payroll-and-hr-support-inc-p11d-and-bookkeeping/online-filing-issues/1046-authentication-error

The HMRC Submission Status is used to select whether or not the submission to HMRC will take place.  If no link with the HMRC is set up, then setting this to Offline will allow the submission functionality to work without the physical link to HMRC.

NB: After April 2016 you will be able to submit your CIS return more than once as HMRC will take the latest submission as the correct one whereas previously the period would have been locked. If you do want to resubmit you will get the following confirmation prompt.

Sicon CIS Help and User Guide - CIS Return prompt

If you click Yes to re-process the warning below will be displayed.

Sicon CIS Help and User Guide - CIS Return warning

The Test HMRC Connection button sends a dummy record to the HMRC test gateway to test the connection is working. It will use the same Automated CIS Submission to HMRC screens as detailed later.

Analysis Tab

Sicon CIS Help and User Guide - Analysis tab

Analysis fields are for reporting purposes only.

Contractor Employer Reference Number

The ERN (Employers’ Reference Number) now needs to be collected and recorded by the company that provides your employers’ liability insurance. Also called an ‘Employer PAYE Reference’, the ERN is a unique number given to every business that registers with HM Revenue and Customs as an employer.


2.7. Supplier CIS Details Import

Supplier Details can be imported from a CSV file.

Sicon CIS Help and User Guide - Supplier CIS Details Import

Example Import Files can be generated from clicking the ‘Example Import File’ button.  This will generate an Excel file with an overview of each field and an example CSV file to be populated with the import.

NB: A Supplier must exist with Sage for the CIS details to be updated.

Click the Find button to locate the previously populated spreadsheet.

Click Check to verify the file details, any errors will be highlighted in red with the ‘problem’ area identified.

Sicon CIS Help and User Guide - Validation errors on import

Amend the file as required, re-find and check. When there are no errors you will be able to import the details.


2.8. CIS Transactions Import

CIS Transaction details can be imported from a CSV file – follow the same procedure as importing Supplier Details.

The Template and Sample Import file are generated from different buttons on the CIS Transaction Import.

Sicon CIS Help and User Guide - CIS transactions import


3. Adding P/L Transactions with CIS

When a Purchase Invoice is entered against a CIS flagged subcontractor, depending on the nominal codes used (the CIS nominal code is set up within the Settings section of the CIS menu) will automatically create and allocated a Credit Note against the invoice for the CIS percentage amount against the labour costs of the invoice.

Sicon CIS Help and User Guide - nominal & vat analysis tab

This will leave an invoice amount of £1100 to pay to the subcontractor (£500 + VAT@20% for Materials plus £500 + VAT @20% Labour – CIS £100 value on the credit note).

Above, you can see that the Invoice (Inv124) has been added with an outstanding amount of £1100 (boxed).

The Credit Note has been applied for the CIS amount of £100.  The Credit Note also has the reference number of the invoice with an additional ‘CIS’ at the end (see highlighted value – Inv124CIS) denoting it to be a CIS Credit Note.

Clicking the CIS Tab button (shown outlined) will bring up the CIS information for this invoice:


3.1. Creating an Invoice with CIS and a Retention

When a Purchase Invoice is entered against a CIS flagged subcontractor then, depending on the nominal codes used (the CIS nominal code is set up within the Settings section of the CIS menu) will automatically create and allocated a Credit Note against the invoice for the CIS percentage amount against the labour costs of the invoice. If the account is also flagged for a Retention, this will also create a Credit Note and adjust the amount of the CIS credit note.

When the invoice is saved a Retention Information window will be displayed, these details may be amended here if required.

When this is OK’d you will get a confirmation to say that a credit has been raised for the value of the retention.

When the retention credit message is confirmed the system will the show the CIS credit Note details.

Above, you can see that the Invoice (Invoice 125) has been added with an outstanding amount of £1047.50 (boxed).

The Credit Note has been applied for the CIS amount of £95.  The Credit Note also has the reference number of the invoice with an additional ‘CIS’ at the end (see highlighted value – Invoice 125CIS) denoting it to be a CIS Credit Note and a Retention Credit Note of 2x£30 – Invoice 125RET to identify this as the retention credit against Invoice 125.

Clicking the CIS Tab will bring up the CIS information for this invoice:

Click the Retentions Tab to see the retention details:

Clicking the Job Costing Tab will allow you to see which Job(s) the invoice is coded to.

NB: This tab will only be available when Job Costing is installed.


4. Adding a Payment to an Invoice with CIS

When a payment is made against an invoice that has a CIS Credit Note, then the payment needs to consider the CIS value.  Using the current example; if a payment of £1100 is paid against this invoice then the system will work out the CIS payment required, in this case, £100. This means that ‘partial’ payments can be made and the CIS will be paid for the same percentage as the ‘partial’ payment against the invoice.

Using the same invoice values as above, if we choose to pay £800 of the invoice then the system will work out what percentage £800 is of £1100 and apply that same percentage to the CIS amount of £100.

Here is the payment of £800 being applied to the invoice which has both Labour and Materials:

As this invoice is being Part Paid, you have the ability to say what you are allocating the payment to:

The default is for the payment to be split equally between Labour and Materials if the invoice is for both (if an Other amount had been entered on the invoice the split would be across all 3 elements).

The ratio of the payment to the invoice is £800 / £1100 = 0.72727272 therefore the Net is shown as 727.27.

The example below is showing that the Materials are being paid in full, which has re-calculated the Labour amount to be paid. As this is less than the amount on the invoice, the CIS value has also been re-calculated as the amount to be paid to HMRC is reduced.

When the transaction enquiry is shown for this payment we see that the payment of £800 is shown and is added to the allocated amount bringing that to £955 (boxed in green), leaving £245 outstanding (highlighted in ORANGE).

However, the CIS amount to be paid for this payment can be seen within the Submit CIS Return screen from the CIS menu:

This shows that for that payment the CIS value to be paid is £50, worked out from the percentage amount of the £800 against the invoice amount of £1100. (These fields are explained in more detail in the CIS Menu section).

Subcontractor Remittance advice layouts can be linked to the remittance layout – this is done from the Cog icon at the top right of the Sage screen then select Choose Layouts.

From the Layout drop down list select the Remittance Only layout then click the … box next to the Filename field and brows to the Construction Subcontractor Remittance.layout file. Click OK to save this preference.


5. Amending Second Reference for CIS Related Invoices

The Amend Details option within Purchase Ledger, Adjust Transactions, will not show the CIS affected invoices as these have the CIS value allocated to them through the allocation of the credit note explained above.  Therefore, as there is an allocation against the invoice, Sage will not allow any changes to take place.

There is now a check box called CIS entries that when checked will display the CIS Invoices that are allowed to be changed (not fully allocated).  This will only allow changes to the Second Reference details.

NB: the CIS entries check box will only be enabled if the supplier selected is a CIS sub-contractor.

Sicon CIS Help and User Guide - Amending Second Reference for CIS Related Invoices


6. Appendix A – XML Naming Conventions

There are a number of XML files that are sent/received during automated CIS submission process.  These, and their naming conventions, are as follows:

  • Sequence (see Appendix A) Filename convention
  • Submission Request CISreturn_Submission_yyyymmdd_hhmmss
  • Submission Acknowledgement CISreturn_Acknowledgement_yyyymmdd_hhmmss
  • Submission Poll CISreturn_Poll_yyyymmdd_hhmmss
  • Submission Response CISreturn_submit_Response_yyyymmdd_hhmmss
  • Delete Request CISreturn_Delete_yyyymmdd_hhmmss
  • Delete Response CISreturn_delete_Response_yyyymmdd_hhmmss

Key:

  • yyyymmdd – year month day (20120410) when file produced
  • hhmmss – hour minute seconds (122754) when file produced

These files will be located in the directory set up in the Settings in the XML Defaults section:

The Submission Request file is found in the CIS Return File Location.  The Submission Acknowledgement file is found in the HMRC Response File Location.  All other files are found in the Processing Files Location.


7. Appendix B – XML File Layouts

Rather than print out all the XML files and go through each line, only the important areas are displayed.

Submission Request

The CISreturn_Submission_ file is the main driving file.  This is created from the CIS Return information and forms the actual submission to HMRC.

There are 3 main sections:

CIS Help and User Guide - 11

CIS Help and User Guide - 11 2

NB: this file is taken from the same example throughout the document.  If there were multiple subcontractors then they would appear as extra<Subcontractor> nodes, one after another.


7.1. Submission Acknowledgement

The CISreturn_Acknowledgement_ file is returned when HMRC receive our CISreturn_Submission_ file. Essentially there is one section, and this will be duplicated throughout the rest of the files. The <Correlation ID> is the unique ID that is used throughout the rest of the files with any information displayed and the <Qualifier> and <Function> setting out the type of file.

CIS Help and User Guide - 11.1


7.2. Submission Poll

The CISreturn_Poll_ file is our file polling HMRC to see if they have finished processing our CISreturn_Submission file. Essentially there is one section, and this will be duplicated throughout the rest of the files. The <Correlation ID> is the unique ID that is used throughout the rest of the files with any information displayed and the <Qualifier> and <Function> setting out the type of file.

CIS Help and User Guide - 11.2


7.3. Submission Response

The CISreturn_Reponse_ file is HMRC’s response once finished processing our CISreturn_Submission file.  There are two sections, the first being much like the previous file and showing the <Correlation ID> is the unique ID that is used throughout the rest of the files with any information displayed and the <Qualifier> and <Function> setting out the type of file.

The second section gives the message, whether passed or failed (this is what is passed into the HMRC Submission Status screen and displayed on the returns).

CIS Help and User Guide - 11.3


7.4. Delete Request

The CISreturn_Delete_ file is our file telling HMRC to clean up the files sent during submission.  Essentially there is one section and this will be duplicated throughout the rest of the files.  The <Correlation ID> is the unique ID that is used throughout the rest of the files with any information displayed and the <Qualifier> and <Function> setting out the type of file.

CIS Help and User Guide - 11.4


7.5. Delete Response

The CISreturn_delete_Response_ file is HMRC telling us that the cleanup is done.  Essentially there is one section and this will be duplicated throughout the rest of the files.  The <Correlation ID> is the unique ID that is used throughout the rest of the files with any information displayed and the <Qualifier> and <Function> setting out the type of file.  It is when we receive this file that the HMRC Submission Status screen button changes to Exit and allows the end of the process.

CIS Help and User Guide - 11.5


8. Enable Module

If you need to manually apply an Enable String, start the Sage 200 application and login as a user with a role which has access to all the CIS features.  Click on the Enable Module.  Enter the enable string as per the screen below and click Apply:

Sicon CIS Help and User Guide - Enable module

 


9. Reports


9.1. CIS Audit Report

Sicon CIS Help and User Guide - CIS Payments report


9.2. CIS Payments Detailed Report


9.3. CIS Payments Detailed Report (E-mail)


9.4. CIS Return Summary


9.5. CIS Subcontractor Monthly Statement


9.6. CIS Subcontractor Monthly Statement (E-mail)


9.7. CIS Supplier List


9.8. Pending CIS Verification


10. Release Notes

The Release Notes show which release of the CIS system includes which new features and for which version of Sage these will work.

The version number indicated in the CIS Release Notes includes a full release number and a sub version number; e.g. ’6.1′ indicates the full release version number of the software.  Pre-release version builds of the software are available to certain clients requiring new or enhanced features being developed from the Sicon Wish List.  If these versions are installed on your system, you will see an additional number e.g. 39.113 making up a specific database version and interim build number of 6.1.39.113.

It is unlikely that these features will be documented in this help and user guide until the end of the development phase.

Construction & CIS Release Notes

11. Sicon V18 New Features & Important Information

New Features

  • New Sales orders sub module added to construction. This will follow the feel of standard sales orders but will then be able to generate applications.
  • Purchase orders can now be linked to supplier applications.
  • Single valuations can be added to multiple applications.
  • You can now apply a cap to the amount you can retain from an account.
  • Retentions are now split into Works/Materials and complete/defects for standard invoice and credit note transactions.
  • CIS percentage split can now be specified on part payment allocation of an invoice.
  • Retention release from applications have been improved so you can now add a valuation and add and release a retention at the same time.
  • Nominal lines can now be specified on an application. along with job header and tax code per line.
  • CIS is now integrated with supplier applications.
  • New status on applications to show applications that have been fully valued but only have retention releases left to complete.
  • Nominal codes can now be set up for posting Application and valuations before an eventual invoice is produced. These nominals will then be reconciled to a job transaction.
  • Job transactions will now be created for valuations.
  • Individual due days added for all retention types on Sales and purchase accounts.
  • New import screen added to import purchase applications.
  • New column in retention ledger to indicate the origin either from ledger of from applications.
  • Retention tab added to transaction enquiry in sales and purchase ledger to list any related retention’s to invoices.
  • 2nd reference can now be entered for bank transactions in applications.
  • On HMRC verification notification screen there is now a new button to print a supplier report with verification details.
  • CIS details import will now allow you to import the rate for a subcontractor.
  • Sicon SOP line tab in applications will show either a quantity or percentage depending on line type.
  • New setting to choose where to get job headers from in Construct data.
  • Application and valuation screens changed to use a sage salvable pattern.
  • Tax codes can now be maintained on construction purchase order lines to then be copied on to applications.
  • Job and Job Manager filters added to the MI Enquiry
  • ‘Correct transactions’ feature in sage will now have CIS, Retention and CITB enhancements
  • Default tax code setting added for PL retentions added through the purchase ledger.
  • Valuation invoice dates will now validate with sages period validation rules if enabled.
  • Construct now import addresses for jobs.
  • Reversing valuations will now prompt for a date

Important Information

  • Various database changes have been made so an update of companies in Sage200 system administrator needs to be run. [v17.0.0]
  • Update companies. New table ‘SiconRetentionSOP’ [v17.0.3]
  • Please update companies. New table ‘SiconSalesOrderPickingListLine’ added. [v17.0.5]
  • Update companies required. [v.17.0.6]
  • Please update companies. New tables added to SQL script. [v17.0.11]
  • Please install latest reports for construction. New Retention release document. Comment lines on SOP documents. [v17.0.11]
  • Update companies needed for new column ‘RetentionsReleased’ [v17.0.12]
  • Update companies for new columns to be created. [v17.14.15]
  • Job costing v17.24.20 or higher required. [v17.14.15]
  • Please make sure latest common components [v17.37.51 or higher] and Job costing [v17.29.22 or higher] (if applicable) pre-release are installed. [v17.15.18]
  • Update companies required for new columns. [v17.15.18]
  • Update companies required for new table changes. [v17.17.19]
  • Update Companies for new ‘taxcodeID’ column on Purchase Orders. [v17.21.20]

[Last important info applied August 17, 2018. v17.21.20]

Sicon Construction v18 New Features & Important Information

Sicon Main Menu