Junk Removal Tracker

A customer calls, describes a pile, and wants a price on the spot. You name a number from gut feel — and find out at the dump scale, or at hour three with the crew on the clock, whether it was a good number. This tracker prices the job before you quote it, in one Google Sheets file, 5 tabs. Pricing Setup holds your numbers once — full-load price, minimum charge, dump fee per ton, crew cost per hour, and the minimum profit you want per job — plus the load price table that turns your full-load price into a price for every fraction. Partial loads are not priced as a straight fraction, because the crew, the drive and the dump trip cost nearly the same: the sample table prices a quarter load at 35% of the full-load price, half at 60%, three-quarter at 80%.

The Quote Calculator is the hero: one row per load size with the quote price, estimated weight and dump fee, labor, total cost, estimated profit and margin, and a Profit Check that flags any load size priced below your minimum before the quote goes out. After the job, the Job Log sets quoted vs. actual — real dump weight, real hours, real profit — and figures the drift between what you predicted and what happened, while the Dashboard totals profit by load size so you can see which loads actually make you money. The fictional sample is one one-truck crew: a $600 full-load price, a $60-per-ton dump fee and a $100 minimum profit, pricing loads at $210, $360, $480 and $600 with estimated profits of $85, $180, $245 and $310 — the quarter load flagged BELOW YOUR MINIMUM at those rates. Its 8 sample jobs close at $3,340 of revenue, $1,684 of costs and $1,656 of profit, $207 a job on average at a 49.6% margin, with total drift of +$16 against the quotes. A pricing and organization tool, not tax or accounting advice.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished spreadsheet file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.