|Automating Reconciliation Work|
|Use your computer to compare and reconcile data.|
|File Size:||56 KB|
|Date Added:||Aug 2001 (revised Sep 2004)|
|Requirements:||Microsoft Excel 97 and higher|
and comparing sets of data to extract differences is a common task in
the accounting and audit profession. It is also required in many
other professions such as scientific research.
This Excel spreadsheet template demonstrates and explain 8 steps to use spreadsheet software to do reconciliation work. The technique is useful for very large sets of data which are impossible to compare manually by hand. The same technique explained here can also be used in database software to compare even larger sets of data.
We revised the spreadsheet on 25 September 2004 to further refine the technique demonstrated. We added 3 extra steps to make the reconciliation technique absolutely foolproof.
|Discuss this Product new|
|Discuss this product on Google Groups.|
Copyright 2014 Francois Andlau - all rights reserved