Skip to content
Free tool

A 13-week cash flow forecast from your open items

Two CSV files and a bank balance: the generator assigns every open invoice to its due week, deducts your recurring outflows and shows the closing balance week by week, with the low point marked.

Your data

Columns needed: a due date and an amount. Header names are detected (e.g. "Fällig", "due", "Betrag", "amount"). Semicolon or comma separated.

🔒 Your files stay in your browser. Nothing is uploaded.

13-week forecast
Enter a balance and add at least one file — or load the example data.
WeekFromInflowsOutflowsClosing balance

The download unlocks after the form below — once, then it stays open on this device.

Get the full result as a file

Unlocks the download here at once — and we email you the 13-week Excel template.

By submitting you agree that we may send you the template by email and occasional marketing updates (unsubscribe anytime). See our privacy policy.

How the generator works

The forecast uses the direct method: for each of the 13 weeks from the Monday of the start week, expected receipts (receivables falling due) and payments (payables falling due plus your recurring outflows) are set against the balance. One week's closing balance is the next week's opening balance.

Overdue items count in week 1, because they are due now. Items beyond the horizon are left out and counted, so you know how much the forecast does not carry. The lowest closing balance is the low point; weeks below zero are red.

What no open-items list carries, such as payroll, social charges, taxes, rent, leasing and loan repayments, goes in as one weekly amount. That is rough, and it is honest: a forecast without that base is too optimistic.

Which file it reads

A CSV as exported from the open-items list of DATEV, SAP Business One and most accounting systems. Two columns are needed: a due date (recognised by headers such as "due", "Fällig", "date") and an amount ("open", "amount", "Betrag"). German and English number and date formats are recognised, with semicolon, comma or tab as separator.

How to get the list is covered in the guides to the open items list and to DATEV. The structure of the forecast itself is in the 13-week forecast guide.

Free Excel template

The 13-week template for rolling the forecast forward: weekly grid, chart, low-point warning, formulas in place.

Get the template

Frequently asked questions

Is my data uploaded?
No. The files are read and calculated in your browser; nothing leaves your machine. Only the form for the download sends your contact details.
What is the low point in a 13-week forecast?
The lowest closing balance within the 13 weeks. It shows whether and when liquidity gets tight, and so whether a line needs raising, a payment term negotiating or an outflow moving.
Why do overdue invoices count in week 1?
Because they are due now. An overdue receivable can arrive any day and an overdue payable can be debited any day; the conservative assumption is the first week.
How is this different from the Excel template?
The generator reads the open-items list and calculates once; the Excel template is for rolling the forecast forward each week, with a chart and a low-point warning. Neither replaces a live forecast from real bank movements.
From a one-off calculation to a live forecast

LiquidityLens builds the rolling 13-week forecast from your open items and bank balances: plan versus actual, low-point warning, current every week. Set up with your data in 30 minutes.

Request a 30-minute pilot