Bank reconciliation automation is easy, if check number column is available. Therefore, we advise you to use this feature of Armarecon. At first step, Click “Check Match” button then select one cell of “Check number” column. After that Armarecon matches all figures with the same check number with balance less than field “Check number matching difference” box in setup tab. We set value of this box zero as default. Therefore, Armarecon matches those figures with the same check number and balance zero in bank reconciliation automation.

Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 1 related to Check Match
Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 2 related to Check Match

Note: “Check Match” button main function is matching figures with same check number. You also can use it for any common data other than check number such as supplier code, customer code, etc.

Previous user manual : Zero Movement Analysis

Next user manual : Extract Check Number