Account reconciliation automation comprises matching process and zero movement analysis. This functionality is useful for certain accounts such as net salary payable, SSO, tax, control accounts and etc. We reconcile them periodically to make their balance zero.

Select figures then click “Zero Move” button.

Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 1 related to Zero Movement Analysis

Figures other than zero in column “Number of zero movement” tell us how many movements with zero balance are ended until this row. In this picture cell M30 is equal to 2 means that there are two movements (K29:K30 and K24:K30) with zero balance.

Select a cell other than zero located in column “Number of zero movement” then click “Show Moves”. Armarecon shows you the beginning and the end of each zero movement by arrows same as above picture. Now you can select one of cells of rows 24 or 29 then click “Match move” to match the zero movement.

Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 2 related to Zero Movement Analysis

Automatic matching by “zero Move” button:

Tick check box then click “zero Move” button. Armarecon will find all zero movements then automatically match them together within account reconciliation automation.

Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 3 related to Zero Movement Analysis

Previous user manual : Quick Sort Detail

Next user manual : Check Match