Optimising online & mobile payment reconciliation

Our client is a leading global fast food company that owns several popular chain stores. The organisation serves over two million customers every week across more than 640 stores nationally. In recent years, they have invested in innovative marketing campaigns with a strong digital focus to attract and retain customers, including online and mobile orders. In this case study, we explore how we provided our client with best practice data integration services that streamlined reporting and the payment reconciliation processes, and provided improved visibility of payment reconciliation data to their franchisees and store owners  

Our client decided to adopt the Braintree payments gateway as the platform to accept and process mobile and online payments. Braintree is a flexible and scalable payments platform that enables customers to pay how they like – via credit and debit cards, PayPal, Apple Pay, Google Pay and more – and integrates them in one place. Its reporting functionality also provides our client with better visibility and granular details on transactions occurring through online and mobile platforms with breakdowns to individual transaction fees.  

Having successfully implemented Braintree, the organisation needed assistance to streamline its reporting and payment reconciliation processes. It engaged Analytics8 to undertake a data integration project to extract data from Braintree and PayPal, and to automate key reports to assist the finance team with payment reconciliation.  

We assembled a team of data specialists and analytics consultants to deliver the project. The initial focus was to define and agree on the data integration requirements to ensure that our client’s expectations could be rapidly met.  

Next, the team developed robust processes to pull data from Braintree (using Braintree’s SDK) and PayPal (with report files provided via SFTP). With the data available, our team then shifted its focus to designing and implementing a rapid data integration process to ingest, process and format data from Braintree and PayPal in a single view, as required for our client’s Payment Reconciliation Report. 

The team had a strong focus on identifying opportunities to accelerate the payment reconciliation process, such as by speeding up data transformation, and built these into the design of the data integration sequence.  

The project was completed in just three months and went live in June 2018.  

• Payment reconciliation has been transformed from a clunky, time-consuming and manual process to being structured, organised and automated.  
• The finance team has much greater visibility of payment reconciliation information, with a newfound ability to assess details at a granular level that provide useful insights for our client’s marketing, customer and management functions. For example, it can now gain insight into customer behaviour as it can identify whether payments were made through either Braintree or PayPal.   
• Reporting on payments reconciliation is faster and more efficient, with a higher level of automation and less time required to extract and transform data needed for our client’s management and franchise reports. 
• Payments data is now available in a single location in the enterprise data warehouse and can be used to fulfil future reporting requirements. 

Our role is now to continue optimising the data integration solution, and provide support as needed.