commaudit

This is a sample. Midwest Foodservice Reps and the manufacturers below are fictional, and the statements were generated with known errors.

Commission audit for Midwest Foodservice Reps

$2,042.75

Recoverable from 4 manufacturers: commission missing or underpaid.

Manufacturers with commission owed
4
Booked orders matched to a paid line
48
Statements held for review
1
Unpaid bookings not flagged
2

Not in the total

Summit Dish Systems is not in this report. Its 1 statement is held until a person checks it.

Lakeshore Ice Machines has 2 booked orders, but no statements were provided for it.

2 unpaid bookings fall outside the statement period or are too recent to be due, so they are not flagged.

Bayline Refrigeration

$39.70shortfall, 1 finding

  1. St. Mary's Hospital Cafeteria

    Underpaid
    Invoice
    INV-041238
    PO
    PO32282
    Date
    2026-04-21
    Booked
    $3,969.85
    Expected
    $198.49
    Paid
    $158.79
    Short
    $39.70

    Paid 4.00% against a contract rate of 5.00% (rate off).

    Evidence
    • Bookings row 3: $3,969.85
    • 2026-05.pdf page 1: $158.79

Copperleaf Smallwares

$1,153.97shortfall, 2 findings

  1. Riverside Hotel

    Missing
    Invoice
    INV-041299
    PO
    PO11866
    Date
    2026-05-05
    Booked
    $14,424.66
    Expected
    $1,153.97
    Paid
    $0.00
    Short
    $1,153.97

    Booked, no matching line on any statement.

    Evidence
    • Bookings row 13: $14,424.66
  2. Red Rock Brewing Company

    Not in your bookings
    Invoice
    INV-041335
    PO
    PO28251
    Date
    2026-06-09
    Paid
    $418.07

    Paid, no matching booking.

    Evidence
    • 2026-06.xlsx row 13: $418.07

Northfield Ovens

$826.58shortfall, 2 findings

  1. Riverside Hotel

    Missing
    Invoice
    INV-041164
    PO
    PO60926
    Date
    2026-04-30
    Booked
    $16,531.58
    Expected
    $826.58
    Paid
    $0.00
    Short
    $826.58

    Booked, no matching line on any statement.

    Evidence
    • Bookings row 7: $16,531.58
  2. Red Rock Brewing Company

    Paid twice
    Invoice
    INV-041197
    PO
    PO33399
    Date
    2026-05-23
    Paid
    $388.67

    Same invoice, amount and commission as 2026-05.pdf page 1.

    Evidence
    • 2026-06.pdf page 1: $388.67
    • 2026-05.pdf page 1: $388.67

Ridgeway Fabrication

$22.50shortfall, 1 finding

  1. Harbor Grill LLC

    Underpaid
    Invoice
    INV-041386
    PO
    PO27180
    Date
    2026-05-18
    Booked
    $9,400.00
    Expected
    $282.00
    Paid
    $259.50
    Short
    $22.50

    Paid on 8,650.00 of sales, booked 9,400.00 (amount off).

    Evidence
    • Bookings row 31: $9,400.00
    • 2026-05.csv row 7: $259.50

Summit Dish Systems

Held for review: 2026-06.xlsx

The lines on this statement add up to $2,147.78, but the statement's printed total is $2,272.78. A statement that doesn't add up is never used, so no findings for Summit Dish Systems are reported until a person has checked it.

The claim email for Northfield Ovens

Subject: Commission discrepancies for Midwest Foodservice Reps, 1 line(s), $826.58

Hello Northfield Ovens commissions team,

We reconciled your recent commission statements against our booked orders and found 1 line(s) where commission appears unpaid or short. Details:

- Riverside Hotel (invoice INV-041164, PO PO60926, 2026-04-30), booked $16,531.58: not on any statement; expected commission $826.58

Total requested: $826.58.

Please confirm these lines and include the adjustment on the next statement, or let us know if any of these orders shipped short, were cancelled, or were paid under a different invoice number.

Thank you,
Midwest Foodservice Reps