How to Pre-validate Your Mapping

When you start preparing for ESEF conversion, you may want to ensure that your mapping is still 100% correct even before you have your figures or the designed PDF report ready. Luckily, this is very easy.

The process is known as pre-validation, which may sound complicated, but really it's just as easy as doing a normal conversion.

Setting Your Excel File Up for Pre-validation

You can pre-validate your mapping by using just your Excel template, and you don't even need to have any figures ready. This lets you check whether the mapping is still 100% correct. It is especially useful to carry out pre-validation if you plan on adding new lines to your financial statements or if you plan to change any of your labels.

  1. It is a good idea to start out by updating the General Data Sheet to reflect the relevant reporting period. This is done by navigating to the sheet titled “General data ESEF” and updating the cells “Start date of reporting period 1” and “End date of reporting period 1”;
  2. Afterwards make sure that the cell titled "Customer taxonomy name" has also updated to reflect end of the reporting period (this should happen automatically);
  3. Then you need to update your financial statements. You do this by copy/pasting the figures from the "period 1 column" on top of the "period 2 column";
  4. The last part of preparing the Excel template for pre-validation is to change every figure which isn't the result of a sum formula (highlighted in green) in your "period 1 column" to 0 (zero). If you have any cells which were previously corrected for rounding errors (highlighted in orange) they will end up with a value of either +1 or -1, in both cases you can correct the issue by removing the +1 or -1 at the end of the sum formula;
  5. When you have updated your Excel file for pre-validation as described above, you can upload it to our Platform and press convert. After the conversion the error report will tell you if there are any issues with your mapping.
  6. If the conversion doesn't return any errors, your mapping is 100% correct. If, on the other hand, there is an issue with your mapping you can contact our support team by emailing and they will help you sort it out.