Blog

12-Week Rolling Cash Flow Forecast: Free Template and How to Use It

Alessandro Badalamenti · Published 17 November 2026 · 9 min read

Laptop showing a 12-week cash flow forecast spreadsheet with a line chart of the projected bank balance dipping and recovering, next to a printed sheet and an espresso, on a desk in an office in Italy
A 12-week cash flow forecast shows the dip in your bank balance months before it reaches your account.

Most cash crunches are not surprises. Salaries, the F24 on the 16th, the 13th-month salary in December and tax advance payments are all known months in advance. What is missing is a single view of when money will really enter and leave your bank account, week by week.

A 12-week cash flow forecast gives you that view one full quarter ahead, while you can still chase a client, move a payment or arrange a credit line calmly.

Short answer

A 12-week cash flow forecast lists, week by week, every receipt and payment that will actually move through your bank account over the next quarter, VAT included, and compares the closing balance with a minimum threshold. Update it every Monday: enter the real balance, roll it forward one week and act on every week below the threshold. Download the free template or see how we can keep it updated with you.

In this guide

  1. What is a 12-week cash flow forecast and why does your business need one?
  2. Why 12 weeks?
  3. What goes into a 12-week cash flow forecast?
  4. Which Italian payment deadlines should be in your forecast?
  5. How do you read a 12-week cash flow forecast? A worked example
  6. Where can you download a free 12-week cash flow template?
  7. How do you use the template every week?
  8. What do you do when the forecast shows a shortfall?
  9. Which mistakes make a cash flow forecast unreliable?
  10. Who can keep your cash flow forecast updated in Italy?
  11. Frequently Asked Questions (FAQ)

What is a 12-week cash flow forecast and why does your business need one?

It is a rolling, week-by-week plan of your bank balance. Each week starts from the opening balance, adds the receipts you expect, subtracts the payments you expect and gives you a closing balance. Every Monday you drop the week just closed and add a new one at the end, so you always see a full quarter ahead.

Your profit and loss tells you whether you make money. Your cash flow forecast tells you whether you will have the money in the bank on the day you need to pay. The two diverge more than most owners expect: clients pay at 60 or 90 days, VAT is collected and then paid over, salaries and taxes leave on fixed dates whatever your sales did that month. In Italy it is often called cash flow previsionale or budget di tesoreria.

  • You see shortfalls early. Two or three months of notice turns a crisis into a to-do list: chase, reschedule, arrange financing.
  • You decide with confidence. A new hire, a large order or an investment: you can see what it does to your cash before you commit.
  • You talk to your bank from strength. A business that shows its forecast weeks in advance gets credit more easily than one that asks in an emergency.
  • You stop checking the bank app every morning. Once the forecast is reliable, you know which weeks are tight and which are calm.

Want a cash forecast without building it yourself?

See our monthly plans for bookkeeping, tax and financial control, in English.

See plans and pricing

Why 12 weeks?

Twelve weeks is roughly one quarter: long enough to see three rounds of salaries, three monthly F24 payments and any seasonal dip, and short enough that most of the receipts in it are already invoiced and most of the payments already have a due date.

If you already follow our 12-week cash flow framework, which explains why the P&L alone is not enough, this page is the practical next step: the template, the Italian deadlines and a worked example.

What goes into a 12-week cash flow forecast?

Only real bank movements, VAT included, placed in the week the money actually moves. Not the week you issue or receive the invoice.

