Data Reconciler

The simple way to compare and reconcile data.

DataRECONCILER™ is a powerful online data reconciliation tool that compares two sets of data.  If you spend hours or days a month reconciling different versions of data, DataRECONCILER will reduce this time tremendously.  It supports data in Microsoft Excel and Comma Separated Value (CSV) file formats that are common export formats for most database and accounting systems.   You can use DataRECONCILER for more than reconciliations; you can compare any two sets of numbers and or text.  For example compare trial balances from different periods, or payroll data from different months, or two versions of budget files for their differences, or even two different contact lists.

Typical Uses of DataRECONCILER Include:

• To reconcile external records to internal records, such as bank statements to cash book transactions, or determine which checks and deposits are still outstanding.

• To reconcile two accounts that represents the same information, such as inter-company accounts or branch office control accounts.

• To migrate data from an old system to a newer system.

• To interface between two different systems, such as your CRM and your order entry system, Microsoft Outlook and Lotus Notes.

• To compare an earlier set of accounting data to a newer set of data, like closing balances to opening balances.

• Comparing vendor shipping records to internal receiving logs.

• Identify and flag large variations in the market value of individual stocks or mutual funds in a portfolio.

• Compare sales pipeline data from different periods for lost sales reporting.

 

Easy to Use

DataRECONCILER requires no downloads or installation of software on your computer.  We provide a secure web hosted software application for file comparisons.   The process is easy. Once you’ve subscribed to the service and created your user ID and password, simply log on to our website, select the files on your computer and upload them to our hosted reconciliation engine.  Then use the configuration wizard to select the parameters from which to do the comparison and DataRECONCILER does the work and provides you back the results.  Your data is safe and secure during the entire process.  All communication between your PC and the application is encrypted* by utilizing a secure 128 bit SSL Internet protocol.  This security covers all site navigation and file uploads and downloads. Our standard subscription service does not include retention of any of your data.  Once your data has been reconciled and you download the results back to your computer it is erased from our server at that point.  Only your comparison parameters (configurations) are saved for future reconciliations.  We do offer a data storage feature where you can save your files as well as your comparison parameters on EMA Softech’s server.

DataRECONCILER Feature List

RECONCILIATION CAPATILITY
Maximum number of rows per list 65,000
Maximum number of columns 255
Maximum number of usable characters per cell 255
Reconciled value precision Unlimited
Value reconciliation Yes
Multiple matching rules Yes
Create custom mapping table between dissimilar elements Yes
Save rules and layouts of source files Yes
MULTIPLE RECONCILIATION STAGES
Number of columns or data items to match in a single rule Unlimited
Define up to 5 independent matching rules at each reconciliation stage Yes
Variable tolerance Yes
MATCHING VALUES
Equals match Yes
Text-to-text Yes
Number-to-number Yes
Text-to-number Yes
Case-insensitive Yes
Tolerant of leading and trailing white space characters Yes
Allows for customized stripping of leading and trailing characters Yes
Proximal date match Yes
Matches within set number of days (1 to unlimited) Yes
Search match Yes
Ability to add custom calculation fields for matching and reporting Yes
MULTIPLE ROW OPTION
One-to-one Yes
One-to-many Yes
Many-to-many Yes
Group & sum Yes
REPORTING OPTIONS
Source list results labels Yes
Standard reports Yes
Customized reports Yes
Summary task reports Yes
Multiple report formats available (.xls, .pdf, .xml, .csv, .txt) Yes
USABILITY FEATURES
Wizard user interface Yes
Upload entire Excel workbook / select spreadsheet (TAB) to use Yes
Saved configurations (comparison rules) Yes
Automatic header identification Yes
Automatic column layout and data type identification Yes
Flexible input file formats Yes
PLATFORM SUPPORT
Web based – Internet application Yes
Web based / Hosted Application / SaaS Model (Software as a Service) Yes
Internal web server based application (private cloud) Yes / Optional
Reconciled data / reports stored on user PC Yes / Optional
Original source data and reconciled data stored on EMA Softech server Yes / Optional
Web browser support IE 6.0+; Firefox;
Google Chrome
Desktop application No
Calculation done on user PC No
Microsoft Excel plug-in No
Microsoft Office Macro Security configuration required No
TYPES OF FILES SUPPORTED
CSV (comma separated value) format Yes
Support for Microsoft Excel 2007 Yes
Support for Microsoft Excel 2003 Yes
Support for any spreadsheet program output to .xls or .xlsx format Yes