# Verworpen uitgaven using in report

**URL:** <https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959>\
**Category:** Reports\
**Tags:** result\
**Created:** [June 5, 2018, 11:27am UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959 "2018-06-05T11:27:46Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joyce](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@Joyce](https://community.silverfin.com/u/Joyce)\
**Post date:** [June 5, 2018, 11:27am UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/1 "2018-06-05T11:27:46Z")

</div>

I want to use the amount stored in place $23 from my reconciliation " Beroepskosten - EMZ" in my report Kostenvergelijking.

Is that possible?

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 11:48am UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/2 "2018-06-05T11:48:56Z")

</div>

Hello @Joyce,

If it’s a custom made template by yours, you can. You can find the way how here:

> [@Link existing template to new report](https://community.silverfin.com/t/link-existing-template-to-new-report/558/2):
>
> Hello @Dons, Seems to me we overlooked this topic, because we are not automatically triggered for this category (we now are). Our apologies. first of al, in your recon template the result of ‘geldboeten’ needs to have a result-tag, f.i. : Geldboeten = {{ $23 | currency }}{% result 'geldboeten' $23 %} So by adding the code {% result 'geldboeten' $23 %} it actually makes it able to link that result (saved i that register $23) in another template. Also, a handle is needed in the recon-template…

If you’re stuck, let us known and we gladly will help you further.

---

<div class="post-metadata">

**Author:** ![Joyce](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@Joyce](https://community.silverfin.com/u/Joyce)\
**Post date:** [June 5, 2018, 12:14pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/3 "2018-06-05T12:14:17Z")

</div>

| {% t “Verworpen uitgaven” %} | | {% assign verworpen\_uitg = $23 %}{% result ‘verworpen\_uitg’ $23 %}| {{ $23 | currency }}

that is the code that i have now. so I added {% result ‘verworpen\_uitg’ $23 %}

But in my report… do i have to use a formula or a group? and what do i have to fill in to get this result from $23 ?

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 12:21pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/4 "2018-06-05T12:21:36Z")

</div>

Confused here if we are taling about the Silverfin template of “Verworpen Uitgaven” or a custom template you made?

Either way, in the report you need to add a formula and link to the result-tag. So in your example that would be :

`reconciliations.handle_of_your_template.results. verworpen_uitg `

where `handle_of_your_template` is the handle you gave to your custom template (no idea what that is). If it’s the total of our template “Verworpen uitgaven” you can use the handle ‘verworpen\_uitgaven’.

It’s explained here as well:

> [@Link existing template to new report](https://community.silverfin.com/t/link-existing-template-to-new-report/558/2):
>
> Hello @Dons, Seems to me we overlooked this topic, because we are not automatically triggered for this category (we now are). Our apologies. first of al, in your recon template the result of ‘geldboeten’ needs to have a result-tag, f.i. : Geldboeten = {{ $23 | currency }}{% result 'geldboeten' $23 %} So by adding the code {% result 'geldboeten' $23 %} it actually makes it able to link that result (saved i that register $23) in another template. Also, a handle is needed in the recon-template…

If that isn’t clear, please let us known where you are stuck so we can help you forward but also update our documentation.

---

<div class="post-metadata">

**Author:** ![Joyce](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@Joyce](https://community.silverfin.com/u/Joyce)\
**Post date:** [June 5, 2018, 12:24pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/5 "2018-06-05T12:24:06Z")

</div>

it is a custom made reconciliation that i named “Beroepskosten”.  
But did i use the code correctly in my reconciliation? Because i don’t get the result in my report…

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 12:25pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/6 "2018-06-05T12:25:43Z")

</div>

Can you post me your code @Joyce ? Perhaps with a screenshot of the handle of that custom template as well as the formula in the report itself.

If I have that, I can check some thing for you

---

<div class="post-metadata">

**Author:** ![Joyce](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@Joyce](https://community.silverfin.com/u/Joyce)\
**Post date:** [June 5, 2018, 12:26pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/7 "2018-06-05T12:26:38Z")

</div>

{% t= “Detail van de kosten” fr:“Détails des frais” %}

{% t= “Fiscale beperking” fr:“Limite fiscale” %}  
{% t= “Aftrekbaar” fr:“Déductible” %}  
{% t= “Ontvangsten/Baten” fr:“Chiffre d’affaires” %}  
{% t= “Beginvoorraad” fr:“Stock initial” %}  
{% t= “Eindvoorraad” fr:“Stock final” %}  
{% t= “Verkochte voorraad” fr:“Stock vendu” %}  
{% t= “Brutowinst” fr:“Résultat brute” %}  
{% t= “Sociale bijdragen” fr:“Cotisations sociales” %}  
{% t= “Toekenning meewerkende echtgeno(o)t(e)” fr:“Octroi époux/-ouse cooperative” %}  
{% t= “Kosten” fr:“Frais” %}  
{% t= “Nettoresultaat” fr:“Résultat net” %}  
{% t= “niet toegewezen bedrag” fr:“comptant non affectués” %}

{% t= “Kosten mbt bedrijfslokalen” fr:“La location et les frais de location” en:“Rent and rental expenses” %}  
{% t= “Kosten mbt voertuigen” fr:“L’entretien et les réparation” en:“Maintenance and repair” %}  
{% t= “Kantoorkosten” fr:“Les fournitures et les services” en:“Supplies and services” %}  
{% t= “Vergoeding aan derden” fr:“Les frais de tiers” en:“Remuneration to third parties” %}  
{% t= “Kantoorkosten”%}  
{% t= “Administratiekosten”%}  
{% t= “Kosten mbt verzekeringen”%}  
{% t= “Specifieke kosten”%}  
{% t= “Uitzendkrachten”%}  
{% t= “Personeelskosten”%}  
{% t= “Persoonlijke bijdragen”%}  
{% t= “Afschrijvingen”%}  
{% t= “Financiële kosten”%}  
{% t= “Andere bedrijfsopbrengsten”%}  
{% t= “Financiële opbrengsten”%}  
{% t= “Totaal” fr:“Le Total” en:“Total” %}  
{% t= “Andere bedrijfskosten” fr:“Les Divers” en:“Miscellaneous” %}  
{% t= “Extra toelichting” fr:“Explication supplémentaire” en:“Additional explanation” %}  
{% t= “Nr.” fr:“N°” en:“No.” %}  
{% t= “Bedrag” fr:“Montant” en:“Amount” %}

{% if cost\_categories\_string == blank or cost\_keys\_string == blank %}  
{% assign cost\_categories\_string = “Kosten mbt bedrijfslokalen|Kosten mbt voertuigen|Kantoorkosten|Administratiekosten|Kosten mbt verzekeringen|Vergoeding aan derden|Specifieke kosten|Uitzendkrachten|Persoonlijke bijdragen|Personeelskosten|Afschrijvingen|Andere bedrijfskosten|Financiële kosten|Andere bedrijfsopbrengsten|Financiële opbrengsten” %}  
{% assign cost\_keys\_string = “lokalen|voertuigen|kantoor|admin|verzek|derden|specifiek|interim|leider|persoon|personeel|Afschrijving|andere|finkost|bedropbr|finopbr” %}  
{% endif %}

{% assign cost\_categories = cost\_categories\_string | split:"|" %}  
{% assign cost\_keys = cost\_keys\_string | split:"|" %}

{% capture table %}

* * *

|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+  
| **{% t “Detail van de kosten” %}** | **{{ period.year\_end\_date | date:’%Y’ }}** | **{% t “Fiscale beperking” %}** | **{% t “Aftrekbaar” %}**

* * *

{% for cost\_category in cost\_categories %}{% assign $11 = 0 %}{% assign $13 = 0 %}{% assign $14 = 0 %}{% assign category\_key = cost\_keys[forloop.index0] %}  
| **{{ cost\_category }}** {% input custom[category\_key].accounts as:account\_collection range:6,7 accounts\_var:costs %} |  
|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+{% for account in costs %}  
|{{ account.name }}|{%=$11+ -1_account.value %}|{% input custom[account.number].beperking as:percentage %}{% if custom[account.number].beperking == blank %}{% assign beperking = 1 %}{% else %}{% assign beperking = 1-custom[account.number].beperking %}{% endif %}{% $13+ -1_beperking_account.value %}|{%=$14+ -1_beperking\*account.value %}{% if forloop.last %}  
| | **{% =$21+ $11 | currency %}** | **{% =$23+ $11-$13 | currency %}** | **{% =$1+ $14 | currency %}** {% result category\_key $14 %}  
|{% endif %}{% endfor %}{% endfor %}

* * *

|-----------40%--------------:|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+  
| **{% t “Totaal” %}** | **{{ $21 | currency }}** | {{ $23 | currency }} | **{{ $1 | currency }}**

* * *

{% endcapture %}

{% if custom.detail.goederen == blank %}{% assign goederen\_range = ‘60’%}{% else %}{% assign goederen\_range = custom.detail.goederen %}{% endif %}  
{% assign goederen = period.accounts | range:goederen\_range %}

|---------------------|-------15%-------:|-------15%-------:|-------15%-------:+  
| {% t “Ontvangsten/Baten” %} {% input custom.detail.omzet as:account\_collection range:7 default:‘70’ accounts\_var:omzet %}| | | {%=$10+ -1_omzet.value | currency %}{% for account in omzet %}  
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ account.name }}|{{ -1_account.value | currency }}{% endfor %}{% ifi goederen.value != 0 %}  
| {% t “Handelsgoederen, grond en hulpstoffen” %} {% input custom.detail.goederen as:account\_collection range:60’ %}| |{{ -1_goederen.value | currency }}{%  
for account in goederen %}  
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ account.name }}|{{ -1_account.value | currency }}{% endfor %}  
| {% t “Beginvoorraad” %} {% input custom.detail.beginvoorraad as:account\_collection range:6,7 accounts\_var:beginvoorraad %} {% input custom.beginvoorraad.doc as:file %}| | {{ -1_beginvoorraad.value | currency}}  
| {% t “Eindvoorraad” %} {% input custom.detail.eindvoorraad as:account\_collection range:6,7 accounts\_var:eindvoorraad %} {% input custom.eindvoorraad.doc as:file %}| |\_{{ -1_eindvoorraad.value | currency}}\_  
| {% t “Verkochte goederen” %}|||_{%=$10+ -1\*(beginvoorraad.value+goederen.value+eindvoorraad.value) | currency %}_  
| {% t “Brutowinst” %} ||| **{{ $10 | currency }}** {% endifi %}{% ifi custom.detail.echtgenote != blank %}{%  
for account in sociale\_bijdrage %}  
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ account.name }}|{{ account.value | currency }}{% endfor %}  
| {% t “Toekenning meewerkende echtgeno(o)t(e)” %} {% input custom.echtgenoot.doc as:file %} | {% input custom.detail.echtgenote as:currency %} | | {%=$10+ -1_custom.detail.echtgenote | currency %} {% endifi %}{% assign bruto\_winst = $10 %}  
| {% t “Kosten” %} | | |{% =$10+ $1 %}  
| {% t “Nettoresultaat” %} | | | **{{ $10 | currency }}**  
|{% fori extra\_account in custom.extra\_accounts %}  
|{% input extra\_account.name %} {% input extra\_account.accounts as:account\_collection range:6,7 %}{% input extra\_account.doc as:file %} | | |{% assign accounts = period.accounts | range:extra\_account.accounts %}{%=$20+ -1_accounts.value | currency %}{% endfori %}  
|  
|{% capture detailmeerminderwaarde %}

