Reconciliations Expenses

Templates
1

We have created a report which uses the data from "(reconciliations.expenses.results.xxxxxx). With this report we want to compare the results of sole traders between different periods (e.g. two years). We chose to work with (reconciliations.expenses.results) because it was necessary the fiscal limitation of costs was also taken into account.

The downside of this is that we only have totals of certain groups of costs, without any details of the costs.

How can we make a report that compares the (fiscal limited) costs of two different periods?

2

Hi @BartDewulf ! Thanks for posting your question on community, and our apologies for the delay in our response.

Your report makes use of results which are ‘sent’ from the reconciliation template ‘Business Expenses’, and ‘received’ in your report, via the tag reconciliations.expenses.results..

I have looked up the code in this template, and it is true that the cost categories consist of groups of accounts, which we call ranges. If you want to break these down and use them in your report, that is possible but you will need to copy the ‘Business Expenses’ (bedrijfskosten) code into your own custom template.

Before you start coding, make sure you are familiar with the Silverfin documentation https://developer.silverfin.com/docs, and try to make efficient use of our community info: New in Community? New to coding templates? Read this first.

Community threads closely related to your topic can be found here: Beroepskosten - reconciliation, Beroepskosten 2.0 - default accounts with categories, Beroepskosten - refer to each account separately or just enter ‘Beroepskosten’ in the community search bar.

The first step in your approach, should be to determine on which level you would like to be able to show the amounts in your report. Next, in your custom template, you should add result tags to your code in order to send the amounts you want.

To give you some clue, in the original Beroepskosten template, have a look for the following code:

In 88:
    {% assign goederen_range = custom.detail.goederen | default:trade_goods_default %}

In 338:
    {% assign goederen = period.accounts | range:goederen_range %}
    {% ifi goederen.name != blank %}
    {% newline %}
    | {% t "Handelsgoederen, grond en hulpstoffen" %} {% input custom.detail.goederen as:account_collection range:trade_goods_range default:trade_goods_default %}| |{{ -1*goederen.value | currency }} {% result 'trade_goods' -1*goederen.value %}
    {% for account in goederen %}
      {% $32+ account.value %}
      {% newline %}
      |      {{ account.name }}|{{ -1*account.value | currency }}
    {% endfor %}

What happens here, is that the range for ‘goederen’ is determined using an accounts selector custom.detail.goederen. Read about accounts selectors on https://developer.silverfin.com/docs/input.

To add detailed results for this category, you can consider adding result tags within the loop (starting with {% for… ), which will send the account.value for each account under the ‘goederen’ range. This will send one amount for each account. Read more on result tags in https://developer.silverfin.com/docs/result and CASE reference values across templates by using result tags.

Hopefully this helps you a little. Creating a custom template is not easy. Therefore do not hesitate to post any of your questions here or in another community thread.

Good luck!