Adding Reporting Periods to the Excel Template

When you receive your Excel template from us, the financial statements will most often have two periods; Period 1 and Period 2. This is common practice, but we've also made it easy for you to add more periods.

In this article we will go over how to add up to six reporting periods to your financial statements. But remember, that any information you add to the Excel Template should also be presented in the PDF version of your annual financial report.

How to Add Extra Reporting Periods to the Excel Template

If your Excel Template was created before March 2021 you can use the following instructions to add reporting periods. If it was created after that you can  use the instructions further down the page to make the process much easier. 

  1. Before you make any changes to your Excel template, start by making sure you have updated your Excel template with the latest version of the ESEF Tagging Template.
  2. In the Excel sheet you use for conversion, you need to add a column for each reporting period you want to add. If for instance you want three reporting periods, you simply add a column next to your period 2 column, and name it "period 3" esef-reporting-period-11
  3. You then repeat this process for each of your financial statements, until every statement has the desired number of reporting periods.
  4. Then open the ESEF tagging template and navigate to the first financial statement you want to add more reporting periods to. This could be Income Statement, for instance. Here you will find a "+" symbol located directly above the D-column. Press it. esef-reporting-period-image-1
  5. This will open extra columns each containing different simplified tags (written in red). The simplified tag in column D is set up for two reporting periods, the simplified tag in column E is set up for three reporting periods all the way up to column H which is set up for 6 reporting periods.
    esef-reporting-period-12
  6. Now copy the simplified tag, with the number of periods you would like, from the ESEF tagging template and into your Excel sheet. Make sure that you replace the proper simplified tag, so "Income Statement By Nature" is replaced with "Income Statement By Nature" for instance. esef-reporting-period-13
  7. Afterwards you need to update the simplified tag so the ranges are specified correctly. The simplified tags in the ESEF tagging template are set up so the the  label range is specified as cells A2-A4 while period 1 is B2-B4, period 2 is C2-C4, and period 3 is D2-D4, but that isn't the case in your Excel sheet. Luckily you simply need to exchange the cell locations specified in the simplified tag to match the cell locations of your specific Excel sheet.

    In the examples below, you can see how it looks when the simplified tag is updated so the label range is changed from A2-A4 to instead specify B4-B34, period 1 is updated from B2-B4 to instead specify H4-H34, period 2 is updated to J4-J34 and period 3 is updated to L4-L34. In your case, you should update the specifications to reflect the positions in your Excel sheet.

    Simplified Tag from the ESEF Tagging Template:
    =SUBSTITUTE("/"&IFERROR(VLOOKUP("Income Statement By Nature";INDIRECT("'General Data ESEF'!PP_Locale");INDIRECT("'General Data ESEF'!PP_LanguageIndex");FALSE);"Income Statement By Nature")&"(labels="&CELL("address";A2)&":"&CELL("address";A4)&",values="&CELL("address";B2)&":"&CELL("address";B4)&"[period=1];"&CELL("address";C2)&":"&CELL("address";C4)&"[period=2];"&CELL("address";D2)&":"&CELL("address";D4)&"[period=3])";"$";"")

    Example of an Updated of the Same Simplified Tag:
    =SUBSTITUTE("/"&IFERROR(VLOOKUP("Income Statement By Nature";INDIRECT("'General Data ESEF'!PP_Locale");INDIRECT("'General Data ESEF'!PP_LanguageIndex");FALSE);"Income Statement By Nature")&"(labels="&CELL("address";B4)&":"&CELL("address";B34)&",values="&CELL("address";H4)&":"&CELL("address";H34)&"[period=1];"&CELL("address";J4)&":"&CELL("address";J34)&"[period=2];"&CELL("address";L4)&":"&CELL("address";L34)&"[period=3])";"$";"")
  8. You then need to repeat the process described in step 6-7 for each of the simplified tags in each of the financial statements in your Excel sheet.
  9. When you've added the extra reporting periods, and filled in the figures, you can run a test conversion with the updated Excel template in the ParsePort XBRL Converter, to check that everything is registered correctly.

How to Add Reporting Periods to the Excel Template for Templates Created after March 2021

If your Excel Template was created after March 2021 you can use the following instructions to add reporting periods. If it was created before that you need to use the instructions above. Before you make any changes to your Excel template, start by making sure you have updated your Excel template with the latest version of the ESEF Tagging Template.

  1. If your Excel template is of a newer version, you will find a + symbol above the rows in your financial statements.esef-reporting-period-22
  2. When you click the symbol, columns D-G will open.esef-reporting-period-23
  3. Then you simply add the figures to the reporting periods you need. As long as you leave the unneeded reporting periods empty, they won’t influence your conversion. So, if you want three reporting periods, you just input the figures in column D and leave the other columns blank.esef-reporting-period-24
  4. Afterwards you repeat the process described in steps 1-3 for each of your financial statements before you click save. It is important that you leave the extra columns open when you save, as our converter will skip over any hidden information.
  5. When you've added the extra reporting periods, and filled in the figures, you can run a test conversion with the updated Excel template in the ParsePort XBRL Converter, to check that everything is registered correctly.