Billing Schemes in the Professional Services Industry

In previous Our Thoughts On articles, I’ve discussed a case study regarding billing schemes in the professional services industry, and my colleague Andy Trettel has talked about using data analytics to identify check and payment tampering schemes.  In this article, we’ll combine these ideas to provide some common data analytics tests to detect billing schemes.

As a refresher, billing schemes attack a company’s cash disbursements and payables cycle by making false claims for payment from the victim company.  These bogus claims induce the victim company to issue payments for goods or services not actually received.  Fraud perpetrators can accomplish this in a variety of ways:

  • Invoicing via shell companies, wherein a fictitious entity is created for the sole purpose of committing fraud
  • Invoicing via non-accomplice vendors, wherein fraudsters use invoices in the name of existing vendors to generate fraudulent payments
  • Overbilling by falsifying or inflating billing records
  • Making personal purchases with company funds, by using company accounts to buy items for themselves, their businesses, their families, etc.

A company should continually monitor relationships with vendors to ensure that vendors are not taking advantage of the relationship with the company and that all vendors are legitimate.  Common data analytics tests to monitor red flags with vendors include:

  • Identify vendors with significant increases or decrease inactivity
  • Extract vendors with incomplete profiles, especially those with missing telephone number or tax ID numbers
  • Review transactions that are just barely under the authorization thresholds

There are various new data analytic tools, besides Excel, to perform these tests that are now available.  We are utilizing several of these tools at Schneider Downs, including:

  • Alteryx – a business intelligence platform and data preparation tool that offers data mining and predictive analytics.  It focuses on accessing, preparing, blending and enhancing data, especially from multiple sources in different formats.
  • Microsoft Power BI – a business analytics solution with interactive visualization and business intelligence capabilities.  It can connect to hundreds of data sources and convert data into dashboards and reports.
  • Tableau – interactive analytics tool to integrate and combine data from multiple sources into visualizations and dashboards, with virtually no programming required.
  • IDEA – an analysis tool that quickly analyzes data, guarantees data integrity and accelerates performing data analytics to assess risk, gather evidence and uncover trends.

If you have any questions regarding potential fraud schemes or the use of data analytics to detect fraud, please contact the Business Advisory Group at Schneider Downs.

You’ve heard our thoughts… We’d like to hear yours

The Schneider Downs Our Thoughts On blog exists to create a dialogue on issues that are important to organizations and individuals. While we enjoy sharing our ideas and insights, we’re especially interested in what you may have to say. If you have a question or a comment about this article – or any article from the Our Thoughts On blog – we hope you’ll share it with us. After all, a dialogue is an exchange of ideas, and we’d like to hear from you. Email us at contactSD@schneiderdowns.com.

Material discussed is meant for informational purposes only, and it is not to be construed as investment, tax, or legal advice. Please note that individual situations can vary. Therefore, this information should be relied upon when coordinated with individual professional advice.

© 2020 Schneider Downs. All rights-reserved. All content on this site is property of Schneider Downs unless otherwise noted and should not be used without written permission.

our thoughts on

Extension of the Main Street Lending Program
Greasing the Skids: Sell-Side Due Diligence
Temporary 100% Deduction of Business Meals Proposed by Senate Republicans
Estate of Jones v. Commissioner
Main Street Loan Modifications for Not-for-Profit Organizations
What is the Impact of COVID-19 on Dealership Valuations?

Register to receive our weekly newsletter with our most recent columns and insights.

Have a question? Ask us!

We’d love to hear from you. Drop us a note, and we’ll respond to you as quickly as possible.

Ask us

contact us

Map of Pittsburgh Office
Pittsburgh

One PPG Place, Suite 1700
Pittsburgh, PA 15222

contactsd@schneiderdowns.com
p:412.261.3644     f:412.261.4876

Map of Columbus Office
Columbus

65 East State Street, Suite 2000
Columbus, OH 43215

contactsd@schneiderdowns.com
p:614.621.4060     f:614.621.4062

Map of Washington Office
Washington, D.C.

1660 International Drive, Suite 600
McLean, VA 22102