Reconciliation provides a valuable tool to reconcile differences between data in different Excel sheets or tabs with the click of a button. Designed as a macro for Excel 2010, it will rapidly search and present discrepancies in large data sets in your spreadsheets, matching any two sets of cells.
This is not a traditional software tool so much as a macro for Excel, allowing you to compare large data sets. The act of doing so can be time consuming on its own, and this macro speeds it up many times over. Installation is not required. Simply open the macro and it will be integrated into Excel for immediate use. While it has limitations (it works much better with text-formatted reconciliation than number-formatted), it is quite fast, running through lists of 1,000, 2,000, and even 10,000 cells in our tests in comparable times. The size doesn't seem to impact the overall efficiency any more than that size spreadsheet would already tax your computer. There are few options and the process only has one button, but if you frequently compare data sets, then this is a very useful tool.
Reconciliation on Fire takes only a couple of minutes to download and start using and it provides immediate, easy comparison features for your Excel spreadsheets. If you are eager to take action and streamline how fast you perform reconciliation tasks, then this is a must.
If you have ever had to compare a fairly large amount of numbers that just won't tie to another set of numbers, then you will understand why this is important. It is a major undertaking if there are many numbers. Sometimes it even requires two people. One person will read the numbers and the other will check the list. An enormous percentage of time is spent finding the proverbial needle in the haystack.
This product will make it much much much easier. It is so easy to use that even if you have just ten numbers you need to compare against another set of ten numbers, you'll be tempted to use it. Another reason to use this is because we now are looking at other types of data. It used to be that we only cared about making sure the totals tied out. Now we have so much software that we need to look at dates and other numbers that don't get totaled, like check numbers. Reconciliation on Fire also looks for inconsistencies in dates and check numbers. It even compares purely textual data like names. So if you have a list of names that may not have the same consistent spelling, then Reconciliation on Fire will also find those inconsistencies.