A diligence review of working capital trends means examining how cash moves through a business over time, not just what a balance sheet shows on one day. The criterion that separates a useful review from a superficial one is whether you are comparing current patterns to a realistic baseline. Start with what you know: the company's normal payment cycles, seasonal swings it has already experienced, and the financing arrangements already in place. A review that ignores these anchors tells you less than one that tests the numbers against them.

What makes a working capital review different from a standard financial check?

A standard financial review answers the question "where does the business stand right now?" A diligence review of working capital trends answers "how is the business actually performing relative to itself over time?" That distinction shapes everything about how you approach the numbers. A company can show healthy current ratios on a single date and still have deteriorating payment habits that will catch up with it. Conversely, a business with tight current ratios may be running efficiently if those ratios are stable and match the industry pattern.

The working capital metrics that matter most in a diligence context are the ones that move. Accounts receivable days, inventory turnover, and payable days are not fixed numbers. They shift with customer behavior, supplier relationships, and operational decisions. A review that flags those shifts and traces them back to causes is doing the work. One that simply records the latest values is not.

You start with what you know by identifying the business cycle first. Is revenue concentrated in certain months? Do major customers pay on specific schedules? Are there contractual payment terms that create predictable swings? These factors give you a baseline that makes the numbers meaningful. Without that baseline, a high receivables balance might look alarming when it simply reflects end-of-quarter invoicing.

The question to ask at this stage is whether you have enough information to build that baseline. If the business has been operating for at least a year, you have prior periods to compare. If it is newer, you work from industry benchmarks and the patterns that emerge from the first few months of data. The key is to resist treating any single period as representative until you have tested it against the cycle.

When you review a business that sells project-based cfo Services, for instance, you expect receivables to spike when a large project is completed and billed. That spike is not a collection problem; it is the normal billing cycle. The same dollar amount sitting in receivables for a business with consistent monthly revenue would tell a different story. Context turns the numbers into information.

Why do trends matter more than point-in-time snapshots?

Working capital is dynamic by nature. A single snapshot tells you the position at one moment, but it does not tell you whether that position is normal, improving, or declining. Trends reveal the direction. A business with rising receivable days over three consecutive quarters is sending a signal that deserves investigation, even if the most recent balance still looks acceptable.

Trend analysis also helps you separate noise from signal. Month-to-month fluctuations in working capital accounts are normal. Quarter-to-quarter patterns are more reliable. Year-over-year comparisons are the most useful for a diligence review because they smooth out seasonality and give you a fair comparison. When you see a consistent direction across those comparisons, you have something worth acting on.

Consider a simple example. Suppose a business reports accounts receivable of $200,000 in January and $210,000 in February. Those numbers alone tell you little. If the trend shows that January receivables were $200,000 while February revenue was 20 percent higher, that is a positive sign. If February receivables rose by the same dollar amount despite flat revenue, that is a different signal. The trend in relation to the business activity is what matters.

The practical step here is to calculate receivables as a percentage of monthly revenue for each period you are reviewing. Do the same for payables relative to monthly purchases. Plot those percentages over time. You are looking for consistency, direction, and any sudden shifts that do not match the business cycle.

When you plot the percentages rather than the absolute amounts, you control for growth. A business that doubles its revenue and doubles its receivables may be running exactly the same operation at scale. A business that doubles its revenue while receivables triple is showing a change in collection efficiency that warrants attention. The ratio tells you what the raw number cannot.

What metrics should I focus on first during a diligence review?

The metrics worth focusing on are the ones that directly affect cash availability. Days sales outstanding tells you how long it takes to collect what the business has billed. Days payable outstanding tells you how long the business takes to pay its suppliers. Inventory days tells you how long capital sits in unsold goods. The gap between DSO and DPO is the operating cash conversion period. That gap is where most working capital problems hide.

