Your listings were worth $0 and the software said so

Open your pipeline and look at what your listings are contributing.

If the answer is nothing, the software is not telling you your listings are worthless. It is telling you it never had a number to show, and decided that zero was close enough.

$0.00

shown for every percentage-based listing

3%

the rate that was stored instead of a dollar figure

$16,350

what one of those rows was actually worth

Figures from the fictional workspace used for our screenshots.

We shipped exactly this, so the explanation is first-hand. A tidy $0.00 in the income column, sitting next to deals showing real numbers, with a pipeline total at the top of the page that had confidently added the zero in.

The cause is dull, which is usually how these go. When you enter a buyer deal you often type the commission as a dollar amount, and it gets stored. When you list a property you far more often enter a rate: three percent of an as-yet-unknown sale price. There is no dollar figure to store, because the number does not exist yet. It is a calculation waiting on a sale.

Our list read the stored field. For listings there was nothing in it. So it printed zero, and the total agreed.

A stored number and a derived number are different things

This is the same mistake as pricing a closed deal from today's cap position, and it is worth naming as a category because it keeps recurring.

Some numbers are facts: entered by a person, or fixed at a moment that has passed. A settled deal's net income is a fact.

Other numbers are derivations: they do not exist until something computes them from inputs. A percentage listing's commission is a derivation, and it stays one right up until closing, when it becomes a fact.

Software that treats a derivation as a fact reads an empty box and reports the emptiness. Software that treats a fact as a derivation recomputes history and changes numbers you already reported. Both failures are silent, and both look like the software working.

Gross commission is not what you are owed either

Even when a dollar figure does exist, it is usually the wrong one to show.

Take a $545,000 purchase at three percent. Gross commission is $16,350. That is the number most systems display, and it is not what the deal is worth to your business.

A referral comes off the top before anything else touches it. An admin fee is money the transaction collects. Neither is in "gross commission", and a quarter of that deal's headline figure belongs to someone in another state.

Show gross across a pipeline of referred deals and the number is inflated by thousands. Show it on percentage listings and it is zero. Neither is a rounding problem.

A total that omits rows is worse than no total

Here is what makes this worse than an ordinary display bug.

A blank field prompts a question. Someone sees the gap, wonders, and checks. The software has told you it does not know, which is a kind of honesty.

$0.00 in a currency column is an assertion. It says the value was computed and the answer is nothing. And when that zero is summed into a pipeline figure at the top of the page, the error stops being visible at all — it is now a slightly smaller number with nothing to distinguish it from a correct one.

We shipped that. On a list whose entire purpose is telling you where you stand.

What to check in whatever you use

Three tests, none of which need our software.

Enter a listing as a percentage and look at the pipeline total. If the row reads zero, the total is wrong by the value of every listing you hold. This is the fastest way to catch it, because listings are exactly where percentage entry is normal.

Add a referral fee and watch the number move. If the displayed figure does not change, you are looking at gross, and gross is not yours.

Change a deal's transaction fee to something non-standard. If a header total stops matching the rows beneath it, two different calculations are running on one screen. That one cost us an afternoon before we found it.

What this does not fix

Correct arithmetic on a projection is still a projection. A percentage listing has no commission until it sells, and a pipeline figure built on list prices is a statement about what you hope happens. It is useful for deciding where to spend Tuesday. It is not income, and no display can make it one.

Nor does any of this settle what your brokerage will actually pay. Splits, caps, and fees sit downstream of every figure here, and your independent contractor agreement (ICA) governs all of them.

KeyFlow now prices every row through the same engine the transaction form uses, so a percentage listing shows what it is currently worth and a referred deal shows what survives the referral. We changed it because our own screenshots did not add up, which is a poor way to find out and the reason this article exists.