We value your privacy

We use cookies to improve the user experience and analyze its performance.

Privacy Policy

ReconArt, Inc.

SITE PRIVACY POLICY

This Privacy Policy governs the manner in which ReconArt, Inc. (“ReconArt”) collects, uses, maintains and discloses information collected from users (each, a “User”) of the ReconArt.com website (“Site”). This privacy policy applies to the Site and all products and services offered by ReconArt.

Personal identification information

We may collect personal identification information from Users in a variety of ways, including, but not limited to, when Users visit our site, register on the site, fill out a form, and in connection with other activities, services, features or resources we make available on our Site. Users may be asked for, as appropriate, name, email address. We will collect personal identification information from Users only if they voluntarily submit such information to us. Users can always refuse to supply personally identification information, except that it may prevent them from engaging in certain Site related activities.

Non-personal identification information

We may collect non-personal identification information about Users whenever they interact with our Site. Non-personal identification information may include the browser name, the type of computer and technical information about Users means of connection to our Site, such as the operating system and the Internet Service Providers utilized and other similar information.

Web browser cookies

Our Site may use “cookies” to enhance User experience. User’s web browser places cookies on their hard drive for record-keeping purposes and sometimes to track information about them. User may choose to set their web browser to refuse cookies, or to alert you when cookies are being sent. If they do so, note that some parts of the Site may not function properly.

How we use collected information

ReconArt may collect and use Users personal information for the following purposes:

  • To improve customer service:  Information you provide helps us respond to your customer service requests and support needs more efficiently.
  • To personalize user experience:  We may use information in the aggregate to understand how our Users as a group use the services and resources provided on our Site.
  • To improve our Site:  We may use feedback you provide to improve our products and services.
  • To send periodic emails:  We may use the email address to respond to their inquiries, questions, and/or other requests.

 

How we protect your information
We adopt appropriate data collection, storage and processing practices and security measures to protect against unauthorized access, alteration, disclosure or destruction of your personal information, username, password, transaction information and data stored on our Site.
Sensitive and private data exchange between the Site and its Users happens over a SSL secured communication channel and is encrypted and protected with digital signatures.

Sharing your personal information

We do not sell, trade, or rent Users personal identification information to others. We may share generic aggregated demographic information not linked to any personal identification information regarding visitors and users with our business partners, trusted affiliates and advertisers for the purposes outlined above.

Changes to this privacy policy

ReconArt has the discretion to update this privacy policy at any time. When we do, we will revise the updated date at the bottom of this page. We encourage Users to frequently check this page for any changes to stay informed about how we are helping to protect the personal information we collect. You acknowledge and agree that it is your responsibility to review this privacy policy periodically and become aware of modifications.

Your acceptance of these terms

By using this Site, you signify your acceptance of this policy. If you do not agree to this policy, please do not use our Site. Your continued use of the Site following the posting of changes to this policy will be deemed your acceptance of those changes.

Contacting us

If you have any questions about this Privacy Policy, the practices of this site, or your dealings with this site, please contact us at: ReconArt – info[at]reconart[dot]com

reconart logo
  • The Solution
    • Bank Reconciliation Software
    • Credit Card Reconciliation Software
    • AP / AR reconciliation Software
    • Securities, Positions&Trades Reconciliation
    • Financial Close Management Platform
      • Financial close: task management
      • Financial close: Balance sheet reconciliation and certification
      • Financial close: Variance analysis
    • Journal Entries Approval Workflow
    • Intercompany Reconciliation Software
    • API for integration of Reconart with other systems
  • Editions
    • Essentials
    • Certify
    • Plus
    • Close
    • Enterprise
  • Software Overview
    • About Us
    • Software Profile
    • Automation Tool
    • Netsuite Account Reconciliation
    • Integration Ready
    • Customer & Industry Profile
    • Security
    • Product Evolution
  • Case Studies
  • Partners
  • Blog
  • Contact Us
main image
ReconArt 
Blog
arrow-right icon follow our blog
Feb / 27 / 2024

Reconciliation Beyond Spreadsheets

Spreadsheets are no doubt a great solution for data analysis and intermittent calculations, but their use as a long-term reconciliation solution proves unsustainable.

Recent studies suggest that Excel is still the most popular reconciliation tool for roughly 70% of the world’s financial institutions. Undoubtedly, its versatility, flexibility and wide accessibility make it a “weapon of choice” for the majority of finance and accounting professionals. But does conventional spreadsheet software have the proper functionalities to serve as an end-to-end reconciliation solution?

As reconciliation tasks grow more complex and transaction volume expands, F&A specialists inevitably encounter numerous unforeseen issues down the road. Backlog is piling up, technical failures emerge, document owners and users change. As a result, business critical pieces of information may fall through the cracks, carrying unpredictable implications. It becomes evident that the long term usage of spreadsheet technologies as a permanent approach in the reconciliation process is far from a productivity enhancement.

