Sure thing @Thijs
Normally we do this for you (if you want, you can ask our first line helpdesk through the chat for this), but it’s the code of the “detail text” that is generating this in an export (you can see that by clicking on “advanced settings” and then changing edit
into advanced
of the URL, and then ENTER it) :
You’ll see this then :
It’s this code that generates all details regarding the working papers in an export :
{% t= "Activa" fr:"Explication actif" %}
{% t= "Passiva" fr:"Explication passif" %}
{% t= "Kosten" fr:"Frais" %}
{% t= "Opbrengsten" fr:"Produits" %}
{% t= "Fsicale toelichting" fr:"Explication fiscale" %}
{% capture sf_default_detail_template %}
{% raw %}
{% unless current_account.details.count == 0 and current_account.value == 0 %}
{% for detail in current_account.details %}{% if forloop.first %}|-----|----14%-----:|-----14%------:+{% endif %}
| {{detail.title}}{% if detail.description != blank %}<br/>{{detail.description | multiline_table}}{% endif %}{% if detail.custom.document %}<br>{% input detail.custom.doc as:file %}{% endif %} |{% if current_account.liability_or_income %}{{-1*detail.value | currency}}{% else %}{{detail.value | currency}}{% endif %}| {% endfor %}
{% endunless %}
{% endraw %}
{% endcapture %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.assets.include_zeros_with_details %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Activa" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Activa" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.liabilities.include_zeros_with_details %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Passiva" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ -1*account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Passiva" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.revenues.include_zeros_with_details.6 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Kosten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Kosten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.revenues.include_zeros_with_details.7 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation' %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Opbrengsten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ -1*account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Opbrengsten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.8 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Fiscale toelichting" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Fiscale toelichting" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
As you can see in the code, everything of recon templates that start with an 8 as virtual account number, will be sorted under the main title “Fiscale toelichting”.
You can change this into something else, or better yet, for those recon templates that only have the purpose of adding attachments, we can add new code in the detail text, looking at a specific range of virtual account number, for instance 88 :
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.88 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Annexes" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Annexes" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
So each recon template for those attachments, need to start with ‘88’ in order to be seen under “Annexes”.
Also, all other recon templates (not related to attachments), should be adjusted as well, like all have to start with 80.
That way, we’ll need to change the detail text and change it into this for instance :
{% t= "Activa" fr:"Explication actif" %}
{% t= "Passiva" fr:"Explication passif" %}
{% t= "Kosten" fr:"Frais" %}
{% t= "Opbrengsten" fr:"Produits" %}
{% t= "Fsicale toelichting" fr:"Explication fiscale" %}
{% t= "Bijlages" fr:"Annexes" en:"Annexes" %}
{% capture sf_default_detail_template %}
{% raw %}
{% unless current_account.details.count == 0 and current_account.value == 0 %}
{% for detail in current_account.details %}{% if forloop.first %}|-----|----14%-----:|-----14%------:+{% endif %}
| {{detail.title}}{% if detail.description != blank %}<br/>{{detail.description | multiline_table}}{% endif %}{% if detail.custom.document %}<br>{% input detail.custom.doc as:file %}{% endif %} |{% if current_account.liability_or_income %}{{-1*detail.value | currency}}{% else %}{{detail.value | currency}}{% endif %}| {% endfor %}
{% endunless %}
{% endraw %}
{% endcapture %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.assets.include_zeros_with_details %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Activa" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Activa" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.liabilities.include_zeros_with_details %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Passiva" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ -1*account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Passiva" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.revenues.include_zeros_with_details.6 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Kosten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Kosten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.revenues.include_zeros_with_details.7 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation' %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Opbrengsten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ -1*account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Opbrengsten" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.80 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Fiscale toelichting" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Fiscale toelichting" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
{% for account_or_text in export.selected_accounts_and_reconciliation_texts.88 %}
{% if account_or_text.is_account %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Annexes" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|------------|------15%------:+{{export.highlight_alt_bg_color}}
| <font color="{{export.highlight_alt_text_color}}"><font color="{{export.highlight_alt_text_color}}">{{ account_or_text.number }} {{ account_or_text.name }}</font></font> | <font color="{{export.highlight_alt_text_color}}">{{ account_or_text.value | currency }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% else %}
{% if forloop.first %}
{% if new_page %}{% newpage account_or_text.preferred_orientation %}{% endif %}{% assign new_page = true %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
# <font size="16">{% t "Annexes" %}</font>
{% else %}
{% changeorientation account_or_text.preferred_orientation %}
{::group}
{% endif %}
|--------+{{export.highlight_alt_bg_color}}
|<font color="{{export.highlight_alt_text_color}}">{{ account_or_text.name }}</font>
{{ account_or_text.rendered_template }}
<br>
{:/group}
{% endif %}
{% endfor %}
Care to give it a try?