The lines of a 12-week cash flow forecast
LineWhat goes in itTip
Opening balanceToday's balance on all business bank accountsUse the real balance, not the accounting one
Receipts from invoices issuedOpen client invoices, in the week each client really paysUse each client's real payment habits, not the due date on the invoice
Receipts from expected salesOrders and sales not yet invoicedBe cautious: better to be pleasantly surprised
Other receiptsLoans, tax refunds, shareholder fundingOnly if the date is certain
SuppliersSupplier invoices due, in the week you will payInclude recurring software and service subscriptions
Net salariesMonthly net pay, plus the 13th-month salary in December (and the 14th where your contract provides it)The single largest fixed outflow for most employers: estimate it with our payroll calculator or see how much an employee costs in Italy
F24 on the 16thPayroll withholding tax, social security contributions, VAT for monthly filersPredictable to the euro: never leave it out
Taxes and advance paymentsIncome tax balance and advances (IRES, IRAP or IRPEF), VAT advanceThe months they fall in are the classic cash traps
Rent, utilities, instalmentsLease, utilities, loan and leasing instalmentsFixed dates, easy to place
Closing balance and alertOpening balance plus receipts minus payments, compared with your minimum thresholdEvery week below the threshold is a signal to act

Leave out anything that does not move cash: depreciation, accruals, provisions. They belong in your profit and loss, not in your cash forecast.

Which Italian payment deadlines should be in your forecast?

Tax and payroll outflows are the easiest to predict and the ones that cause the most trouble when forgotten. The usual calendar for a small business in Italy looks like this; your exact dates depend on your entity, your tax regime and your employment contracts. To check the dates that apply to you, use our tax deadline checker.

  • The 16th of every month: the F24. Withholding tax on salaries and on professional invoices you received, social security contributions for your employees and, if you file VAT monthly, the VAT for the previous month. Quarterly VAT filers pay in the months after each quarter.
  • End of each month: salaries. Net pay to your employees. In December add the 13th-month salary (tredicesima), which roughly doubles the month's payroll; some national collective agreements also provide a 14th-month salary in summer.
  • End of June: income tax balance and first advance. The balance for last year and the first advance payment for the current year (IRES and IRAP for an SRL, IRPEF for sole traders and freelancers), plus INPS contributions for the self-employed.
  • End of November: second advance. The second income tax advance payment, often the largest single tax payment of the year for a growing business.
  • 27 December: VAT advance. The advance payment on next year's VAT, landing right after December salaries and the 13th-month salary.

When a deadline falls on a Saturday, Sunday or public holiday it moves to the next working day, which can push it into the following week of your forecast. That is why you place deadlines by date, week by week.

Stack of printed financial spreadsheets, a calculator and a desk calendar with dates circled, on a wooden desk in a small business office in Italy
Salaries, the F24 on the 16th and tax advance payments are known months ahead: circle them once and they stop being a surprise.

How do you read a 12-week cash flow forecast? A worked example

These are the example figures from the free template: a small business starting on Monday 2 November 2026 with €18,000 in the bank and a minimum threshold of €15,000. It sells steadily: over the 12 weeks it collects €134,000 and pays out €129,000. Amounts VAT included, rounded.

12-week cash flow forecast: November 2026 to January 2027
WeekReceiptsPaymentsClosing balanceWhat happens
1 (from 2 Nov)€9,000€7,000€20,000November rent
2 (from 9 Nov)€12,000€3,500€28,500Quiet week
3 (from 16 Nov)€10,000€12,500€26,000F24 on the 16th
4 (from 23 Nov)€14,000€18,000€22,000Salaries and loan instalment
5 (from 30 Nov)€12,000€16,000€18,000Second income tax advance, rent
6 (from 7 Dec)€12,000€3,500€26,500Quiet week
7 (from 14 Dec)€13,000€13,000€26,500F24 on the 16th
8 (from 21 Dec)€12,000€27,000€11,500Salaries plus 13th-month salary, instalment: below threshold
9 (from 28 Dec)€9,000€11,000€9,500VAT advance, rent: lowest point
10 (from 4 Jan)€10,000€2,500€17,000Back above the threshold
11 (from 11 Jan)€10,000€4,500€22,500Quiet week
12 (from 18 Jan)€11,000€10,500€23,000F24 (the 16th falls on a Saturday)
Total, 12 weeks€134,000€129,000€23,000Lowest balance: €9,500 in week 9