Spreadsheets containing interrelated tables with thousands of rows and columns have innate limitations and tend to fail under excessive data loads. Manual manipulation of intricate formulas and advanced Visual Basic scripting are likely to produce flaws. Changes in source systems and migration campaigns, or even a key user out of office could cause major disruptions in the workflow and data inconsistencies. Additionally, unrestricted control on user permissions, absent audit trail options and minimal data security easily constitute compliance lapses.

Here is a summary of the top 6 reasons why commonplace spreadsheet technology can no longer meet the advancing reconciliation needs of mature business organizations.

1 )  Lack of automation – a taxing compromise

As a rule, manual reconciliation is an overwhelming job. Input data is retrieved from various sources and in different formats. Compiling and transforming it to achieve normalization and enrichment on import, all done by hand, is tedious, time consuming, error prone and without auditable control. Reliable, scalable and maintainable automation of those recurring tasks is beyond the scope of spreadsheets product features. However, a modern reconciliation tool can handle the entire process automatically, applying any necessary data clean-up and enrichment as soon as the data is available.

2)  Slow and unreliable performance in larger scales

Dealing with larger data sets than a spreadsheet application is designed for can really slow you down. Heavy duty documents take ages to load, update and save even with the simplest of changes. Almost every organization at some point generates such documents for a variety of purposes in different departments (Budgeting, Sales, Planning, etc.). Also, in a regular spreadsheet, manual cell value updates may accidentally interfere with prior values, formulas and settings. The insertion of an additional field normally suggests that historic data should be related. However, maintaining historic relevance in spreadsheets is not always feasible. Obviously, in those cases the capacity of customary spreadsheet software is exceeded. Paradoxically, growth in data loads (usually a measure of success) can become a significant challenge for which spreadsheet technology is ill-suited.

3)  Rudimentary matching capabilities

Reconciliation via spreadsheets relies excessively on the knowledge of the reconcilers. In spite of the numerous predefined financial, mathematical, statistical, and database functions, spreadsheets are incapable of applying complex business logic. A specialized reconciliation solution, on the other hand, accommodates a rule-based communication across data sheets and information sources. It also takes steps further with exception management features, thus ensuring reconciliation process continuity, independent of the human factor.

According to Ignat Chakaroff, Product Specialist at ReconArt:

“The only known way to find duplicates within Excel is to have them all on one single sheet, which not only creates a data and processing burden, but also limits your matching capabilities to one single column at a time.

Our data shows that three out of four new ReconArt clients today face one-to-many or many-to-many matching scenarios, sometimes even coupled with variance tolerances which is near-impossible to achieve just by using Excel.”

4)  Versions history and data accuracy

Employees regularly store documents locally on their PC for reporting purposes. When a handful of experts rely on the same Excel report exchanged over email or some form of shared repository, it is arguable which is the latest version. Rolling back changes is also out of question. Collaboration among multiple users and keeping track of document versions easily gets out of hand. The aftermath can involve overlapping modifications, conflicting redactions, as well as inaccurate and repetitive data. Utilizing web-based applications hosted in the cloud, the proper mitigation of these complications is essentially effortless. They would allow smooth, secure, and synchronized collaboration while sparing troublesome deployment and upgrades.

5)  Tracking changes and auditability

Data entries and calculations output in a spreadsheet reconciliation framework often appear chaotic and unstructured. There is no clear workflow schedule visible or enforced. The separation of duties remains a vague concept. Changes administered on the formulas leave no definitive audit trail, although the reconciliation results can be affected dramatically. Drilling down to the finest transaction details frequently relies on fleeting human recollections which renders basic understanding by uninvolved parties impossible. There are no comprehensive exceptions management procedures at place. Those factors seriously hamper audit readiness.

6)  Absent analytics functionality

Spreadsheet based reconciliation relies on daily / monthly snapshots of data and fails to fully capture the dynamic process. An essential functionality such as transaction dating, which flags and sorts out outstanding transactions, is unattainable with generic productivity software. Reporting on aging and tracking exceptions to resolution remains out of scope. It is nearly impossible to generate advanced analytic cross-sections of matched transactions revealing important metrics such as volumes through different channels, fees paid, payment delays, etc. On the other hand, a specialized reconciliation tool offers enhanced analytics, sophisticated aggregations and dashboards, visualization of KPIs and integration with more advanced analytical solutions.

In Conclusion

An automated end-to-end solution is the smart choice to manage an elaborate reconciliation process in a professional manner. If you identify with the pain points outlined above, it could well be the right time to upgrade to an agile reconciliation and reporting solution.

ReconArt™ was developed with these challenges in mind and has successfully replaced retrograde spreadsheet-based tools with a solution capable of:

  • Full automation under one integrated product – data sourcing & import, transformation & enrichment, matching, exceptions management, reporting & analytics
  • Reconciliation of multiple data sources in various formats – fast & efficient
  • Web-based, ERP integrated, business user friendly
  • Super granular audit trail & full compliance
  • High volume transactional matching with the support of a powerful rules engine capable of applying advanced rules across many accounts at once

Learn more about the challenges our clients faced and how ReconArt™ revolutionized their reconciliation process in the post-spreadsheet era.

 

TekSavvy

