TIP: Eque2 have provided the the following documentation for their CIS Solution, Domestic Reverse Charge VAT and How to configure VAT codes in Sage 200 for Construction Reverse Charge VAT (Spring 2019 Enhancements or earlier).Limitations of Workaround- The workaround will not support the use or postings for offering Early Settlement Discount.
- The workaround will not support VAT Inclusive Pricing.
- The workaround will not support customers working in a non-base currency.
- The Reverse Charge Purchases VAT code can only be used for Standard item lines (not Free text item lines).
- It is only possible to set up a single reverse charge purchase VAT Code.
- If you receive purchases of 5% and 20% then this workaround will not work and you must upgrade to Summer 2019 or above.
- If you are already using the Reverse Charge Purchases VAT terms for use with carousel fraud then you must upgrade to Summer 2019 or above.
- If you are already using the Reverse Charge Purchases VAT terms for Postponed VAT Accounting the same code would need to be used which could make analysis more difficult.
Sage 200 Professional Summer 2019 Enhancements offers a more integrated solution but will still require a 3rd Party CIS solution. Steps for Initial SetupSalesYou will need to create two new VAT rates in the program as below. These should be copies of the Standard VAT Rate, be given an appropriate description, using the applicable rate of VAT and set to be included in the VAT Return. To create new VAT rates, open the Settings menu within Accounting System Manager and choose VAT Rates. Code/Rate | Description | Name | VAT Return | Terms | % | 211 | Construction Industry Scheme Sales 20% | CIS Sales 20% | Yes | Not Applicable | 20.00 | 221 | Construction Industry Scheme Sales 5% | CIS Sales 5% | Yes | Not Applicable | 5.00 |
1 Customers have the flexibility to create their own codes, these are example codes but are also used on the supplied SOP Invoice layout (this will need to be amended if different codes are used). Boxes VAT codes affect on the VAT ReturnVAT Rate | Sale or Purchase | Net or VAT amount | Box |
---|
21 | Sales | Net | 6 | VAT | 11 | 22 | Sales | Net | 6 | VAT | 11 |
1 The VAT amount is negated by producing a VAT Only credit note (as detailed in Steps to be repeated for every sales invoice generated section below). This will separate these transactions from others in the system and will support any reconciliation required. PurchasesYou can only create one new VAT rate in the program, choosing either 5% or 20%. This should use the existing Reverse Charge VAT Rate Term, be given an appropriate description, using the applicable rate of VAT and set to be included in the VAT Return. Code/Rate | Description | Name | VAT Return | Terms | % | 231 | Construction Industry Scheme Purchases | CIS Purchases | Yes | Reverse Charge Purchases2 | 5.00 or 20.003 |
1 Customers have the flexibility to create their own codes, this is an example codes. It is only possible to set up a single reverse charge purchase VAT Code so many need to use an existing code if the terms have already been used. 2 This VAT Code using these term can only be used for Standard item lines (not Free text item line). 3 It is only possible to set up a single reverse charge purchase VAT Code, if you receive purchases of 5% and 20% this workaround is not suitable and you will need to upgrade. Boxes VAT codes affect on the VAT ReturnVAT Rate | Sale or Purchase | Net or VAT amount | Box |
---|
18 | Purchases | Net | 7 | VAT | 1 and 4 |
Steps to be repeated for every invoice generatedSales- Invoice - Raise an invoice with the relevant new VAT code. You will need to make sure that you don't mix and match VAT rates on the invoice. Where a service is supplied, all goods supplied in conjunction will also be subject to the reverse charge. (This will affect boxes 1 & 6 on the VAT Return).
- Credit - Raise a VAT Only credit note. Use the same VAT rate and VAT amount as the invoice undergoing Reverse Charge. (This will affect box 1 on the VAT return, reversing the VAT. Credit note must not be printed and sent to the customer).
- Print Invoice - The new invoice layouts (available here, see the Help Files for instructions on using alternative layouts) reduces Gross VAT, removes VAT and adds in the Reverse Charge text on to the invoice. This will ensure the customer (Contractor / Sub-Contractor) knows they are responsible to pay the VAT.
- Statement - Your 3rd Party CIS solution vendor should be able to provide you with a new statement that advises that credit notes will be shown where CIS Reverse Charge VAT is in play.
PurchasesRaise invoice using the new VAT code where appropriate. Other points to note:- Users are responsible for ensuring that the correct combination of VAT Rates for a CIS & NON-CIS Invoices is used.
- The workaround will not support invoice consolidation. This should be disabled.
- The workaround will result in a customer statement showing a mixture of postings for the invoice and the credit note.
- The workaround relies on the VAT Rates being created using Code 21 for 20% - Sales Reverse Charge and Code 22 for 5% - if any other codes or rates are used the layout will need to be adjusted.
- We have provided an example invoice layout, which can be used in both Invoicing & SOP. If you require adjustments to this or any other layout you could use our Report Design Service.
- The layout supplied by customer services provides a single version of the HMRC prescribed reverse charge text only.
- The gross values in Sage 200 will appear in forms with the VAT included. The VAT figure will also be displayed.
- Gross values on printed Purchase Order documentation will include the VAT amount within the totals.
[BCB:21:Support message - Sage Q&A Live:ECB]
|