The business sells every week, yet between Christmas and New Year its balance falls to €9,500, €5,500 below the threshold. None of it is a surprise: the 13th-month salary, the second income tax advance and the VAT advance are known months ahead. The difference is seeing them at the beginning of November. With two actions decided in week 1, collecting €6,000 of overdue receivables by week 6 and agreeing with a supplier to move a €3,000 payment from week 8 to week 10, the balance never falls below €18,000.

How solid are the books behind your forecast?

A forecast is only as good as your bookkeeping. Answer 8 questions in our free Bookkeeping Health Scorecard and get a personalised score with recommendations.

Take the free scorecard

Where can you download a free 12-week cash flow template?

Right here: a ready-made Excel file with formulas, alerts and a chart already set up, and the example data from this page for you to overwrite. It also works in Google Sheets and LibreOffice. No sign-up needed.

Free download

12-week cash flow forecast template (Excel, free)

  • Settings: start date, today's bank balance, your minimum cash threshold and your available credit line.
  • Weekly forecast: receipts and payments for 12 weeks, with net cash flow and closing balance calculated automatically, including lines for the F24, salaries and tax advance payments.
  • Alerts and chart: every week below the threshold or overdrawn is flagged in red, and the chart shows your balance against the threshold.
  • Actuals: a row to enter the real balance every Monday, with the variance against the forecast.
  • Instructions: the 5 steps to use it every week, on one page.

Download the free Excel template

Cells in grey italic are example data: replace them with yours. Cells with a light background contain formulas. If you would like us to fill it in from your bookkeeping and update it with you, book a free call.

How do you use the template every week?

The first set-up takes an hour or two. After that, the weekly update takes about 30 minutes, always on the same day.

  1. Set the basics. Enter the Monday your forecast starts, today's bank balance, the minimum threshold you do not want to go below and any credit line you can draw on.
  2. Enter the certain payments first. Salaries, the F24 on the 16th, tax advance payments, rent and instalments. They are fixed and they are the ones that hurt when forgotten.
  3. Add receipts realistically. Open invoices in the week each client really pays, not on the due date. Then expected sales, cautiously.
  4. Read the alert row and the chart. Every week marked BELOW THRESHOLD or OVERDRAWN needs an action now: chase receipts, move payments, or arrange financing in time.
  5. Roll it forward every Monday. Enter the real balance for the week just closed, read the variance against the forecast, drop that week and add a new week 12 at the end. Large variances tell you which assumptions to fix.
Tablet showing a bar chart of weekly cash movements on a marble meeting table, with printed charts and an open notebook with a checklist, in a bright office in Italy
Thirty minutes every Monday: the real balance in, the past week out, a new week 12 added and one decision for every tight week.

What do you do when the forecast shows a shortfall?

The point of the forecast is to give you time. With weeks of notice, the options are many and cheap; with days of notice, they are few and expensive. Work in this order.

  • Speed up receipts. Chase overdue invoices first, then consider shorter payment terms for new orders, deposits on large jobs or invoicing at milestones rather than at the end.
  • Reschedule payments. Agree new dates with suppliers before the due date, not after. Most suppliers accept a short delay when asked in advance with a clear plan.
  • Plan the tax payments. Some Italian taxes can be paid in instalments, and advance payments can sometimes be reduced if this year is genuinely worse than last. These are technical choices with penalties if done wrong: decide them with your commercialista, not alone.
  • Arrange financing in time. A credit line or a short-term loan costs less and is easier to obtain when you ask weeks ahead, forecast in hand.
  • Review the plan itself. If the forecast shows a shortfall every quarter, the problem is structural: margins, payment terms or fixed costs. That is a conversation about your business model, not your cash.

Which mistakes make a cash flow forecast unreliable?

