If you are an accountant, an auditor, or marketing people, you must be familiar with reconciliation(check two sets of data, usually two tables, for similarities and differences). Athough you may not feel boring, the efficiency and accuracy is a problem. You can use Isolist to ease your work.
Suppose you have two tables(as two spreadsheets in Excel). One is the subscription table recording which customer subscribes for what amount of money on which day. The other table records the detailed invoice information such as on which day the invoice is issued for which customer and the amount involved. As an accountant, you need to check the two tables for consistency. If there is a subscription entry in the first table without matching entry in the invoice information table, there would be a problem. Note that the tables are large(more than 1000 rows), which makes it hard to check manually. Isolist can be used here to do the work and will cost less than one minute.
Invoice Information Table
Isolist is an Excel plugin shown as a button on ribbon. Now click the “Match and Reconcile” button,
match and reconcile button on Excel
you will see the GUI of Isolist,
Click “Next” button to continue. You need to specify which two tables(spreadsheets) you want to compare and match. Input the names of the two sheets and which fields to be reconciled(in this case the amount field in the subscription table and the gross field in the invoice table need to be consistent). Click “Next” button to continue.
The second table to be matched.
Now you need to specify one or more matching rules, which tell Isolist how to extract a row in the first table and a row in the second table to compare. In this case, we want to extract a row in the subscription table, then extract the row in the invoice table that has the same customer id and proximate date (+/- 3 days) to the date in the subscription row(because usually an invoice is issued near the subscription date), and compare the amount field(in the subscription table) and the gross field(in the invoice information table) to see if they are equal. So we add two matching rules: one requires CustIDs are equal for the two rows from the two tables, the other requires the dates are near. Click “Next” button to continue.
add match rules
Isolist matching rule 1
Isolist matching rule 2
Here we can choose various reporting options. We can let Isolist add a column to the two tables to show whether the row is reconciled or not. We can also let Isolist generate a detailed report and summary report about the reconciliation status. Click “Finish” button, Isolist begins to execute the reconciliation, and generate the results in a short time.
Isolist result options
Now we can see the results. Every row in the table is added a new column showing “Reconciled”(which means a matching row in the other table is found), or “Not matched(which means a matching row in the other table is NOT found). We also get a summary report.
Isolist result 1
Isolist result 2
Isolist result 3
From the above reports, you can easily find potential problems (Not matched rows) that need further investigation. The whole process takes minutes to complete. Isolist saves you big time.
Click here to know more about Isolist.
Click the following links to buy Isolist with big discount.
Reconciliation Software – Reconcilable.com
Reconcilable can reference lookup tables and calculate values on your data, reducing the need for manual data preparation or ETL tools. Report and export Tailor reports to meet your needs, then save them for re-use. Build report books to deliver a complete report pack in a single action. Share data with Excel
20 Best Reconciliation Software in 2022 | Get Free Demo
- Lendio. Write a Review. Visit Website. Request Demo. Get Quote. Lendio is a fully featured Accounting Software designed to serve Enterprises, SMEs and StartUps.
- Redwood. Write a Review. Visit Website. Free Demo. Get Quote. Redwood SaaS Workload Automation simplifies enterprise automation with end-to-end process orchestration.
- Sage 50cloud. Category Champions. 4.6(12 Reviews) Free Demo Get Pricing. Sage offers a complete desktop accounting software that helps you spend less time managing your accounts and more time developing your business.
- EASYGST – GST Return Filing & Reconciliation Software. Category Champions. 5(6 Reviews) Free Demo Get Pricing. Simplifies the GST Return filing Process for Chartered Accountants, Tax Professionals & Corporates.
- Firmway. Contenders. 4.3(3 Reviews) Free Demo Get Pricing. India’s premier online software for Account confirmation and reconciliation. Our solutions help companies in automating the current process hence improving their operational efficiencies.
- enReconcile. 5(1 Review) Free Demo Get Pricing. enReconcile by Taxilla offers most advanced innovation to deliver highest efficiency, accuracy and cost-advantage.
- Recosso. Category Champions. 5(1 Review) Free Demo Get Pricing. Recosso is a reconciliation tool which will help you to reconcile your digital payment in real time and reduce human errors.
- ReconArt. Emergents. Write a Review. Free Demo Get Pricing. Do you find it hard to get a hold over transaction lifecycle? Then use ReconArt, the innovative reconciliation software.
- AutoRec. Emergents. Write a Review. Free Demo Get Pricing. Do an effortless import and export of any detail with the help of AutoRec, the cloud-based reconciliation software.
- Statement Matching. Emergents. Write a Review. Free Demo Get Pricing. Keep a track overall credit card notes, miss-posting and over-payment issues with the notification and alert feature of Statement Reconciliation, the leading reconciliation software.
Reconciliation Software – 2022 Reviews, Pricing and Demos
Reconciliation software automates the account reconciliation process to create accurate, high-quality financial statements.
Best Reconciliation Software Solutions in 2022 | Try Free …
- Lendio. Software by Lendio. Write a Review. Visit Website. Request Demo. Get Quote. …
- Redwood. Reliably orchestrate any process with Redwood SaaS. Write a Review. Visit …
- BlackLine. Emergents. Software by BlackLine Inc. Write a Review. Free Demo Get Pricing. …
- Xero. Category Champions. Software by Xero Limited. 4.8(13 Reviews) Free Demo Get …
- Adra Accounts. Emergents. Software by Trintech. Write a Review. Free Demo Get Pricing. …
- Traverse Distribution. Emergents. Software by Open Systems Inc. Write a Review. Free …
- OneStream XF. Contenders. Software by OneStream Software LLC. 5(1 Review) Free …
- Gresham. Contenders. Software by Gresham Technologies plc. 5(1 Review) Free Demo …
- Flare. Emergents. Software by Flares Inc. Write a Review. Free Demo Get Pricing. …
- Statement Matching. Emergents. Software by Statement Matching. Write a Review. Free …
Isolist Excel Add-In Download – Isolist adds powerful …
Jul 26, 2022 · Isolist Excel Add-In. 2.0. Isolist adds powerful reconciliation functions to Excel, making it the fastest and easiest tool available for reconciling your data.
Isolist Reconciliation Software (7 Downloads) – Zedload
Crack in this context means the action of removing the copy protection from software or to unlock features from a demo or time-limited trial.
Isolist for Excel adds powerful reconciliation functions to Excel.
Isolist can help beginners or occasional users to complete their reconciliations more easily and will help even experienced pros to get their work done much faster. Download Now 1.
13 Best Bank Reconciliation Software | 2023 Reviews, Pricing
Dec 30, 2019 · ReconArt is a world class reconciliation software designed to work with a large variety of business scenarios.
5 Best Reconciliation Tools: Complete Guide – SolveXia
Sep 11, 2020 · 5 Best Reconciliation Tools: Complete Guide Reconciliation tools automate the financial close process and will maximise your team’s productivity.
Isolist Excel Add-In (free version) download for PC
Jul 10, 2011 · From the developer: Isolist adds powerful reconciliation functions to Excel, making it the fastest and easiest tool available for reconciling your data.
Isolist Standard Single User Download
Nov 18, 2012 · Isolist adds powerful reconciliation functions to Excel, making it the fastest and easiest tool available for reconciling your data. Unlike ‘…
Best Reconciliation Software – 2022 Reviews & Comparison
Reconciliation software, also known as bank reconciliation or account reconciliation software.
9 Reasons to upgrade your reconciliation software – LinkedIn
Apr 01, 2020 · Our experience within the financial services industry has revealed that firms’ outdated reconciliation software have 9 key problems: Rarely deliver continued operational …
Odoo 14 Reconciliation Tool – ERP GAP
Oct 23, 2020 · Reconciliation Models The Odoo Reconciliation Model is great for automating and expediting the process of your reconciliation by telling Odoo what information to look for …
GL Payroll Reconciliation Tool – University of California, Los Angeles
May 03, 2021 · The GL Payroll Reconciliation Tool offers several important benefits: Provides detailed step-by-step instructions to the user.
Test version launched for new Excel reconciliation tool
May 25, 2007 · AccountingWEB. 25th May 2007. Former management accountant Jim Johnson has turned his hand to programming to create Isolist.
Reconciliation In Excel Software – Free Download … – WinSite
Reconciliation In Excel Software – Free Download Reconciliation In Excel Reconciliation In Excel Software Remove Hyperlinks In Excel v.1.0.2.