Skip to main content

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.

Global module

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:

  1. Existing open items — invoices already outstanding at the start of the forecast
  2. Forecasted items — new invoices generated during the forecast period, with assumed payment delays

Creating the module

  1. In your Forecast, click Add a budget
  2. Choose Outstanding Items
  3. 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.

Choose a recent reference 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):

SettingWhat 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.
ProbabilityThe 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:

TypeBudget account
Receivables cash collectionsMaps to AR / debtors account
Payables cash paymentsMaps to AP / creditors account
Per analytical axisOptional — 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