Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Revenue and Customs.
WorkflowMax itself does not handle CIS deductions like Xero can, but you can connect your WorkflowMax account to your Xero organisation and have your invoices and bills sync through to Xero.
Reconciling aged receivables in both Xero and WorkflowMax
If you are a subcontractor dealing with CIS deductions on your sales invoices, you can reconcile the aged receivables in both Xero and WorkflowMax as follows:
- Create the invoice in WorkflowMax without including the CIS deductions.
- Approve the invoice. If you are using the integration, the invoice is automatically sent to Xero.
- If you are using the CIS function in Xero, you must change the account code of each line to match your CIS account codes. Xero will calculate the CIS amount and deduct this from your invoice total.
- Send the invoice to your client from Xero. Due to the CIS deduction, the invoice total in Xero will be less than the invoice total in WorkflowMax.
Recording payments
When the invoice is paid in Xero, the payment shows in WorkflowMax as Part Paid, due to the CIS deduction.
To correct this in WorkflowMax, you need to record the difference manually as a ‘payment’ for the amount of the CIS deduction:
- Go to Business > Invoices and open the Awaiting Payment tab.
- Locate the invoice.
- In the invoice, open the Payments tab.
- Add the date the payment was received
- The amount paid will default to the outstanding amount, which is the CIS deduction amount.
- In the reference field type ‘CIS’.
- Select Add Payment. This generates a payment for the unpaid invoice amount. The invoice will then be removed from the Awaiting Payments tab and is shown as paid in full.
Recording CIS deductions in bulk
If you wish to record the CIS deductions in bulk, you can run the WorkflowMax sample report called PAYMENTS - Part Paid Invoice Report The report lists all part paid invoices recorded in WorkflowMax, letting you spot those with CIS deductions. To run this report:
- Go to Reports > Report Builder.
- In the Samples tab, scroll down and click the title PAYMENTS - Part Paid Invoice Report.
- In section 1, rename the report so that you can easily identify it. For example: PAYMENTS - Part Paid Invoice Report - CIS deductions.
- In section 4, make sure that your own name is shown, otherwise you will not see the report in your My Reports screen.
- Save and Preview the report. The report is saved under your My Reports tab for you to use in future.
- In the on-screen report output, open each invoice in turn by right-clicking the hyperlinked invoice number and selecting Open link in new tab.
- To record the payment of each invoice, follow the steps shown under Recording payments above (starting at Step 3).
Please note, recording invoice payments in this way can affect your reporting. If you're not sure how this will affect your business reporting, we recommend discussing it with your accountant.