Verworpen uitgaven using in report

[Joyce]

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

Is that possible?

[sven]

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

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.

[Joyce]

| {% 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 ?

[sven]

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

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.

[Joyce]

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…

[sven]

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

[Joyce]

{% 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+ -1account.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+ -1beperkingaccount.value %}|{%=$14+ -1beperking*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+ -1omzet.value | currency %}{% for account in omzet %}
|      {{ account.name }}|{{ -1account.value | currency }}{% endfor %}{% ifi goederen.value != 0 %}
| {% t “Handelsgoederen, grond en hulpstoffen” %} {% input custom.detail.goederen as:account_collection range:60’ %}| |{{ -1goederen.value | currency }}{%
for account in goederen %}
|      {{ account.name }}|{{ -1account.value | currency }}{% endfor %}
| {% t “Beginvoorraad” %} {% input custom.detail.beginvoorraad as:account_collection range:6,7 accounts_var:beginvoorraad %} {% input custom.beginvoorraad.doc as:file %}| | {{ -1beginvoorraad.value | currency}}
| {% t “Eindvoorraad” %} {% input custom.detail.eindvoorraad as:account_collection range:6,7 accounts_var:eindvoorraad %} {% input custom.eindvoorraad.doc as:file %}| |_{{ -1eindvoorraad.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 %}
|      {{ 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+ -1custom.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+ -1accounts.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+ -1meer.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+ -1beperkingmeer.valuemeer.value as:currency %}
| {%=$4+ -1beperkingmeer.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+ -1account.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+ -1beperkingaccount.valueaccount.value as:currency %}
| {%=$4+ -1beperkingaccount.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-(-1custom.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 %}

[sven]

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.

[Joyce]

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?

[sven]

Yes @Joyce,

That can be found here as well:

Result-tag in text-template

@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 ).

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