When making a custom account template, you should be aware that the name of your object used for inputting an amount, should be named custom.value .
If you don’t do this (f.i. you name it custom.amount) that object will be an option to filter on in the auto reconciliation (which is not needed, because you use other filters to calculate the value of each filter).
If you have this for example :
The last column never has to be an option for the auto reconciliation (as you see below), while the other columns will be:
This is part of the code I use for above template f.i. :
| {% $0+input detail.custom.amount %}
| {% input detail.custom.impairment %}
| {% $1+input detail.custom.value %}
So detail.custom.amount is a part of the options for auto reconciliation while detail.custom.amount is not.
If my last column would be something like detail.custom.amount_2 f.i., then auto reconiliation would not work: then you would be able to filter on columns, but the value of each filter wouldn’t be calculated in the last column.
So always name your object ‘value’ so the auto reconciliation knows which object needs to calculate with the filters used!