 NOTE: If any of the scenarios below advise on using the Excel adaptor, click here more information on how to use it.
Sage 200 Spring 2018 Enhancements onwards is compliant with MTD. Read more The MTD submissions module is a standalone tool for non-compatible versions of Sage 200 to enable customers to undertake MTD submissions. The MTD submissions module also provides additional functionality, not available in product e.g group submissions and complex VAT scenarios. | Scenario | Sage 200 | Notes | | Standard VAT | Y | Sage 200 compatible versions or via the MTD Submissions module. | | Partial Exemption | Y | Instructions from Ask Sage article should be followed and then be submitted from a Sage 200 compatible version or via the MTD Submissions module. | | Cash Accounting | N | Sage 200 is not suitable for these VAT schemes. | | Flat Rate - Invoice Based | N | | | Flat Rate - Cash Based | N | | | Apportionment retail VAT scheme 1 & 2 | N | | | Point of Sale Retail VAT Scheme | N | | | Direct Calculation VAT Scheme 1 & 2 | N | | | Second Hand Margin VAT Scheme | N | | | Tour Operators Margin VAT Scheme | Y | | | Reverse Charge – small electronic goods | Y | Sage 200 compatible versions or via the MTD Submissions module. Details are available in our helpfiles. | | Non-GBP Base Currency | N | MTD submission module with Excel adaptor and additional steps*. Applicable to Sage 200 Professional users only. | | Complex VAT Scenarios (not covered above) | N | Depending on the scenario, adjustments may be able to be made to in product processing. Or alternatively via MTD submissions module with Excel adaptor | | Group VAT | N | MTD Submissions module with Excel adaptor | | Older version of Sage 200 | N/A | Submit via the MTD Submissions Module – full details on our approach by version can be found here. | Please remember it's important that any adjustments are made on the vat return, prior to the submission. MTD Submissions Module As the MTD Submissions module is available for use across the Sage Product range, we’ve included a comparison of the features below: | Scenario | MTD Submissions Module | Notes | | Multiple Sage Products | Y | An MTD module must be purchased/ registered for each Sage product being submitted from. Any adjustments should be made in the product prior to submission. | | Excel as source of data | Y | We do not support Excel as the only source of data. It must be used in conjunction with a submission from a Sage product. | | Group Vat (Multiple Sources/ Excel ) | Y | MTD submissions module with Excel adaptor. | MTD Submissions with Sage 200 & Non-GBP Base Currency* | Scenario | Notes | | ROI customer, needs to produce VAT returns to HMRC & Irish Tax authority (ROS). Base currency is EURO & Country is IE. | - Set up 2 separate sets of VAT codes;
- One for use with ROS return
- One set for HMRC, ensuring that they are unticked for use on the VAT3 return
- Ensure as processing transactions, that the correct exchange rate is entered on any transactions that would be used on UK VAT submission.
Items bought/sold in base currency won’t have an exchange rate so the exchange rate will need to manually entered once the data is downloaded to excel. The exchange rate is published by HMRC once a month. - Create a report to extract the transactions associated with the UK tax codes.
Use the following tables:
- SLPostedCustomerTran
- PLPostedSupplierTran
- CBPostedTran
and include exchange rate, net & VAT values this will allow you to calculate the transaction back to base currency - GBP. - Pull the data into Excel, and build relevant formulas to calculate the vat return.
- Pull the calculated VAT figures into the MTD Excel adaptor and submit.
- Keep a copy of the transactions and calculations, this will be required should HMRC undertake an audit.
Note: VAT Impacting Journal Entries - This approach won’t work with journal entries that may impact the VAT return. e.g. Scale Fuel Charges.
It is a customer’s responsibility to: - check with HMRC that they are happy with the submission of a company’s VAT using the workaround above.
- Keep a list of the transactions & calculations to provide proof of the submitted figures.
| | Customer with Non GBP base currency – incorrect setup and base currency should be GBP base currency. | Customers data sets should be set up correctly. | | Customer with Non GBP base currency – due to parent company currency, group requirements. | - Ensure the transactions are being processed, that the correct exchange rate is entered on any transactions that would be used on UK VAT submission.
Items bought/sold in base currency won’t have an exchange rate so the exchange rate will need to be manually entered once the data is downloaded to Excel. The exchange rate is published by HMRC once a month. Note: For any invoices produced for UK customers, you must ensure that the invoices produced show the GBP value. - Create a report to extract the transactions associated with the UK tax codes
Use the following tables: - SLPostedCustomerTran
- PLPostedSupplierTran
- CBPostedTran
and include exchange rate, net & VAT values this will allow you to calculate the transaction back to base currency - GBP. - Pull the data into Excel, and build relevant formulas to calculate the vat return.
- Pull the calculated VAT figures into the MTD Excel adaptor and submit.
- Keep a copy of the transactions and calculations, this will be required should HMRC undertake an audit.
Note: VAT Impacting Journal Entries - This approach below won’t work with journal entries that may impact the VAT return. e.g. Scale Fuel Charges.
It is a customer’s responsibility to: - Check with HMRC that they are happy with the submission of a company’s VAT using the workaround above.
- Keep a list of the transactions & calculations to provide proof of the submitted figures.
| [BCB:19:UK - Sales message :ECB] |