Turn a company's monthly reports into Profitowable benchmarking numbers. Files are read on this page — nothing is uploaded.
Before you upload
In your dispatch software, run the Dispatching Analysis report and choose Export to Excel. Use the full report — do not use the Simple export. The simple version leaves out the itemized charges this tool needs to categorize revenue and count tows.
Drop the dispatch export here, or click to choose
Accepts the detailed .xlsx export (one row per call). Nothing leaves your browser — parsing happens on this page.
Wipes this file and every box assignment so you can drop next month's export into a clean tool.
Report summary — check this against your software first
These are the raw billed totals from the export, shown only to confirm the file read correctly — they should match your dispatch software. Your actual Profitowable figures (with storage on a collected basis) are further down in the Storage panel and the income boxes.
Official subtotals — billed (from the export)
Payment status
Charge lines → box assignment
Auto-assigned by the rulebook. Amber rows need your call — assign them or leave excluded. Change any box with the dropdown; your changes flow into the totals below.
On paid / on open invoices splits each line by the payment status of the invoice it sits on — it does not change the box totals. Income is booked as billed, and the open portion shows up as accounts receivable on your benchmarking form, so it still gets counted. Storage is the one exception: it's counted only when collected, in the panel below.
Charge line
Total $
Calls
On paid invoices
On open invoices
Income box
Status
Call duty class — for lines that follow the job
Some charge lines ride on every kind of job — mileage, fuel surcharge, hourly tow fees, winching — so no single box is right for them. Set those lines to “⇢ Follow the call's duty class” in the table above and their dollars get split job by job, using the column you pick here.
Pick the column that honestly says how big the job was. Vehicle Class is often left at its dispatch default, so check the average invoice in the table below before trusting it — the truck that ran the call is usually the more reliable signal.
Recovery rule — a call is Recovery only when its recovery charges exceed the threshold
Recovery/rotator charges are detected automatically. If a call's recovery charges exceed the threshold, the whole call books as Recovery; smaller ride-along recovery folds into the call's duty box (Light or Medium/Heavy), so it never inflates Recovery.
Recovery charges over$
Storage — counted when collected, not when billed
Billed storage is phantom until someone claims or buys the vehicle. Payments are applied to towing first; storage only counts once towing is covered. The rest is left out as future bad debt.
Profitowable boxes — the numbers to enter
C — Income (less bad debt)
Total income$0
Call counts
Before you upload
In the shop system, run Sales By Profit Center for the month and save it as a PDF or Excel file. Only four profit centers count as towing: HD Tow and HD Winch Out (heavy duty), LD Tow and LD Winch Out (light duty). Recovery and every other profit center are left out.
Towing summary — the numbers to enter
Heavy duty
Light duty
Total towing
Profit center mapping
Profit center
Counts as
Tows (invoices)
Gross sales
Discounts
Net sale
Parts in it
Towing revenue
Avg / tow
Tows = "Invoice Count Excluding $0.00 Invoices" for each profit center. Towing revenue = Net Sale (sales after discounts, before sales tax) with the Parts column taken out, so parts sold on a tow invoice are not counted as towing. Untick Leave parts out to include them, or switch to Gross Sales.
Parking, Recovery and every other profit center are not counted. Vernell's has no medium duty. Change any row with its dropdown — changes are saved and reused next month.
Before you upload
In QuickBooks, run Profit and Loss Detail for the month on an accrual basis and export it to Excel. This tab pulls the towing lines out of the mixed P&L, applies your towing percentages to payroll and expenses, and compares the towing revenue with the other reports you have added.
Towing bottom line — from this P&L and your percentages
Income follows the choices in Compare towing revenue below. Labor and expenses follow the percentages you set. Add to combined totals sends income, tow counts, and Sections E, F and G to the Combined tab.
1 · Towing revenue found on the P&L
What the P&L line says
Lines
Invoices
Revenue
Benchmarking box
Lines are matched by their description, because this P&L has no class or location. Add-on and review rows are other charges billed on the same invoice as a tow. Change any row's box with its dropdown — choices are saved for next month.
2 · Compare towing revenue with the other reports
Benchmarking box
This P&L
Other reports
Difference
Send to benchmarking
Other reports is everything already on the Combined tab (the Sales By Profit Center report and Towbook). Where the two don't match, pick which number goes to the benchmarking report. Picking This P&L replaces the other reports' number for that box. Rows that only the P&L has start on Leave out once other reports are loaded, because those fees and add-ons are usually already inside the Towbook and shop report totals. Switch one to This P&L only if you know it is not counted elsewhere.
3 · Towing labor — percent of each person's pay
EmployeeGross payEmployer tax% towingTowing share
Pay comes from the paychecks on the P&L. Gross pay goes to E — Gross Payroll and employer taxes to E — Payroll Processing. Percentages are saved, so next month you only change what moved.
Every expense account on the P&L is listed. Accounts you leave at 0% stay with the shop. Paychecks are handled in step 3 and are not repeated here. Payroll booked as a lump follows the towing share from step 3.
Combined totals
Run a report on the Towbook, Vernell's or P&L tab, then click Add to combined totals. Every report you add shows up here as its own column, mapped to the same Profitowable boxes, with a total on the right. Adding the same company and period again replaces the earlier one.
Nothing added yet. Load a report on the Towbook, Vernell's or P&L tab and click Add to combined totals.
Boxes are in the same order as the Profitowable benchmarking form. Click Copy next to a number, then paste it into that box in the portal.