Start with DSO because receivables are usually the largest and most volatile component of working capital for most businesses. Calculate it by dividing accounts receivable by total credit sales in the period, then multiplying by the number of days. Do this for each period in your review window. The average matters less than the direction and the range. A business with DSO trending upward is either collecting less efficiently or holding receivables for reasons that deserve explanation.

DPO deserves equal attention. A business that consistently extends its payable days may be managing cash well, or it may be delaying payments that will eventually catch up and create supply chain problems. The difference matters for a diligence review. You want to know whether the extension is intentional and sustainable or a sign of financial stress.

Inventory days completes the picture. For a business with physical products, slow-moving inventory ties up cash that cannot be used for operations or debt service. For a service business, inventory is less relevant but still worth checking if there are any work-in-progress balances. The key is to match the metric to the business model rather than applying a standard formula.

Once you have calculated the three metrics, calculate the cash conversion cycle: DSO plus inventory days minus DPO. A conversion cycle of 45 days means the business is effectively financing 45 days of operations from its own working capital or credit facilities before cash comes in from customers. If that cycle is growing while revenue is flat, the business is consuming more cash to sustain the same sales volume. That is a pattern that changes the risk profile.

How do I identify unusual patterns in accounts receivable during a review?

Unusual patterns in receivables usually show up in one of three ways: a concentration of old balances, a mismatch between invoice dates and payment patterns, or a gap between revenue recognized and receivables recorded. Each of these patterns points to a different underlying cause, and a good diligence review traces them back rather than stopping at the surface number.

Start by aging the receivables. Group outstanding balances by how long they have been outstanding. If a large share of receivables is over 60 or 90 days past invoice date, that is a flag. Some of it may be legitimate, such as retainers held until project completion or milestone payments tied to client approvals. But a high concentration of old balances without a clear business reason is worth questioning.

The second check is whether the aging has been stable over time or worsening. A business that has always had a high percentage of receivables over 60 days because of client contract terms is different from one where that percentage has been rising over the past two quarters. Trend matters here as much as the absolute number.

The third check looks at the relationship between revenue and receivables. If revenue is growing but receivables are growing faster, something in the collection process is not keeping pace. If revenue is flat but receivables are rising, that is a more serious signal. In a diligence context, you want to understand whether the receivables balance is supported by actual invoices and whether those invoices are likely to be paid in the normal course.

Look also at customer concentration within receivables. If the top three customers represent 70 percent of outstanding receivables, the collection risk is concentrated. If one of those customers is experiencing financial difficulty, the impact on cash could be immediate and severe. A healthy business typically spreads its credit exposure across a broader base, though the appropriate level of concentration varies by industry and business model.

Another pattern to watch is receivables that swing dramatically from one period to the next. A business that reports $50,000 in receivables in one month and $400,000 in the next is either seasonality or channel stuffing. Channel stuffing means the business is pushing product to distributors or customers who have not yet sold through, artificially inflating current revenue at the cost of future returns and cash collections. A diligence review should flag this pattern and investigate the underlying sales agreements.

What should I watch in payables when reviewing working capital trends?

Payables tell you how the business manages its relationships with suppliers, and more importantly, how it manages its cash. A business that stretches payables too far risks losing supplier goodwill, triggering penalty clauses, or facing demands for faster payment that create cash crunches. A business that pays too quickly may be giving up working capital flexibility it could use elsewhere.

The first thing to check is whether the payable days are stable or shifting. A sudden increase in DPO might look like good cash management. It might also be a sign that the business is delaying payments to conserve cash. If that is the case, you would expect to see other signs of cash pressure, such as delayed payroll tax deposits, increased credit line usage, or overdue statements to key vendors. One metric alone never tells the full story.

The second check is whether the payable terms match what the business has negotiated. If the stated payment terms are Net 30 but the actual DPO is consistently above 45, either the terms are being ignored or there is an implicit arrangement with certain suppliers. A diligence review should identify which vendors are being paid late and whether those delays are deliberate or unintentional.

