Making Sense of Transaction Matching: How SAP Solution Extension by BlackLine Enhances SAP Innovations


This blog originally appeared on SAP’s blog, and is Part 6 of this blog series. Read the full series here.

In our last several blogs, we’ve reviewed SAP’s core ERP functionality—including the differentiators of SAP S/4HANA—and how BlackLine’s financial close offerings extend and complement the ERP.

In today’s edition, we’ll discuss scenarios involving high volumes of transactions and compare SAP’s solutions for matching and reconciling to BlackLine’s functionality.

What Is Transaction Matching, Anyway?

Balance sheet substantiation, manual journal entries, and task management tend to get a lot of attention when it comes to the month-end close.

One challenge not as commonly discussed is reconciling high volumes of transactions. Specifically, how balances in certain general ledger accounts are made up of hundreds of thousands of individual line items that must be reconciled against other data sources to be substantiated.

Despite the other critical tasks on their plate, accountants often spend a significant amount of time using spreadsheets, formulas, and other error-prone processes to sift through mountains of data. The goal is to identify errors, exceptions, or reconcile (unmatched) items that require follow-ups or adjusting entries, and doing this manually adds to an already tall task.

SAP ERPs and SAP Account Substantiation and Automation by BlackLine have functionalities to automate and de-risk the traditionally manual methodologies. Let’s explore them.

SAP’s Matching Solutions

As we discussed in our earlier blog, one of the benefits of SAP S/4HANA’s Universal Journal architecture is its elimination of some basic reconciliation, or matching. Scenarios like reconciling subledger details to the general ledger.

For those organizations not yet running SAP S/4HANA, SAP ECC offers standard reports to help facilitate the reconciliation of data within the ERP. Subsequent steps, which are typically manual, are then required to identify errors or make adjustments.

Beyond standard subledger to GL reconciliations, SAP has robust matching capabilities for a few specific and complex use cases.

First, using SAP Leonardo Machine Learning capabilities, SAP Cash Application solution learns from accountants’ past manual actions to apply payments to open invoices. This intelligent receivable matching helps companies lower days sales outstanding and free accountants from manual work.

In addition, SAP Goods and Invoice Receipt Reconciliation provides transaction matching functionality to optimize and clarify the SAP open items derived from the purchasing process.

A Flexible Extension of the SAP ERP

While the ERP is the system of record and the general ledger and related subledgers contain important financial data, critical information for reconciliation and substantiation lives outsides the ERP, as well. Other data sources might include bank detail, point-of-sale systems, credit card detail, payroll, or HR systems and more. And disparate ERP landscapes pose additional reconciliation challenges.

To extend SAP’s intra-ERP functionality, SAP Account Substantiation and Automation by BlackLine enables robust, flexible transaction matching that supports a variety of use cases and allows for the reconciliation of information from any data source – including those outside of SAP.

These solutions can handle robust logic, complex data relationships (think one-to-many and many-to-many), and fields outside the ERP.

BlackLine Transaction Matching in SAP Account Substantiation and Automation by BlackLine is flexible, business owned, and fully integrated with other processes such as balance sheet substantiation and journal entry management. This allows for maximum automation and auditability. And as the business or systems landscape evolves over time, the rules engine can be easily updated without involving IT.

More Time to Focus on What Matters

With the advanced rules engine provided by SAP Account Substantiation and Automation by BlackLine, organizations have matched millions of transactions in seconds or minutes. The solutions identify exceptions and suggest matches, which help focus accountants’ attention on potential risks and adjustments. This frees them from the manual “rainbow spreadsheets” to which they’re often accustomed.

Adjusting journal entries and clearing documents can also be automated and posted directly to SAP ERPs, and reconciling items are automatically incorporated into the balance sheet substantiation process.

A Blog Series to Answer Your Questions

There are a number of common questions about BlackLine and SAP and how our solutions work together. Please check out these blogs to answer them: