Industry Use Cases

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.

Try Jolene.pro · Follow Jolene.pro on LinkedIn

Leave a comment