Prior to adopting new technology, TekSavvy was using Microsoft Excel to perform its monthly reconciliations. However, the single workbook created to handle them grew to be very cumbersome to deal with. Additionally, the way it was set up back then, only one person at a time could perform reconciliation tasks. There would be errors and sometimes, most likely because the workbook was so large, Excel would crash before the document could be saved. This would result in data loss plus all the ensuing wasted time to recover it.

As TekSavvy was expanding rapidly, the company knew it needed to get beyond Excel which wasn’t able to keep up with the level of activity that the company was seeing. Therefore, TekSavvy went out to market looking for a tool that would automate its month end close and account reconciliations.

 

University of Auckland

The University of Auckland has a decentralized finance function. This leads to over 2,500 individual reconciliations that have to be completed each month. The task of collating all the balance sheet reconciliations for the quarterly review was overly onerous and time consuming. Accountants would perform balance sheet reconciliations manually using Microsoft Excel spreadsheets. These reconciliations were then printed, reviewed and approved, and then stored as hard copies across multiple physical locations.

In summary, prior to embarking on the search for technology to address these issues, the University was experiencing major process inefficiencies, lack of visibility over key account balances and compliance with internal policy, internal control weaknesses raised by external auditors, risk of non-compliance with GAAP, and unnecessary printing and storage costs.

 

First National Bankers Bank

Prior to implementing ReconArt™, the bank used an internally IT-developed program only for the transaction matching and account reconciliation of its own account with the central bank (the Fed). All other reconciliation processes were done manually in Excel spreadsheets, with a heavy reliance on IT personnel when a mismatched item occurred.

FNBB has gained multiple advantages from the deployment of the ReconArt™ solution, such as:

  • Automation of key reconciliations in Finance Division, which were previously Excel based.
  • Time savings in several different areas – minimized IT support, 75-80% time saved in Fed reconciliations, speed up audit at month and year-end.
  • Elimination of manual and semi-manual spreadsheet-based processes.
  • Immediate identification of exceptions and their related risk.

 

Fiesta Insurance

As a direct result of deploying ReconArt™, Fiesta has gained multiple benefits, including automation of processes that were being handled manually using Excel spreadsheets and manual data input into QuickBooks.

“ReconArt™ offered excellent value and immediate return on investment. ReconArt as a partner demonstrated a clear and concise understanding of transaction matching. The modern design of the ReconArt™ solution means business users can configure new processes including data mapping and match rules with no more than Excel skills. This extreme ease-of-use makes ReconArt™ “revolutionary in the field of automating reconciliations” without IT involvement.”
says Diane Chaidez, Controller at Fiesta Insurance Franchise Corporation

 

New South Wales Treasury Corporation (TCorp)

TCorp was spending time extracting information from a number of systems and importing them into spreadsheets manually. After that, users were required to print the information and manually match items line by line between reports to undertake a reconciliation. The main cash reconciliation could itself take up to half a business day each day for one staff member. The information was stored in spreadsheets, something that TCorp’s leadership team believed posed a risk.

TCorp went out to market looking at a number of options for an automated reconciliation solution. Its two primary objectives were to find software to:

  • Reduce operational risk – move away from vulnerable spreadsheets, and
  • Save time and resource – free up valuable headcount to focus on higher value tasks

The overall benefits are best summed up by TCorp’s Head of Finance & Reporting, Raffi Kalenderian:

“ReconArt™ has delivered significant time savings along with risk reductions. It paid for itself almost immediately. We will now continue to deploy ReconArt™ to other important reconciliations within the business as time progresses.”

Share this post

Ready to learn more about our solution?
Let’s Talk Reconciliation Beyond Spreadsheets

Case Study

Banco Unico (now Nedbank Mozambique)

Banco Unico (now Nedbank Mozambique)

Industry: Banking
Focus: Complex Transaction Matching, Journal Entries

Banco Unico (now Nedbank Mozambique), the fifth largest bank in Mozambique, has earned a reputation of an innovative, dynamic and client oriented financial institution

read more

ReconArt Customers

Here are some of the customers who leverage our reconciliation software to automate their reconciliation and close processes.

Soyven
Gathern
Navan
Klar
Daikin
Expedia
Umpqua bank
Calgary co op B&W
deVolksbank
Nedbank
Asos
Fiat Chrysler
Ferratum
Quikrete
New York City Department of Finance
Worldremit
Bill
Catalyst
Xendit
Agency Insurance Company
MidFlorida Credit Union
Sparkasse Bank Malta

Let's Talk

We welcome the opportunity to explore your needs and introduce you to our solution.

Let us know you have interest
What to expect from us
  • check iconQuick response
  • check iconCollaborative discovery
  • check iconTransparency and openness
  • check iconClear next steps
facebook icon
twitter icon
Linkedin icon
ReconArt Americas
4720-E Langston Blvd,
Arlington, VA 22207
United States
1-855-RECONART (Toll Free)
ReconArt Worldwide
+1 571-210-2444 info@reconart.com
Copyring 2025 ReconArt, Inc. All Rights reserved.
Terms & Conditions | Privacy Policy