Anticipating Cash Shortages

It's not surprising for a seemingly profitable business to experience financial difficulties. This is because while profit represents income and expenses incurred over a specific period, cash flow shows when money enters and leaves a bank account or cash register.

Due to credit sales, delayed collections, inventory purchases, tax payments, loan installments, and capital expenditures, significant timing discrepancies can occur between profit and cash flow. A business may show a profit on its income statement but struggle to pay employee wages, taxes, or suppliers on the same day.

One practical way to manage this discrepancy is to prepare a short-term cash flow forecast. Specifically , a 13-week cash flow model helps a business monitor its payment capacity for approximately three months in weekly detail.

The model's goal is not to predict the future perfectly. The aim is to identify cash flow problems early, gain time for decision-making, and minimize financial surprises.

What is the 13-week cash flow forecast?

The 13-week cash flow forecast is a dynamic financial planning tool that shows a business's current cash, expected receivables, and planned payments on a weekly basis.

At the end of each week, the actual figures are entered into the system, the completed week is subtracted from the forecast, and a new week is added to the end of the model. This provides the business with a continuous financial outlook of approximately three months.

The basic calculation is quite simple:

Weekly cash flow + expected cash inflows - expected cash outflows = estimated weekend cash flow

However, the value of the model comes not from the complexity of the formula, but from the quality of the data used.

Instead of treating the amounts in the sales budget as direct cash inflows, the actual payment habits of customers should be taken into account. Similarly, the date on which expenses are accounted for should be separated from the date on which they are actually paid.

Why is an income statement alone insufficient?

The income statement is necessary for evaluating a company's performance; however, it does not replace a short-term payment schedule.

A sales invoice issued with a deferred payment date may generate revenue, but the business's available cash may not increase because the customer hasn't paid yet. Conversely, paying a debt that was expensed in the past this week could reduce available cash.

Similarly, using credit is not income, but it provides cash to the business. Loan principal payments also do not appear as expenses on the income statement; however, cash is still withdrawn from the bank account.

Therefore, when preparing a cash flow forecast, it is not sufficient to look only at accrual-based accounting records. Accounting records, bank transactions, customer collection expectations, and upcoming payment obligations should be evaluated together.

Which items should be included in the model?

Cash inflows

Expected incoming data should be prepared as accurately as possible on a customer and payment term basis. Using only the total sales target may make collection dates appear more optimistic than they are.

• Expected collections from existing trade receivables

• Cash and deferred payments arising from new sales

• Credit card and online payment channel collections.

• Export proceeds and other foreign currency collections

• Credit usage

• Co-financing or capital inflows

• Incentives, support and refunds

• Other unusual cash inflows

It is important to track confirmed collections separately from incoming transactions that are still in the possibility stage. A positive outcome of a sales negotiation does not automatically mean the sale price will be deposited into the company's bank account within a specific week.

Cash outflows

On the outgoing side, focusing solely on supplier invoices is insufficient. Payroll, taxes, financing, and investment payments must also be included in the same view.

• Supplier and service provider payments

• Salaries and other payments to employees

• Tax and social security obligations

• Rent, energy, software, and subscription expenses.

• Loan principal and interest payments

• Bank and other financing costs

• Stock purchases

• Machinery, equipment and other investment expenditures

• Payments planned to partners

In particular , periodic liabilities such as VAT, withholding tax, social security contributions, provisional tax, and corporate or income tax can significantly alter a business's cash needs in payment weeks.

Therefore, the amount of taxes and similar obligations, as well as their payment dates, should be checked with a financial advisor, taking into account the current declaration and payment schedule.

Separate available cash from credit limit.

One common mistake in cash management is treating unused bank credit as part of available cash.

However, unused credit limit is not cash . It is a source of financing that the business can access when needed.

Therefore, it is useful to have three separate representations in the model:

• Available cash

• Available credit limits

• Total liquidity capacity

This distinction more clearly shows whether the business can sustain its operations with its own generated cash or with bank financing.

Furthermore, having a credit limit does not necessarily mean that it can be used under the same conditions when needed. Since banks' limits, collateral, and disbursement conditions may change, credit capacity should not be considered as certain as having a cash balance.

How to prepare it step by step?

1. Verify initial cash: Bank accounts and cash balances must be checked. Amounts that are blocked, held as collateral, or not freely accessible must also be shown.

2. Age your accounts receivable list: Create a list based on customer, invoice, due date, and expected payment date. For customers with a habit of late payments, don't rely solely on the contract due date.

3. Schedule payments for payment weeks: Distribute supplier due dates, payment commitments, and recurring expenses across the relevant weeks.

4. Add payroll and government payments: Track wages, taxes, and social security payments on separate lines instead of grouping them under a single overhead item.

5. Show financing movements: Model current loan installments, planned loan disbursements, and other financing inflows with realistic dates.

6. Add investment and inventory needs: Make upcoming machinery, equipment, or significant inventory purchases visible not just when they occur, but from the week they are planned.

7. Calculate the weekly closing balance: Each week's closing cash should be the starting balance for the following week.

8. Compare with actual results: Examine the differences between the forecast and the actual result to update assumptions for the following weeks.

What does a simple tracking chart look like?

The lines can be further detailed according to the business structure. The following structure can be used as a starting point:

Simply including approved invoices in the table may not be sufficient. Expected expenses such as rent, energy, logistics, maintenance, or similar costs that have not yet been invoiced should also be considered based on reasonable assumptions.

Don't just wait until it hits below zero: set a minimum cash level.

In cash flow forecasting, the important factor is not just whether the bank balance will be negative or not.

