How do I use the VAT return for Xero GLOBAL?

Learn how to use the VAT reporting for Xero organisations based in Malta.

Xero does not yet provide a VAT report for GLOBAL versions of their software. DataDear can help business owners or accountants looking for a better way to manage the VAT reporting.

:bulb: This functionality is currently only available for Malta-based companies - if you are interested to extend this functionality in your country, get in touch with DataDear support or with your account manager.

DataDear will help you save time by automatically producing your report in the correct
format. Better yet, it will automatically handle exceptions, identify late entries added to a
previously submitted period, and convert all values to Euro’s.

If you work with multiple clients you can re-use your mappings across any Xero organisation.

Mapping the Tax rates

This task is an important first step and only needs to be done once per company. Mapping the tax rates to the VAT return will ensure all the transactions in the system are assigned to the correct box in the VAT return.

  1. Login to DataDear web Dashboard using your credentials.

  2. Click on the VAT Reporting tab in the menu.

  3. Select the Map Tax Rates button next to the organisation you wish to use.

  4. Select the Reporting Country and choose Continue. If there is a message that the organisation is disconnected, you will need to reconnect this from the Organisations tab before starting the mapping process.

  5. The VAT form of the selected reporting country is presented on screen.

  6. For each box select the rates to include / associate with this box.

:information_source: You can map multiple rates to one box or multiple boxes with the same rate (for example when using reverse charge)

  1. Once you have correctly mapped your rates, use the Show Unmapped Tax Rates to ensure you haven’t missed any rates. You may also move the remaining to out of scope (transactions with these these tax rates will be ignored when compiling the report).

  2. Choose the Continue button to review all mapped tax rates.

  3. You may save this mapping as a template. This can be reused across the practice by all users having access to this company within the DataDear. account
    image

View & Edit Mapping

You may need to view and / or edit the mapping of an organisation in case where tax rates have changed or there was a mistake in the mapping.

Choose the respective button next to the organisation and follow the same above steps to change the tax rate mappings.
image

Generate the Tax Report

Once the mapping is ready, you may proceed to generate the tax report.

  1. Select the Tax Reports button next to the organisation you wish to use. This is activated once the Tax Rates have been mapped.

  1. Choose the reporting from - to dates using the provided calendar.

  2. Use the Generate and Send button to start the process.

  3. You will receive an email once the report has been completed - this email will contain a link to download the report. The download links are also available within the Tax Report page.

:warning: The report remains available for 7 days before it is automatically deleted from the system. Deleted files cannot be restored and the download link will no longer be available.

  1. The tax report page also shows all previously generated reports including the reporting details and when this was downloaded.

  2. You can generate this report as many times as required - you may then use the the Mark as last submitted button in this table when a version is ready to submitted to the authorities. This timestamp is used to handle any exceptions - i.e. when DataDear detects entries that were created after the submitted date with an earlier transactional date.

VAT Report

To access and use the VAT Report:

  1. Use the provided link (in the email or directly in the VAT page) to download a .zip file
    image

  2. The zip file contains an Excel workbook with 4 tabs:

  • VAT Return - This sheet is filled in Malta VAT return ready for review.

  • Detailed VAT Return - This is the DataDear feed showing all the figures and transactions on which the VAT Return is being computed. This sheet cannot be refreshed.

  • Exceptions Report - Any transactions having the created date after the previous VAT return and the transactional date before it was generated will be logged in this sheet.

  • Additional Values - This sheet is confirming the selected report period, the generated date and the VAT Control Account Code.

  1. When the VAT Return is ready to be submitted with the authorities, you will need to manually copy the figures using the tools provided by the local VAT Department.

:information_source: Discussions with local authorities are ongoing to open the VAT api so this form can be submitted electronically.