From Manual Matching to 99.6% Automation: Beauty Pie's BlackLine Success Story

Beauty Pie, a global retail company, was struggling to keep up with its rapid growth. With transaction volumes soaring, the finance team turned to BlackLine's Transaction Matching solution to automate its complex reconciliation processes, dramatically improving efficiency, accuracy, and visibility.

The Challenge

When Andy Young joined Beauty Pie as Financial Controller, he found a small dedicated team trying to keep up with manually reconciling an increasing number of transactions. "The business had grown, but the team hadn't been able to grow with it. A lot of controls were manual, and processes were sometimes haphazard." 

The team was processing in excess of 100,000 transactions a month and performing a three-way match manually in spreadsheets. "We had a huge volume of transactions, and it was extremely time consuming and manual to reconcile one of the big balance sheet accounts," says Young. "Whilst we knew things were OK, as the balance sheet account reconciled, we didn't know what was going on under the bonnet. If something didn't match, we didn't know why. We couldn't identify what the issues were." 

Why BlackLine

In the search for a solution that would offer both automation and increased visibility, the team considered BlackLine and two other vendors. 

"One vendor was very expensive and seemed like they'd never handled similar transaction matching before. They promised they could do it, but it was all AI-based, didn't seem proven and seemed like implementation would take much longer," says Young. "The other vendor was similar to BlackLine, but in the end, it came down to BlackLine's price, experience, speed of implementation and reputation." 

The team implemented BlackLine Transaction Matching. "I'm a bit of a geek with technology," says Young. "Beyond the weekly calls with BlackLine, that taught us how import definitions and matching rules worked, we were fairly self-sufficient." 

The Results

Streamlined three-way matches. With BlackLine, matches are made between the bank account, the ecommerce site, and NetSuite. Out of over 1,000,000 transactions since going live, only 4,100 are unreconciled. "We're auto-matching 99.6% of our transactions," says Young. "In the past, this reconciliation was complex and time consuming, taking many days of manual work each month to get this point. Now it only takes a few hours." 

Reduced risk and increased accuracy. Prior to BlackLine, it was difficult, if not impossible, to identify the reasons for non-reconciled transactions due to Beauty Pie's increasing transaction volume and the time taken to reconcile. "With BlackLine, we can get under the hood and see what's not working. I can flag issues a lot sooner," says Young. "For example, we found a very specific marginal case where our ERP was converting US dollar amounts into pounds but posting in US dollars. Although this did not happen very often, we were out by 20% on these specific transactions. Without BlackLine, there's no way we could have identified the source of the problem." 

Improved efficiency and gained ROI. The team has discovered new and creative ways to use Transaction Matching, increasing both efficiency and ROI. "We also realised we can use Transaction Matching to match against ourselves," says Young. "For example, cancelled transactions that net to zero and are only in one system are now being matched. It also doesn't have to be a dollar amount that is matched. BlackLine is helping us get rid of a lot of noise." 

 

Industry

Retail

ERP

NetSuite

Region

Global

Company Size

Midsize

Business Impact

Streamlined three-way matches, automating 99.6% of transactions

Reduced risk, increased accuracy, and improved efficiency

Cut reconciliation time from multiple days down to just hours

Gained ROI and freed up the team for more strategic work