/ Cash-flow

See the gap before it sees you.

Open invoices in, a 13-week picture out: when money lands, when it leaves, and the first week the running balance drops below zero. Everything happens in your browser; nothing is sent anywhere.

These numbers never leave this page. No request is sent; close the tab and they are gone.

/ What this checks

How the 13-week projection is calculated, and what the first gap means.

The calculation runs in JavaScript on this page as you type; there is no submit button and no request to a server. Each line is split on a semicolon, comma or tab into an amount, a due date and an optional third column. Lines whose third column says paid, yes, tak, zapłacona or 1 are left out. The rest are placed into 13 consecutive seven-day windows counted from the present moment, which are not calendar weeks. Anything already overdue goes into the first window. Starting from the cash figure you enter, each window's net amount is added to a running balance.

Each bar is the projected balance at the end of one seven-day window, labelled with the day and month on which the window starts, and a red bar is a balance below zero. The line above the chart names the first window in which the balance turns negative, with the amount, or states that there is none. Bar height is scaled to the largest absolute balance on the chart, so compare bars within one chart and not between two. A skipped-lines notice means the amount or the date on those lines could not be read. A header line containing the word amount or kwota is ignored silently.

The projection knows only the lines you paste. Payroll, rent, tax and loan instalments are absent unless you enter them as negative amounts, and every open invoice is assumed to be paid exactly on its due date, which is the optimistic case. Anything due later than 13 weeks from today is left out. There is no currency handling: all amounts are summed as one unit. Write decimals with a dot, because a comma is read as a column separator, and write dates as YYYY-MM-DD, since other formats depend on the browser. Before acting on the picture, run it again with habitual late payers moved by their usual delay.

What is a 13-week cash flow forecast?
It is a short-term forecast of money coming in and going out, week by week, across one quarter. Thirteen weeks is the usual horizon because it is long enough to include a full cycle of payroll, tax and supplier payments, and short enough that most of the amounts are already known from issued invoices and signed commitments. It is normally updated every week, dropping the week that passed and adding a new one.
What is the difference between profit and cash flow?
Profit is revenue minus the costs recognised in a period under accounting rules. Cash flow is the money that actually enters and leaves the bank account in that period. A business can report a profit and still run out of cash when customers pay later than staff and suppliers have to be paid, or when money goes into stock, loan repayments or tax.
How do you calculate a cash flow gap?
Start with the opening cash balance. For each period in date order, add the receipts you expect and subtract the payments you owe, and keep a running balance. The gap is the first period in which that balance falls below zero, or below the reserve you want to hold, and its size is how far below it falls. Closing it means collecting sooner, paying later or arranging finance before that date.
Next

When one check is not the whole job.

The delivered version watches your invoices by itself and flags the gap weeks ahead.