How Do You Prepare 30-, 60-, and 90-Day Cash Flow Forecasts?

Even if a month’s total income exceeds its expenses, a short-term cash shortfall can occur when payment dates are misaligned. If salaries are deposited at the end of the month while rent, credit card debt, and bills are due in the first week of the month, the monthly total alone does not provide sufficient information. A 30-, 60-, and 90-day cash flow forecast makes this timing risk visible by projecting cash inflows and outflows forward along with their dates.

A forecast is not about knowing the future balance with absolute certainty. It can be altered by delayed collections, unexpected medical expenses, changes in bill amounts, or currency fluctuations. A sound approach involves comparing different time periods and scenarios rather than relying on a single figure, regularly updating assumptions, and allowing for uncertainty.

What do 30-, 60-, and 90-day horizons indicate?

30 days: short-term payment schedule

The first 30 days cover salary, rent, credit card payments, recurring bills, subscriptions, and known daily expenses. Since most of the data is recent, there is generally less uncertainty regarding dates and amounts. The purpose of this view is not so much to focus on the end-of-month total, but rather to identify which days the balance will approach its lowest level.

60 days: The impact of recurring payments and delays

The second month is the period when recurring transactions resume and the effects of decisions made in the first month become apparent. Installments, bills that come every two months, expected receivables, and variable income become more significant. Here, you can see how a payment deferred or a collection delayed in the first 30 days carries over into the following month.

90 days: Recurring obligations and scenario planning

The three-month view is useful for incorporating expenses that do not occur every month—such as insurance, maintenance, education, taxes, or travel—into your plan. However, as the period lengthens, the margin of error in forecasting increases. Therefore, view the 90-day outlook not as a definitive calendar, but as a scenario framework for exploring upcoming peaks and potential funding gaps.

What data is needed before starting the forecast?

• Current available cash and account balances
• Dates of expected inflows such as salary, rental income, freelance work, and other sources
• Due dates for rent, bills, installments, subscriptions, and debt payments
• Estimates of variable expenses such as groceries, transportation, healthcare, and social activities
• Annual or quarterly payments
• The certainty of expected receivables and the potential for delays
• Amounts of credit card installments falling due in future months

Do not include your credit card limit in your opening balance; the limit is not income. For budgeting purposes, you can treat credit card spending as an expense on the transaction date; for cash outflow purposes, you can treat it as an expense on the date the card balance is paid off. However, to avoid counting the same expense twice in the same table, clearly indicate which method you are using.

Step-by-Step 90-Day Cash Flow Statement

1. Verify the opening balance

Record the amount of freely available funds in your account and cash on hand as of a specific date. List separately any amounts that are frozen, earmarked for other purposes, or otherwise not readily available. If you’re converting a foreign currency account to your primary currency, note that the exchange rate used may vary and the actual conversion amount may differ.

2. Separate certain and expected inflows

Classify income with highly predictable dates—such as regular salary—as “certain”; add freelance income for which invoices have not yet been paid or expected receivables to the “expected” category. Before treating the expected amount as available cash, assess the likelihood of collection and any past delays. An overly optimistic collection date may mask a cash shortfall.

3. Schedule Outflows by Due Date

First, record mandatory and contractual payments on their actual due dates. Then, distribute variable expenses in weekly or monthly blocks. If a rare payment, such as annual insurance, spans 90 days, show the entire amount on the due date; you may also consider setting aside a monthly allowance for similar future expenses.

4. Calculate the balance after each transaction

Add each deposit to the opening balance and subtract each withdrawal. Look not only at the balances at the end of days 30, 60, and 90, but also at the lowest balance in between. A negative balance on day 12, even if the period ends with a positive result, indicates a problem with the payment sequence.

5. Regularly compare estimates with actuals

During your weekly review, mark the actual transactions and note any differences in amounts and dates. If market expenses are consistently underestimated by 20%, update the next 60- and 90-day rows. If collections are delayed by an average of one week, adjust not only this month’s opening balance but also the opening balances for subsequent periods.

How should the three scenarios be set up?

