During your onboarding meeting you were provided with a fully-tagged Excel template, which you will use when converting your annual report to ESEF.
This Excel template contains the figures for your most recent annual report and moving forward all you need to do is to update the template to fit your next annual financial report by following one of the two guides on this page:
- Updating Your Excel Template without Account/Mapping Changes
- Updating Your Excel Template with Account/Mapping Changes
Any questions about updating the Excel template should be answered in the guides below. In case your question isn't answered, email your question to wkrt.support@workiva.com and one of our Professional Services Specialists will get back to you.
Updating your Template without account or mapping changes
If you don’t have any changes to text in the accounts of your financial statements or the mapping, follow the instructions below:
- Navigate to the sheet titled “General data ESEF” and scroll down to the Dates section.
- Update the lines “Start date of reporting period 1” and “End date of reporting period 1”.
The rest of the reporting periods will update automatically based on Period 1. - Copy and paste the values from Period 1 to Period 2. Remember to keep the calculations (the fields highlighted in green), as these contain sum-formulas needed to convert your files to a compliant ESEF report.
-
Add the new figures in your Period 1 column.
Make sure that the figures in the Excel table exactly match the figures in the annual report. You also need to make sure that the fields highlighted in green remain unchanged, as they contain the formulas needed to convert your files to ESEF.Note: Sometimes it will be necessary to add a rounding (+1 or -1) to a sum in order to match the figure in your report. A cell that contains a rounding will appear orange. When entering your new numbers you will be able to see whether a rounding is necessary or not, and to adjust the sum-formulas accordingly.
- Your Excel template is now ready for conversion. You can upload the Excel file by itself to make sure that there are no errors or inconsistencies in your Primary Financial Statements and in the calculations, and that everything has correctly been updated.
Afterwards, you can upload the Excel along with your corresponding new PDF annual financial report, and do a more thorough check of the tags.
We always recommend that you run a test conversion using just your Excel template first, to ensure that everything has been updated correctly. If you experience any issues feel free to reach out to us at wkrt.support@workiva.com.
Updating your template with account or mapping changes
If you need to make changes to either the mapping or the text in the accounts of your template, then follow the instructions below:
- Navigate to the sheet titled “General data ESEF” and scroll down to the Dates section.
- Update the lines “Start date of reporting period 1” and “End date of reporting period 1”.
The rest of the reporting periods will update automatically based on Period 1. - Copy and paste the values from Period 1 to Period 2.
Remember to keep the calculations (the fields highlighted in green), as these contain formulas needed to convert your files to a compliant ESEF report.
You can add new lines by inserting a line in Excel. The tags should then automatically update to include the new lines. You can always check the range of the simplified tag by double clicking on it and ensuring all relevant lines are included. - To change the text of one of your Financial Statements Line items (FSLI), make the changes in the Excel template.
- Once you have made all the changes to your Excel template, send it to the Workiva Professional Service Team so that we can update your mappings accordingly. We will let you know when the updates are complete on our side, and you will be ready to test your files with your latest report.
We always recommend that you run a test conversion using just your Excel template first, to ensure that everything has been updated correctly. If you experience any issues feel free to reach out to us at wkrt.support@workiva.com.