Help Centre › Building Processes
Reconcile two sets of records and report what did not match.
Add it to a process
In the process designer, open the Add step tab. Find Reconcile two sets of records under Process, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| First set (e.g. the ledger) | Yes | Variable holding the first set of records (e.g. the ledger) |
| Second set (e.g. the bank statement) | Yes | Variable holding the second set (e.g. the bank statement) |
| Reference field on the first set | No | Field on the first set holding the business reference |
| Reference field on the second set | No | Field on the second set holding the business reference |
| Amount field on the first set | No | Field on the first set holding the amount |
| Amount field on the second set | No | Field on the second set holding the amount |
| Date field on the first set | No | Field on the first set holding the date |
| Date field on the second set | No | Field on the second set holding the date |
| Amount tolerance | No | How much two amounts may differ and still count as agreeing. Leave blank or 0 for exact. |
| Date window (days) | No | How many days apart two dates may be and still count as the same settlement. |
| Match one record against several that add up to it | No | For invoices settled in instalments, or one payment covering several invoices. Off by default. Default: off. |
| Match references case-sensitively | No | Compare references case-sensitively. Off by default. Default: off. |
| Variable | No | Variable to store the result in Default: reconciliation. |
What it gives back
{reconciliation}{variable}– {matched, breaks, summary} — summary.difference is the headline figure
See all Process steps.