Result tag Vaste Activa : full net book value

Templates
1

Hi,

I would like to link a own reconciliation to the “Vaste Activa” reconciliation from Silverfin.

I would like to get the total net book value of all (in)tangible assets (# 20/21/22/23/24/25/26/27).

I used the following tag : period.reconciliations.vaste_activa.results.mva_netto_bw

But this result tag is limited to #22-27.
How to add #20/21 ?
Which result tag I should use ?

Thanks

2

@Alexandra

Thank you for your question.

In order to proper get back to you, please, can you clarify which of the following do you require:

a) To link results from a custom template into “Vaste Activa” template.
Here is an explanation how to do it: CASE Annual Accounts (BE): link custom templates to Silverfin module of the Annual Accounts

b) or to use results from “Vaste Activa” template?

Thanks,
Jelena

3

Why not use directly the value of the accounts and use f.e.:
{% assign netvalue = #20__27 %}
The variable netvalue will give you the amount you need
netvalue = {{ netvalue | currency }}

4

Hi,

Indeed, I prepared a reconciliation which details depreciation for each assets, items by items.
As we had to select first accounts to display, I would like to be sure that we did not forget to select an account and that my depreciation table corresponds to the vaste activa table. It is why, I put a check at the end of the document to compare the net book value of items from my “depreciation table” to the net book value of the “vaste activa” model.

I used the following tag : period.reconciliations.vaste_activa.results.mva_netto_bw

But this result tag is limited to #22-27.
How to add #20/21 ?

Here is my code :


→ TABLEAU DES AMORTISSEMENTS {{ period.year_end_date|date:’%d/%m/%Y’ }} ←

{%if custom.invest.range == blank%}{%assign account_range = ‘20__27’%}{%else%}{%assign account_range = custom.invest.range%}{%endif%}

{%ic%}Sélectionner les comptes qui doivent apparaître : {%endic%}{%input custom.invest.range as:account_collection range:2 default:account_range%}

{% assign accounts = period.accounts.starred|range:account_range%}

{%for current_account in accounts%}

{%assign $22 = 0%}{%assign $23 = 0%}{%assign $24 = 0%}{%assign $25 = 0%}{%assign $26 = 0%}{%assign $27 = 0%}

|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|
|||
|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|
|COMPTE |{{ current_account.number }}| {{ current_account.name|upcase }}||
|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|
||||

{%capture style_titre_amort%}|:—20%—:|:—10%—:|:—6%—:|:—4%—:|:—10%—:|:—10%—:|:—10%—:|:—10%—:|:—10%—:|:—15%—:+{%endcapture%}

{%capture style_corps_amort%}|:—20%----|:—10%—:|:—6%—:|:—4%----:|----10%—:|—10%—:|—10%----:|----10%—:|----10%—:|—15%----:+{%endcapture%}

{% stripnewlines%}
|Description
|Date Acq.
|Méthode
|Durée
|Valeur
Acq.
|Amort.
antérieurs
|Solde
à amortir
|Amort.
ex.
|Amort.
total
|Valeur
nette
{%newline%}{{ style_titre_amort }}{% for detail in current_account.custom.details %}
{% capture investment_key %}investment_{{ current_account.mapped_number }}_{{ detail.key }}{% endcapture %}
{% capture investment_key_depreciations_cy %}{{ investment_key }}_depreciations_current_year{% endcapture %}
{% assign depreciation_current_year = current_account.results.[investment_key_depreciations_cy] %}
{%newline%}
{%newline%}{{ style_corps_amort }}
{%newline%}
|{{ detail.custom.title}}
|{{ detail.date |date:’%d/%m/%Y’}}
|{{ detail.custom.l_d }}
|{{ detail.custom.jr }}
|{%=$22+ detail.custom.value|currency %} {%$32+ detail.custom.value %}
|{%=$23+ detail.custom.vorige_afschr|currency %} {%$33+ detail.custom.vorige_afschr %}
|{{ detail.custom.value-detail.custom.vorige_afschr|currency }}{%$24+ detail.custom.value-detail.custom.vorige_afschr %}{%$34+ detail.custom.value-detail.custom.vorige_afschr %}
|{%=$25+ depreciation_current_year %} {%$35+ depreciation_current_year %}
|{{ detail.custom.vorige_afschr+depreciation_current_year|currency }}{%$26+ detail.custom.vorige_afschr+depreciation_current_year %}{%$36+ detail.custom.vorige_afschr+depreciation_current_year %}
|{{ detail.custom.value-detail.custom.vorige_afschr-depreciation_current_year|currency }}{%$27+ detail.custom.value-detail.custom.vorige_afschr-depreciation_current_year %}{%$37+ detail.custom.value-detail.custom.vorige_afschr-depreciation_current_year %}{%endfor%}
{%newline%}{{ style_corps_amort }}
{%newline%}
|Total compte
|
|
|
|{{ $22|currency }}
|{{ $23|currency }}
|{{ $24|currency }}
|{{ $25|currency }}
|{{ $26|currency }}
|{{ $27|currency }}
{%newline%}{{ style_corps_amort }}
{%newline%}|||||{% endstripnewlines%}

{%endfor%}


{{ style_corps_amort }}
|||
{{ style_corps_amort }}
{%stripnewlines%}|TOTAL EXERCICE
|
|
|
|{{ $32|currency }}
|{{ $33|currency }}
|{{ $34|currency }}
|{{ $35|currency }}
|{{ $36|currency }}
|{{ $37|currency }} {%assign report_valeur_nette = period.reconciliations.vaste_activa.results.mva_netto_bw %}{%assign check_total_valeurnette = $37-report_valeur_nette%}{% if ABS(check_total_valeurnette) <= 0.01 %}{%unreconciled 0 as:indicator%}{%else%}{% unreconciled check_total_valeurnette as:indicator %}{% endif %}
{%newline%}
{{ style_corps_cession }}
{%newline%}
|||||
{%endstripnewlines%}

5

Thank you for your answer.

First, I wanted to link my reconciliation to the vaste activa reconciliation in order to be sure that both reconciliations correspond.

With your solution I will be sure that all (in)tangible assets are full disclosed… It could be a good alternative…