working capital and FCF: How to Run a working capital analysis to Identify Cash Traps

🧭 Overview / What This Guide Covers

working capital and FCF can look “fine” in management reports while cash is quietly trapped in inventory, overdue invoices, or unfavorable payment timing. This guide shows you how to run a practical working capital analysis to surface operational cash traps and translate them into an actionable plan that improves FCF conversion and liquidity. It’s built for CFOs, FP&A, finance ops, and operators who need repeatable diagnostics (not one-off spreadsheet investigations). You’ll learn what to measure, how to pinpoint root causes, and how to operationalise fixes-building on the broader framework in the pillar guide.

✅ Before You Begin

To run a credible working capital analysis, you need a consistent definition set, clean data, and agreement on what “good” looks like. Start by confirming which period you’ll analyse (monthly vs weekly), and align on whether your focus is quarter-end reporting, cash runway, or improving cash flow optimisation outcomes. Pull the minimum dataset: revenue by customer, invoice issue/due/paid dates, AR ageing, AP ageing, supplier terms, inventory on hand by SKU/category, COGS, purchase orders, and operational volume drivers (units shipped, projects delivered, usage).

You also need access and permissions: finance system exports, sales ops/CRM for billing realities, and operations/warehouse inputs for stock accuracy. Decide upfront how you’ll segment findings (top 20 customers, product lines, regions), because segmentation is where cash flow working capital traps become visible. Finally, standardise your baseline calculation logic so the team can reproduce it-especially the bridge between profit and cash, which underpins working capital management and FCF performance and operations reviews. If you need a consistent starting point for conversion maths,use the same formula logic described in the free cash flow conversion walkthrough.

🛠️ Step-by-Step Instructions

Define or prepare the essential foundation.

Define the scope of your working capital and FCF review: which entities, which currency, and which operating cycle you’re analysing (order-to-cash, procure-to-pay, or build-to-sell). Then map the working-capital accounts to operational reality: which AR balances are “real” collectable invoices vs disputes, which inventory is active vs obsolete, and which AP is trade payables vs accrual noise. Build a simple driver map: what creates invoices, what triggers collections, what drives purchasing, and what determines reorder points.

This is also the moment to set governance: who owns AR actions, who owns stock discipline, and who can approve supplier term changes. To reduce manual rework, consider capturing these drivers in a structured model so you can update assumptions without rebuilding spreadsheets-Model Reef’s driver based modelling workflow is designed for exactly this kind of operational-to-cash translation. Your output is a documented foundation you can reuse every month.

Begin executing the core part of the process.

Calculate your baseline cash flow efficiency metrics and establish a “normal” range. At minimum, compute DSO (days sales outstanding), DIO (days inventory outstanding), DPO (days payable outstanding), and cash conversion cycle. Then bridge to outcomes: how changes in AR, inventory, and AP moved cash compared to operating profit. This is where FCF conversion and liquidity starts to become measurable, not anecdotal.

Don’t stop at company-wide averages-run the metrics by segment (customer tier, SKU family, region, channel). A healthy average can hide a damaging tail (e.g., a few slow-paying customers dominating receivables and free cash flow drag). For inventory, separate “needs to be held” stock from “optional” stock so your inventory impact on cash flow is grounded in service levels and lead times. If you want deeper inventory-specific diagnostics, connect this step to the inventory deep-dive guide.

Advance to the next stage of the workflow.

Identify the cash traps by tracing timing, not just balances. Start with AR: compare invoice terms vs actual payment behaviour, and create a simple waterfall-what portion is current, what’s overdue, and what’s disputed or unbillable. Then look for process causes: late invoicing, missing PO details, approval bottlenecks, unclear acceptance criteria, or poor dunning cadence. The goal is to pinpoint which operational step is creating cash flow working capital drag.

Next, quantify the cash opportunity: “If we moved the top 10 delinquent accounts back to terms, what happens to cash in the next 4-8 weeks?” This turns working capital management into a prioritised action list. Keep your analysis practical: focus on repeatable drivers, not one-off anomalies. If you need a focused framework for converting revenue into cash and avoiding collection delays,use the receivables guide as a companion reference.

Complete a detailed or sensitive portion of the task.

Move to payables and purchasing discipline carefully-this is where well-intended actions can damage supplier relationships. Start by documenting true payment terms by supplier (not what the contract says, but what actually happens). Then identify “early pay” behaviour: invoices paid before due date due to batch runs, missing approvals, or teams paying to avoid escalations. This is a direct payables effect on cash flow lever, and it often delivers faster impact than complex operational programs.

Validate your conclusions with procurement and ops: if you extend terms, will it cause supply disruption or price increases? If you centralise approvals, will it delay critical purchases? Treat this step as risk-managed optimisation: improve timing without breaking the supply chain. When done well, payables improvements strengthen FCF conversion and liquidity while keeping operations stable. For a deeper breakdown of supplier-term tactics and safeguards,use the payables playbook.

