How to reconcile automatically?

Templates
,
1

We would like to add to the reconcilitation template ‘Liquide middelen’ that if none of the 55-accounts is <0, the template is shown as reconciled (no manual input needed).

{% ic %}
{% if #55 < 0 %}
{::warningtext}
Negatieve banksaldi individueel overboeken naar rubriek 43!
{:/warningtext}
{% endif %}
{% endic %}

2

Hi @sylvia.debaeremaeker,

you could look at the end-value of each account, and take a value other than zero to a register if the account value is less than zero. That register can then be used in a unreconciled-tag, like this:

{% for acc in period.accounts.55 %}
  {% if acc.value < 0 %}
    {% $0+ 1 %}
  {% else %}
    {% $0+ 0 %}
  {% endif %}
{% endfor %}

{% unreconciled $0 %}

Can you let me know if this works for you?

3

Hi Sven

No, i still have a red triangle.

4

Can you post your coding you use @sylvia.debaeremaeker ? gladly to take a look at it

5

{% for acc in period.accounts.55 %}
{% if acc.value < 0 %}
{% $0+ 1 %}
{% else %}
{% $0+ 0 %}
{% endif %}
{% endfor %}

{% unreconciled $0 %}

6

Okay @sylvia.debaeremaeker,

That’s my code used for a simple example to you :slightly_smiling_face: Are you sure that is enough?

Anyway, if you would use my code, then you need to set the type of reconciliation into this:

42

Because that would put the template automatically on green. If you don’t have this setting, you probably configured it that data needs to be inputted first before reconciling, no?

More info here as well: