A 13-Week Cash Flow Forecast: Make Decisions Before Cash Gets Tight

Sales do not always translate into available cash

A service business can have paying customers, a full schedule and positive accounting results while still struggling to cover payroll. Often, the problem is timing: expenses come due before customer payments reach the bank.

For South Florida small businesses, seasonal demand, customer payment schedules and potential operational disruptions make one question especially useful: which commitments can we cover over the coming weeks?

A 13-week cash flow forecast helps answer that question. It does not guarantee liquidity or replace your accounting records. It gives you a practical way to spot pressure early and decide what to collect, pay, postpone or reconsider.

What the forecast actually tells you

A cash forecast maps expected receipts and payments by week. Unlike a sales budget, it focuses on when money should enter or leave your bank account—not when you issue an invoice or record revenue.

Thirteen weeks covers roughly one quarter. That provides enough runway to see upcoming obligations while keeping the discussion grounded in near-term decisions. Early weeks should be relatively detailed; later weeks will involve more assumptions.

The calculation is straightforward: opening cash plus expected receipts minus expected payments equals projected closing cash. That closing balance becomes the following week’s opening balance.

Start with a simple working file

Use a shared spreadsheet with one column per week. You do not need to buy software before testing whether this routine improves your visibility.

Organize the rows into four groups:

• Opening available cash, with restricted or committed funds identified separately.
• Expected receipts, including invoice collections, customer deposits and other identifiable inflows.
• Expected payments, including payroll, vendors, rent, insurance, taxes, debt payments and owner withdrawals.
• Projected closing cash and a minimum cash threshold chosen for your business.

Check automatic withdrawals and quarterly or annual payments, too. They can disappear from view when the owner focuses only on routine weekly expenses.

For credit cards, reflect the cash outflow when the card payment is due, rather than also counting the purchase as a cash payment on its transaction date. Apply a consistent approach and resolve accounting questions with your accounting professional.

Forecast collections, not optimism

An issued invoice is not cash in the bank. Estimate collection dates using agreed payment terms, the customer’s actual payment history and any outstanding approval requirements.

For each significant receipt, record an expected date, a person responsible for follow-up and a short explanation of the assumption. If payment depends on finishing a deliverable or obtaining customer acceptance, make that dependency visible.

Keep confirmed business separate from open sales opportunities. Treating your entire pipeline as dependable cash can hide a funding gap rather than help you prepare for it.

Look for internal obstacles as well: invoices sent late, incorrect billing details, missing purchase orders or work awaiting sign-off. Fixing the billing process may be a more immediate lever than generating additional sales, although it cannot ensure faster payment from every customer.

Build scenarios and decision rules

Create a base forecast and a pressure scenario. The latter might include a delayed customer payment, reduced activity or an unexpected operating expense. Avoid assigning probabilities unless you have a reasonable basis for them.

Set a minimum cash threshold based on your obligations and risk tolerance. There is no universal amount. A firm with fixed payroll and long-term commitments needs a different approach from an independent professional with flexible expenses.

Agree on actions to consider when projected cash approaches that threshold:

• Confirm customer payment dates and clear billing roadblocks.
• Discuss revised payment timing with vendors before invoices become overdue.
• Review purchases, subscriptions and commitments that can still be changed.
• Assess financing options early, including their costs and repayment obligations.

Moving a payment does not remove the expense. Any changes must respect contracts, employment obligations and applicable tax requirements. Keep potential financing separate from available cash until the funding is actually confirmed.

Give the forecast a weekly operating rhythm

Assign someone to maintain the file and someone with authority to act on it. In a small business, that may be the same person. Replace the completed week’s estimates with actual transactions, then add a new week at the end.

Focus the review on three signals: the lowest projected cash balance, overdue customer payments and differences between forecast and actual results. Determine whether those differences reflect shifted dates or genuine changes in revenue and expenses.

Close with specific actions, owners and deadlines. Without that step, the forecast can become another report that gets updated but never influences a decision.

Make visibility part of how you operate

The goal is not to predict every transaction perfectly. It is to identify pressure while you still have options and connect commercial decisions with your ability to meet commitments.

People. Systems. Progress. If you would like help establishing this routine, consider a free first consultation with PROMATEK Consulting or explore the PROMATEK Maturity Index diagnostic.