Forecast cash by expected receipt and payment week, using reconciled opening balances and realistic agent-retained amounts. Test a delayed receipt, keep reserved funds separate and decide on spending before the lowest-balance week arrives.
In this guide
A strong pipeline can coexist with a tight business bank balance. The operational question is when cash will be available to cover commitments, not merely how much commission appears in the pipeline. A weekly forecast gives an agent a way to test that timing before approving another recurring expense.
This is an original planning worksheet for your own business operating cash. It is not investment advice, a tax calculation or a substitute for accounting records. All amounts, dates and spending thresholds below are invented illustrations. Use your actual brokerage arrangements and work with your accountant on reserves, obligations and owner compensation.
1. Establish the cash that is available for operations
Begin with reconciled balances. Identify funds already assigned to tax obligations, restricted purposes or other commitments so the same dollars are not available twice in your plan. Client funds never belong in this operating worksheet. List pending payments and known withdrawals that have not yet appeared in the balance.
The SBA’s business-finance guidance emphasizes bookkeeping, available cash and bank reconciliation, and recommends obtaining accounting help when needed. The forecast here applies those general principles to commission timing; it does not choose an accounting or tax treatment for your business.
- Opening operating cash: the verified amount available for the modeled expenses.
- Reserved funds: money excluded from discretionary operating decisions.
- Known payments: amount, due date and evidence for each commitment.
- Expected receipts: agent-retained amount, anticipated receipt week and unresolved conditions.
- Owner transfers: planned withdrawals shown separately from vendor expenses.
Do not start with gross commission income and assume the whole figure reaches your account. Use the amount expected after applicable brokerage deductions and referral payments, then show any remaining obligations separately. Check the actual statement when money arrives and reconcile differences rather than carrying an estimate indefinitely.
2. Build a rolling weekly forecast
Use a column for each coming week and rows for opening cash, receipts, operating payments, owner transfers and closing cash. For each column, calculate closing cash as opening cash plus receipts minus payments and transfers. Carry that closing amount into the next week’s opening row. Choose a horizon long enough to include your meaningful scheduled commitments.
| Illustrative row | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening cash | $8,000 | $5,000 | $9,000 | $6,000 |
| Expected receipts | $0 | $7,000 | $0 | $0 |
| All modeled outflows | $3,000 | $3,000 | $3,000 | $3,000 |
| Closing cash | $5,000 | $9,000 | $6,000 | $3,000 |
In this example, all outflows combine operating payments and planned owner transfers solely to keep the table small. Your working sheet should separate them. The expected $7,000 receipt is not a guarantee; it belongs in a forecast with its timing assumption visible.
3. Test a delay instead of averaging away the problem
Now move the same expected receipt from Week 2 to Week 4, keeping everything else unchanged. This is a timing scenario, not a probability estimate. It answers whether the current spending plan would remain workable if the receipt arrived later.
| Delayed-receipt scenario | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening cash | $8,000 | $5,000 | $2,000 | -$1,000 |
| Expected receipts | $0 | $0 | $0 | $7,000 |
| All modeled outflows | $3,000 | $3,000 | $3,000 | $3,000 |
| Closing cash | $5,000 | $2,000 | -$1,000 | $3,000 |
Both scenarios end Week 4 at $3,000, yet the delayed scenario shows a $1,000 shortfall in Week 3. A monthly total hides that difference. The negative figure flags a funding gap under these assumptions; it is not permission to overdraw an account or postpone an obligation. Discuss options before the affected week.
4. Give each expected commission a timing record
For each anticipated receipt, record the file identifier, expected agent-retained amount, scheduled closing information, expected payment timing and unresolved dependencies. Avoid putting unnecessary client details in a business forecast. A signed contract, a completed closing and money received are different states, and the sheet should preserve that distinction.
Keep an expected case and a delay case. Do not assign a universal percentage probability to each transaction stage unless you have a defensible method and understand its limitations. For immediate operating decisions, a transparent delay test can be easier to explain than a weighted pipeline total that appears more certain than it is.
Example question for accounting or brokerage support: “For my operating forecast, I have estimated [net amount] arriving in [week]. Which deductions or payment steps still need confirmation, and what evidence should I use to update that assumption?”
5. Make spending decisions against the lowest projected balance
Set a planning floor appropriate to your business with professional input. Treat it as a decision trigger, not a universal reserve rule. Before adding spending, enter the initial cost, recurring charges, commitment period and payment weeks. Compare the lowest projected balance in both scenarios with that floor.
| Forecast condition | Operating response to consider |
|---|---|
| Unclear receipt amount or date | Confirm evidence before treating the estimate as dependable |
| Balance falls below the chosen floor | Review discretionary spending and owner-transfer assumptions |
| A required payment lacks funding | Raise the issue promptly with the appropriate adviser |
| New recurring expense deepens the gap | Reassess timing, scope and commitment before approval |
Do not assume more lead spending will produce cash in time for the gap. Lead generation may be a sound business decision, but its future outcome does not pay an already scheduled bill. Evaluate the marketing decision and cash timing separately, using realistic assumptions for both.
6. Reconcile weekly and improve one assumption
- Replace the completed week’s forecast with actual receipts and payments.
- Reconcile balances against the appropriate records.
- Move delayed receipts to the revised week and document why.
- Add new commitments and remove expenses actually cancelled.
- Review the lowest projected balance and record the next decision.
Your first action is to model the next four weeks using verified cash and known commitments, then move one expected receipt two weeks later. If the decision changes, identify the action and owner now. The Business Growth pillar of the Elite Agent Operating System connects production planning with sustainable operations. Explore Elite Agent Accelerator on Skool if you want coaching around maintaining the planning habit; use qualified financial professionals for the accounting and tax decisions.
