---
title: "Forensic Accounting Expert Allowed to Testify Despite Lack of SQL Expertise"
meta:
  "og:description": "The forensic accounting expert was allowed to testify because he tested the accuracy of SQL queries, despite relying on technical assistance"
  "og:title": "Forensic Accounting Expert Allowed to Testify Despite Lack of SQL Expertise"
  author: "Expert Witness Profiler"
  description: "The forensic accounting expert was allowed to testify because he tested the accuracy of SQL queries, despite relying on technical assistance"
---

# Forensic Accounting Expert Allowed to Testify Despite Lack of SQL Expertise

Posted on September 16, 2025 by Expert Witness Profiler

Plaintiff Pietoso, Inc. operates Café Napoli restaurant in Clayton, Missouri. It has a Service Agreement for waste removal from the restaurant with Defendant Allied Services, LLC—a subsidiary of Defendant Republic Services, Inc. The Service Agreement sets a basic-service rate of $323 per month, but it allows Allied to unilaterally increase this rate for certain enumerated reasons. All other rate increases require Pietoso’s consent.

Pietoso’s service rate increased incrementally from $323 per month in 2011 to $870.25 per month in 2018. Discovery revealed that Defendants increase their prices every 10-12 months through a Yield Management Process (YMP) whereby parent company RSI generates budget guidance for its subsidiaries using an algorithm that incorporates local division budgets, costs, and historical average price increases as well as individual customer histories, including prior increases, responses thereto, and profitability.

