Finance & FP&A

How to build a 13-week cash flow forecast as Property Management Founders

Finance & FP&AFor Property Management Founders3 apps11 steps~22 min to set up

Your 13-week cash flow forecast probably lives in a Google Sheet or Excel file that someone on your team updates every Monday by logging into AppFolio, exporting the rent roll, cross-referencing against your Plaid or bank statement for trust account activity, then manually keying in expected maintenance vendor payments and owner distribution dates. One missed late-pay, one surprise HVAC repair, or one owner pulling funds early and the whole model is wrong before lunch. You're running on a 2-week-old snapshot and guessing at the next 90 days on a portfolio that might have 150–400 units across multiple entities, each with its own trust and operating account.

Build this on Starch → See the apps used

Finance & FP&AFor Property Management Founders3 apps11 steps~22 min to set up

Outcome

What you'll set up

A live 13-week cash flow dashboard that pulls actual bank account balances and transaction history from your Plaid-connected trust and operating accounts every day — no manual export, no re-keying

A scenario model that lets you stress-test what happens to cash if delinquency jumps 8%, a major roof replacement hits in week 6, or owner distributions go out two weeks early

A weekly digest that flags anomalies — a vendor charged $4,200 when they normally charge $800, or a rent collection shortfall relative to your expected roll — before they compound

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Runway Analysis Scenario Analysis Transaction Insights

Data sources & config

Starch connects directly to Plaid on a scheduled sync — your trust account and operating account transactions and balances refresh daily and are stored in Starch's database. AppFolio, Buildium, Propertyware, and Rent Manager are reachable through browser automation — no API needed — so Starch can pull your current rent roll, lease expirations, and open work order costs to feed into the forecast. QuickBooks, if you use it for your management company books, syncs on a schedule as well and contributes vendor payment history.

Prompts to copy

Connect my Plaid accounts — operating account ending 4421 and property trust account ending 8873 — and build me a 13-week cash flow forecast broken out by: rent collections expected each week, owner distributions scheduled, recurring vendor payments (landscaping, trash, pest control), maintenance reserve draws, and management fee transfers to my operating account.

Build me three scenarios side by side: (1) current pace, (2) delinquency rises to 7% of portfolio (currently 2.3%), (3) emergency capital expenditure of $28,000 hits in week 5. Show me ending cash balance and weeks of runway under each scenario.

Watch my Plaid-connected accounts and flag any vendor charge that is more than 40% above that vendor's 90-day average, any new vendor I haven't paid before, and any week where rent collections come in more than 15% below my expected roll.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect your operating account and property trust account(s) to Starch via Plaid scheduled sync. Balances and categorized transactions refresh daily — you are not uploading anything manually.

2 If you use QuickBooks for your management company entity, connect it via Starch's scheduled sync. Vendor payment history, bills, and journal entries sync automatically and give the forecast its expense baseline.

3 Give Starch browser access to your property management software (AppFolio, Buildium, Propertyware, or Rent Manager — all browser-automatable). Starch reads your current rent roll, scheduled owner distribution dates, and open maintenance work orders with estimated costs.

4 Open the Runway Analysis app and tell Starch which Plaid accounts represent your operating cash versus trust funds held for owners. This matters — you do not want owner reserves showing up as your operating runway.

5 Describe your recurring cash outflow calendar: management fee transfer timing, payroll run dates (if staff are on your payroll), monthly vendor ACH dates for landscaping, insurance, utilities on common areas. Starch maps these onto the 13-week grid.

6 Set your expected rent collection curve — for example, 'we collect 80% of monthly rent by the 5th, another 15% by the 10th, and late fees plus stragglers by the 20th.' Starch uses this pattern against your current rent roll to project weekly inflows.

7 Open the Scenario Analysis app and build your stress cases: a delinquency spike scenario (raise the non-collection rate to whatever your worst recent month looked like), a capex surprise scenario (insert a one-time maintenance draw in a specific week), and an early-distribution scenario (owner pulls funds two weeks ahead of schedule).

8 Open the Transaction Insights app and set anomaly thresholds: flag any vendor 40%+ above their 90-day average, flag any new payee, flag any week where Plaid-confirmed rent deposits are more than 15% below your expected roll.

9 Schedule a Monday morning digest: Starch sends you a Slack message summarizing the current week's opening cash position, the three largest expected outflows, any anomalies flagged since last Monday, and updated 13-week runway under your baseline scenario.

10 At month-end, tell Starch to reconcile: 'Compare my projected rent collections for the month just closed against what actually deposited into the trust account by property, and show me which properties came in short and by how much.' This becomes your delinquency audit trail.

11 Share a read-only view with your accountant or bookkeeper — they see the same live numbers you do without needing AppFolio access or a bank login.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

Week of March 3, 2026 — 220-door residential portfolio, two entities

Sample numbers from a real run

Trust account opening balance (Mar 3)	187,400
Expected rent collections — Mar 1–7 (80% of $214,000 monthly roll)	171,200
Owner distributions — Mar 5 batch	-148,600
Landscaping vendor ACH (monthly)	-3,800
Maintenance reserve draw — HVAC unit 14B	-4,200
Management fee transfer to operating account	-18,800
Trust account projected close (Mar 7)	183,200
Operating account opening balance (Mar 3)	41,500
Management fee inflow from trust	18,800
Payroll run (Mar 7 — 4 staff)	-11,400
Recurring SaaS and admin spend	-1,900
Operating account projected close (Mar 7)	47,000

