reconart logo
  • Covid-19 Update
  • The Solution
    • Bank Reconciliation
    • Credit Card Reconciliation
    • Accounts Reconciliation: AP & AR
    • Positions, Holdings & Trades Reconciliation
    • Financial Close Management Platform
      • Financial close: task management
      • Financial close: Balance sheet reconciliation and certification
      • Financial close: Variance analysis
    • Enhanced Control: Journal Entries
    • Intercompany Reconciliation
    • API for integration of Reconart with other systems
  • Pricing
    • Essentials
    • Plus
    • Certify
    • Close
    • Enterprise
  • Software overview
    • About Us
    • Software Profile
    • Automation Tool
    • Netsuite Account Reconciliation
    • Integration Ready
    • Customer & Industry Profile
    • Implementation & Support
    • Product Evolution
  • Case Studies
  • Partners
  • Blog
  • Contact Us
ReconArt 
Blog
arrow-right icon follow our blog
Sep / 16 / 2022

The Struggles with Credit Card Recs Solved

These days it seems like we are receiving more and more requests to help with the automation and streamlining of credit card reconciliation. As a platform historically rooted in principles such as the ability to handle large data volumes, various and complex data sources, and multi-step matching scenarios, ReconArt™ is perfectly suited to answer this call.

E-commerce and Retail are among the first industries that come to mind when discussing this process – but nowadays, they are hardly the only ones that might be ‘drowning’ in credit card transactions coming in from various sources such as card-specific statements (VISA/MC, AMEX, etc.), online payment platforms (PayPal, ProPay, Cybersource, Amazon Payments, etc.), shopping cart solutions (Magento, Opencart, etc.), sales tax solutions (such as Avalara), and other consolidated merchant bank providers. The travel and hospitality industry with their bookings, non-profits with their donations, benefits administrators with their payment management, technology providers with their subscriptions – this is everywhere. And when we also count corporate credit card, or employee expenses, it’s hard to imagine any organization that can’t benefit from a solution engineered to handle the range and scale of these reconciliations comprehensively. Here are some of the most common challenges we hear about:

  • Multiple data sources. Juggling different data formats, different cutoff times, and different pieces of information associated with card-based processes can be very challenging. Some organization still struggle by downloading various statements and reports and ‘massaging’ them in Excel for hours before even being able to compare them. ReconArt™ allows users to easily configure and automate their data source imports, so that their available data is already imported, normalized and matched by the time they start their day.
  • Batched items. It can be nearly impossible to connect batched sums to detail level transactions. As many organizations can’t keep up with daily manual reconciliation, the process gets put off to month-end. By that time, there are hundreds of transactions to sift through, making the effort even more overwhelming. In ReconArt™, users can create automated match rules that can be as simple or as complex as needed, ensuring that they don’t waste precious time on ticking and tying matching items. Additionally, when the automation capabilities of ReconArt™ are leveraged, the organization can move toward daily or near continuous reconciliation of their card-based transactions.
  • Timing issues & Exceptions. At any given point in time, it’s impossible to distinguish simple timing delays, which will naturally get resolved in a day or two, from real problems. There is never any real visibility into what is truly outstanding. The ReconArt solution allows for outstanding items to be categorized automatically, which empowers users to collaborate and investigate only the items that they need to spend time on – ultimately resolving them completely. ReconArt™’s ability to set the right focus for investigations and exceptions means priority and risk can be managed better and with more visibility.
  • Growing volumes. With all the above at play, transaction growth can compound problems. Reluctant to add more headcount for manual reconciliation efforts, many organizations simply lose control over this process and become swallowed up in this necessary but tedious work.
  • Multi-step processes. It’s rare that all you need to do is compare list A to list B – and that’s it. Reconcilers need to be able to interact comprehensively with their data: labeling and investigating exceptions, conducting research, generating reports, looking at trends, creating and approving journal entries, posting information in other systems of record. ReconArt™ accommodates all of the above in one fully auditable platform.

But let’s take a step back.

Credit Card Reconciliation SoftwareThe classic example for this type of reconciliation involves a transactional comparison between credit card activity (in the form of bank activity and/or additional credit card statements) and what the company’s books show regarding credit card sales. Sounds pretty straight-forward on the surface. If you dissect the transactional flow of just a handful of organizations, however, you will find that there is actually a lot of variety (and potential complexity) in how organizations handle their credit card matching. This is due to the various business processes, workflows, systems of record, and data sources involved. Here are some common needs we come across:

  • A simple comparison between credit card statements and the GL.
  • Same as above, with an additional check against the bank .
  • A simultaneous comparison between credit card activity and two internal systems, such as a GL and employee expense reports, for example.
  • A 2-step comparison between an invoice system (that is separate to the GL/ERP) and the online payment platform (let’s say PayPal), with a subsequent comparison of the matched items coming out of that process to a sales tax software; followed by posting into the GL from ReconArt™.

So there actually isn’t one typical credit card reconciliation method – because all of the above scenarios reflect completely different business processes. This opens up some great conversations on our initial Discovery/Demo calls with prospective new users. Interestingly, more than any other transactional reconciliation process, credit cards often present transactional flow situations that on the surface can be perceived as a 3-way-match or multi-way match. This is because, at the end of the day, it seems like what we want is for all systems involved to reflect the same thing. Our tools are well suited to “many-legged” reconciliation and to giving insight into a transaction’s lifecycle.

The competitive advantages that the ReconArt™ solution offers are extremely applicable to credit card recs – proven ability to work with all the typical data sources, handling huge transaction volumes, providing integrated exception management, leveraging automation throughout, all while allowing for easy, intuitive administration and everyday business use. Without a doubt, credit card reconciliations have joined the ranks of some of the most interesting processes ReconArt™ deals with, and it is certainly one that is affecting a rapidly growing number of organizations. Having already leveraged best-practice reconciliation technology and strong automation; we welcome every opportunity to be the best long-term solution for this widespread business need.

Share this post

Ready to learn more about our solution?
Let’s Talk The Struggles with Credit Card Recs Solved

Case Study

New South Wales Treasury Corporation

New South Wales Treasury Corporation

Industry: Government
Focus: Risk Management, Time Savings

TCorp is also a manager of clients’ asset and liability portfolios, providing financial risk management and investment management services to the NSW Government and its constituent businesses.

read more

ReconArt Customers

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

Soyven
Karhoo
Trip Actions
Aditya
Fujifilm
Expedia
Umpqua bank
Calgary co op B&W
Fullerton B&W
Nedbank
Asos
Fiat Chrysler
Ferratum
Quikrete
Deliveroo
Worldremit
Boston private bank
Fullerton
Catalyst
Voyager
Toa

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
6462 Little River Turnpike
Alexandria VA 22312-1411
United States
1-855-RECONART (Toll Free)
ReconArt Worldwide
+1 571-210-2444 info@reconart.com
Copyring 2023 ReconArt, Inc. All Rights reserved.
Terms & Conditions | Privacy Policy