How to Build a 90-Day Cash Flow Forecast Step by Step

Why 90 Days Is the Sweet Spot for Cash Flow Forecasting

A 90-day cash flow forecast strikes the ideal balance between accuracy and usefulness. It is short enough to be reliably accurate yet long enough to give you time to act on what you see. Most businesses can predict income and expenses within this window with reasonable precision.

Whether you are managing payroll, planning a large purchase, or negotiating vendor terms, a 13-week cash flow view tells you exactly where you stand and where you are heading.

Step 1: Gather Your Starting Data

Begin with your current cash balance across all business accounts. Then collect the following information:

• Accounts receivable: All outstanding invoices and their expected payment dates.
• Accounts payable: All bills you owe and their due dates.
• Recurring revenue: Subscriptions, retainers, or contracts with predictable payment schedules.
• Recurring expenses: Rent, payroll, insurance, software subscriptions, and loan payments.
• Variable expenses: Marketing spend, contractor costs, and materials that fluctuate month to month.

Step 2: Map Cash Inflows Week by Week

Organize your expected cash inflows on a weekly basis for the next 13 weeks. Start with confirmed income such as signed contracts and invoices already sent. Then layer in projected income based on your sales pipeline and historical conversion rates.

Be conservative with projected income. Discount projected pipeline revenue by 20 to 30 percent to account for delays and lost deals.

Step 3: Map Cash Outflows Week by Week

List every known outflow by the week it will actually leave your account, not when it is invoiced. For variable expenses, use a three-month average from your recent history as a baseline.

Do not forget irregular expenses like quarterly tax payments, annual insurance renewals, or planned equipment purchases.

Step 4: Calculate Weekly Net Cash Flow

For each week, subtract total outflows from total inflows. Then calculate a running cash balance by adding each week's net cash flow to the previous week's ending balance.

If the running balance dips below zero or below your comfort threshold at any point, you have identified a potential problem that needs attention now.

Step 5: Identify Risks and Build Buffers

Review your forecast for potential stress points. Common risks include late customer payments, unexpected expenses, and seasonal revenue dips. Many businesses maintain a cash reserve equal to at least two weeks of operating expenses.

Automate the Cash Flow Forecasting Process

Building a 90-day forecast manually in a spreadsheet works, but it is time-consuming and error-prone. Finntree automates much of this process by analyzing your bank transaction data and generating cash flow projections automatically.