Help center
Cost accounting & budgets

Forecast my cash week by week

1 min read Treasury > Cash forecast
Download as PDF

Here you see your cash for the coming weeks, computed from the book.

How to

  1. Pick the horizon in the list at the top of the page (« 13 weeks (book) » by default).
  2. Set your threshold: « ⋯ », then « Threshold and settings ».
  3. Spot the « Low point » tile and the « Below threshold » weeks.
  4. Click an amount in the « By week » tab for its detail.
  5. Click « What if »: late customers, moved payment, one-off.
  6. Click « Export », as CSV or Excel.
Demonstration video: Forecasting your cash over 13 weeks
Learn more

The forecast starts from today's cash and adds, week by week, what the ledger expects: nothing to enter again. It rolls on its own: every Monday, the closed week moves to actuals and a new week appears at the end of the horizon. Scenarios (« What if ») change no data.

Read the forecast

The tiles show « Cash today », « Low point » (the lowest end-of-week balance and its date), « Receipts, 13 wks » and « Payments, 13 wks » (the number follows the chosen horizon). The curve shows the actuals of closed weeks, the forecast as a dashed line and the alert threshold. « By week » tab: click an amount to see the items behind it (invoice, bill, run, entry) and open them. The « incl. estimated » column opens the estimate basis.

Where the amounts come from

Cash today: class 5 accounts of posted entries, except items to cash (51) and discounting (565). Customers and suppliers: the unlettered items of accounts 41 and 40, at their due date, net of partial payments. An invoice entered or synced counts once, through its entry. A supplier invoice placed in a payment run is paid on the run date. Bills receivable in portfolio or at the bank, accepted bills payable: at their due date. VAT: the 443 / 445 balance on your country's payment day. Payroll: net salaries of approved runs, payroll charges due, and the following months estimated from the last run. Recurring: each upcoming occurrence. A customer item overdue more than 90 days is left out (listed in « Assumptions »).

The estimate

So the forecast does not fall to zero after the known due dates, each week gets an estimate: the weekly average of cash movements with no invoice (cash sales, bank fees, expenses paid directly) over the last 3 months. Movements forecast elsewhere (customers, suppliers, bills, VAT, payroll, recurring) are left out of it. « See the basis movements » lists the entries used.

Choose the horizon

The forecast covers 13 weeks by default. The list at the top of the page offers 4, 8, 13, 26 or 52 weeks: your choice is kept for this book on this device, and « (book) » marks the book's horizon. The book administrator sets the book's horizon in « ⋯ » > « Threshold and settings » > « Forecast horizon » (4 to 52 weeks; empty, the book follows the organization). An organization administrator also sets the « Organization default horizon » there, used by all its books without their own. The Monday e-mail alert and the dashboard use the book's horizon. The forecast stays weekly. Each change is written to the audit log.

Alert threshold and low point

« ⋯ » menu > « Threshold and settings » (book admin): « Minimum cash (alert threshold) », « Estimate basis » (last 3 to 6 months) and the delay after which a receivable is left out. Weeks under the threshold show « Below threshold » and the lowest one « Low point »; with no threshold, the alert is below zero. « E-mail me on a low point » sends an e-mail on Monday when a low point is forecast, to you only; turn it off in the same menu.

Run a scenario

« What if » opens the scenario: « Customers pay late » shifts customer receipts by N days; in a week's detail, « Exclude » or « Move » a payment; « One-off » adds a receipt or a payment on a date. The curve and tiles show the scenario against the base. « Reset » goes back to the base. Nothing is saved.

Actual and forecast, reliability

Each week, the forecast is set aside. « Actual and forecast » tab: for each of the last 8 closed weeks, what was received and paid (class 5 movements) against what was forecast the week before, and the variance. Reliability sums up these variances as a percentage. With Procura, « Include committed orders » (« ⋯ » menu) adds purchase orders not yet invoiced.

Frequently asked questions

Why is a customer invoice missing?

It may be a draft (not in the ledger yet), already lettered with its payment, overdue more than 90 days (« Assumptions » > « Receivables left out ») or due after the last week of the horizon.

Why « Partial data »?

A source (for example bills or payroll) could not be read: the forecast shows the rest and names the missing source. Reload the page; if the message stays, contact support.

Read next

Third parties, due dates & reminders
Track customer and supplier due dates (due-date ledger, aged balance)
Unmatched items with their due date, days late and payment method, and outstanding amounts by age bucket.
Third parties, due dates & reminders
Pay suppliers in one run: transfer file and remittance advices
Select the due supplier items, have the run approved, post it to the bank with lettrage, then download the transfer file and the advices.
Third parties, due dates & reminders
Manage bills of exchange (drafts, LCR, promissory notes)
Create a bill from open invoices, send it for collection or discount, record an unpaid bill, pay a supplier bill.
Invoicing & VAT
Prepare my monthly VAT return
Collected VAT minus deductible VAT for the month: the amount to pay, computed from posted entries.
Invoices & bank
Reconcile my bank account
Import the statement as the bank provides it, validate the automatic proposals and settle invoices on the way.
Cost accounting & budgets
Enter a budget and compare it with actuals
An amount per account and month, for the whole book or an analytic section, compared with the ledger at the date you choose.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support