Reconciliation on Fire is an useful tool that can compare two data ranges from one or more Excel files in order to find the differences. It is designed to automate the checking process when you need to compare large data sheets.
It is recommended for the users that compare bank data files or other types of data that can be exported as worksheets and opened in Microsoft Excel. This tool is a macro that needs to be opened with Excel as well as the files that you want to compare.
Requirements:
· Microsoft Excel
What's New in This Release: [ read full changelog ]
· Fixes a few bugs but adds two new options on the options tab.
· You can choose if you want to ignore zeros. This is could be very convenient if there are many zeros and you don’t care about them. It always ignored blank cells, but now it can also ignore zeros.
· Another feature is to hide the comments. When a discrepancy is found, a comment is created. That could be a problem if there are too many comments. Now they can be hidden. Suppressing zeros and hiding comments are the default settings.