* * *

|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+  
| **{% t “Detail van de meer- en minderwaarden” %}** | **{{ period.year\_end\_date | date:’%Y’ }}** | **{% t “% Fiscaal beperkt” %}** | **{% t “Belastbaar” %}**

{% stripnewlines %}

## {% newline %}

{% newline %}  
{% newline %}

{% newline %}{% ifi custom.meerwaarde.accounts != blank %}  
|-----------40%--------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+  
{% newline %}  
| **Meerwaarde** {% input custom.meerwaarde.accounts as:account\_collection range:76 accounts\_var:meerwaarde %}||||  
{% newline %}  
{% for meer in meerwaarde %}  
{% assign toegewezen = toegewezen | append: account.number | append:";" %}  
| {{ meer.name }}  
| {%=$2+ -1_meer.value | currency %}  
| {% input custom[meer.number].beperking as:percentage placeholder:‘0.00%’ %}  
{% if custom[meer.number].beperking == blank %}  
{% assign beperking = 1 %}  
{% else %}  
{% assign beperking = 1-custom[meer.number].beperking %}  
{% endif %}  
{% $5+ -1_beperking_meer.value_meer.value as:currency %}  
| {%=$4+ -1_beperking_meer.value as:currency %}  
{% newline %}  
{% endfor %}  
{% newline %}  
{% newline %}{% endifi %}

