Cash problems usually show up first in receivables and the forecast. These guides cover credit control processes and policies, DSO and ageing, bad debt provisions, payment reminders, working capital and rolling cash flow forecasts tested against buffers and covenants.
How to calculate days sales outstanding, a worked example, the common mistakes that distort it, and practical ways to collect cash faster without hurting sales.
How to calculate days payable outstanding, what a rising or falling DPO tells you, and how to manage supplier payment timing without damaging relationships.
A controlled process for writing off bad debts: when a debt is uncollectable, who approves it, how to post it against the provision and what to keep on file.
Build an aged debtors report in Excel from an open invoice list: days overdue, aging buckets, a pivot by customer and the checks that keep it accurate.
How to calculate working capital and the current and quick ratios, what they tell you, and practical ways to improve working capital safely.
Set customer credit limits with a simple, written method: what information to gather, how to size the limit, who approves it and how to review it over time.
A simple process for logging, owning and resolving disputed customer invoices, with an Excel dispute log, target times and root-cause reporting.
Compare forecast cash flows with actuals week by week, measure forecast accuracy, find the lines that are always wrong and improve the next forecast.
The difference between direct (receipts and payments) and indirect (profit-based) cash flow forecasting, when each works best and how to use both together.
A B2B collections call script: preparation, opening, confirming the debt, handling common responses, agreeing a date and following up.
Design a B2B dunning process: reminder stages before and after the due date, owners, escalation steps and how to measure results.
What a customer credit application form should ask for, how to check the answers, and how to turn the form into a credit limit decision you can defend.
Build a 12-month cash flow forecast for a small business in Excel: the rows, the formulas, realistic customer receipts and a monthly update routine.
How to add base, downside and upside scenarios to a cash flow forecast in Excel with a scenario switch, sensitivity tables and trigger points for action.
Physical and notional cash pooling explained, how pooling creates intercompany balances, the accounting entries and the controls a group needs to keep it clean.
How to calculate best-possible DSO, average days delinquent and the collection effectiveness index (CEI) in Excel, with a worked example.
The accounts receivable KPIs that matter, with Excel formulas: DSO, best-possible DSO, CEI, overdue %, dispute time, promises kept and bad debts.
Build a rolling 13-week cash flow forecast using the direct method: structure, data sources, a cash buffer line, the weekly roll and variance tracking.
A step-by-step credit control process with an example chase schedule, dispute handling, DSO measurement and the UK statutory late-payment rules.
Five overdue invoice reminder emails, from a friendly pre-due note to a final notice, with the timing for each and what to include so invoices get paid.
How to calculate a bad debt provision for trade receivables with a provision matrix under IFRS 9 or CECL, with a worked example and the steps to support it.
What a credit control policy should cover: credit checks, limits, payment terms, the collection timetable, account holds, disputes and write-off approval.
The cash conversion cycle formula (DIO + DSO - DPO), a worked example, and practical ways to shorten it so less cash is tied up in running the business.
How to set a minimum cash buffer: three methods, a worked example, and how to test a weekly cash forecast against it so a shortfall shows up early.
How to monitor loan covenants such as leverage, interest cover and minimum liquidity: calculate headroom, forecast it forward and act before a test date.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
The Cash Flow Forecasting & Liquidity Control System tests every week of a rolling cash forecast against your minimum cash buffer and lending covenants, and flags a breach before it lands. Excel, no macros, one-time price.
Accounts Payable · Payment Fraud · Month-End Close · Reconciliations · Fixed Assets · Expenses · Comparisons · Glossary
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.