How to Update Your Excel Template for 2020 ESEF Reporting

When you’ve been onboarded as a ParsePort customer we provide you with a fully tagged Excel template, which you will use when converting your annual report to ESEF.

This Excel template contained 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:

Any questions about updating the Excel template should be answered in the guides below. In case your question isn't answered, feel free to send your question to support@parseport.com and one of our account managers will get back to you.

Updating Your Template without Changes to Your Mapping

If you don’t have any changes to text in the posts of your financial statements or the mapping, then you can simply follow the instructions below:

  1. The first thing you need to do when updating your Excel template from one year to the next, is to update the dates in your General Data Sheet. Start by navigating to the sheet titled “General data ESEF” and scroll down to the dates section. Here you need to 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.esefgeneraldatadateupdate
  2. You also need to make sure the line “Customer taxonomy name” has been updated so the date reflects the current report. This will happen automatically as long as you haven't changed the cell manually.
  3. Afterwards you need to go through your financial statements and update your figures. First you copy/paste the column containing your 2019 figures (the period 1 column) into the column containing your 2018 figures (the period 2 column). And remember to make sure, that the fields highlighted in green and orange remain unchanged, as these contain sum-formulas needed to convert your files to ESEF.ESEFupdatenumbers1
  4. Then you need to update the date and the figures in your period 1 column to reflect your 2020 report. Again making sure that the fields highlighted in green remain unchanged, so they contain the sum-formulas needed to convert your files to ESEF. Note: If any cells are highlighted in orange, it means they are set up to correct a rounding error, if this is the case, and you don't have the same rounding error for your 2020 report, you need to remove the +1 or -1 at the end of the calculation.ESEFupdatenumbers2
  5. After this, your Excel template is ready for conversion along with your corresponding 2020 PDF annual financial report, and you can even test the result by uploading only the Excel template to our converter, which will let you know if everything has been updated properly.

We always recommend that you run a test conversion using just your Excel template, to ensure that everything has been updated correctly. If you experience any issues feel free to reach out to us at support@parseport.com.

Updating Your Template with Changes to Your Mapping

If you need to make changes to either the mapping or to the text in the posts of in your template, then you simply need to follow the instructions below:

  1. The first thing you need to do if you want to add more lines to your annual financial statements or change your mapping is to make the changes in your template.
  2. You can add new lines by simply inserting a line in Excel, the simplified tags will then automatically update to include the new lines. Be mindful that you need to make sure to add the new line within the parameters specified in the simplified tags, they will then adapt to include the added line.New-label-added
  3. If you want to change the text of one of your posts, you simply need to make the changes in the Excel template.
  4. Afterwards you should upload the Excel file to the ParsePort XBRL Converter and press convert. This way you can check if your changes have impacted the mapping, the converter will let you know if something within the file wasn't mapped.
  5. In rare cases the simplified tags will not pick up the changed text or the new post. If this happens, you need to highlight the cells in your template where you have made changes and send a copy of the Excel template to support@parseport.com with a request to test and/or map the changed file.esef-change-name-of-label
  6. Afterwards you will receive an updated template, and you can then start adding your figures for 2020.
  7. To update your new Excel template from one year to the next you first need to update the dates in your General Data Sheet. Start by navigating to the sheet titled “General data ESEF” and scroll down to the dates section. Here you need to 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.esefgeneraldatadateupdate
  8. You also need to make sure the line “Customer taxonomy name” has been updated so the date reflects the current report. This will happen automatically as long as you haven't changed the cell yourself.
  9. Afterwards you need to go through your financial statements and update your figures. First you copy/paste the column containing your 2019 figures (the period 1 column) into the column containing your 2018 figures (the period 2 column).ESEFupdatenumbers1 
  10. You can then update the date and the figures in your period 1 column to reflect your 2020 report. Here you should make sure not to update the cells highlighted in green, as they contain sum formulas needed for the calculations and will update automatically based on the figures in the other cells. Note: If any cells are highlighted in orange, it means they are set up to correct a rounding error, if this is the case, and you don't have the same rounding error for your 2020 report, you need to remove the +1 or -1 at the end of the calculation.ESEFupdatenumbers2
  11. After this, your Excel template is ready for conversion along with your corresponding 2020 PDF annual financial report, and you can even test the result by uploading only the Excel template to our converter, which will let you know if everything has been mapped properly.

We always recommend that you run a test conversion using just your Excel template, to ensure that everything has been updated correctly. If you experience any issues feel free to reach out to us at support@parseport.com.