TOOLS AND TEMPLATES · 7 OF THEM

THE FILES WE USE WITH CLIENTS.

QUICK ANSWER

Everything on this page is a working file and not a brochure: the same workbooks SPM installs for clients, published so a contractor can fix his own billing without hiring anybody.5 workbooks, one $49 cash flow forecast, and a benchmark dataset any machine can read. We will never sell your information.

A spreadsheet you keep, update and take to your estimator is worth more than a web form that gives you a number and forgets it. That's why most of this page is workbooks.

THE WORKBOOKS

7 FILES, AND WHAT EACH ONE DOES.

LENDER AND SURETY WIP SCHEDULE TEMPLATE

One row per open job, 100 lines, with the unused ones collapsed behind a single plus sign and every total spanning all of them

Five entries per job: contract price including change orders, estimated total cost, cost to date, billed to date, and the description

Eleven columns calculated from those, including percent complete, earned revenue, and over and underbillings

EXCEL WORKBOOKGet it

EQUIPMENT AND VEHICLE COST BASIS TEMPLATE

One row per unit: number, year, make, model, VIN, current value, useful life in years and in Hobbs hours, replacement cost, and annual maintenance, insurance and other

Four rates calculated per unit: hourly for metered equipment, then daily, weekly and four week

Company totals across the fleet, so the whole equipment cost basis is one number you can put against overhead

EXCEL WORKBOOKGet it

OVERHEAD CALCULATOR

Seven cost sections with the line items already written in, from office rent through to non-direct employees and business taxes

Three input columns, weekly, monthly and annual, so each cost goes in at the frequency you really pay it and the workbook annualizes it

Your rate against target revenue and against actual revenue side by side, which is the comparison that shows whether the rate you bid survives the revenue you booked

EXCEL WORKBOOKGet it

SCHEDULE OF VALUES AND PAY APPLICATION TEMPLATE

One SOV Calculator tab where the contract, the retainage rate and the line items get entered once

A Change Order Log that bills onto every application from a single entry

36 pay applications, each one carrying its own period, the previous applications, this period, materials stored, complete to date, balance to finish and retainage

EXCEL WORKBOOKGet it

G702 AND G703 APPLICATION AND CERTIFICATE FOR PAYMENT

Page 1, the G702 Application and Certificate for Payment

The G703 Continuation Sheet

EXCEL WORKBOOKGet it

13-WEEK CASH FLOW FORECAST TEMPLATE

$49, PAID · $49 once. It carries the overhead calculator as well, and the download link doesn't expire.

Thirteen weeks rather than a month, because the week you need to see is rarely the one you're in

Receipts dated on how each general contractor really pays rather than on the contract terms

Retainage on its own line, since it's money earned that nobody sends on the normal cycle

EXCEL WORKBOOKGet it

CASH FLOW INTERVENTION

$497, 90 MINUTES · $497. A working session on Microsoft Teams, and the forecast gets filled in with your numbers rather than delivered blank.

The 13-Week Cash Flow Forecast Template, downloadable straight after payment and re-downloadable from a link that doesn't expire

A 90 minute working session where the forecast gets filled in with your real numbers rather than delivered blank

The billing and collection changes that come out of it, made during the call rather than written up afterwards

90 MINUTE SESSIONGet it

THE ONE CALCULATOR

MARKUP VERSUS MARGIN, IN YOUR BROWSER.

The one piece of arithmetic on this site that's worth doing in a web page, because it's a single conversion and getting it backwards is the most expensive mistake in construction pricing. A job marked up 20 percent earns a 16.7 percent margin, and a contractor who believes those are the same number is short 3.3 points on everything he sells.

NOTHING ENTERED, NOTHING STOREDOpen the calculator

THE DATASET

48 TRADES, PUBLISHED AS DATA.

Gross margin, overhead and net profit for every trade across 7 revenue bands, as two fetchable endpoints rather than a page you have to read. Free, no attribution required beyond a link, and every figure carries its provenance so you can see which are measured and which are derived.

TRADE BENCHMARK DATASET, JSON

All 48 trades across 7 revenue bands: gross margin, overhead and net profit, with the provenance on every figure.

/construction-benchmarks.json

TRADE BENCHMARK DATASET, CSV

The same dataset as a spreadsheet, so it opens in Excel and can be pasted next to your own numbers.

/construction-benchmarks.csv

IF YOU WOULD RATHER BE SHOWN

SIX SESSIONS, NO REGISTRATION.

A six part series on making payroll out of the work you've already done rather than out of a line of credit. Each session covers one of the five financial holes in a subcontracting business and points at the workbook on this page that closes it. Nothing to enter, nothing to join.

6 PARTSNever Miss Payroll Without Taking On Debt

THE DOCUMENT TEMPLATES

