Outstanding Items
The Outstanding Items module forecasts the cash flow timing of your accounts receivable (AR) and accounts payable (AP). It takes your open invoices at a reference date and models when they will be paid — then combines that with forecasted payment delay assumptions for future invoices.
Outstanding Items is a global module — it applies at the forecast level and is shared across all scenarios.
Why this matters
The gap between when an invoice is issued and when it's paid is one of the most common sources of cash flow surprise. This module makes that timing explicit in your forecast by combining:
- Existing open items — invoices already outstanding at the start of the forecast
- Forecasted items — new invoices generated during the forecast period, with assumed payment delays
Creating the module
- In your Forecast, click Add a budget
- Choose Outstanding Items
- Follow the setup wizard (6 steps)
Step 1 — Introduction
Select the reference date — the point in time from which the module reads your open receivables and payables. Monitr loads all outstanding invoices from your accounting integration as of that date.
Using the most recent closing date gives the most accurate starting position. If your last import was yesterday, use yesterday.
Step 2 — Open Receivables
Review and configure the open customer invoices (receivables) at the reference date.
For each open invoice group:
- Manual unwinding items: specific invoices where you know the exact payment date — enter it directly
- Automatic unwinding: apply a default collection timeline for invoices where you don't have specific payment dates
The automatic unwinding setting defines how the remaining open balance clears over time (e.g. 50% in 30 days, 30% in 60 days, 20% in 90 days).
Step 3 — Open Payables
Same configuration as Open Receivables, but for supplier invoices (payables):
- Manual unwinding for specific invoices with known payment dates
- Automatic unwinding timeline for the remaining balance
Step 4 — Forecasted Items
Configure payment delay assumptions for new invoices generated during the forecast period (those not yet outstanding at the reference date):
| Setting | What it controls |
|---|---|
| Days Sales Outstanding (DSO) | Average days from invoice date to customer payment. E.g. 45 days means revenue cash arrives ~45 days after invoice. |
| Days Payable Outstanding (DPO) | Average days from receiving a supplier invoice to payment. |
| Probability | The probability that a forecasted receivable is collected. Lower probability = more conservative cash forecast. |
You can set different DSO/DPO per budget account (e.g. B2B customers at 45 days, government clients at 60 days).
Step 5 — Mappings
Assign budget accounts for cash flows from outstanding items:
| Type | Budget account |
|---|---|
| Receivables cash collections | Maps to AR / debtors account |
| Payables cash payments | Maps to AP / creditors account |
| Per analytical axis | Optional — assign different accounts per business line or entity |
Step 6 — Result
Review the monthly cash flow forecast showing:
- Cash inflows from customer payment collections
- Cash outflows for supplier payments
- Net working capital impact per month
- Outstanding balance (AR/AP) at end of each period
How it combines with actuals
The Outstanding Items dashboard shows:
- Actuals: real open invoices imported from your accounting software
- Forecast: the module's projected cash collections and payments
Together these give you a 360° view of your working capital position.
Output in reports
- Balance Sheet → AR and AP balances (declining as items are collected/paid)
- Cash Flow → cash inflows from collections and outflows from payments, correctly timed by DSO/DPO