A real estate agent cash flow forecast should start with cash actually available, then place expected broker-paid receipts and documented business outflows into the weeks when they are likely to hit the account. Treat every pending commission as conditional, use the amount expected to reach the agent—not the transaction’s headline commission—and record the evidence behind each amount and date. Run a best-supported case and a delay case, then compare forecast deposits and payments with actual activity each week. The forecast is useful when it triggers a decision before a shortfall rather than explaining one afterward.
Commission businesses create a timing problem that a production report cannot solve. A strong pipeline can coexist with a strained operating account when listing expenses, software renewals, contractor invoices, and other obligations arrive before the associated closings. A weekly forecast gives those timing gaps a visible place to live.
A Cash Flow Forecast Is Not a Profit and Loss Statement
A profit and loss statement reports revenue and expenses over a completed period. A cash flow forecast looks forward and estimates when money may enter and leave the business account. The two reports answer different questions: one addresses operating performance, while the other addresses whether cash is likely to be available when an obligation comes due.
The distinction matters because accounting recognition and cash movement are not always simultaneous. Federal small-business guidance treats income statements, balance sheets, and cash flow statements as related but separate views, and the FDIC’s current small-business curriculum distinguishes a historical cash flow statement from a projection used for planning. A profitable period does not, by itself, establish that the next several weeks are funded.
Pipeline is different again. A signed client, executed contract, scheduled closing, funded transaction, and deposited agent payment represent different stages. Keep the operational pipeline beside the cash forecast, but do not turn every pipeline amount into forecast cash.
For Texas sales agents, compensation timing also runs through the brokerage relationship. TREC Rule 535.3 and Texas Occupations Code §1101.651 govern how a sales agent may receive compensation. For forecasting purposes, the relevant receipt is therefore the amount and timing supported by the brokerage’s records and applicable written agreements—not a commission figure remembered from the contract or entered in a CRM.
Build the Forecast Around the Business Account
Use weekly columns and roll the forecast forward on the same day each week. Extend it far enough to cover the commitments you are actively managing; there is no universal number of weeks that fits every agent business.
A useful real estate agent cash flow forecast contains these rows:
Forecast row | What belongs there | Supporting evidence |
|---|---|---|
Opening available cash | Reconciled cash available for business operations | Bank record and completed reconciliation |
Expected broker-paid receipts | Agent-side amounts that may reach the business account | Brokerage statement, commission record, closing status, and expected payment process |
Other business inflows | Documented non-commission receipts, if applicable | Agreement, invoice, or payment notice |
Required operating outflows | Recurring or committed payments | Invoices, contracts, payroll records, card statements, and autopay schedule |
Transaction-linked outflows | Costs connected to identified files or listings | Approved order, invoice, vendor schedule, or brokerage policy |
Planned discretionary outflows | Spending that has not yet become a fixed obligation | Written proposal or internal spending plan |
Separately classified transfers | Owner, tax, financing, or capital movements as directed by the business’s advisers | Bookkeeping records and adviser-approved classification |
Ending available cash | Opening cash plus receipts less outflows | Formula checked against the preceding rows |
Do not count a balance twice because it appears in both a bank account and bookkeeping transfer account. Do not include money that is unavailable for current operations without labeling the restriction. If an expense has already cleared, move it into actual activity rather than leaving it in a future week.
The forecast should show the agent-side receipt expected to land in the account. A gross deal commission may remain as a reference field, but it is not the same as available cash. Use the brokerage’s actual documentation for known allocations, referral obligations, fees, or adjustments, and flag anything unresolved instead of inventing a net number.
Update the Forecast From Evidence Each Week
Reconcile opening cash first
Begin with cleared bank activity and identify outstanding transactions. The U.S. Small Business Administration includes available cash and bank reconciliation among the core financial functions a business should manage. If the opening balance is wrong, every later week inherits the error.
Keep business and personal activity separated in the records. IRS Publication 583 emphasizes records that identify receipt sources, support expenses, and clearly show business income and deductions. The forecast does not replace those records; it depends on them.
Give every expected receipt a status and date range
For each transaction, record the best-supported agent receipt amount, the working receipt week, the source of that estimate, and the next fact that could change it. Relevant evidence may include the executed agreement, financing and title milestones, the scheduled closing, funding confirmation, the brokerage’s commission documentation, and the brokerage’s payment process.
Do not apply a generic closing probability across every file. A forecast is more useful when uncertainty is explicit. If the receipt date is unresolved, show an earliest supported week and a later plausible week, then use the later timing in the delay case.
Enter outflows when the business is expected to pay them
Start with obligations that already exist: recurring software, insurance, contractor invoices, approved marketing orders, transaction expenses, rent or workspace commitments, and other documented payments. Use the actual due date or autopay date rather than spreading costs evenly for visual convenience.
Keep proposed spending separate from committed spending. That distinction preserves a decision the agent may still control. It also prevents an optional purchase from looking equivalent to an invoice already owed.
Compare forecast with actual activity
At each update, replace projected deposits and payments with actual amounts and dates. Record why a meaningful variance occurred: closing moved, brokerage documentation remained incomplete, a vendor billed earlier than expected, a charge duplicated, or an expense had been omitted.
The purpose is not to create a flattering accuracy score. It is to find the recurring assumptions that make the forecast unreliable. If broker-paid receipts routinely arrive later than entered, revise the timing rule. If annual renewals repeatedly surprise the business, build a verified renewal register.
End with an owner, action, and deadline
A highlighted shortfall without a next step is only an alarm. Assign each exception to a person, state the evidence still needed, name the action available, and set the next review date. Close resolved items rather than carrying stale warnings forward.
If the forecast reveals a recurring gap between the work required to keep the business moving and the operating support available around it, request a confidential conversation with Martin Collum Real Estate. The discussion can begin with your actual constraints without turning the forecast into a recruiting spreadsheet.
Test Delays Before They Become Emergencies
Use scenarios to expose concentration and timing risk, not to predict a guaranteed outcome.
- Best-supported case: Use the amounts and dates supported by current file, vendor, and brokerage records. This is not an optimistic case.
- Delay case: Move one or more material receipts to a later plausible week while leaving committed outflows in place.
- Receipt-removal case: Exclude a contingent receipt so the business can see which obligations depend on that single transaction.
- Proposed-spend case: Add a contemplated commitment and identify the receipts required to support it.
Do not assign industry-standard fall-through rates or claim that one cash reserve fits every agent. Set an internal liquidity floor with the appropriate accounting and financial advisers, based on the business’s obligations and risk tolerance.
Decision triggers should be specific. Examples include a projected ending balance below the business’s approved floor, a promised receipt date passing without payment, required outflows exceeding evidence-backed receipts, or a proposed commitment depending on one uncertain closing. The corresponding action may be to obtain missing brokerage documentation, verify a closing change, correct a duplicate charge, reschedule discretionary spending where contracts allow, or seek professional advice before adding an obligation.
Keep a record of the trigger and the decision. That history shows whether cash pressure came from timing, inaccurate records, uncontrolled commitments, or a recurring operating constraint.
Keep Adjacent Economic Questions in Their Own Reviews
This forecast owns weekly liquidity and receipt timing. It should not absorb three different analyses that already have their own methods:
- To compare the complete cost of two brokerage operating models, use The Real Cost of a Brokerage Split.
- To decide whether a specific campaign earned enough attributable closed business to justify the spend, use Real Estate Agent Marketing ROI.
- To decide whether to build staff, buy vendor capacity, or use shared brokerage infrastructure, use How to Scale a Real Estate Agent Business.
A cash forecast may reveal when one of those decisions needs attention, but it does not answer the decision by itself. It also does not establish taxable income, determine deductible expenses, value the agent’s unpaid time, or replace the business’s books.
Frequently Asked Questions
What is a real estate agent cash flow forecast?
It is a forward-looking schedule of cash expected to enter and leave an agent’s business account. It begins with reconciled available cash, places evidence-backed broker-paid receipts and documented outflows into expected weeks, and calculates the resulting weekly balance. It is a planning tool, not a guarantee that a pending transaction will close.
How often should a real estate agent update a cash flow forecast?
Update it on the same day each week and whenever a material receipt, closing date, or obligation changes. Weekly review makes timing changes visible before the related payment is due. Replace projections with actual deposits and payments, preserve the variance reason, and roll the ending balance into the next week.
Should every pending transaction appear as expected cash?
No. Keep the complete pipeline in the transaction system, but include a forecast receipt only when you have a supportable amount, timing range, and payment path. Label the uncertainty and test a later or removed receipt in a downside case. A contract or scheduled closing is not the same as cash available to spend.
Should the forecast use gross commission or the expected agent deposit?
Use the amount reasonably expected to reach the agent’s business account, supported by brokerage records and applicable written agreements. A gross commission figure may remain as a reference, but treating it as available agent cash can overstate liquidity. Do not guess at unresolved deductions or payment timing.
Why can a profitable agent still have a cash shortage?
Profit and cash measure different things. Income and expenses may be recognized in a different period from the related deposit or payment, and a real estate business may incur operating or listing costs before a commission is received. Review the profit and loss statement, balance sheet, cash activity, and forecast together.
Can a spreadsheet be enough?
Yes, if it has controlled formulas, a consistent owner, source evidence, version discipline, and a repeatable review process. Software does not make unsupported dates reliable. Whether the forecast lives in a spreadsheet or accounting platform, reconcile it to actual bank and brokerage records and protect confidential client information.
Make the Next Cash Decision Before It Is Urgent
A useful forecast does not promise that the pipeline will convert on schedule. It shows which obligations depend on that timing, what evidence is missing, and which decision must be made if cash arrives later.
Bring a redacted weekly forecast and the operating constraint it exposed, then request a confidential conversation with Martin Collum Real Estate. We can discuss whether the support structure around your business matches the way your work and cash actually move.
Disclaimer
This article provides general business-management information and is not tax, accounting, legal, investment, or individualized financial advice. Accounting treatment, business structure, contractual obligations, and compensation processes vary. Consult your sponsoring broker and appropriately qualified bookkeeping, tax, legal, and financial professionals before changing records, payment practices, reserves, financing, or contractual commitments.
