use XML for EC Sales
For the XML button to become available on the EC Sales List report and for you to be able to send your EC Sales report online to HMRC in the correct format, you need to ensure you have carried out the following actions:
Register with HMRC
You must register with HMRC and obtain a User Name and Password to transmit documents to HMRC by XML. You can do this via HM Revenue & Customs at: http://www.hmrc.gov.uk/online/index.htm
Enter your User ID and Password
The User ID and Password, issued when you register with HM Revenue & Customs, should be entered on the Comms tab of the Company Details window. This will enable Access Accounts to connect for communications.
Set the XML Format
If you need to set up an XML format, follow the steps below.
Open the System Options window (System > [Settings] Options > System Control Options)
Go to the Documents tab, and open the XML Formats window.
Click on the Import formats icon.
Select the required Template (i.e. for EC Sales List format choose EC Sales List Bulk or EC Sales List online, for Irish Intrastat choose Intrastat (Ireland), etc.) and click Accept. The Import Template Result window is displayed.
If the Import is successful, you may just close the Results window by clicking Accept.
If the import fails, copy the information from the results window to your clipboard so that you can paste it into Notepad or Word and print it for reference. You will need to contact your support provider for assistance.
When you close the Results window, you will be returned to the XML Formats window. The selected format should be visible in the list of imported formats.
The format will be active and cannot be edited or deleted.
Update your VAT Return Figures
Your EC Sales List must have been printed and updated using the EC Sales List window.
Note: you will need a working Internet connection.