{% newline %}{% ifi custom.minderwaarde.accounts != blank %}

{% newline %}  
| **Minderwaarde** {% input custom.minderwaarde.accounts as:account\_collection range:66 accounts\_var:minderwaarde %}|  
{% newline %}  
{% for account in minderwaarde %}  
{% assign toegewezen = toegewezen | append: account.number | append:";" %}  
| {{ account.name }}  
| {%=$2+ -1_account.value | currency %}  
| {% input custom[account.number].beperking as:percentage placeholder:‘0.00%’ %}  
{% if custom[account.number].beperking == blank %}  
{% assign beperking = 1 %}  
{% else %}  
{% assign beperking = 1-custom[account.number].beperking %}  
{% endif %}  
{% $5+ -1_beperking_account.value_account.value as:currency %}  
| {%=$4+ -1_beperking_account.value as:currency %}  
{% newline %}  
{% endfor %}  
{% newline %}{% endifi %}

{% newline %}  
{% newline %}  
{% newline %}  
{% newline %}  
{% endstripnewlines %}  
|----------40%---------------:|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+  
| **{% t “Totaal” %}** | **{{ $2 | currency }}** | | **{{ $4 | currency }}**

* * *

{% endcapture %}  
| {% t “Verworpen uitgaven” %} | | {% assign verworpen\_uitg = $23 %}{% result ‘verworpen\_uitg’ $23 %}| {{ $23 | currency }}  
| {% t “Investeringsaftrek” %} | | | {% input custom.detail.investaftrek as:currency %}  
{% assign proef= ($10+$23-(-1_custom.detail.echtgenote)) %}  
{% ic %}_{% t “proef” %} {{ proef | currency }}\*{% endic %}