For example, a business that closes the week with a positive balance of 100,000 TL might seem problem-free at first glance. However, if there are high-amount payroll or tax payments due a few days later, this balance may not be sufficient for the business.

Therefore, it is beneficial to establish a minimum operational cash level or safety buffer based on the business structure.

A drop in the estimated closing balance below this level should be considered an early warning, even if the account hasn't yet turned negative.

This approach provides more time for intervention in management.

Always compare the prediction with the actual result.

One of the most valuable features of the 13-week model is that it not only shows the future but also allows businesses to measure their own forecasting capabilities.

Three key data points can be tracked for each week:

Prediction – Actual – Deviation

For example, if customer collections for a given week were projected at 700,000 TL but only 420,000 TL were collected, a negative difference of 280,000 TL occurred.

The real question here is not simply how big the difference is:

Why were we wrong?

Did the customer pay late? Was the sales team overly optimistic about collection? Was the collection postponed to another week? Did the sale not go through?

When this analysis is performed regularly, important information about the company's collection and payment behavior begins to emerge.

For example, if the model shows that customers pay, on average, 10-15 days after their contract due dates for several months, future forecasts should no longer be based on contract due dates but on actual collection behavior .

Thus, the model evolves into a self-improving management tool over time.

Use scenarios instead of a single prediction.

Cash flow forecasting is not a definitive result, but a management tool based on assumptions. Therefore, different scenarios can be prepared, including both positive and negative base scenarios.

For example, in a negative scenario, payment to a major customer might be delayed for a few weeks, sales volume might be reduced, or the impact of a foreign currency payment might need to be recalculated.

The scenarios make it easier to answer the following questions in particular:

• What happens to the minimum cash level if the largest customer's payment is late?

• How does an unexpected inventory purchase affect payment capacity?

• Is it possible to continue operations without using the credit limit?

• Which payment schedules can be adjusted to manage the cash deficit?

• Is the timing of the new investment appropriate for the existing working capital?

• To what extent do exchange rate or interest rate movements affect payment capacity?

The aim is not to rely on a single number, but to enable management to foresee the potential outcomes it may face.

The most common mistakes

Treating sales and collections as the same thing.

Showing all sales budget amounts as cash inflows in the same week is misleading. Customer payment terms, past delays, checks, and processing times for payment channels must be taken into account.

Adding tax and payroll payments later

Remembering recurring obligations in the payment week can create significant cash flow problems. A link should be established between the accounting and reporting calendar and cash flow forecasting.

Counting unusable balances as cash

Collateral, blocked, or purpose-built accounts should not be treated as operational cash. Freely available cash must be reported separately.

Viewing your credit limit as if it were your bank balance.

Unused credit limit is not a company's available cash. Financing capacity and available cash should be monitored separately.

Not updating the forecast

Once a study is prepared and filed, it quickly becomes outdated. Weekly updates reflect changes in collection and payment behavior in the model.

Getting lost in too much detail

Creating a separate line for every small expense can make the model unmanageable. Key items that influence management decisions should be tracked in detail, while low-value items should be tracked in meaningful groups.

What should be done when a cash shortage occurs?

A negative or critically high balance in the forecast is not a bad sign in itself. The real risk is that this is only discovered when the payment due date arrives.

Thanks to early warning, the business can:

• It can speed up the collection of overdue receivables,

• We can reassess payment plans with customers,

• You can negotiate payment terms with suppliers,

• You can change the stock purchase plan.

• They can reschedule investment spending,

• You can organize the purchasing schedule,

• Suitable financing options can be evaluated in advance.

The measures to be taken should not rely solely on credit utilization. Setting credit limits on a customer-by-customer basis, reducing low-movement inventory, improving purchasing discipline, and prioritizing capital expenditures can also significantly improve working capital.

If financing is needed, initiating discussions with banks or other financial institutions before a cash shortage occurs offers the business more options.

The cost of financing, its term, collateral requirements, impact on cash flow, and tax implications should all be considered together.

Combining accounting data with management decision-making.

A sound cash flow forecast requires the management, sales, purchasing, and accounting functions to work together.

Accounting records provide the basis for current receivables and payables. However, estimating the collection date solely from accounting records may not always yield accurate results.

The invoice due date may be one thing, but the actual payment date of the customer may be another.

Therefore, especially for significant amounts of receivables, the collection expectations of the sales team or the person in direct contact with the customer should be included in the model.

Similarly, the purchasing side should incorporate upcoming orders and payment obligations for which invoices have not yet been generated into the model, while management should incorporate planned investment and financing decisions.

A financial advisor can contribute to the process by checking the declaration and payment schedule, ensuring the consistency of records with bank transactions, planning tax liabilities, and interpreting financial results.

Thus, the 13-week cash flow forecast ceases to be merely a spreadsheet and becomes an integral part of the business's regular decision-making process.

Conclusion

A 13-week cash flow forecast is a practical management tool that makes the short-term payment capacity of SMEs visible.

Its success depends less on complex formulas and more on accurate initial data, realistic collection assumptions, a complete overview of upcoming liabilities, and a disciplined weekly update.

Monitoring a company's profitability along with its cash generation capacity helps in more controlled planning of tax, payroll, supplier, investment, and financing payments.

However, perhaps the most important advantage of the 13-week model is this:

It may not solve the problem, but it will buy the administration time to resolve it.

From a business management perspective, there is a huge difference between noticing a cash flow problem on the due date and identifying it 6-8 weeks in advance.

Therefore, the 13-week cash flow forecast should be considered not only a tool for businesses experiencing financial difficulties, but also an early warning and financial management system that healthy businesses can regularly implement.

Bonus: 13-Week Cash Flow Forecast Chart: Download it here.