Ask AwraIQ about features, pricing, onboarding, login, integrations, security, demos, mobile apps, automation, reports, or support.
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.
- Opening · cash and bank today1,840,000
- Week 1 · in 620,000 · out 910,000Overdue invoices land here1,550,000
- Week 3 · payroll and VATStatutory deductions, VAT on the 20th880,000
- Week 4 · below thresholdThreshold 500,000390,000
Illustration of the screen’s shape. Figures are examples.
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.
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.
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.
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.
Where its numbers come from.
Frequently asked questions
Where do the forecast figures come from?
What happens to an overdue invoice or bill?
Can it allow for customers who pay late?
What can a scenario change?
We trade in more than one currency. How is that shown?
Who can see and change the forecast?
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.