The third check looks at the composition of payables. Are there large balances owed to a small number of suppliers? That concentration creates vulnerability. If one major supplier shortens terms or demands faster payment, the impact on cash could be significant. Spreading payables across more vendors reduces that risk, all else being equal.

Watch also for payables that are aging in the same way as receivables. If a business carries significant payables over 60 or 90 days old while continuing to extend credit to its own customers, it is funding its customers at the expense of its suppliers. That pattern cannot continue indefinitely. Eventually suppliers restrict credit, demand cash in advance, or charge higher prices to compensate for late payment. The working capital review should identify how close the business is to that inflection point.

How do I evaluate inventory from a working capital diligence perspective?

Inventory evaluation in a diligence review is less about the accounting valuation and more about the cash implications. The question is not just whether inventory is correctly valued on the balance sheet, but whether the amount of capital tied up in inventory is appropriate for the business model and the sales volume it supports.

Calculate inventory days by dividing the inventory balance by cost of goods sold and multiplying by the number of days in the period. Do this for each period in your review. Compare the result to industry norms for similar businesses, and then compare it to the business's own historical trend. If inventory days have been rising while sales have been flat, that is a signal worth investigating.

Look at the composition of inventory as well. A business that holds large quantities of raw materials may be managing supply risk. A business with a high proportion of finished goods relative to its sales pace may be building inventory that will not convert to cash on schedule. If the products have a limited shelf life or are subject to obsolescence, slow-moving inventory carries additional risk beyond the working capital impact.

The practical question is whether inventory levels are consistent with the purchasing and production cycle. A business that holds a quarter of inventory from the prior season while ramping up new production is carrying extra cost. That cost shows up in the working capital position and in the cash flow statement. A diligence review should flag it rather than accepting the balance sheet number at face value.

Pay attention to write-downs and reserves. If the inventory balance has remained roughly flat while the business has taken consistent write-downs for obsolete stock, the gross inventory number is overstating the real value. A business with $500,000 in inventory and a $150,000 reserve is effectively carrying $350,000 in usable stock. The reserve may be appropriate, but it should be compared to historical levels and industry standards to determine whether it is sufficient.

How does the cash flow statement connect to a working capital diligence review?

The cash flow statement is where working capital changes become visible in actual cash terms. A business can show strong net income and still run out of cash if its working capital is growing faster than operations can support. The operating activities section of the cash flow statement shows the cash impact of changes in receivables, inventory, and payables. Those changes tell you whether working capital growth is consuming cash or releasing it.

A working capital review that ignores the cash flow statement is incomplete. When DSO is rising, you expect to see a use of cash in the receivables line on the cash flow statement. When DPO is extending, you expect to see a source of cash in the payables line. If those relationships do not hold, something in the accounting or the business story may not be aligning.

Consider a business that reports rising DSO but shows a positive cash flow from receivables on the cash flow statement. That is unusual and deserves investigation. Either collections improved dramatically in the final days of the period, the business collected receivables that were not on the balance sheet, or there is an error in how the numbers were recorded. A diligence review should trace the discrepancy rather than accept the apparent contradiction at face value.

The cash flow statement also reveals financing decisions embedded in working capital. If payables are rising faster than the business can explain from normal operations, you may see draws on the credit line appearing as a financing activity. That draw tells you the business is using borrowed money to fund payables rather than generating sufficient cash from operations. That is a different risk profile than a business that extends payables while maintaining positive operating cash flow.

What cash conversion issues should signal concern during a diligence review?

The cash conversion cycle measures how long between paying for inputs and collecting from customers. A lengthening cycle is not automatically a problem, but it has consequences. The longer the cycle, the more working capital the business needs to fund operations. For a business with limited access to credit, a long conversion cycle can create a cash constraint that limits growth or creates vulnerability during slow periods.

