Unreconciled

Unreconciled tags are used to indicate whether or not a template (account or reconciliation template) is reconciled; this is used quite often and has a direct impact on the progress of the workflow.

When all unreconciled tags have zero as an outcome (not to be mistaken for empty), the template will be fully reconciled and a green dot will be visible at the template level.

{% assign income_accounts_total = period.accounts | range:"70" %}
{% unreconciled -income_accounts_total-table_total %}

📘

A common scenario is detailing amounts in a table, then checking that value against the value on the trial balance. In the example above we take the income accounts, so we invert it with a minus, and the local variable table_total which is the sum of all inputs. It's also common to have users detail information as positives, so the table_total does not need its sign reversed.

Formula equal to zero (reconciled)

Formula different from zero (unreconciled)

Unreconciled as indicator

When using more than one unreconciled tag, it can become hard to see which parts of the template need to be reconciled.
Therefore we suggest to always use the unreconciled tag as an indicator: this means the output of the formula in the unreconciled tag will be made visible with a red triangle (in case of unreconciled) or a green dot (in case of reconciled).

{% unreconciled -income_accounts_total-table_total as:indicator %} {{ -income_accounts_total | currency }}

Formula equal to zero (reconciled)

Formula different from zero (unreconciled)

📘

UX consideration

Even if there is only one unreconciled tag in your template, it's good UX to display the indicator either way. It helps users find which part of the template is affecting the reconciliation status.

Unreconciled text attribute

When the indicator is unreconciled (red triangle), you can add a string of text to explain the difference by adding the unreconciled_text attribute.

{% unreconciled -income_accounts_total-table_total as:indicator unreconciled_text:'Difference explanation' %}

Output

If you don't use the text attribute on an unreconciled indicator, hovering over it will just show the outcome of the formula.

Output