Base scenario

Based on the most likely revenues, expenses, and dates. Use actual data from the last three to six months; set aside any unusual months with an explanatory note. The base scenario is the plan’s primary reference but is not guaranteed.

Conservative Scenario

Assume lower variable revenue, later collection dates, and reasonably higher flexible expenses. The goal is not to dramatize the worst-case scenario but to assess resilience against common negative deviations. You can also add a buffer line for unexpected expenses.

Optimistic Scenario

This scenario reflects favorable conditions, such as revenue arriving on time, certain variable expenses remaining low, or a planned refund being received. Do not interpret this scenario as an authorization to spend. Use the difference between the base and conservative results to understand which assumption most significantly affects the balance.

When comparing scenarios, look not only at the total amount but also at the day with the lowest balance, the number of days you’re in the red, and the total of mandatory payments approaching their due dates. This way, you’ll find answers not only to the question “What will be left after 90 days?” but also to “Where am I vulnerable along the way?”

What should you pay attention to in maturity management?

If a cluster of payments falls within a specific week, and the contract allows it without incurring additional costs, you can inquire with the service provider about payment term options. However, changing the date does not eliminate the debt; it may result in fees, interest, or new obligations. Verify the current terms directly with the relevant institution.

Do not assume that expected receivables are automatically collected on the due date. Use distinct statuses such as “expected,” “overdue,” and “collected.” Scheduling a new mandatory payment to cover an unpaid receivable can create a chain reaction of outstanding balances. Keeping the due date and the scheduled payment date separate for your own debts also provides an early warning.

How is uncertainty accounted for?

You can add a confidence level to each forecast line: high, medium, or low. A fixed salary may have a high confidence level, while commission income may have a low confidence level. Using a range (lower and upper limits) instead of a single figure for variable expenses also provides a more realistic view. Keep in mind that the confidence level will naturally decrease as the period lengthens.

To measure forecast error, calculate the “actual minus forecast” difference at the end of the period. If the difference consistently points in the same direction, it may indicate systematic optimism or pessimism. A single large difference does not prove that the method is ineffective; it is necessary to determine whether the event was a one-time occurrence or a recurring pattern.

How should the Biriqim Pro forecast be positioned?

Biriqim Pro provides liquidity alerts based on 7-, 30-, 60-, and 90-day cash flow projections derived from historical data. This feature helps analyze past records and entered planned transactions. Incomplete, outdated, or incorrect data affects the output; the application cannot accurately forecast revenue or expenses it is not aware of.

The projection is a planning tool; it is not a credit decision, a payment guarantee, or personalized financial advice. Verify the results against your own maturity dates, update your scenarios, and rely on the official records of the relevant institution for significant obligations. Biriqim does not process any payments or transfer funds between accounts.

Common forecasting errors

• Treating expected income as a confirmed balance
• Forgetting annual and periodic payments in the 90-day calendar
• Counting credit card spending and credit card debt payments twice
• Focusing only on the end of the period and overlooking shortfalls on intermediate days
• Relying on a single scenario and ignoring uncertainties regarding amounts and dates
• Failing to update estimates based on actual results

Frequently Asked Questions

How many months of historical data are needed for a 30-day forecast?

Three months of records can serve as a starting point; 12 months provide more insight into seasonal and annual expenses. Manually adding specific due dates in a new system can help reduce the gap caused by a short history.

Why does the 90-day forecast change more frequently?

As the forecast horizon lengthens, uncertainty and date drift increase. Therefore, the 90-day outlook should be updated regularly and interpreted using scenarios rather than a single figure.

Does a negative projected balance mean a definite shortfall?

No. This is a warning based on current assumptions. There may be missing or incorrect entries; nevertheless, it’s helpful to promptly verify the accuracy of dates, mandatory payments, and expected revenues.

Is the Pro cash flow feature available on the free plan?

No. Biriqim’s 7-, 30-, 60-, and 90-day AI-powered cash flow projections are included in the Pro plan. The free plan offers basic recording and tracking capabilities; it does not include AI forecasts.