When to use it
Collections and large payments fall in different periods.
Property decision guide
HOA and Condominium Cash Flow Planning
A budget explains planned income and expense. A cash forecast explains when money will be available and when payments fall due. Boards need both when insurance installments, repairs, collections or vendor commitments create uneven timing.
Start with reconciled and usable balances
Choose a cutoff date and reconcile the opening balance to bank and accounting records. Distinguish bank balance, outstanding payments, restricted funds, committed expenditure and money available for the forecast purpose. Keep operating and reserve schedules separate unless the applicable authority and professional advice permit the proposed use.
A reserve account can have a large balance while the operating account faces a payment shortfall. Do not combine accounts into one reassuring total without identifying their purposes and restrictions.
- Opening reconciled balance by account and purpose
- Outstanding checks, transfers and pending bank transactions
- Approved commitments not yet invoiced
- Assumptions about collection dates and reliability
Forecast receipts and payments by expected date
Use the horizon that fits the decision: weekly detail for a near-term payment pressure and monthly detail for annual planning. Enter receipts when collection is reasonably expected, not merely when charges are billed. Keep uncertain collections identifiable and run a delay scenario.
For payments, use executed agreements, installments, payroll or service schedules, approved projects and known liabilities. Separate committed payments from estimates and discretionary future work. Record the owner and evidence for each material assumption.
- Recurring receipts and aged balances with an evidence-based timing assumption
- Insurance installments and contract renewal payments
- Professional fees, projects, approved changes and retainage
- Contingency scenarios rather than unsupported guaranteed receipts
A transparent worked example
Illustrative example only: opening available operating cash is $100,000. Expected receipts are $40,000 and planned payments are $120,000. Forecast closing operating cash is $20,000. If $25,000 of receipts is delayed, closing cash becomes minus $5,000. This identifies a timing decision; it does not establish permission to transfer reserve money.
The calculation is opening available cash plus expected receipts minus expected payments. Carry each period’s closing amount into the next opening amount and retain the underlying assumptions. Explain a negative value as an unresolved funding gap rather than allowing the spreadsheet to hide it in a combined account balance.
- Label all example numbers as hypothetical
- Report the lowest forecast balance and when it occurs
- Test delayed collection, earlier payment and higher project cost separately
- Record which option requires professional advice or formal approval
Compare options without assuming authority
Possible responses may include an agreed vendor payment schedule, revised project sequencing, lawful funding arrangements, or changes in the collection forecast supported by actual evidence. Each option has a different service consequence, cost, approval requirement and risk of delay.
Do not present unapproved borrowing, reserve transfers, assessment changes or deferred safety work as available cash. Have the relevant accountant, counsel and technical professional confirm the options that affect their responsibilities. Preserve approval conditions before incorporating an option into the base forecast.
- Amount and timing of the gap
- Reason the gap occurs and evidence supporting it
- Feasible options and consequences of each
- Approval owner, required decision date and interim controls
Reconcile the forecast to actual results
At each refresh, compare expected and actual receipts and payments by the same period. Explain timing changes separately from permanent changes in income or cost. Keep the prior version so leadership can see which assumption moved.
Record forecast error, unresolved liabilities and the next low point alongside the annual budget variance. A balanced annual plan may still need corrective action before a large invoice becomes due.
Hypothetical worked example
An expected receipt is treated as available cash
A fictional forecast includes an uncertain receipt as if it were already collected. An upcoming commitment can only be met if that receipt arrives on time.
Original fictional example · no completed client assignment or property inspection is represented.
| Record to obtain | Review question or calculation |
|---|---|
| Reconciled opening balances | Separate collected money from forecast inflows |
| Confirmed commitments and due dates | Show the effect of delay without replacing unknowns with zero |
| Receipt assumptions and restrictions | Refer funding authority to the appropriate decision owner |
Useful working output: A dated base case and a visible receipt-delay scenario.
What would change the decision?
Open each challenge to test the reasoning against a different finding.
A profitable month still produces a cash shortage
Check: Place actual collection dates and contractual payment dates on the same weekly timeline. Show opening available cash and excluded reserve purposes.
Decision effect: Explain the timing gap and options before the payment falls due. An accounting surplus does not move a collection date.
A forecast assumes every overdue assessment is collected
Check: Separate confirmed receipts from uncertain collections and show the payment schedule under each assumption without changing the opening balance.
Decision effect: Make the shortfall exposure visible to the authorized decision maker. Do not report the optimistic case as cash already available.
Adapt the record request to authorized access, governing documents and the actual property. The example does not verify any unknown input or replace a professional conclusion.
Budget Variance Bridge: Rate, Quantity and Interaction · More finance and reserves examples
Before acting on this guide
Set the review boundary and the acceptance test.
What the evidence does not prove
Do not equate a positive bank balance with permitted available funds.
What to verify before acceptance
Run a dated collection-and-payment sequence using confirmed opening balances and disclose unconfirmed inflows.
Original proposed coordination checks · adapt to authorized access, the actual obligation and the appropriate professional review. These are not findings about your property.
Follow the related handoff workflow · Read the review definitions
A number, its evidence and the decision
Cash timing can change a decision before the annual total does
A balanced annual plan can still have a difficult payment month. Compare available operating cash with near-term obligations, and separate restricted balances from funds actually available for the stated use.
Opening cash
Reconcile the balance and permitted use.
Receipts
Identify expected dates and collection assumptions.
Commitments
Schedule approved and recurring payments.
Decision
Review the lowest projected balance and its uncertainty.
A worked example with visible assumptions
With fictional available operating cash of $180,000 and monthly outflow of $45,000, the simple ratio is four months. This assumes no receipts and steady outflow. It excludes restricted reserves, payment spikes and receivable risk; use a dated cash schedule for a funding decision.
Original hypothetical arithmetic example. The amounts describe a fictional scenario, not observed property performance or a recommended target.
Continue with HOA and Condominium Cash Flow PlanningExplore the calculation
Enter non-negative values using the same scope and period. This calculation stays in your browser tab.
Read restrictions before totals
A combined bank balance can include money unavailable for operating expenses. Reconcile account purpose and applicable restrictions.
Timing is material
Insurance premiums, project deposits and annual fees can make a flat monthly average misleading. Plot their actual payment dates.
A ratio is not a funding approval
The calculation describes entered amounts. It does not determine lawful reserve use, approve an assessment or establish a universal cash target.
Working checklist
HOA and Condominium Cash Flow Planning checklist
A reusable control-definition worksheet. Add property-specific owners, dates, evidence links and status before using it as an action record.
These rows define suggested controls, not completed property findings. Interpret each check against your actual property records, responsible role and acceptance evidence. See the review instructions and reuse terms.
12 checks shown
No check matches those filters. Try a different term or area.
| Review area | Check | Evidence to request | Decision question |
|---|---|---|---|
| Opening | Reconcile available balances | Bank reconciliation ledger and pending payments | Which balances are usable for this purpose? |
| Opening | Separate restricted purposes | Account purpose adopted plan and qualified advice | Is each proposed use authorized? |
| Receipts | Estimate collection dates | Billing aging and collection history | When is receipt reasonably expected? |
| Receipts | Identify uncertain income | Evidence source and scenario assumption | What if collection is delayed? |
| Payments | Map fixed commitments | Executed contracts and installment schedule | Which due dates are unavoidable? |
| Payments | Include open project exposure | Approved changes pending requests and retainage | What cost is not yet invoiced? |
| Payments | Separate estimates | Forecast basis owner and review date | Which payment remains uncertain? |
| Forecast | Carry closing balances forward | Period-by-period opening receipts and payments | Does the calculation reconcile? |
| Forecast | Identify the low point | Lowest projected balance date and cause | When will funding be needed? |
| Scenarios | Test delay and cost changes | Base case and documented alternative assumptions | Which assumption creates the gap? |
| Decisions | Confirm feasible options | Authority professional advice and consequence review | Which option can lawfully proceed? |
| Review | Compare forecast with actuals | Prior version actuals and variance explanation | Which timing assumption needs correction? |
Frequently asked questions
Does an annual budget surplus guarantee enough cash?
No. Receipt and payment timing, restricted purposes, outstanding obligations and collection delays can create a shortfall within the year.
Can operating and reserve balances be combined?
Show them separately with their purposes and restrictions. Any proposed use or transfer requires the applicable authority and appropriate professional advice.
What should a negative forecast balance trigger?
Verify the assumptions, identify the timing and amount of the gap, and present lawful options with their approval requirements before the payment deadline.