Free tool for coworking operators
Coworking Space cash flow forecast for the next 13 weeks
A coworking forecast is monthly billing against the lease. Member move-ins and move-outs change it month by month.
Add one-off items (tax payment, equipment, a big invoice)
$
$
$
Negative for money going out, positive for money coming in.
Lowest point
-
Safe line (2 payrolls)
-
cash you never want to drop under
Weeks under the safe line
-
of the next 13
| Week of | Comes in | Payroll | Bills and other | Cash at week end |
|---|
The starting numbers are an example for a coworking space. Replace them with yours.
Getting the forecast right for a coworking space
- Put each office's billing in its billing week, and end it on its notice date.
- Show deposits returned to departing members in their weeks.
- Put the lease and common-area charges on their due dates.
An example
Three private offices give notice for the end of June. Each paid $2,000 a month and holds a $2,000 deposit. In July, revenue drops by $6,000 and $6,000 in deposits goes back out. The forecast shows both in the same month.
What to watch
- Offices coming off term in the same month
- Month-to-month members as a share of revenue
- Deposits owed back to departing members
Get your full forecast every Monday
One Page CFO builds your 13-week forecast from your QuickBooks, invoice by invoice, and a CFO checks it before it reaches you.