The template is the easy part. These are the habits that make a forecast drift away from reality.

  • Mixing profit and cash. Entering invoices on the issue date instead of the payment date. The forecast becomes a second profit and loss and stops warning you.
  • Forgetting VAT. Receipts and supplier payments include VAT; the VAT you owe leaves later with the F24. Leave VAT out and every number is wrong.
  • Optimistic receipts. Using the due date on the invoice when you know the client always pays 30 days late. Use real habits.
  • Leaving out the known deadlines. The 13th-month salary, tax advance payments and the VAT advance are certain. They are also the most common reason a forecast fails.
  • Updating it once a quarter. A forecast that is not rolled forward every week is out of date by week three. The weekly routine is the method.
  • Late bookkeeping. If your books are only updated every few months, you do not know your open invoices and payables. Timely bookkeeping is the foundation.

Who can keep your cash flow forecast updated in Italy?

Whoever already keeps your books has the data: open invoices, payables, payroll and the tax calendar. The extra step is using it every week to look ahead. That is how we work at TMG Books: an organized team that handles the full range of commercialista services and, on top of that, proactive financial control. Everything in English.

  • Books kept up to date. Timely monthly bookkeeping, so your open invoices and payables are always current.
  • Cash forecast and financial control. Your 12-week forecast prepared, rolled forward and reviewed with you through our financial control service, alongside budget and monthly KPIs.
  • Tax deadlines handled by a team. Tax returns, F24 payments and tax planning handled by a team, so every deadline is already in your forecast before it arrives.
  • A plan that fits. Several companies, several bank accounts or seasonal peaks? We build it into a custom plan around your business.

Frequently Asked Questions (FAQ)

What is a 12-week cash flow forecast?

It is a week-by-week plan of the money that will actually enter and leave your bank account over the next 12 weeks, so you can see a cash shortfall two or three months before it happens.

Each week starts from the opening balance, adds expected receipts, subtracts expected payments and gives you a closing balance to compare with a minimum threshold. Every Monday you roll it forward by one week, so the horizon is always about a quarter ahead. It does not replace your profit and loss: it answers a different question, whether you will have the cash to pay. To build yours, book a free call.

Why 12 weeks and not a full year?

Because 12 weeks is roughly one quarter: long enough to see salaries, tax deadlines and slow months coming, short enough to forecast with real invoices and real due dates.

A yearly cash plan is useful for strategy, but week by week it becomes guesswork after the third month. A 12-week horizon covers three monthly F24 payments, three rounds of salaries and any quarterly or seasonal peak, and it stays reliable because most of the receipts in it are already invoiced. To set the right horizon for your business, book a free call.

What should a 12-week cash flow forecast include?

Every real bank movement, VAT included: receipts from invoices already issued, receipts from expected sales, supplier payments, net salaries, F24 payments, taxes and advance payments, rent, loan instalments and anything else that leaves the account.

Then three control lines: the closing balance for each week, your minimum cash threshold and an alert for every week below it. What you leave out is just as important: depreciation, accruals and anything that does not move cash. To check your list of items, book a free call.

Is the free 12-week cash flow template really free?

Yes: it is a free Excel file, with no sign-up, that you can download from this page and use in Excel, Google Sheets or LibreOffice.

It has formulas, alerts and a chart already set up, and example data in grey italic that you simply overwrite with your numbers. If you would rather have a team fill it in from your bookkeeping and keep it updated with you every week, book a free call.

How do I update a rolling 12-week cash flow forecast every week?

Every Monday, enter the real bank balance for the week just closed, compare it with the forecast, drop that week and add a new week 12 at the end.

Then update the receipts you now know better (a client who said they will pay late, a new order) and check the alert row. It takes about 30 minutes once the file is set up. The value is in the habit: a forecast updated every Monday is always about three months ahead, one updated once a quarter is always out of date. To set up the weekly routine, book a free call.

What is the difference between a cash flow forecast and a profit and loss budget?

The budget measures whether you make money; the cash flow forecast measures whether you will have money in the bank on a given day.

The profit and loss counts invoices when you issue them and costs when you incur them. The cash flow forecast counts only when money actually moves: a client paying at 90 days, VAT collected and paid over, a 13th-month salary paid in December. A business can be profitable and still run out of cash. You need both, built on the same bookkeeping. To connect them, talk to our team.

