One Sale, Six Payments: Why Commission Spreadsheets Break on Big Jobs

I used to ask my manager what I was owed. Not because he was hiding anything — because I had no way of knowing myself.

That is an uncomfortable thing to admit when your whole job is selling. I could tell you every deal I had closed that year, down to the address. The CRM had all of it. What the CRM did not have — what nothing had — was a record of the commission payments. Those arrived as line items in my bank account, and sometimes as a text message telling me a check was ready.

So once a month I would ask. And he would tell me, and he was always right, and I would move on. But someone else knowing is not the same as knowing.

Why home improvement is different

A lot of sales jobs are easier to track than mine. The deal closes, the commission is calculated, and the payment follows.

Remodeling does not always work that way. The customer pays the company in progress draws — a deposit, then money at demo, at rough-in, at drywall, at fixtures, at final walkthrough. Your commission follows that schedule, because the company pays you out of money it has actually collected.

A bath remodel might settle in two payments. A full-house interior and exterior job takes five or six, spread across most of a year. Here is what one looks like — a $94,000 remodel at a flat 6%:

Seven months from signature to the last dollar. Six separate payments, none of which look like the commission on their own.

Now run twenty of those at once, at different stages, and answer this: how much are you owed right now? Not what you sold. What is earned and unpaid, today.

That number is not in your CRM. Your CRM tracks sales, not what got paid to you. It is not on your pay stub either, which shows what arrived this period and nothing about what is still outstanding. The only place it can exist is somewhere you build yourself.

What happened to me

I have an IT background, so when I got tired of asking, I built a tool for myself. Then I went back through the previous year to load it up — bank statements, text messages, WhatsApp threads, anything that told me a payment had landed. It took a weekend.

One deal came up about $2,500 short. Every other payment reconciled. That one did not.

I sat on it. It was a year old by then. I trust my manager completely — he has always paid me every dollar I have earned. And I had no record to bring him, just a gap in a spreadsheet I had made myself. What was I going to say? I think you missed something twelve months ago, but I cannot prove it. So I marked the deal paid in full and moved on.

Months later it came up in conversation by accident. He mentioned paying me on that job. We both went and checked dates. The payment had gone out — it had just been recorded against a different deal, a large one that was running at the same time. That other deal now showed $2,500 more than it should have. Mine showed $2,500 less.

We fixed it in ten minutes.

That is the part worth sitting with. I did not lose that money to a bad manager. I nearly lost it to not being able to ask. Trust does not stop honest mistakes. It just means nobody notices them.

Why the spreadsheet does not hold

Everyone starts in Excel. I did. It works fine until progress payments show up, and then it breaks in a specific, predictable way.

You need somewhere to put each payment. So you add columns: Payment 1, Payment 2, Payment 3. Then a full-house job takes six, so you add three more. Now every row in the sheet is six columns wide, and most of your deals were paid in one or two.

Four deals, and already most of the grid is empty. At forty deals you are scrolling sideways past blank cells looking for the one row that still owes you something.

The problem is not that Excel is weak. It is that a spreadsheet wants every row to be the same shape, and commission payments are not the same shape. One deal has one payment. The next has six. A grid cannot hold that without either wasting most of its columns or running out of them.

And the column you actually care about — what am I still owed — has to be recalculated by hand every time a payment lands, on the right row, with the right number of terms. Miss one and the sheet is quietly wrong, and it stays wrong, because nothing tells you.

The other half: you are never at the computer

The grid problem is about shape. This one is about timing, and it is the reason my own sheet had a hole in it in the first place.

You find out you got paid on a Tuesday afternoon, sitting in a driveway between appointments. Logging it means going home, opening a laptop, opening the sheet, scrolling down to find the right deal among forty, scrolling right to find the first empty payment column, and typing a number into a cell whose header you can no longer see.

So you do not. You tell yourself you will catch up Sunday. By Sunday there are three payments to enter and you are reconstructing them from your banking app, guessing which deposit belonged to which job.

Google Sheets on a phone is worse, not better. The grid does not fit a phone screen, so you are pinching and dragging to land on one cell, and one fat-fingered tap puts $1,128 on the wrong row. I tried. I stopped trying.

That is the thing I actually wanted to fix. Not a better spreadsheet — a way to log a payment in ten seconds, standing in a driveway, on the phone that is already in my hand. Pick the deal, type the amount, done. If it takes longer than that it does not get done, and if it does not get done the whole record is worthless.

It is not just me

After I had been using my own tool for a while, I showed it to a couple of friends who sell construction. I expected them to shrug.

Both had the same problem. One of them was not tracking at all — he took what arrived and assumed it was right. He told me he had lost about two or three thousand dollars the year before, and more than that the year before it. He cannot prove that figure and neither can I; nobody kept the records that would settle it. That is exactly the point. The money you cannot account for is money you cannot ask about.

That is when I stopped thinking of this as my problem. Most reps in this trade are in a spreadsheet. Most of those spreadsheets stop working at the same place mine did.

Five things to track instead

You do not need eight columns. You need five things, and one of them is the reason the other four exist.

1. 1The deal, with its contract value. Whatever the commission is calculated from — the contract total, or gross profit if that is your agreement. Write down which one, because it matters and people forget.
2. 2Your rate, and what it applies to. Flat percentage, tiered ladder, per-job bonus. If your plan changed mid-year, the deal remembers the rate it was sold under, not the rate you are on now.
3. 3Every payment as its own record — amount, date, and which deal it belongs to. This is the one a spreadsheet cannot do. A payment is not a column on a deal. It is a thing in its own right that points at a deal, and it can point at the wrong one. Mine did.
4. 4What is still owed. Commission earned minus payments received, calculated for you, every time, on every deal. Never by hand.
5. 5How long since the last payment. Not how long since you signed — how long since money last moved. A deal that paid twice and then went quiet four months ago is the one to ask about. A deal signed eight months ago that paid last week is fine.

That last one is the whole thing. “How much am I owed” is a number you can look up. “Which deal has gone quiet” is the question that gets you paid, and it is the one a spreadsheet will never answer, because the sheet does not know what today’s date is.

What I would tell you to do

Start the record. That is it. Even a notes app beats nothing, as long as every payment gets a date, an amount, and a deal name attached to it.

Because the failure here is not usually theft, and it is not usually your manager. It is that two jobs ran at the same time, a payment got filed under the wrong one, and nobody had the paperwork to notice for a year.

I got mine back because he happened to mention it. That is not a system.