Q4 Agent Commission Cash Forecast: Build It in September

Build your Q4 agent commission cash forecast around the date each net payment is expected to become available in your account. Keep prospective business, conditional receipts from scheduled closings and collected cash separate. Then test whether October–December bills remain covered if a December closing moves into January.

September gives you time to adjust spending before the quarter begins. Aim for a dated cash schedule that identifies the first potential shortfall and the spending decisions that could prevent it.

Establish your available opening cash

Gather bank records, recent commission statements, unpaid bills and recurring commitments. NAR’s May 8, 2025, budgeting guidance recommends grounding plans in historical operations and paying attention to team compensation and monthly costs.

Project your September 30 available balance from today’s cash plus remaining September receipts and payments. Exclude money already reserved for taxes or other purposes, then replace the projection with reconciled cash when October begins. Record future reserve transfers as planned cash uses so those dollars do not appear available for routine spending.

Separate pipeline stages from collected cash

Use these categories in your worksheet:

• Collected: Record the actual deposit. Money included in the opening balance must not also appear as a future receipt.
• Closed, unpaid: Enter the outstanding net amount, expected availability date and anything still needed for payment release.
• Under contract: Include a conditional receipt using the scheduled closing and verified payment process. Note unresolved inspection, financing or title issues and the next confirmation date.
• Listings, active buyers and leads without a purchase contract: Keep these in a separate opportunity list. Exclude them from the receipts used to test committed bills.

A pending file’s full amount belongs in the scheduled scenario only with the explicit assumption that it closes and pays. Test delay and failure separately instead of multiplying commissions by guessed conversion percentages; the stage labels do not establish probabilities.

Calculate the net payment and its availability date

For each file, start with the commission payable to your brokerage for your side of the transaction. Apply referral deductions, broker and team splits, and transaction charges in the order your agreements specify. Those agreements establish the commission economics for that file.

Hypothetical calculation: A $12,000 commission has a $3,000 referral deduction. Assume the agent receives 70% of the remaining $9,000, with a $300 transaction charge withheld from that share. The expected deposit is $6,000: $9,000 × 70% − $300. These terms are invented for illustration and do not represent standard rates. The deposit is before personal taxes and other business spending.

For a team forecast, choose either full receipts with agent payouts recorded as cash uses, or receipts net of those payouts. Do not deduct the payouts twice. Use the brokerage contribution margin template separately to assess what each closing contributes toward overhead.

Record the closing date and expected bank-availability date separately. Ask your brokerage whether payment depends on funding or file approval, which processing schedule applies and whether anything is missing from the file. Have your broker confirm deductions and release conditions, and your accountant confirm planned reserves and owner withdrawals.

Build the scheduled and delayed-closing scenarios

The SBA’s January 2017 Small Business Start-up Guide, page 19, includes monthly projections and a cash-flow projection in its planning framework. The worksheet below is an original illustration, not an SBA or NAR form.

Create one row per transaction. Alongside the columns below, retain its stage, payment confirmation, unresolved issue and date last checked. Every amount and date in this example is hypothetical; all three files are assumed to be under contract.

In the delayed case, assume File C closes January 4 and pays January 8. These intervals are scenario assumptions, not promised processing times.

Now assume $8,000 in available opening cash on October 1 and $8,000 of planned cash uses each month. Those uses include bills, owner withdrawals and planned reserve transfers; opening cash already excludes existing reserves. Assume no other receipts, borrowing or capital contributions. Hold cash uses constant to isolate the payment delay.

Ending available cash = opening available cash + net receipts − planned cash uses.

Carry each month’s ending balance into the next month:

The delayed case exposes a $3,000 year-end funding gap before any corrective action. A January receipt cannot pay a December bill on time. The negative figure identifies an unfunded plan, not an available overdraft.

Monthly totals can also hide an earlier shortfall, so place receipts and bills on a weekly calendar. In this example, if all $8,000 of November cash uses fall before the November 20 deposit, the $6,000 opening balance produces a temporary $2,000 gap despite the $5,000 month-end balance. Extend the schedule through January, including bills due before January 8.

If File C fails altogether, remove its assumed receipt from both December and January. Retain costs already incurred or still payable, and remove only costs that would actually disappear under the applicable agreement.

Identify which spending can change

Build your delayed-closing budget from actual obligations. Check brokerage or desk charges, software, insurance, staff or contractor commitments, debt payments and renewal bills. Keep each payment on its due date unless you have a confirmed change. Show owner withdrawals separately so household needs remain visible.

Mark discretionary spending with its earliest cancellation date and any exit cost. Deferring a new campaign may preserve cash, but it also changes the activity available to generate future business. Reflect that decision in your opportunity plan.

Refresh weekly and when a file changes

Update the forecast on the same weekday each week and immediately after a closing-date change, cancellation, revised deduction or payment confirmation. Replace estimates with actual deposits, preserving the previous forecast so you can identify whether a miss came from the amount, timing or failure to close.

At month-end, reconcile cash and extend the forecast another month. Use recurring payment delays to improve the assumptions in your broader agent business planning. Before authorizing optional spending, check the lowest projected cash balance in the delayed case.