The cycle extends when DSO increases, when inventory days increase, or when DPO decreases. Any combination of these changes pushes cash further out. A business that is growing rapidly may see its conversion cycle lengthen as it invests in receivables and inventory to support higher sales. That is not necessarily a problem if the growth is profitable and the business has the financing to support it. It becomes a problem when the growth is not funded by operations and the business is relying on credit lines that may not be available when needed.

Watch for a conversion cycle that is long relative to industry benchmarks and growing. That combination suggests the business is either in a structurally weak position or losing control of its working capital. Either way, a diligence review should flag it clearly so that the implications for financing needs and risk are understood before any commitment is made.

The question to ask is whether the conversion cycle is a result of deliberate strategy or an unintended drift. Some businesses deliberately extend payables to improve cash position. Others accept longer receivable collection periods to support sales to customers who need more time. If the changes are intentional and supported by the business model, they deserve different treatment than the same numbers arising from poor execution.

A conversion cycle that is deliberately extended to support growth is different from one that extends because the business cannot collect efficiently. The first is a financing decision. The second is an operational problem that will get worse without intervention. The diligence review should distinguish between them by asking whether the working capital decisions are generating returns that justify the cash tied up.

What documentation should a working capital diligence review produce?

A working capital diligence review should produce three types of output: a data summary, a trend analysis, and a findings report. The data summary presents the raw calculations for DSO, DPO, inventory days, and the cash conversion cycle across all periods reviewed. This is the factual foundation that others can verify independently.

The trend analysis interprets those numbers in context. It identifies which metrics are stable, which are improving, and which are deteriorating. It traces the drivers of significant changes back to their underlying causes. This is where the review adds value beyond the spreadsheet: it connects the numbers to business events, cfo services strategic decisions, and operational patterns.

The findings report presents the key observations in a form that supports decision-making. It states which working capital trends represent normal business patterns, which represent risks that need monitoring, and which represent problems that require immediate attention. Each finding should cite the supporting data and explain the implication for cash position and financing needs.

The format of the findings should be clear enough that someone who did not do the review can understand what was found and why. A table summarizing the key metrics across periods, with color coding or annotations for items that warrant attention, often communicates the findings more effectively than narrative text alone. The goal is to enable a decision, not to demonstrate analytical depth.

What should I ask and confirm with a professional before making a decision based on this review?

A diligence review of working capital trends identifies patterns and flags signals. Interpreting those signals in the context of a specific transaction or financing decision requires judgment that goes beyond the numbers. Before you rely on the findings to make a decision, confirm a few things with an advisor who knows the business and the context.

First, confirm that the accounting policies underlying the working capital balances are consistent with what is being assumed. If revenue is recognized early or payables are recorded differently than your calculations assume, the metrics will be misleading. Ask to see the policies and check whether they have changed during the period you are reviewing. A change in revenue recognition policy, for instance, can make DSO appear to improve when the underlying collection performance has not changed.

Second, confirm that the seasonality in the business has been properly accounted for. A business with strong fourth-quarter revenue will show different working capital positions depending on when the snapshot is taken. Year-end comparisons are more reliable, but if the business is growing rapidly, even year-over-year comparisons may need adjustment for the growth rate between periods.

Third, confirm that the financing arrangements in place are consistent with the working capital needs you have identified. A business with a long cash conversion cycle needs either a reliable credit facility or sufficient equity cushion. If the financing is dependent on continued bank relationships or investor support, the working capital review should be linked to an assessment of those arrangements. A business that looks adequately capitalized on average may be underfinanced at the peak of its cash conversion cycle.

The final confirmation is the most important one. Ask whether the working capital trends you have identified are consistent with the narrative the business is providing. If the management says collections have improved but your DSO calculations show otherwise, that discrepancy needs to be resolved before you proceed. A forecast is a working picture, not a promise. Update it when the assumptions change, and make sure the assumptions you are using are the ones the business actually operates under.