Finalise, confirm, or deploy the output.

Turn findings into a cash-optimisation backlog with owners, timelines, and measurable targets. Your “deliverable” isn’t a report-it’s a set of operational changes that improve cash flow optimisation and sustain better FCF performance and operations outcomes. For each initiative, define: the metric (e.g., DSO down 5 days), the operational change (e.g., invoice within 24 hours of delivery), the control (e.g., weekly AR review), and the expected cash impact range.

Then stress-test your plan under realistic scenarios: what happens if sales spike, lead times extend, or customers pay slower? Scenario planning helps you avoid “optimisation” that collapses under pressure. If you want to operationalise scenario testing without rebuilding models each cycle, use a scenario analysis workflow to run best/base/worst cases and share outputs with stakeholders. Final checkpoint: confirm your metrics update cadence and lock in a monthly review rhythm.

⚠️ Tips, Edge Cases & Gotchas

The most common mistake is treating working capital as a finance-only problem. Cash traps usually sit in operational workflows: delayed billing, inconsistent delivery acceptance, unmanaged reorders, or uncontrolled vendor purchasing. A second pitfall is optimising one lever while breaking another (e.g., cutting inventory so aggressively you miss shipments, which then slows collections and worsens receivables and free cash flow).

Watch for seasonality and growth effects. During growth, cash flow working capital often deteriorates even when margins improve, because you’re funding receivables and inventory before cash arrives. Also isolate one-time noise: a single large prepaid contract, a supplier settlement, or an inventory write-off can distort trends.

Be careful with “DSO improvements” that are really just factoring or aggressive credit holds-those can improve near-term FCF conversion and liquidity while damaging customer relationships. Finally, don’t rely on end-of-month snapshots; use rolling weekly views to spot traps early. If you want a structured set of interventions across AR/AP/inventory and governance, align your actions to a working-capital strategy framework.

🧪 Example / Quick Illustration

A distributor has steady revenue and improving EBITDA, but cash is tightening. Finance runs a working capital analysis and finds: DSO is stable overall, but two large customers have drifted from net-30 to net-65 due to invoice disputes; inventory has grown 18% because reorder points weren’t updated after a product mix shift; AP is being paid 10 days early because invoices are approved in weekly batches.

Action: they implement an “invoice-ready” checklist at shipment to reduce disputes, adjust reorder points for slow-moving SKUs, and change AP runs to pay closer to due date. Output: within eight weeks, overdue AR declines, inventory stops growing, and cash stabilises-improving working capital and FCF without cutting growth. The team also links invoice timing to expected collections so weekly cash predictions improve (this is especially effective when you model invoice and bill timing explicitly).

❓ FAQs

The fastest way to improve FCF conversion and liquidity is usually to fix timing problems in AR and AP before you attempt big operational redesigns. Start by identifying late invoicing, disputed invoices, early payments, and inconsistent approval workflows. These issues often unlock cash in weeks, not quarters, because they change when money moves rather than what the business sells. Once timing is under control, move to structural initiatives like reorder optimisation and credit policy updates. If you take a staged approach, you’ll see progress quickly while building a foundation for longer-term working capital management gains.

Yes- cash flow efficiency metrics like DSO/DIO/DPO can be misleading if you only review company-wide averages. Averages hide the “tails” that cause most cash pain: a handful of customers paying late, a few SKUs tying up capital, or specific suppliers being paid early. Segment your analysis by customer, product family, region, and contract type. That’s how you uncover the real cash flow working capital traps and prioritise the fixes with the highest impact. If you keep the segmentation consistent month to month, your working capital and FCF insights become trendable and operationally actionable.

Inventory is often the largest and least visible cash trap because it feels like an operational requirement, not a finance variable. The key is separating “service-level inventory” from “excess inventory” and then quantifying the inventory impact on cash flow for each segment. Look for slow movers, obsolete stock, and safety stock that no longer matches lead times or demand variability. Then tie stock decisions to cash outcomes so operations can see the trade-off between availability and liquidity. When you do this well, you improve FCF performance and operations without creating fulfilment risk.

You can run this process in spreadsheets, but it gets fragile when you need recurring updates, scenarios, and stakeholder alignment. A structured modelling approach helps you keep logic consistent while changing assumptions quickly-especially if you’re connecting operational drivers to working capital and FCF outcomes. If you want to operationalise the workflow, use a platform that supports driver-based inputs, scenario comparisons, and shareable outputs so finance and ops work from the same numbers. Model Reef’s product tooling is designed for building and maintaining these operational cash models without constant spreadsheet rebuilds.

🚀 ➡️ Next Steps

If you’ve identified cash traps, the next step is turning them into a managed cadence: weekly cash/working-capital review, monthly metric resets, and a clear owner for each lever. Start with the highest-confidence timing fixes, then expand into structural process improvements that sustain better cash flow optimisation over time. Keep your actions measurable, and treat every change as a driver you can monitor-so improvements to financial health and working capital are visible to leadership and operational teams.