Isolist has many features that elevate it's capabilities far above what can be achieved using Excel formulae such as VLOOKUP.
- Up to 65,0000 rows per list.
- Value reconciliation Isolist reconciles two lists together and compares the value associated with each row - the standard functionality required by accountants, auditors and others.
- VBA automation Start a reconciliation process from your Excel VBA code using a custom procedure method provided with Isolist. Great for those situations where your reconciliation task is part of a larger automated process.
- Multiple matching rules Within a single reconciliation task, use several matching rules to define which rows from each list should match. Each rule creates a relationship between a column from each list:- multiple rules let you use several columns to build up the complete logic you need to match rows between the two lists. more
- Multiple reconciliation stages Split your reconciliation task into two or more stages to apply different matching rules or tolerances to different rows in your data. Use this feature either when your lists contain different row or transaction types that require specific rules to be matched, or else to provide alternative matching rules for rows that fail to match using more strict criteria. more
- Row filters Apply a reconciliation or a reconciliation stage to a subset of the rows in your lists by using Row Filters.
- Variable tolerance Choose the precision you require when comparing the values from each row.
- Proximal date match When you expect your transactions to occur close together in time, but not necessarily on the same day, then match them with a Proximal Date match type. You can specifiy how many days apart the transactions may be whilst still counting as matched.
- Search match If your matching term is embedded somewhere within a longer field of text, use a Search match. In a Search match, the cell-value from one list is searched within the cell values from the other list and a match is made where the value is found.
- Named lists Give your lists a name to identify them easily in the reports produced by Isolist.
- One-to-one reconciliation Reconcile single rows from one list with single rows from the other list. If several rows are found with the same matching criteria then Isolist chooses those closest in value to match first.
- Group-and-sum reconciliation Used for one-to-many or many-to-many matching. where Isolist finds multiple rows with the same matching criteria, their values are summed together before being compared with the row sum on the other side. more
- Source list result labels Appends a Reconciliation Status column to each source list range, showing the reconciled or not-reconciled status of each row directly against your original data. Where a row is reconciled one-to-one, the reconciliation status doubles as a hyperlink to the matching row in the opposite list.
- Standard reports Get clear, detailed output from your reconciliation process with a standard report. Standard reports can show unmatched rows, reconciled rows (either individually or grouped and summed) or merged rows (lists all rows from both lists side by side, with reconciled rows aligned).
- Customized reports When you need your reconciliation output in a specific layout or style, use a custom report template. Isolist completes the given template with the actual results from your reconciliation.
- Configuration memory Isolist automatically memorizes the configuration you last used when reconciling, so there's no need to re-configure each time you run the same task.
- Specify list by sheet This is the quickest and easiest way to tell Isolist which cell-range in your workbook contains a list to be reconciled. Simply select a worksheet and Isolist will search for the precise range containing your list data.
- Specify list by range When you need more control over which cell-range contains your list data, specify it by range, using the range address or the name of a named range.