Identify vendor billing trends with the 3-Way Match Discrepancy Report

Prev Next

This improvement adds a dedicated report that surfaces all open and reconciled discrepancies across vendor bills, helping accounts payable (AP) teams spot patterns and take action to reduce recurring exceptions.

What's changing?

Previously, reviewing 3-Way Match discrepancies required opening each vendor bill individually and checking flagged mismatches one at a time. Now, ServiceTitan includes a 3-Way Match Discrepancy Report in the Reports section. AP teams can view every discrepancy across all bills in a single place, filter by vendor, date range, business unit, and discrepancy type, and compare purchase order (PO), receipt, and bill values side by side. The report displays variance amounts and percentages for each comparison, along with reconciliation reasons, so teams can identify trends, engage vendors about recurring issues, and refine internal purchasing processes.

Before and After

Before (Current)

  1. Go to Accounting > Accounts Payable > Bills.

  2. Open a vendor bill that has a discrepancy flag under the Bill No. column.

  3. Click the discrepancy flag to see a summary of found discrepancies for that single bill.

  4. Repeat for each bill individually to understand how many discrepancies exist across vendors.

  5. Manually track patterns across bills using a spreadsheet or notes.

Impact: Reviewing discrepancies one bill at a time makes it difficult to identify trends across vendors, time periods, or discrepancy types.

After

  1. Go to Reports and open the 3-Way Match Discrepancy Report.

  2. Set filters for vendor, date range, business unit, or discrepancy type.

  3. Review all open and reconciled discrepancies across bills in a single table.

  4. Compare PO, receipt, and bill values with variance amounts and percentages displayed for each record.

  5. Use the findings to engage vendors, adjust pricing, or update internal processes.

Impact: Reviewing all discrepancies in one report saves time and helps AP teams take targeted action to reduce recurring exceptions.

Who uses this feature

  • All business types

  • Administrators, managers, accountants, bookkeepers

  • Region availability: All regions

 


How it works for your industry

Residential Service and Replacement

  • An office manager notices that a plumbing supply vendor consistently overbills for fittings. They filter the 3-Way Match Discrepancy Report by that vendor and date range to see every flagged mismatch, then share the findings with the vendor to negotiate corrections.

  • A bookkeeper runs the report filtered by discrepancy type to find all quantity mismatches over the past quarter. They discover that partial deliveries are the leading cause of discrepancies and work with the warehouse to improve receiving procedures.

  • An administrator reviews the report monthly to track whether the number of pricing discrepancies is decreasing after a Pricebook correction. The trend confirms the correction is working.

Commercial Service and Replacement

  • A controller filters the report by business unit to compare discrepancy rates across branches.

  • An accounts payable (AP) clerk runs the report to find all bills with unresolved discrepancies before month-end close. They reconcile the remaining items in bulk instead of searching bill by bill.

  • A manager identifies that a specific vendor's bills consistently show tax discrepancies. They use the report data to renegotiate the vendor agreement and align on tax calculations.

Residential Construction

  • A project accountant filters the report by date range to review all discrepancies on material orders for a large remodel. They spot a pattern of overcharges on lumber and escalate to the vendor before approving further invoices.

  • A bookkeeper uses the Bill vs. purchase order (PO) Variance percentage column to flag any bills with variances above a set threshold. This helps prioritize which discrepancies to investigate first.

  • An administrator runs the report across all vendors to prepare for a quarterly vendor performance review, using the data to evaluate which suppliers have the fewest billing issues.

Commercial Construction

  • A project manager filters the report by PO number to see all discrepancies tied to a specific multi-delivery purchase order (PO). They identify that one delivery was billed at a higher unit cost than agreed and request a credit from the vendor.

  • An accounts payable (AP) team filters by reconciliation reason to see how many discrepancies were resolved as pricing errors vs. quantity errors. They use the breakdown to target process improvements on the most common root cause.

  • A controller reviews the report monthly to monitor overall discrepancy volume and value. A spike in receipt vs. PO variances triggers a review of the receiving process at a specific job site.

How to prepare?

  1. Have an administrator reach out to Support or your Customer Success Manager (CSM) to have 3-Way Matching and Advanced Reporting configurations enabled if they are not already active.

  2. Confirm your team creates purchase orders, receipts, and bills in ServiceTitan for every purchase so discrepancy data is available in the report.

  3. Identify the discrepancy types and vendors your team wants to track most closely, so you can set report filters that match your priorities.

  4. Train your accounting staff to run the report on a regular cadence, such as weekly or before month-end close, to catch trends early.