On Monday March 3, Starch's Runway Analysis dashboard shows $187,400 in the trust account and $41,500 in the operating account. Plaid confirmed both balances at 6 AM. The rent roll from AppFolio (pulled via browser automation Sunday night) shows 220 leases at an average $973/month — $214,060 total monthly roll. Starch projects $171,200 arriving in the trust account by March 7 based on the 80% early-week collection curve you configured. Owner distributions of $148,600 go out on March 5 via ACH. After the management fee transfer of $18,800, landscaping ACH of $3,800, and the HVAC draw of $4,200 for unit 14B that came in as an approved work order, the trust account closes the week at $183,200 — healthy. The operating account absorbs the management fee inflow, pays a $11,400 payroll run on March 7, and closes the week at $47,000. Transaction Insights flagged one anomaly mid-week: the HVAC vendor charged $4,200 against a 90-day average of $890. Starch surfaced it Tuesday morning in Slack so you could confirm it was the approved work order before worrying. The Scenario Analysis tab shows that if delinquency jumps from the current 2.1% to 7% starting April 1 — the rate you saw during your worst COVID month — operating account runway drops from 14 weeks to 9 weeks, and you would need to either delay one owner distribution cycle or draw on your line of credit by week 11.

Measurement

How you'll know it's working

Weeks of operating cash runway (management company entity, separate from owner trust funds)

Rent collection rate by week vs. expected roll — tracked by property and by unit class (single-family vs. multifamily)

Trust account ending balance vs. total owner distribution obligations due within 30 days

Maintenance reserve draw rate as a percentage of gross collected rent — actual vs. budgeted

Delinquency balance (total past-due rent across portfolio) tracked week-over-week

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

Excel or Google Sheets with manual AppFolio export

Works but requires someone to export the rent roll, reconcile against bank statements, and update formulas every week — one bad cell or a skipped Monday and your forecast is stale before you act on it.

AppFolio or Buildium built-in reports

These show you historical actuals inside the PMS but don't produce a forward-looking 13-week cash view, don't separate trust account health from operating account runway, and can't incorporate vendor payment timing from QuickBooks or your bank feed.

QuickBooks cash flow forecast

Covers your management company operating entity reasonably well, but has no visibility into the trust account, rent roll, or maintenance pipeline — and you'd still be reconciling two separate systems manually.

Mosaic, Jirav, or Runway (FP&A SaaS)

Purpose-built financial planning tools that are well-suited to SaaS or venture-backed companies; property management cash flow has different structures (trust accounts, owner distributions, per-property variance) that these tools weren't designed around, and they price for teams with a dedicated finance hire.

On Starch RECOMMENDED

One platform — runway analysis, scenario planning, transaction insights all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

My trust account holds owner funds — will Starch mix that up with my operating cash?

No. When you set up the forecast, you tell Starch which Plaid-connected accounts are trust accounts and which are your management company's operating accounts. The runway calculation for your business only looks at your operating account. Trust account balances are tracked separately and compared against your owner distribution obligations — you can see both without them getting conflated.

I use AppFolio but AppFolio doesn't have a public API. Can Starch still pull my rent roll?

Yes. Starch automates AppFolio through your browser — no API needed. It logs in as you, navigates to the rent roll and work order screens, and extracts the data. The same approach works for Buildium, Propertyware, and Rent Manager.

Is this SOC 2 certified? My property owners sometimes ask about data security.

Starch is not SOC 2 Type II certified today — that is worth knowing upfront. Data is encrypted in transit and at rest, but if your owner contracts or state trust account regulations require a SOC 2 vendor, that is a real consideration. It is on the roadmap.

Can I track cash flow separately for each property or each owner entity?

Yes. When you describe the app to Starch, tell it how you want the data segmented — by property, by owner entity, by unit type, or any combination. If your rent roll from AppFolio includes property identifiers, Starch can break out collection rates and maintenance draws at that level. The more specific you are in the prompt, the more specific the output.

I have QuickBooks for my management company but not for the trust accounts. Does that cause a gap?

Not a blocking one. Plaid covers the trust account side with daily transaction and balance syncs. QuickBooks — which Starch connects directly to on a scheduled sync — fills in your management company's vendor payment history and payroll timing. You describe to Starch how the two sets of accounts relate and it builds the forecast accordingly.

What happens if a vendor payment clears at an unexpected time and throws off the weekly projection?

Transaction Insights monitors your Plaid feeds daily. If an ACH clears earlier or later than expected, Starch flags it as a variance against the projected schedule and Slack-notifies you. The 13-week model updates to reflect the actual, so you are not carrying a stale assumption forward.

Can I share the forecast with my CPA or a part-time CFO without giving them bank login access?

Yes. Starch lets you share a read-only view of any app or dashboard. Your CPA sees the same live numbers you do — Plaid-backed, updated daily — without needing a Plaid login, bank credentials, or access to your property management software.