Commercial and Working Capital
Commercial and Working Capital focuses on the quality of revenue rather than revenue volume alone. It asks whether customer mix, pricing discipline, credits, collections, and supplier obligations are helping the business convert sales activity into healthy cash outcomes.
Commercial decisions shape more than the top line. Discounting, refunds, delayed collections, unapplied cash, and uneven supplier-payment timing can all weaken the company even when reported sales look strong.
The reader should approach this perspective as a bridge between sales behavior and liquidity. The sequence is designed to show how customer-level and supplier-level patterns move through pricing, settlement, receivables, payables, and ultimately cash conversion.
How to Approach This Perspective
- Start by understanding revenue quality before jumping into receivables and payables aging.
- Compare customer-side and supplier-side timing to see how working-capital pressure builds on both sides of the business.
- Treat pricing, credits, and unapplied cash as indicators of process quality, not just isolated exceptions.
- Use summary reports first, then move into detail only where balances or timing patterns remain unclear.
Core Questions
- Which customers, regions, or segments appear most commercially important?
- Where do pricing pressure, returns, credits, or unapplied cash change the quality of reported revenue?
- Which working-capital signals suggest collection or supplier-payment pressure?
- How does commercial activity translate into settlement timing and cash conversion?
Recommended Report Sequence
- Monthly Revenue and Gross Marginanchor
- Design Service Revenue and Billed Hoursdrill-down
- Sales Commission Expense by Rep and Segmentdrill-down
- Budget vs Actual Revenue Price Volume Cost Bridgedrill-down
- Customer Sales Mix by Region and Item Groupanchor
- Price Realization vs List by Customer and Portfoliodrill-down
- Customer Credit and Refundsdrill-down
- Customer Deposits and Unapplied Cash Agingdrill-down
- Sales Commission Payable Rollforwarddrill-down
- Monthly AR Aging Summaryanchor
- Monthly AR Aging Detaildrill-down
- Monthly AP Aging Summarydrill-down
- Monthly AP Aging Detaildrill-down
- Supplier Purchasing Activity by Categorydrill-down
- Cash Conversion Timing Reviewanchor
Report Blocks
Monthly Revenue and Gross Margin
Compare invoiced revenue, gross margin, discounts, and returns across fiscal periods.
Start with the monthly revenue bridge to establish the high-level commercial result before moving into customer, pricing, and settlement detail.
Discussion Questions
- Which periods show strong revenue but weaker-than-expected margin quality?
- Do discounts and returns appear concentrated or broadly spread?
- What commercial questions does this summary leave unanswered?
Suggested Analysis
- Compare revenue, gross margin, discount, and return behavior across months.
- Identify months that warrant a customer-level or pricing-level drill-down.
- Use the report to frame the rest of the commercial pack.
Design Service Revenue and Billed Hours
Review billed design-service hours and posted service revenue by customer and invoice month.
Use the service billing view to separate the hourly design-services line from the goods business and see how customer-month revenue converts from approved hours.
Discussion Questions
- Which customers generate the most billed design-service hours each month?
- Does the service revenue mix stay concentrated in a small number of customers?
- Where does realized hourly revenue look strongest or weakest?
Suggested Analysis
- Compare billed hours, invoice count, and service revenue by customer-month.
- Look for months where service hours rise without a proportional revenue change.
- Use the result to decide whether the next drill-down should be customer mix, engagement staffing, or collections timing.
Sales Commission Expense by Rep and Segment
Review gross commission expense, clawbacks, and net commission expense by sales rep, revenue type, customer segment, and month.
The commission expense view connects billed revenue to selling-cost behavior by rep, revenue type, and customer segment.
Discussion Questions
- Which reps or segments drive the largest commission expense?
- Does commission cost follow merchandise and design-service revenue mix?
- Where do credit-memo clawbacks materially change the original expense?
Suggested Analysis
- Compare gross commission expense with clawbacks and net commission expense.
- Split the result by revenue type and customer segment before ranking reps.
- Use the result beside revenue, returns, and price-realization reports.
Budget vs Actual Revenue Price Volume Cost Bridge
Compare budgeted and actual quantity, net revenue, price realization, and standard-cost consumption by collection and style family.
The revenue price-volume-cost bridge shows whether plan variance comes from demand, realized selling price, or standard-cost consumption by portfolio slice.
Discussion Questions
- Which collections or style families miss plan because of volume versus price?
- Where does cost variance offset or amplify the revenue variance?
- Which portfolio groups deserve commercial or sourcing follow-up first?
Suggested Analysis
- Compare budget and actual quantity, revenue, and COGS by collection and style family.
- Separate price variance from volume variance before jumping into customer detail.
- Use the bridge to decide whether the next step is pricing, mix, or cost review.
Customer Sales Mix by Region and Item Group
Review billed sales mix by customer geography, segment, and item group.
The customer sales mix report shows where revenue is concentrated by geography, customer type, and product family.
Discussion Questions
- Which regions and customer segments drive the largest share of billed sales?
- Does the product mix differ materially by customer segment?
- Where might revenue concentration create commercial risk?
Suggested Analysis
- Rank customer-region combinations by revenue and billed quantity.
- Compare item-group mix across segments and geographies.
- Look for evidence of dependence on a narrow customer or product slice.
Price Realization vs List by Customer and Portfolio
Compare realized billed pricing to base list price by customer, segment, region, collection, and style family.
Use price realization to separate headline revenue from realized commercial discipline and pricing leakage.
Discussion Questions
- Which customers or portfolio groups realize the lowest percentage of list price?
- Does price realization differ more by customer segment or by product portfolio?
- Where would management want to inspect promotions or overrides?
Suggested Analysis
- Compare base list revenue to net revenue by customer and portfolio group.
- Highlight low price-realization pockets that still carry high revenue.
- Use the report to decide whether discounting looks strategic or uncontrolled.
Customer Credit and Refunds
Review customer credits created by credit memos and whether those balances have been refunded or remain open.
Use customer credit and refund activity to identify where post-sale corrections or overpayments turn into open customer-credit balances.
Discussion Questions
- Which credit memos create customer credit instead of simply reducing AR?
- Are credits being refunded quickly or left open?
- What might open customer credit suggest about sales quality or settlement control?
Suggested Analysis
- Compare credit memo amount, customer credit created, and refunded amount.
- Flag open customer-credit balances that remain unresolved.
- Relate credit behavior to returns, customer service, or pricing issues.
Customer Deposits and Unapplied Cash Aging
Review customer receipts, open unapplied balances, and how long cash remained unapplied before first use.
Use unapplied cash aging to show that cash received is not the same as receivables settled, which makes it a strong teaching bridge between sales and working capital.
Discussion Questions
- How much cash remains unapplied after receipt?
- Which receipts stayed open the longest before application?
- What control or process issues could create persistent unapplied cash?
Suggested Analysis
- Compare receipt amount, applied amount, and open unapplied balance.
- Focus on receipts with long delays before first application.
- Connect unapplied cash behavior to the working-capital story.
Sales Commission Payable Rollforward
Reconcile commission payable from invoice-line accruals through credit-memo clawbacks and sales-rep payments.
The commission payable rollforward shows how sales activity creates a separate O2C liability before monthly rep settlement clears it.
Discussion Questions
- Which months show the largest commission payable buildup?
- Do credit-memo clawbacks materially offset the invoice-line accruals?
- How does monthly commission payment timing affect commercial cash conversion?
Suggested Analysis
- Compare accrual, clawback, payment, and ending-payable columns by month.
- Read the payable movement beside AR, unapplied cash, and cash-flow reports.
- Use the result to separate sales-cost accrual timing from payroll timing.
Monthly AR Aging Summary
Summarize month-end receivables exposure by customer, region, and segment.
The AR summary shows whether billed revenue is translating into timely collections at the customer level.
Discussion Questions
- Which customer groups hold the most open and past-due receivables?
- Does the aging mix suggest stable collections or growing stress?
- Where would management need invoice-level detail next?
Suggested Analysis
- Compare current and past-due balances by customer segment over time.
- Focus on customers with persistent balances in older buckets.
- Use the summary to target a detailed AR review.
Monthly AR Aging Detail
Track open customer invoices at each month-end with due-day aging based on the last day of the month.
The invoice-level AR detail shows the exact documents driving the summary aging pattern.
Discussion Questions
- Which invoices remain open across multiple month-ends?
- Where do due-date timing and settlement behavior diverge most sharply?
- Which customers appear to have the oldest invoice-level pressure?
Suggested Analysis
- Trace recurring invoice numbers across month-end snapshots.
- Isolate invoices that move slowly through the aging buckets.
- Compare cash applied and credit memo applied against the remaining open balance.
Monthly AP Aging Summary
Summarize month-end payables exposure by supplier, category, and risk rating.
The AP summary compares commercial growth and collections against the company's cash obligations to suppliers.
Discussion Questions
- Which supplier groups carry the largest open balances?
- Does AP aging suggest deliberate working-capital management or payment strain?
- How should AP behavior be interpreted alongside AR?
Suggested Analysis
- Compare AP aging concentration by supplier and category.
- Contrast payables behavior with receivables behavior across month-ends.
- Use the summary to frame supplier-level follow-up questions.
Monthly AP Aging Detail
Track open supplier invoices at each month-end with due-day aging based on the last day of the month.
The invoice-level AP detail shows which supplier documents are driving the month-end obligation profile.
Discussion Questions
- Which supplier invoices remain open across multiple month-ends?
- Where do payment timing and due-date timing diverge most clearly?
- Which supplier relationships would management watch most closely?
Suggested Analysis
- Trace recurring invoice numbers across month-end snapshots.
- Compare open balances to supplier category and risk rating.
- Identify invoices that stay unresolved long after their due date.
Supplier Purchasing Activity by Category
Review purchasing commitments by supplier, category, risk rating, and item group.
Use supplier purchasing activity to connect the payables story back to sourcing volume, supplier mix, and category exposure.
Discussion Questions
- Which supplier categories dominate committed purchasing volume?
- Does supplier spend appear diversified or concentrated?
- How might purchasing mix influence AP and inventory risk?
Suggested Analysis
- Compare ordered value by supplier, category, and item group.
- Note high-value suppliers that also carry large AP exposure.
- Use the result to set up supplier-risk discussion.
Cash Conversion Timing Review
Compare invoice-to-settlement and receipt-to-payment timing across sales, purchasing, and goods receipts.
The timing review links commercial activity and procurement activity to the actual pace of settlement.
Discussion Questions
- Which document family takes the longest to reach first settlement?
- Are settlement delays concentrated in AR, AP, or goods-receipt timing?
- What does this imply about operational cash conversion?
Suggested Analysis
- Compare average days to first settlement across the three metric families.
- Identify months with elevated open-document counts.
- Use the timing view to explain changes in working capital and cash flow.