Plaintiff Pietoso centrally asserted that Defendants’ YMP price increasepractice violated the Customer Service Agreement (CSA) Rate Adjustment clause. Pietoso engaged [Patrick Kilbourne](https://expertwitnessprofiler.com/expert-witness/Patrick-Kilbourne/1514384) to calculate damages for the class.

Defendants filed a motion to exclude Kilbourne’s expert testimony because his methodology is insufficiently precise to satisfy the legal standards for admissibility of expert testimony.

## **Forensic Accounting Expert Witness**

[Patrick J. Kilbourne](https://expertwitnessprofiler.com/expert-witness/Patrick-Kilbourne/1514384) is a Managing Director at Berkeley Research Group, a business consulting firm. He has an MBA from the University of Pennsylvania Wharton School of Business.

Kilbourne is a Certified Public Accountant, Certified Management Accountant, and Certified Fraud Examiner. He is also Certified in Financial Forensics and Accredited in Business Valuation by the American Institute of Certified Public Accountants.

[Want to know more about the challenges Patrick Kilbourne has faced? Get the full details with our Challenge Study report](https://expertwitnessprofiler.com/order/add?eId=1514384&amp;pId=3).

## **Discussion by the Court**

Accounting for YMP increases in excess of actual operating cost increases, plus the average fuel recovery fee (FRF) as a percentage of the service price, plus the average environmental recovery fee (ERF) as a percentage of both, Kilbourne estimated total damages for the class at $75.1 million. While his report provided averages beyond the class period, it demonstrated the feasibility of extracting more specific data for each year and customer.

Kilbourne indicated that he was able to calculate damages for each class member by site and service. His report shows several examples calculating damages for specific customers based on YMP price increases within a certain date range. Between 2017 and 2019, Pietoso paid $2,526 over the contractually permissible increases (i.e., operating costs plus CPI). Based on the service rate for each month during that period, Pietoso paid $2,546 in FRF and $3,240 in ERF.

### **Application of Contract Terms**

Defendants challenged Kilbourne’s methodology in several respects. First, the CSA defined the “Company” as a specific local division, but Kilbourne didn’t analyze division-level costs, which vary widely between urban and rural areas. Instead, he combined statewide costs to yield an average.

Further, Kilbourne didn’t isolate disposal or transportation cost increases or those attributable to changes in the law, as the Rate Adjustment clause contemplates. He also didn’t isolate the additional category related to recyclable waste contained in some contracts. Rather, he combined all operating costs, thus diluting the contractual categories such that the result is inaccurate.

Defendants contended that they produced division-level financial data sufficiently specific to facilitate more accurate calculations.

Given the data available in the format produced, the Court held that Kilbourne’s inability to isolate costs corresponding to contractual categories is understandable. This is not a defect in methodology warranting exclusion but rather a limitation due to Defendants’ accounting – one that actuallyfavors Defendants by overstating cost increases and potentially understating damages.

In related points, Defendants criticized Kilbourne’s calculations for failing to account for negotiated credits and rollbacks or customer consent. But whether customers consented to increases is a central fact issue beyond Kilbourne’s assignment here.

#### **CAGR for Average Increase in Operating Costs**

Because Defendants’ financial statements don’t separate costs categories as between commercial, industrial, and residential customers or between small and large containers, and also because multiple divisions were combined into one financial statement prior to 2018, Kilbourne examined Defendants’ total operating costs of $152.9 million in 2016 to $203.2 million in 2022 to arrive at an average annual cost increase rate, or compounded annual growth rate (CAGR), of 4.9%.

He compared this with the average annual price increases for customers to estimate damages as the difference between cost increases and price increases.

In their motion to exclude, Defendants argued that Kilbourne’s methodology is flawed in that the time period Kilbourne used (2016-2022) doesn’t match the class period, and the annual average of 4.9%, while perhaps useful to predict future growth, is imprecise and factually inaccurate to calculate damages from historical data.

The Court found Kilbourne’s general approach of calculating damages as the difference between customers’ actual rate hikes and contractually “allowable” increases as a percentage increase in annual operating costs plus CPI logical. While CAGR for 2016-2022 may not be the applicable variable if or when damages are calculated in this case, Kilbourne offered a feasible model using the data available, and his report demonstrates that operating cost increases are ascertainable for any given year and also by local division after 2017, as may be required.

#### **YMP Recommendation**

Next, Defendants argued that Kilbourne’s methodology is defective because he erroneously relied on “reason code 64” to identify YMP increases, when in reality local divisions use the code differently, according to some witness testimony. But that same evidence and other testimony in the record confirms that code 64 is indeed the correct code for YMP increases, and any other use of code 64 is viewed as misuse or unintended use.

The Court found Kilbourne’s reliance on Defendants’ own coding system entirely reasonable. Any margin of error in this respect is attributable to flaws in Defendants’ data, not in Kilbourne’s methodology.

Defendants also argued here that Kilbourne’s method is unreliable because he ignored the fact that local divisions often depart from YMP recommendations. But Kilbourne expressly acknowledged this fact and noted that it would be possible to exclude YMP increases that were different from the algorithm amount if needed. The data captured every invoice and corresponding payment. Again, the Court is not persuaded that Kilbourne’s model couldn’t accommodate those adjustments, and error-free perfection is not the standard.

#### **SQL Qualifications**

As the Court understands it, Kilbourne and his staff used a computer code called structured query language (SQL, or “sequel”) to identify the characteristics of the Plaintiff class and extract their invoicing and payment records from the voluminous data produced by Defendants. Kilbourne relied on technical staff to perform the query to identify class members, then he verified it for accuracy using a quality control test process. Defendants asserted that Kilbourne’s methodology is unreliable because he isn’t qualified in SQL; rather he adopted a methodology of non-experts that he can’t independently opine on because he lacks the necessary expertise.

Kilbourne is, however, an expert in accounting and financial analysis, not computer science. The Court finds it reasonable that his examination of voluminous financial data might require technical assistance to manipulate, sort, and extract the characteristics and figures relevant to this case.

Staff with SQL expertise assisted Kilbourne, and he tested the accuracy of SQL queries through quality control processes. The Court is satisfied that his method is reliable.

Moreover, even accepting Defendants’ tenuous premise here, expertise with SQL is collateral to Kilbourne’s essential qualifications as a CPA and financial analyst. The Court therefore finds that any arguable deficiency goes only to the weight of his testimony, not its admissibility.

#### **Fuel and Environmental Recovery Fees**

Defendants’ financial records showed that fuel and environmental costs are included in Defendants’ annual operating costs incorporated in their price increases under the Rate Adjustment clause. However, Defendants also charged additional fuel and environmental recovery fees (FRF and ERF, respectively) as a percentage of the amount invoiced for the underlying services. Kilbourne was asked to calculate the total amount of these surcharges for each class member during the class period. The data enabled him to isolate amounts specific to these fees and calculate average annual increases for each year.

Defendants asserted that Pietoso has failed to plead a viable theory of damages with respect to these fees, leading Kilbourne to merely perform simple math without any meaningful analysis.

The Court will not exclude Kilbourne’s testimony on these fees. Defendants offered no argument that Kilbourne’s methodology is unreliable; they only dispute the applicability of these fees to a damages calculation. Kilbourne has demonstrated his ability to isolate these fees in the data and calculate them in relation to underlying price increases. If the jury deems some portion of the fees recoverable, Kilbourne’s methodology is reliable, and his testimony is relevant and likely to assist the trier of fact

## **Held**

The Court denied the Defendants’ motion to exclude the testimony ofPlaintiff’s damages expert, Patrick Kilbourne.

## **Key Takeaway:**

While individual credits and rollbacks may require further examination, the Court is not persuaded that Kilbourne’s model cannot accommodate such adjustments, as the data captures every customer transaction. In the Court’s view, this doesn’t render Kilbourne’s methodology preclusively unreliable. Nothing in [Rule 702](https://www.law.cornell.edu/rules/fre/rule_702#:~:text=Rule%20702%20sets%20forth%20the,is%20a%20relatively%20narrow%20inquiry.) “requires the court to nitpick an expert’s opinion in order to reach a perfect expression of what the basis and methodology can support.”

Even viewing Kilbourne’s technical staff as independent experts, the Court found no basis to exclude his opinions, as experts frequently rely on the expertise of others outside their field.

## **Case Details:**

---

## **You Might Also Like**

![Intellectual Property Expert&#39;s Opinion on Misappropriation Excluded](https://ewp-blog.expertwitnessprofiler.org/wp-content/uploads/2026/03/blog-pic-640X480-2026-03-13T205412.117.jpg) [**Intellectual Property Expert’s Opinion on Misappropriation Excluded**](https://expertwitnessprofiler.com/forensic-accounting-expert-allowed-to-testify-despite-lack-of-sql-expertise/intellectual-property-experts-opinion-on-misappropriation-excluded)![Automotive Industry Expert&#39;s Testimony on Pricing Practices Excluded](https://ewp-blog.expertwitnessprofiler.org/wp-content/uploads/2026/03/blog-pic-640X480-2026-03-13T191143.335.jpg) [**Automotive Industry Expert’s Testimony on Pricing Practices Excluded**](https://expertwitnessprofiler.com/forensic-accounting-expert-allowed-to-testify-despite-lack-of-sql-expertise/automotive-industry-experts-testimony-on-pricing-practices-excluded)![Consumer Credit Expert Allowed to Opine on Mixed Files](https://ewp-blog.expertwitnessprofiler.org/wp-content/uploads/2026/03/blog-pic-640X480-2026-03-13T160600.039.jpg) [**Consumer Credit Expert Allowed to Opine on Mixed Files**](https://expertwitnessprofiler.com/forensic-accounting-expert-allowed-to-testify-despite-lack-of-sql-expertise/consumer-credit-expert-allowed-to-opine-on-mixed-files)![Appraisal Expert&#39;s Testimony on Deceptiveness Excluded](https://ewp-blog.expertwitnessprofiler.org/wp-content/uploads/2026/03/blog-pic-640X480-2026-03-11T194055.299.jpg) [**Appraisal Expert’s Testimony on Deceptiveness Excluded**](https://expertwitnessprofiler.com/forensic-accounting-expert-allowed-to-testify-despite-lack-of-sql-expertise/appraisal-experts-testimony-on-deceptiveness-excluded)![Psychology Expert Allowed to Opine on EMDR Therapy](https://ewp-blog.expertwitnessprofiler.org/wp-content/uploads/2026/03/blog-pic-640X480-2026-03-11T153456.164.jpg) [**Psychology Expert Allowed to Opine on EMDR Therapy**](https://expertwitnessprofiler.com/forensic-accounting-expert-allowed-to-testify-despite-lack-of-sql-expertise/psychology-expert-allowed-to-opine-on-emdr-therapy)