VSTO Add-In Reconciliation for Excel is an excellent tool that carry out bank reconciliations quickly and automatically. It is quite useful to save time and avoid errors associated with doing it manually.
Advantage:
- Saving of time, therefore, increase in the efficiency of the accounting, finance and auditing departments.
- Minimizes errors in manual reconciliations.
- You can use not only for bank reconciliations, but you can reconcile any type of information or transaction.
As a VSTO Add-In for Excel, it uses the tools available in Excel spreadsheets, considerably facilitating its management, analysis and presentation, applying all the benefits that Excel offers us. Reconciliations can be made monthly, weekly and at the convenience of the user.
Types of matching rules can be parameterized to carry out reconciliations, either by code, reference and/or dates, at the user’s convenience, thus facilitating the analysis of unmatched transactions and giving security to the matched transactions with respect to the selected matching rules.
It is frequently used to carry out bank reconciliations, but you can reconcile all kinds, amount or quantities, purchase book and sales book, suppliers, accounts receivable, can be carried out, it is only necessary to have the two files to compare transactions.
In parameters can be configured to carry out the reconciliation by partial amounts, taking into account the common references of the two lists of information or transactions to be compared (many transactions to one transaction), comparing total amounts with partial amounts.
Tolerance can be given in the amounts to reconcile, since generally in accounting there are differences in rounding when recording a transaction.
Complete the reconciliation by using manual reconciliation to reconcile the transactions that for some reason could not be automatically reconciled.