Instructions for Creating an XML Scheme from an XLS File

1 ASSISTANCE IN CREATING AN XML FILE FROM AN EXCEL FILE This document is a technical guide on how to create an XML file from an Excel file. The fields in the XML scheme are mapped to corresponding cells in the Excel file, enabling automatic generation of the XML file after data entry. Additionally, it provides Instructions for filling out fields in financial statement forms (GFI, PFI, and TFI).

1. Display of the „Developer tab“
   To generate an XML file, it is necessary to enable the display of the „Developer tab“ in Excel:
   By clicking on „File“, the following menu will appear on the left side:

2 Select „Options“. The following window will appear:

3 Select „Customize Ribbon“ and on the right side select „Main Tabs“, then check the box for „Developer“.

4
2. Data Entry
The corresponding Excel template must be filled with data. In each template, on the „General Data“ form, there is a field called „Institution Code“, which is a number, and the codes of individual institutions can be found on the website http://reports.hanfa.hr/ by selecting the „XML scheme“ section. This section contains all XML schemes for all reports. After selecting the report you wish to create, four files will appear:
By opening the file containing the word „Lists“, a file with all institution codes of reporting entities for individual reports will open. You can open the file in any web browser. After opening the file, you will read the institution code as follows:
The institution code of the company „Hrvatska elektroprivreda d.d.“ is 294. Pay attention to the fact that the institution code is listed before the company name (Končar – Elektroindustrija d.d. has institution code 501, and Jadranski naftovod d.d. has institution code 568).

5
3. Generating the XML File
After filling in all data, generate the XML file. The XML file is generated by selecting the „Export“ function in the „Developer“ tab:
After that, save the file locally on your computer. The generated file is submitted to the appropriate location according to the Technical Guide on Data Submission.
4. Changing Data
If you need to change data for any reason, enter the corrected data into the Excel file and repeat the procedure as defined in step 3.
5. List of Reported Persons
The report on the list of reported persons is specific in that the form repeats. The template looks like this:
For each new row in the report, right-click on the blue row (row 6 in this case) and select „Insert“. You must have as many rows as the form repeats. If you have one empty row, delete it, otherwise an incorrect XML file will be generated.

6
In this case, it is necessary to delete row 10. The row is deleted by right-clicking on the row and selecting „Delete“.
6. Instructions for Filling Out Fields in Financial Statement Forms (GFI, PFI, and TFI)
All fields in the form are mandatory to fill out, meaning that if there is no specific data for a particular item, zero (0) is entered into the cell (for example, the part related to discontinued operations in the Statement of Comprehensive Income and all other cells with no data). Additionally, if you are filling out the cash flow by the indirect method, zeros must be entered into the direct method form, or if you are filling out the cash flow by the direct method, zeros must be entered into the indirect method form.
7. Corporate Governance Practices Questionnaire for Share/Bond Issuers
In the Corporate Governance Practices Questionnaire for share/bond issuers, the „Management“, „Supervisory Board“, and „GS - individual“ forms are specific because the form repeats as many times as the company has management members, supervisory board members, or as many times as the general meeting was held during the year for which data are being filled out. Below are instructions for adding/deleting rows in the „General Meeting individual“ form in the Corporate Governance Practices Questionnaire for share issuers, and the same instructions apply to the „Management“ and „Supervisory Board“ forms in the Corporate Governance Practices Questionnaire for bond issuers.

7
For each new row in the form, right-click on the gray row (row 4 in this case) and select „Insert“. The report must have as many rows as the form repeats (in this example, how many general meetings were held in the year for which data are filled out). If there are empty rows in the report, they must be deleted, otherwise an incorrect XML file will be generated. The row is deleted by right-clicking on the row and selecting „Delete“. If you want to change data in certain cells (for example, the answer to questions 9.3 and 9.4 in cells B4 and C4), you must delete the data cell by cell and enter new data. If multiple cells are selected and their content is deleted, an incorrect XML file will be generated.
8. Compliance Questionnaire
If the first question is answered and an explanation for that question is entered, but they need to be deleted because the answers are not correct, they are deleted by positioning in cell E and pressing the „Delete“ key, and the procedure is repeated for cell G. If both the answer to the question in column E and G are simultaneously selected and the answers in that row are deleted, the XML file will be generated incorrectly.