Here's something true about contractors who do commercial work.

You always know where the job stands. Walk the site on the last Friday of the month and you can call it trade by trade: grading's done, the steel is half set, the roofers start Tuesday. You carry the percent-complete of a $1.4 million job around in your head, and you're right. That part you're great at. You've done it a thousand times.

So why does billing for work you already finished take a whole evening, and still come back with a red circle on it?

It shouldn't. And it doesn't have to.

Quick story.

My dad's been a commercial contractor in Georgia for about 30 years. Churches, restaurants, shopping plazas. (He built the house I grew up in too, but the real work was always commercial.) And on commercial jobs, you don't just send an invoice when you're done. You get paid in draws, and every draw starts with a pay application: the contract broken out line by line, what you billed on previous applications, what you finished this period, what's stored on site, and retainage held out of every single line.

The building was never the problem. The man can price a job from the truck. The problem was the end of the month, when getting paid for the work meant sitting down with last month's application, a calculator, and a form where every line has to tie to the penny.

Because here's the thing about pay apps: someone checks them. An architect or an owner's rep goes through every line, and if your "previous applications" column doesn't match last month's totals, or the retainage doesn't compute, it doesn't get fixed with a phone call. It comes back. And a pay app that comes back doesn't cost you a few days. It costs you the whole cycle, thirty more days of fronting payroll and materials on money you already earned.

That's not a billing problem. That's a spreadsheet problem.

So I fixed his spreadsheet.