How to generate an XML file from the Excel template
To generate the XML file from the Excel template, the following steps are to be used:
- Download the latest Excel WCDMO Reporting Form template.
- Complete all reportable fields as appropriate according to the requirements detailed in the latest version of the WCDMO Data Catalogue.
- Once the data is complete, save the file as ‘XML Data’. N.B. Take care not to select ‘XML spreadsheet 2003’ or ‘Strict Open XML Spreadsheet’ by mistake.
- Within Excel, select File – Save As. The Save As window will appear.
- Use the dropdown option ‘Save as type’ to select ‘XML Data’.
- Choose a location to save the file, type a suitable file name (See WCDMO Data Catalogue, Annex 1 – Data Item File Naming Conventions for details) and select ‘Save’.
- The generated XML file can be uploaded to the BEEDS portal. Submitting the Reporting Form in any other file format is not permitted in BEEDs.
N.B. It is not supported to export to ‘XML Data’ using MacOS. Using the Excel file and generating an XML template is only supported when using a Windows PC.
How to submit via the BEEDS Portal
Please refer to the BEEDS User Guide (available on the BEEDS resources page) for more information on the processes to submit data, manage users and update firm details.
- For any queries on the BEEDS portal, please contact BEEDSqueries@bankofengland.co.uk.
- For enquiries that do not relate to the BEEDS portal, firms should contact the Wholesale Cash Supervision team: wholesalecashsupervision@bankofengland.co.uk
Ends