AWRA OpsHub Search
Accounting · Cash forecast

Thirteen weeks of cash, from the documents you already have.

The forecast starts from today’s cash and bank balances in the ledger, then places every open customer invoice, supplier bill, issued purchase order, payroll run, unpaid expense and tax liability in the week it is expected to move. Nothing is typed into a spreadsheet, so the forecast changes when the books do.

Scenarios beside the base CSV export In the mobile app
What the forecast reads

Every line is a document, dated the way it was written.

Week 1 starts on this week’s Monday. A document whose date has already passed — an overdue invoice, a late bill — lands in week 1, because it is still owed and the earliest it can move is now. Anything expected after week 13 is left out.

Money in

  • Open customer invoices by due date — optionally moved by each customer’s average days late over the last year.
  • Invoices your recurring schedules will raise, on the dates they will raise them.
  • Recurring journals that move money into a cash account.

Money out

  • Supplier bills by due date.
  • Issued purchase orders not yet billed, at expected delivery plus that supplier’s usual terms (30 days when there is no history to learn from).
  • Payroll: unpaid runs, and months with no run projected from the last regular one; statutory deductions on the 9th of the month after.
  • Unpaid approved expenses, and VAT and withholding owed per the ledger, due on the 20th of the month after.
From Accounting → Cash forecast

Read it, question it, try the other version.

Read the weeks

Opening, inflows and outflows by category, and the closing balance for each of thirteen weeks, with a chart of the closing line.

Open any figure

Every amount in the table is a link. It lists the invoices, bills, orders or runs behind it, so a surprise in week 6 has a name.

Set your floor

Pick a low-cash threshold and the page says which week first falls below it. Switch payment history on to move receipts by how late each customer usually pays.

Try a scenario

Move receipts by N days, collect only part of them, delay supplier payments, or add a one-off in or out. The scenario runs beside the base, never over it.

Rules that keep it honest

The properties a finance lead checks first.

One currency at a time

Base currency by default. Pick another and you see the bank accounts held in it and the documents raised in it. Unlike currencies are never added together and never converted.

A scenario is a second view

Adjustments apply to a copy of the forecast’s items, so base and scenario are always the same documents seen two ways. No invoice or bill date changes.

The opening is the ledger

Today’s balance on the same cash and bank accounts the cash-flow statement treats as cash, so the forecast and the statements start from one number.

Estimates say so

A payroll month projected from the last regular run is marked as an estimate in the drill-down, apart from runs that exist.

Two permissions

Anyone who can view accounting reads the forecast. Saving scenarios and the threshold takes the separate manage-cash-forecast permission.

Out as CSV, in the app

Export the weeks as CSV for the board pack. The same forecast and saved scenarios are served to the mobile app over the API.

Cash forecast — what ships today, and what we can add

What AWRA OpsHub does today

  • A rolling 13-week forecast opening on today’s cash and bank ledger balances, week 1 starting this Monday.
  • Inflows from open customer invoices, invoices recurring schedules will raise, and recurring journals into cash.
  • Outflows from supplier bills, unbilled issued purchase orders, payroll and its statutory deductions, unpaid approved expenses, VAT and withholding owed, and recurring journals out of cash.
  • Customer payment history, optionally moving each expected receipt by that customer’s average days late over the last year.
  • A low-cash threshold and the first week each forecast falls below it.
  • Saved scenarios: move receipts, collect a share of them, delay supplier payments, one-off inflows and outflows, shown beside the base.
  • Drill-down from every figure to the documents behind it, a CSV export, and the forecast in the mobile app.

More we can add to your workspace

  • Forecast against actual: each week, once it has passed, set beside what the bank actually did. Commission it
  • An email or push alert when the forecast first dips below your threshold. Commission it
  • Planned items from a schedule, such as loan repayments, capital purchases and dividends, entered once and repeated. Commission it
  • A daily view of the first two weeks for a tight month. Commission it
  • A consolidated view across currencies at a rate you choose and record. Commission it
  • A longer horizon, such as six or twelve months by month. Commission it

Where we point you to a specialist

  • We will not add one currency to another. A forecast is in one currency, and a conversion you did not choose would hide the risk you are looking for.
  • We will not change a document to fit a scenario. A scenario is a view; the invoice and the bill keep their dates.
  • We will not present the forecast as a promise. It is your own documents, dated as written, and it moves when they do.

Forecast against actual and the low-cash alert are the two items most finance teams ask for first. Tell us how you review cash each week and we will come back with a written spec, a timeline and a price.

Frequently asked questions

Where do the forecast figures come from?
From documents already in your workspace. The opening position is today’s ledger balance on your cash and bank accounts. Money in is open customer invoices, the invoices your recurring schedules will raise and recurring journals into cash. Money out is supplier bills, issued purchase orders not yet billed, payroll and its statutory deductions, unpaid approved expenses, VAT and withholding owed per the ledger, and recurring journals out of cash.
What happens to an overdue invoice or bill?
It lands in week 1. It is still owed, and the earliest it can move is now. A document expected after week 13 is left out.
Can it allow for customers who pay late?
Yes. Switch payment history on and each customer’s expected receipt moves by their average days late over the last year.
What can a scenario change?
It can move receipts by a number of days, collect only a percentage of them, delay supplier payments by a number of days, and add one-off inflows or outflows. The scenario is shown beside the base forecast and changes no document.
We trade in more than one currency. How is that shown?
One currency at a time, your base currency by default. Choosing another shows the bank accounts held in that currency and the documents raised in it. Currencies are never added together or converted.
Who can see and change the forecast?
Anyone with the view-accounting permission can read it and export it. Saving scenarios and the low-cash threshold needs the manage-cash-forecast permission.

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center