Which Italian deadlines should I put in my cash flow forecast?

At a minimum: the F24 payments due on the 16th of each month, salaries, the 13th-month salary in December, income tax payments and advance payments, and the VAT advance due on 27 December.

The F24 on the 16th typically includes payroll withholding tax, social security contributions and, for monthly VAT filers, VAT. Income tax balances and the first advance payment usually fall at the end of June, the second advance at the end of November. When a deadline falls on a weekend it moves to the next working day. These are the easiest outflows to predict, so they should never be a surprise. Your exact calendar depends on your entity and tax regime: to map it, book a free call with our team.

What minimum cash threshold should my business keep?

A common rule of thumb is enough cash to cover two to four weeks of fixed outflows: salaries, the F24 on the 16th, rent and loan instalments.

In the worked example on this page the threshold is €15,000 for a small business with about €12,000 of monthly net salaries. Businesses with seasonal sales or clients who pay late should keep more. The threshold is a decision, not a formula: set it, write it in the template and treat every week below it as a signal to act. To set the right threshold for you, book a free call.

What can I do when the forecast shows a cash shortfall?

Act on receipts first, then on payments, and only then on financing: chase overdue invoices, agree new dates with suppliers, and arrange a credit line before you need it, not during the shortfall.

In our example two actions decided in week 1, collecting €6,000 of overdue receivables by week 6 and moving a €3,000 supplier payment from week 8 to week 10, keep the balance at €18,000 or more for all 12 weeks. Banks lend more easily to a business that shows a forecast weeks in advance. To work out your options, book a free call.

Can I build a 12-week cash flow forecast in Excel?

Yes: for most small businesses Excel is the right tool, and our free template already has the structure, formulas, alerts and chart in place.

The limit is not Excel but the data: the forecast is only as good as your list of open invoices, supplier payables and deadlines. When you manage several bank accounts or companies, or updating the file takes more than an hour a week, it is worth moving from Excel to a financial dashboard connected to your bookkeeping. To check what fits your business, book a free call.

Why does a profitable business run out of cash?

Because profit is measured on invoices and costs, while cash moves only when you collect and pay, and in Italy the gap between the two can be months long.

Clients paying at 60 or 90 days, growing stock, the 13th-month salary, tax advance payments and loan instalments all absorb cash even when the profit and loss is positive. In our example the business sells every week, yet between Christmas and New Year its balance falls to €9,500, below its safety threshold. The forecast is there so you see it in November. To check your position, book a free call.

Who should prepare the 12-week cash flow forecast?

Ideally whoever already keeps your books, working with you: they have the open invoices, the payables and the tax calendar, and you know the commercial side.

The traditional commercialista calls you about deadlines, not about cash. We work as an organized team: we handle the full range of commercialista services, from bookkeeping to tax returns, and on top of that we prepare and review your cash forecast with you, in English. To see how it would work for your business, book a free 30-minute call.

How do I start a 12-week cash flow forecast today?

Download the free template, enter today's bank balance and your minimum threshold, then list every invoice you expect to collect and every payment you expect to make over the next 12 weeks.

Start with the certain items (salaries, F24, rent, instalments, invoices already issued), then add expected sales cautiously. Next Monday, compare the real balance with the forecast and roll it forward one week. If you would rather have a team set it up from your bookkeeping and keep it updated for you, book a free call.

The bottom line

A 12-week cash flow forecast is your bank balance, week by week, compared with a minimum threshold, with every receipt and payment placed in the week the money really moves. Rolled forward every Monday, it shows you salaries, F24 payments and tax advances two or three months ahead, while you can still act calmly.

Want to know today how much cash you will have in three months?
Let us build your forecast together.

Tell us about your business, your bank accounts and your deadlines, and we will come back to you with how we would set up your 12-week forecast.

Contact our team

Enjoy This Article? You May Also Like:

Figures are illustrative, based on the template's example data; tax deadlines are indicative and depend on your entity and regime. This is not advice for your specific case.