FM Studio Consulenza
FM Studio di Consulenza ProfessionaleDirection. Organisation. Results. Everything else is theory
ItalianoEnglish
Current affairs  ·  Training  ·  Topics  ·  Tools  ·  About the author

← All articles

13-week cash forecast: why the month-end balance is not enough and how to build one

19 November 2026, 08:11

On 13 November the Bank of Italy published its Financial Stability Report. According to its projections, the share of loans to companies that become difficult to repay during the year would rise from 2.1%, the average for 2026, to 2.3% in 2027, mainly because borrowing costs more: in September new loans, excluding overdrafts, cost 3.8% on average, against 3.4% in March.

An unpaid instalment is the last step of a cash shortfall that could have been seen earlier, in the week when payments exceed receipts by more than the credit line can cover. The tool that shows it in time is the 13-week cash forecast: a quarter divided into seven-day periods, with how much is expected to come in, how much has to be paid and how much will be left in the accounts at the end of each one.

The month-end balance hides the worst days

Those who forecast cash usually do so month by month, lumping together movements that fall on very different dates. On the 16th, social security contributions and employees' withholding tax are paid; salaries go out at the end of the month or at the start of the next; and many customers pay at 60 or 90 days end of month, with due dates that almost all fall on the same day. A month's balance can close even and still contain, in the middle, a week in which the overdraft exceeds the credit line: the weekly forecast shows it, the monthly one does not.

A quarter is the right horizon because it leaves time to prepare for a difficult due date, and is also short enough for most receipts to be already written in the invoices issued and in the orders to be delivered.

Receipts are forecast with customers' real delays

The starting point is today's balance, that is, the cash in the accounts minus the overdraft already used. Receipts are taken from the customer ledger in the management software, which however shows the due dates written on the invoice. The typical mistake is to take those dates at face value: each major customer has its own habit, and its average delay is found by comparing, on the invoices collected in recent months, the due date with the day the money arrived. Every invoice of that customer is moved by the same delay; for the others an average calculated on all of them together is enough.

To the invoices already issued are added those that will be issued for the orders being delivered during the quarter, with each customer's payment terms. Invoices already presented to the bank for an advance, on the other hand, have already brought in their money: at the due date the customer's payment closes the advance and adds nothing, while if the payment does not arrive the bank debits the amount back to the account.

The heaviest payments are already known today

Suppliers' invoices are in their ledger; salaries and contributions are known to whoever handles the payroll; loan and lease instalments can be read in the repayment schedules. In December come outflows that do not recur every month: the thirteenth-month salary, which almost doubles the wages to be paid, and, for those who owe it, the VAT advance payment, due by the 27th.

For each week the closing balance is the opening balance plus receipts minus payments, and it is compared with the overdraft facilities. For unexpected events it is prudent to leave about a quarter of the facility unused: the week in which the forecast overdraft exceeds three quarters of the agreed limit is the one to prepare for. With a few weeks' notice there are three options: asking the customer on whom that week depends to confirm the payment date, agreeing with a supplier to move a due date, or asking the bank for a temporary increase in the facility. A request that arrives a month ahead, forecast in hand, is discussed on the figures; one that arrives the day before the due date, much less so.

Each week the actual figures replace the estimate

The forecast is redone every week, on Monday for example. The actual receipts and payments of the seven days just gone take the place of the estimated ones; that period then drops out of the forecast and a new one is added at the end. Comparing actual and estimated receipts shows which customers paid later than usual, and those days go into the next forecast. The work is done by the accounts department, with the software's ledgers exported to a spreadsheet; whoever handles controlling compares the forecast with the year's targets, to understand whether a cash variance comes from sales or from payment times.

Over the next quarter, which week will have the lowest balance, and will the overdraft facility be enough to cover it while leaving a quarter free?

This article was prompted by a news item published in Teleborsa on 13 November 2026.

Written by Dr Flavio Marzani, founder of www.fmstudioconsulenza.it

Cash and liquidityBanks and debt

Share this article with someone who needs it:LinkedInWhatsAppE-mail

Read also