{% newpage %}

{{ table }}  
{% ifi anderebo.value != 0 %}  
{{ detailmeerminderwaarde }}{% endifi %}

{% assign niet\_toegewezen = #6-#619999+#7+(bruto\_winst+$0+$21+$20+$2)-(-1\*custom.detail.echtgenote) %}  
{% unexplained niet\_toegewezen %}

{% ic %}_{% t “niet toegewezen bedrag” %} {{ niet\_toegewezen | currency }}_{% endic %}

{% ifi custom.extra.bijlage.document or custom.extra.toelichting != blank %}

{% stripnewlines %}

| ------ |
| --- |

{% newline %}  
| **{% t “Extra toelichting” %}**  
| {% input custom.extra.bijlage as:file placeholder:’’ %}  
{% endstripnewlines %}

{% input custom.extra.toelichting as:text size:mini placeholder:’’ %}  
{% endifi %}

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/1X/80cfc48306f94ad3ab74c34f362044216a686f94.png)

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 12:30pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/8 "2018-06-05T12:30:30Z")

</div>

I see your handle is `beroepskosten` but in your formula you use this:

`reconciliations.beroepskosten .results.verworpen_uitg`

You can’t have a space in your handle @Joyce. Can you try with that, without the space? So remove it in your template of the space is there too, and also in your formula.

---

<div class="post-metadata">

**Author:** ![Joyce](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@Joyce](https://community.silverfin.com/u/Joyce)\
**Post date:** [June 5, 2018, 12:31pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/9 "2018-06-05T12:31:22Z")

</div>

yes… i also found it… working too fast 🙄

now i have another thing with this.  
Can i use an amount from my report in my reconciliation?

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 12:36pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/10 "2018-06-05T12:36:51Z")

</div>

Yes @Joyce,

That can be found here as well:

> [@Result-tag in text-template](https://community.silverfin.com/t/result-tag-in-text-template/866):
>
> @sven Can you tell me how you get a result of a category u use in a report, to be shown in a text-template ? I guess it has something to do with the handle an tag you give in that report, but does their has to be a reference like period.reconciliation.(handle-name).results.(tag) ? Thx in advance for the answer !

I’ll close this topic for now, so people will find the solution quicker and topics don’t get overloaded with all kinds of questions (see why we do this, [here](https://community.silverfin.com/t/new-in-community-new-to-coding-templates-read-this-first/941/2) ).

Good luck, and don’t hesitate to create a new topic if you’re stuck. Thanks for your contribution to our Community!

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 5, 2018, 12:37pm UTC](https://community.silverfin.com/t/verworpen-uitgaven-using-in-report/959/11 "2018-06-05T12:37:01Z")

</div>

Closed on June 5, 2018, 12:37pm UTC