Allianz Trade expects around 24,500 corporate insolvencies in Germany in 2026 — the highest number in twelve years. Per the KfW Mittelstandspanel, roughly 11% of German SMEs already rate their own liquidity position as critical. Whatever the specific reason a business ends up in that group, the pattern beforehand is almost always the same: nobody saw the cash gap coming until it was too late to act on it.
This is exactly the problem a 13-week cash flow forecast is built to solve. Not a budget. Not an annual plan. A living, weekly-updated view of exactly how much cash the business has, and exactly when it might run short — refreshed every week, not once a quarter.
This guide covers what a 13-week rolling forecast actually is, how accurate it really is, what German banks now expect to see, and how to build one without buying software you don't need.
In short: a 13-week rolling cash flow forecast is the 2026 standard for liquidity planning in the German Mittelstand — banks now expect it as part of lending diligence, and forecast accuracy runs above 95% in the first four weeks, dropping to 70–85% by week thirteen. With insolvencies at a 12-year high, weekly cash visibility is no longer optional for SMEs above roughly 20 employees.
Why liquidity planning is urgent in Germany right now
The numbers are not abstract. Allianz Trade's 2026 forecast of around 24,500 corporate insolvencies would be the highest count in over a decade, and the KfW Mittelstandspanel already puts 11% of SMEs in a self-reported critical liquidity position. None of this means every business is at risk — but it means the margin for "we'll figure out cash flow at month-end" has gotten thinner across the board.
The businesses that get caught out rarely fail because they were unprofitable on paper. They fail because a payment they were counting on slipped by three weeks, a large customer stretched their terms, or a tax payment landed in the same week as payroll — and nobody had visibility far enough ahead to see the collision coming.
What a 13-week cash flow forecast actually is
A 13-week cash flow forecast is a rolling, week-by-week projection of cash in and cash out, covering roughly one quarter at a time. Each week has three components: an opening balance, the week's expected inflows and outflows, and a closing balance that becomes next week's opening balance.
The "rolling" part matters as much as the "13-week" part. Every week, the oldest week drops off the front of the model and a new week gets added at the end — so the business always has a full quarter of forward visibility, not a forecast that gets stale the moment it's built.
Why 13 weeks, not 4 or 52
Thirteen weeks is a deliberate balance. A 4-week view is too short to see a quarterly tax payment or a seasonal dip coming. A 52-week annual budget is too coarse-grained and too quickly out of date to manage actual weekly cash decisions. Thirteen weeks — one quarter — is long enough to plan around, short enough to stay accurate, and it happens to match the reporting cadence banks and investors are used to.
How accurate is a rolling forecast, really
Forecast accuracy degrades the further out you look — which is expected, not a flaw. The value is in the combination of near-term precision and medium-term direction, refreshed weekly.
| Forecast horizon | Typical accuracy | What it's good for |
|---|---|---|
| Weeks 1–4 | 95%+ | Operational decisions: exact payment timing, short-term facility drawdown |
| Weeks 5–8 | 85–90% | Planning: spotting a likely cash dip early enough to act |
| Weeks 9–13 | 70–85% | Direction: is the trend improving or worsening, not exact numbers |
Because the model rolls forward every week, this week's "week 9" becomes next week's "week 8" and picks up accuracy automatically as it gets closer. That's the core mechanic that makes a rolling forecast far more useful than a static one built once a quarter.
Building the forecast: what goes into each week
The structure is simple even when the inputs aren't:
- Inflows: customer receipts (by actual expected payment date, not invoice date), any financing drawdowns, asset sales
- Outflows: payroll, supplier payments, rent and recurring costs, loan repayments, and — a common German-specific blind spot — Umsatzsteuer (VAT) payment dates, which land at fixed points regardless of how the rest of the month is trending
- Opening and closing balance: each week's closing balance is next week's opening balance, giving a continuous thread across the full 13 weeks
The discipline that makes this work is grounding inflow timing in realistic expected payment dates, not invoice due dates — customers rarely pay exactly on terms, and a forecast built on optimistic assumptions fails at exactly the moment it's needed most.
DATEV and Liquiditätsplanung: what's built in, what isn't
Most German SMEs run on DATEV, and DATEV does offer a licensable Liquiditätsplanung module. What it does well: pulling accurate historical transaction data. What it doesn't do automatically: building forward-looking assumptions about a customer who's historically 15 days late, or a supplier payment that's being deliberately delayed this month. DATEV gives you the base data; someone still has to own the forecasting logic on top of it.
Excel vs specialised software: when each makes sense
Neither answer is right for every company. A single-entity business with a disciplined weekly update habit can run a clean 13-week forecast in Excel indefinitely — the tool has never been the limiting factor for a well-run process. Specialised liquidity management software starts earning its cost once there are multiple entities or currencies, high transaction volume that makes manual updates error-prone, or — most commonly — nobody in the business who will reliably do the manual update every single week without being chased.
The honest failure mode isn't "wrong tool." It's a forecast that gets built once, looks great in the board deck, and is never updated again.
Liquidity planning for Mittelstand, startups and subsidiaries
The priority shifts by segment:
- Mittelstand companies most often build a 13-week forecast because a bank asked for one as part of a credit line renewal — see the next section on what lenders expect.
- Startups and scale-ups use it primarily for runway visibility between funding rounds, and increasingly fold it directly into investor-grade reporting packages rather than treating it as a separate document.
- Subsidiaries of international groups usually need the local forecast to roll up into a group-level view, which raises its own timing questions around HGB reporting cycles and intercompany settlement dates — part of the broader finance function build-out for a German entity.
What German banks expect to see in 2026
Lenders increasingly expect a rolling 13-week cash forecast as a standard part of credit diligence — a weekly breakdown of expected inflows and outflows, not a static annual projection. A business that can produce this on request, already updated and already accurate, signals exactly the kind of financial control a lender wants to see. A business that has to build one from scratch when asked signals the opposite, regardless of how the underlying numbers actually look.
Where an interim controller fits in
Building and maintaining a 13-week rolling forecast is Interim Controller scope, not a CFO-level strategic decision — it's process discipline: getting the right inputs from sales, procurement and payroll every week, keeping the model accurate, and making sure someone actually owns the weekly update. The judgment calls that come out of it — whether to draw a credit line, delay a hire, chase a customer harder — sit with management, informed by numbers they can trust.
Most Mittelstand companies don't need to hire this permanently. They need someone to build the process, run it through a few cycles until it's reliable, and hand it over — which is exactly the kind of scoped mandate an interim controller is built for.
5 mistakes that break a cash flow forecast
- Building it once and never updating it. A forecast that isn't refreshed weekly is a snapshot, not a forecast.
- Using invoice due dates instead of realistic expected payment dates. Optimistic inflow timing is the single most common cause of forecast failure.
- Forgetting fixed-date obligations. VAT payments, loan instalments and payroll don't move — build them in first, then fit everything else around them.
- No single owner. A forecast that's "everyone's job" quietly becomes nobody's job by week three.
- Treating it as a finance-only document. Sales and operations hold the real information about payment timing and delayed deliveries — a forecast built without their input is a finance team's best guess, not a company-wide view.
Conclusion
A 13-week rolling cash flow forecast isn't complicated in structure — inflows, outflows, opening and closing balance, updated weekly. What makes it valuable is the discipline of actually keeping it current, and the honesty of grounding it in realistic payment timing rather than best-case assumptions.
With insolvencies at a 12-year high and banks treating rolling forecasts as standard diligence, this is no longer a nice-to-have for the German Mittelstand. It's the difference between seeing a cash gap twelve weeks out — with time to act — and finding out about it the week it happens.
Not sure your business would see a cash gap coming with twelve weeks' warning?
Let's build a 13-week forecast that actually gets updated.
Book a call → or get in touch directly.
Frequently asked questions (FAQ)
What is a 13-week cash flow forecast?
A rolling, week-by-week projection of cash inflows, outflows, and opening/closing balances covering roughly one quarter at a time. Each week a new week is added at the end and the oldest week drops off, keeping a constant 13-week forward view.
How accurate is a rolling 13-week forecast?
Typically above 95% accurate in weeks 1–4, 85–90% in weeks 5–8, and 70–85% in weeks 9–13. Accuracy improves automatically as each week rolls closer, since the forecast is refreshed weekly rather than built once.
Do I need software, or can I use Excel for liquidity planning?
Excel works well for a single-entity business with a disciplined weekly update habit. Specialised software starts paying for itself with multiple entities or currencies, high transaction volume, or when no one reliably does the manual weekly update.
Does DATEV include liquidity planning?
DATEV offers a licensable Liquiditätsplanung module and provides accurate historical transaction data, but it does not automatically build forward-looking payment assumptions — someone still needs to own the forecasting logic on top of the base data.
When should a company bring in an interim controller for liquidity planning?
When the business needs a reliable 13-week forecast process built and run through several cycles, but doesn't need to hire that capability permanently — typically because a bank has asked for one, or a company is heading into a funding round or credit renewal and doesn't yet have the discipline in place.