How to Find Waste Hauling Customers Still Billed at Last Year’s Rates
A new dumpster rate took effect in July, but the August invoice still shows the old price. The billing clerk needs the affected sites and charges before changing a rate or contacting anyone.
What to pull
Use a customer rate workbook and invoice detail tab, or export invoice lines from accounting and pair them with the rate schedule from dispatch or your contract tracker. Keep customer ID, site, service code, effective dates, units and base price.
How to check it
Select both sheets in Jolene.pro. For each billed service, pick the signed rate in force on its service date. Compare like units. Keep disposal, taxes and fuel surcharges separate from the base price.
Which invoice lines used an expired base rate? Show the site, service date, billed rate, effective agreed rate, units and source rows.
What to do with the result
Four pulls billed at $145 after a signed increase to $160 put $60 on the review list. Confirm the effective date and any grandfathered terms. Fix the recurring rate before the next run and have billing decide how to handle earlier invoices.
Sample figures. Check signed rates and any customer-specific terms before adjusting an invoice.