12 MORE, ALL BY EMAIL.

Trackers, billing paperwork and the notices that protect a receivable. Every field you need to change is highlighted and none of them carry anybody else's job. The legal ones say plainly that they're a starting point for your own attorney, because notice windows and clause enforceability vary by state.

TRACKERS

Project Document Tracker. Six tabs covering everything a job generates: submittals, RFIs, change orders, drawing sets, purchase orders and open action items.

BILLING

T and M Rate Sheet. Every piece of equipment you run, priced by day, week and month, with the fuel it burns and what it costs to get it there, plus crew rates at regular and overtime.

Change Order Letter. A letter submitting a change request to a general contractor, with the clarifications and exclusions paragraph that decides what you are and aren't agreeing to. Attorney review before use.

JOB PAPERWORK

RFI Template. A single request for information, formatted to go to a general contractor, an architect or an owner, with a note in every field telling you what belongs there.

Submittal Cover Sheet. The cover page and contact sheet for a submittal package. Enter the spec section, submittal number and date once and the contact sheet reads them by formula.

FIELD

Job Safety Analysis. A one page JSA: the task broken into steps, the hazard in each step, and the protection that controls it.

Jobsite Map and Contact Sheet. One page a crew can read: project number and title, address, field supervisor and project manager with numbers, additional site contact, jobsite hours, parking, and room for a map.

GETTING PAID

Notice of Nonpayment. A formal notice that a payment has come due and not been paid, addressed to the party who owes it and copied to the project owner. Attorney review before use.

PROTECTING THE WORK

Notice of Delay. A notice that something outside your control has moved the schedule, with the date it began and the factual cause. Attorney review before use.

Notice to Stop Work. A direction to a party working under you to suspend operations, with the effective date, time and the specific portions of work covered. Attorney review before use.

Notice of Termination. A notice ending a party's services on a project, referencing the agreement it was formed under and attaching it. Attorney review before use.

Subcontract Agreement. A full subcontract agreement for hiring a subcontractor under you: the parties, the upstream contract it flows from, the engineer, the scope and the terms. Attorney review before use.

$10.7M+

Client AR Recovered Since 2023

Active Trade Specializations

60 DAYS

Average Onboarding Time

COMMON QUESTIONS

BEFORE YOU DOWNLOAD ANYTHING.

What do these tools cost?

Most of them. All 5 Excel workbooks are emailed to you as attachments, and we will never sell your information. The 13 week cash flow forecast costs $49 and the working session that fills it in with you is $497. The two benchmark dataset endpoints need nothing at all, because a machine reading them cannot fill in a form.

Do I have to become a client to use them?

No. These are the same workbooks SPM installs for clients, published because a contractor who fixes his own billing with a free spreadsheet is a better conversation later than one who never heard of us. Nothing on this page requires an engagement, a call or a commitment.

Why is one of them behind a payment?

The 13 week forecast is the tool the whole practice runs on and it's the one that takes a working session to fill in properly, which is why it's sold with one. At $49 it's priced to be bought and not to be a lead magnet. The other four workbooks carry no price because a schedule of values or an equipment rate is arithmetic you can check yourself.

Is there a calculator I can use without downloading anything?

The markup versus margin calculator runs in your browser with nothing entered and nothing stored. Beyond that the answer is deliberately no: an overhead rate or an equipment rate built in a web form and forgotten is worth less than the same number in a workbook you keep, update and take to your estimator.

What's the video series?

A six part series on making payroll out of the work you've already done rather than out of a line of credit. Six sessions, no registration, and each one points at the tool on this page that closes the hole it covers. It's the fastest route through all of this if you would rather be shown than read.

WHERE TO GO NEXT

HOW TO USE THEM

Schedule of Values, In Depth WIP Schedules Calculate Your Overhead Rate

WHAT THEY FIX

Construction Cash Flow Job Costing Out of Cash With Work Sold

IF YOU WANT IT RUN FOR YOU

Pricing, Every Band How SPM Runs Client Finance Run on CFOS, Full System Index

Josh Luebker

FRACTIONAL CFO · THE CONSTRUCTION CFO

Former commercial project manager and master electrician: 150+ projects worth $2.1B combined, from $50,000 to $300M. Now fractional CFO to commercial subcontractors.

About Josh | LinkedIn

THE FILES WE USE WITH CLIENTS.

7 FILES, AND WHAT EACH ONE DOES.

MARKUP VERSUS MARGIN, IN YOUR BROWSER.

48 TRADES, PUBLISHED AS DATA.

SIX SESSIONS, NO REGISTRATION.

12 MORE, ALL BY EMAIL.

BEFORE YOU DOWNLOAD ANYTHING.

WANT THESE FILLED IN WITH YOUR OWN NUMBERS?