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 adds payment delay assumptions for future invoices generated during the forecast period.

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 by combining:

1. Existing open items — invoices already outstanding at a reference date, with configured collection/payment timelines
2. Forecasted items — new invoices generated during the forecast period, with assumed payment delays per budget account

Prerequisites

A Historic Outstanding Items integration must be set up before the wizard can be used for open receivables and payables. Forecasted items are always available without an integration. The integration imports a snapshot of your open AP/AR as of a chosen reference date from your accounting provider.

Supported providers: Exact, Moneybird, Twinfield, Yuki, Odoo.

Set it up under Integrations → Historic Outstanding Items.

Creating the module

1. In your Forecast, click Add a budget
2. Choose Outstanding Items
3. Follow the 6-step setup wizard

Step 1 — Introduction

An overview screen explaining the module. No configuration here.

Steps 2 & 3 — Open Receivables / Open Payables

Steps 2 and 3 are identical in structure — one for customer invoices (receivables), one for supplier invoices (payables).

Reference date

A dropdown at the top of both steps lets you choose the reference date — the snapshot point from which open items are loaded. The options are months ±6 around your entity's last actuals date.

note

The displayed date is one day after the selected month-end. This is intentional: items due on the reference date itself are treated as overdue in Monitr's calculation.

Enable toggle

A toggle at the top of each step enables or disables unwinding for that item type entirely. Disabling skips that item type from all cash flow calculations.

Automatic unwinding

Items not assigned to manual unwinding are processed automatically. They are split into two buckets:

• Pending — due date is after the reference date (not yet overdue)
• Overdue — due date is on or before the reference date

For each bucket, define a payment distribution table: how the total balance clears over time. Each row has a payment delay (months) and a weight (percentage). Weights across all rows in a bucket must add up to exactly 100% — saving is blocked otherwise.

Use the eye button to preview which invoices fall into each bucket (filterable by debtor/creditor name).

Manual unwinding

For invoices where you know the exact payment date, move them to the manual list. A two-panel editor shows automatic items on the left and manual items on the right — use the arrow buttons to move items between panels. Once on the manual side, assign a specific payment date to each item. Payment dates must be after your last actuals date.

UnwindGraph

A cash flow preview chart at the bottom of each step shows the projected collections or payments for the next 12 months based on your current configuration. It updates live as you make changes.

Step 4 — Forecasted Items

Configure payment delay assumptions for new invoices generated during the forecast period — invoices that don't exist yet at the reference date.

The step shows your full reporting structure (Reporting Line → Mapping → Budget Account). For each budget account, set:

• Item type — whether this account generates Receivable items (customer invoices), Payable items (supplier invoices), or neither
• Payment delay — the number of months after the invoice period before payment is expected (minimum 1 month)

Setting a value on a parent row cascades to all child rows beneath it.

Step 5 — Mappings

For each item type (Receivable and Payable), assign one Balance Sheet reporting line mapping. This mapping is shared across all three forecast sub-types.

Each sub-type — Manual, Automatic, and Forecast — also gets its own label/description for how the budget line appears in reports.

Step 6 — Result

Two charts — one for receivables, one for payables — showing the projected cash flow month by month. A scenario selector at the top lets you overlay budget data from a specific scenario.

Clicking any bar opens a detail panel with three tabs:

• Manual — specific invoices with assigned payment dates: relation name, invoice name, amount, due date, payment date
• Automatic — items processed by the distribution rules: relation name, due date, total amount, overdue status, payment delay, weight %, unwound amount, payment date
• Forecast — budget-account-level items from the forecast: budget version, budget type, budget account, amount, forecast period, delay, payment date

Click Finish to name and save the budget version.

The Outstanding Items dashboard

Tab	What it shows
Current Receivables	Open customer invoices: aging buckets, debtor breakdown, invoice detail table
Current Payables	Open supplier invoices: aging buckets, creditor breakdown, invoice detail table
Forecasted Receivables	Expected cash inflows, powered by this module
Forecasted Payables	Expected cash outflows, powered by this module

The detail table on Current tabs shows: invoice code, due date, relation name, original amount, amount outstanding, and days overdue. Items can be filtered by aging bucket (clicking the chart) or by debtor/creditor name.

Output in reports

• Balance Sheet — AR and AP balances declining as items are collected and paid on the mappings set in Step 5
• Cash Flow — cash inflows from collections and outflows from payments, timed correctly by your configured delays