Effective reconciliation

There are some tips that helps you to perform effective reconciliation of accounts. We update this part based on feedback of users in future.

• Save your file with new version within matching process in order to not miss data in case of hanging.
• As first step, use “Check match” button in case of existing check column or common identical data such as supplier code, customer code, etc.
• Use quick sort in next step to match one by one combinations to reduce unmatched figures as much as possible. Less unmatched figures means faster engine output in next steps that is important for effective reconciliation of accounts.
• In case of exiting some figures that will not be matched with other figures at all. Use predetermined match reference such as “Temp” in order to remove that figures from matching process temporarily. You will remove “Temp” reference at the end of matching process to report them as unmatched figures.
• In next step, run engine to find (1-X) one by two, one bye three and others separately (do not use accumulated in huge data). Do the same for 2-X and 3-X.
• Run engine daily with 1 day and match figures then increase number of days based on system power and your experience. The aim is to divide figures to groups with less number of figures in order to reduce number of possible combination.
• Find optimized maximum figures in each scan and update related box in setup page
• Find optimized engine max time process then update related box in setup page. This avoids missing data and time in case of hanging.