Industry Use Cases

How to Find Completed Waste Pickups You Never Billed For

Dispatch marked the extra dumpster pickup complete on Thursday. The customer’s invoice went out Friday with their regular monthly charge and nothing for the extra trip. Both records look fine on their own. The gap shows up when you put them side by side.

Start with one closed billing cycle and one type of separately billed service, such as extra pickups or roll-off hauls. That keeps routine stops covered by a flat fee off the review list.

Bring the pickup log and the invoice lines

If you work in Excel, use your completed work orders, invoice register with one row per charge, and customer rate sheet. Keep job ID, customer, site, service type, service date, quantity, amount, and any invoice reference.

If you use dispatch and accounting software, export completed jobs from a report such as the ServiceCore Job Data Report and invoice details from a report such as Sales by Product/Service Detail in QuickBooks Online. Keep the rate sheet or service terms as a third tab. Include later invoices if they cover pickups in your review period.

Match the pickup to the charge

Use a shared job ID first. If dispatch links a job to an invoice, inspect the lines on that invoice. Where there’s no shared reference, compare customer, site, service date, and service type where present. Keep ambiguous matches for manual review.

Which completed extra pickups have no matching invoice line? Separate bundled, waived, and uncertain matches. Show the job ID, site, service date, expected charge where there’s an agreed rate, and source rows.

Review the exceptions before billing

Suppose eight pickups lack a clear line. Three are included in the monthly plan and two may be on a consolidated invoice. If the remaining three have no matching charge and carry an agreed rate of $175 each, that’s $525 to review. Open the source rows, check later invoices and alternate item codes, then send the confirmed job IDs to billing.

Save the analysis in Jolene.pro and rerun it for the next cycle.

The example uses sample data. Verify service terms, credits, and later invoices before adding a charge.

Try Jolene.pro · Follow Jolene.pro on LinkedIn

Leave a comment