Reports and Analytics

Interpret this report

Discussion questions

Which expense or margin lines appear to move most with revenue over time?
When net income changes sharply, which lines are most responsible?
What would management want to explain before presenting these results externally?

Suggested analysis

Compare gross margin, operating income, and net income by month.
Flag months where expense growth appears to outpace revenue growth.
Note whether profitability appears stable, seasonal, or unusually volatile.

Monthly Balance Sheet

Analyze monthly ending balances for assets, liabilities, equity, and current year earnings.

Row grain: One fiscal month and balance-sheet line.
Period basis: Cumulative ending balances by fiscal month; interim equity includes current-year earnings.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which balance-sheet sections seem to shift most across the modeled range?
Do asset changes appear to be financed by operations, liabilities, or equity?
Which balances would you inspect next if liquidity tightened?

Suggested analysis

Trace period-end movements in current assets against current liabilities.
Compare retained earnings and current-year earnings to the income statement trend.
Identify balance-sheet accounts that move independently from revenue.

Monthly Indirect Cash Flow

Reconcile net income to cash movement and review monthly operating, investing, and financing activity.

Row grain: One fiscal month and cash-flow statement line.
Period basis: Fiscal-month movement; opening journals establish beginning cash rather than operating cash flow.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which adjustments explain the largest differences between net income and operating cash flow?
Does operating cash flow move consistently with reported profitability?
When cash generation weakens, which bridge lines explain the gap?

Suggested analysis

Compare net income with net cash from operating activities.
Highlight working-capital adjustments that recur across multiple months.
Note whether investing or financing activity is overshadowing operating cash movement.

Pro Forma Monthly Income Statement

Review the driver-based monthly income statement budget built from forecast volume, planned pricing, standard cost, payroll, and recurring expense drivers.

Row grain: One budget fiscal month and income-statement line.
Period basis: BudgetLine fiscal year and month; planned activity, not posted results.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly budget horizon

Interpret this report

Discussion questions

Which planned months rely most on volume versus cost discipline to protect margin?
Where does the pro forma expense run-rate diverge most from the posted income statement?
Which income-statement assumptions would management challenge first?

Suggested analysis

Compare the pro forma run-rate to the posted income statement by month.
Identify planned margin or expense inflection points before they occur in actuals.
Use the output to frame follow-up on pricing, mix, or cost assumptions.

Pro Forma Monthly Balance Sheet

Review the driver-based monthly balance-sheet roll-forward for receivables, inventory, payables, accruals, fixed assets, equity, and cash.

Row grain: One budget fiscal month and balance-sheet line.
Period basis: Planned month-end balances with derived current-year earnings.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly budget horizon

Interpret this report

Discussion questions

Which projected balance-sheet accounts move most with the sales plan?
Does the model rely more on inventory, receivables, or payables to support growth?
Where would liquidity tighten first if assumptions slip?

Suggested analysis

Compare projected month-end balances to posted balance-sheet trends.
Focus on the working-capital accounts that move most sharply in the forecast horizon.
Use the output to connect planned growth to financial position.

Pro Forma Monthly Indirect Cash Flow

Reconcile the pro forma budget from net income to operating, investing, financing, and ending-cash movement.

Row grain: One budget fiscal month and cash-flow statement line.
Period basis: Budget-month movement; the first period starts from opening-journal balances.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly budget horizon

Interpret this report

Discussion questions

Which planning assumptions drive the largest gap between pro forma net income and cash?
Do projected investing needs materially change the liquidity story?
Which periods show the most pressure on ending cash?

Suggested analysis

Compare pro forma operating cash to the posted cash flow statement.
Trace the months where working-capital movement overwhelms earnings.
Use the forecasted cash line to identify the next liquidity drill-down.

Budget vs Actual Statement Bridge by Month

Compare key income statement, balance sheet, and cash lines between the pro forma budget and posted actual results.

Row grain: One fiscal month, statement, and bridged statement line.
Period basis: Budget horizon against posted fiscal months; future budget-only months show zero actuals.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which statement lines explain the biggest gaps between plan and actual?
Are the largest variances concentrated in performance, position, or cash?
Which bridge lines look like planning error versus execution drift?

Suggested analysis

Compare budget and actual on the key income statement, balance sheet, and cash lines.
Focus on months where multiple statement lines break in the same direction.
Use the bridge to decide whether the next drill-down is commercial, operational, or liquidity-focused.

Budget vs Actual by Cost Center

Compare budgeted and actual spend by cost center and account classification.

Row grain: One fiscal year, month, cost center, and budgeted operating-expense account.
Period basis: Budget month against posted expense month; actuals exclude year-end closing entries.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which cost centers appear most consistently over or under budget?
Do budget variances align with observed revenue or operating changes?
Which variances look structural rather than one-time?

Suggested analysis

Compare spending variance patterns by month and cost center.
Distinguish recurring unfavorable variances from isolated months.
Link cost-center variance to the profitability story from the income statement.

Working Capital Bridge by Month

Compare the month-end balances of the main working-capital buckets and track net working capital over time.

Row grain: One fiscal year and fiscal period.
Period basis: Running ledger ending balances by fiscal month, rather than monthly expense or cash flow.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which working-capital bucket contributes the most to month-to-month movement?
Do AR, inventory, AP, and deposits appear to move together or independently?
Which bucket would management monitor most closely?

Suggested analysis

Compare month-over-month changes in AR, inventory, AP, GRNI, deposits, and accruals.
Tie large movements back to the balance sheet and cash flow statement.
Use the bridge to define the next focused working-capital analysis.

Budget vs Actual Working Capital and Cash Bridge

Compare budgeted and actual balances for the main working-capital buckets plus ending cash across the planning horizon.

Row grain: One fiscal month and working-capital or cash metric.
Period basis: Budgeted and actual month-end balances; future budget-only months show zero actuals.
Process: Journals and Close
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

Discussion questions

Which projected receivable, inventory, payable, or cash balances differ most from actual?
Do liquidity variances come from collections, inventory policy, payment timing, or accrual cadence?
Which balance should management monitor most closely next month?

Suggested analysis

Compare planned and actual ending balances for the main working-capital buckets and cash.
Highlight months where cash variance follows directly from receivable or inventory variance.
Use the bridge to set up deeper collection, replenishment, or payment-timing analysis.

Cash Conversion Timing Review

Compare invoice-to-settlement and receipt-to-payment timing across sales, purchasing, and goods receipts.

Row grain: One source month and timing metric family.
Period basis: Invoice or goods-receipt month; elapsed days end at the first linked settlement in the file.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Monthly

Interpret this report

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.

Sales and Customers

Connect revenue and margins with pricing, customer mix, receivables, deposits, and commissions.

Connect the evidence: Order-to-Cash · Sales and customer tables · Customer settlement practice · Customer account case · Design Services

Monthly Revenue and Gross Margin

Compare invoiced revenue, gross margin, discounts, and returns across fiscal periods.

Row grain: One fiscal year and fiscal period.
Period basis: Posted SalesInvoice and Shipment activity grouped by ledger fiscal month.
Process: Order-to-Cash
Practice: Lesson 6: Find the Accounting Entries

Monthly

Choose a Product and Pricing Priority

Interpret this report

Discussion questions

Which periods show the strongest combination of revenue and margin?
Do returns and discounts appear to move with revenue or against it?
Where would management want a deeper portfolio or customer-level explanation?
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, discounts, and returns by period.
Flag months where margin behavior does not follow revenue behavior.
Use the result to decide whether a pricing, customer, or portfolio drill-down is needed.
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.

Sales and Margin by Collection and Style

Review sales volume, margin, and portfolio mix by collection, style family, and material.

Row grain: One item group, collection, style family, material, and lifecycle status.
Period basis: Whole-file billed sales less credited returns and their standard costs; no monthly cutoff.
Process: Order-to-Cash
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

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.

Row grain: One fiscal month, collection, and style family.
Period basis: Budget month against invoice-date month; actual cost uses current item standard cost for comparability.
Process: Order-to-Cash
Practice: Lesson 12: Turn Records into a Conclusion

Monthly

Interpret this report

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.

Price Realization vs List by Customer and Portfolio

Compare realized billed pricing to base list price by customer, segment, region, collection, and style family.

Row grain: One invoice month, region, segment, customer, collection, and style family.
Period basis: Invoice-date month; billed price is compared with line-level base list price.
Process: Order-to-Cash
Practice: Lesson 4: Follow a Goods Sale

Monthly

Choose a Product and Pricing Priority

Interpret this report

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 Sales Mix by Region and Item Group

Review billed sales mix by customer geography, segment, and item group.

Row grain: One invoice month, region, segment, item group, and item.
Period basis: Invoice-date month; billed sales timing rather than shipment timing.
Process: Order-to-Cash
Practice: Lesson 4: Follow a Goods Sale

Monthly

Interpret this report

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.

Design Service Revenue and Billed Hours

Review billed design-service hours and posted service revenue by customer and invoice month.

Row grain: One invoice month and customer grouping (name, region, segment).
Period basis: Invoice-date month; billed hours and invoice-line service revenue are aggregated before comparison.
Process: Design Services
Practice: Lesson 7: Follow Design Time into Billing

Monthly

Interpret this report

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.

AR Aging

Review open customer invoices by aging bucket and identify collection pressure.

Row grain: One open sales invoice.
Period basis: Latest invoice, application, or credit-memo date in the file; not today's date.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Current snapshot

Monthly AR Aging Summary

Summarize month-end receivables exposure by customer, region, and segment.

Row grain: One month-end and customer grouping (name, region, segment).
Period basis: Calendar month-end open receivables, with settlement and credits limited to that cutoff.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Monthly month-end

Interpret this report

Discussion questions

Which customer segments appear to hold the largest past-due balances?
Does the aging profile look stable or increasingly stressed over time?
Which customers would merit a detailed follow-up?
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 versus past-due balances by month-end.
Identify customers with persistent balances in older aging buckets.
Use the summary to decide where invoice-level review is needed.
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.

Row grain: One open sales invoice at each month-end.
Period basis: Calendar month-end; includes invoices, applications, and credits dated on or before the cutoff.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Monthly month-end

Interpret this report

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.

Customer Credit and Refunds

Review customer credits created by credit memos and whether those balances have been refunded or remain open.

Row grain: One credit memo that creates customer credit.
Period basis: Whole-file cash applications and refunds; the credit-memo date labels the row, not an as-of cutoff.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Current snapshot

Interpret this report

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.

Row grain: One cash receipt, including fully applied receipts.
Period basis: Age uses the latest receipt date; application totals use the whole file, not a historical cutoff.
Process: Order-to-Cash
Practice: Lesson 5: Follow Customer Settlement

Current snapshot

Interpret this report

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 Expense by Rep and Segment

Review gross commission expense, clawbacks, and net commission expense by sales rep, revenue type, customer segment, and month.

Row grain: One accrual month, sales rep, revenue type, and customer segment.
Period basis: Accrual-date month with all linked clawbacks attributed to the original accrual; not clawback-month activity.
Process: Order-to-Cash
Practice: Lesson 6: Find the Accounting Entries

Monthly

Interpret this report

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.

Sales Commission Payable Rollforward

Reconcile commission payable from invoice-line accruals through credit-memo clawbacks and sales-rep payments.

Row grain: One fiscal year and fiscal period.
Period basis: Posted accruals, clawbacks, and payments by fiscal month with a running payable balance.
Process: Order-to-Cash
Practice: Lesson 6: Find the Accounting Entries

Monthly

Interpret this report

Discussion questions

Which months build the largest sales-commission payable balance?
How much of the payable is reduced by credit-memo clawbacks before payment?
Does commission settlement timing explain part of the operating cash-flow bridge?
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 commission accrual credits with clawback and payment debits.
Read the ending payable beside the working-capital bridge and indirect cash flow.
Use the result to decide whether the liability is normal timing or a follow-up item.
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.

Purchasing and Inventory

Review supplier activity, receipt reliability, inventory coverage, and the timing of payables.

Connect the evidence: Procure-to-Pay · Purchasing tables · Receipt-to-payable practice · Supplier obligations case

Supplier Purchasing Activity by Category

Review purchasing commitments by supplier, category, risk rating, and item group.

Row grain: One order month, supplier grouping, and item group.
Period basis: Purchase-order date month; commitments, not receipt or invoice recognition.
Process: Procure-to-Pay
Practice: Lesson 8: Follow a Purchase

Monthly

Interpret this report

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.

Supplier Lead Time and Receipt Reliability

Review how quickly suppliers begin and complete receipts after purchase orders are issued.

Row grain: One order month and supplier grouping.
Period basis: Purchase-order date month; first and latest observed receipt dates use the whole file. Latest receipt need not mean fully received.
Process: Procure-to-Pay
Practice: Lesson 8: Follow a Purchase

Monthly

Interpret this report

Discussion questions

Which suppliers are slowest to first receipt or full receipt?
Where do partial receipts or no receipts appear most often?
How might unreliable receipts affect inventory and capacity pressure?

Suggested analysis

Compare average days to first and full receipt by supplier.
Focus on suppliers with repeated partial or missing receipt patterns.
Relate receipt reliability to inventory and planning risk.

Inventory Coverage and Projected Stockout Risk

Review the latest projected inventory coverage, net requirements, and stockout-risk signals by item and warehouse.

Row grain: One item and warehouse at the latest planning week.
Period basis: Latest supply-plan bucket; average weekly forecast spans 21 days before through 35 days after that bucket.
Process: Manufacturing
Practice: Lesson 9: Follow Manufacturing Costs

Current planning snapshot

Interpret this report

Discussion questions

Which items or warehouses show the most urgent stockout-risk signals?
Does low projected availability cluster by collection, style family, or warehouse?
How should management distinguish normal replenishment from true risk?

Suggested analysis

Compare weeks of coverage against risk labels.
Focus on expedite-priority items and negative projected availability.
Relate coverage problems to forecast and supplier behavior.

AP Aging

Review open supplier invoices by aging bucket and identify upcoming cash commitments.

Row grain: One open supplier invoice.
Period basis: Latest supplier-invoice or disbursement date in the file; not today's date.
Process: Procure-to-Pay
Practice: Lesson 8: Follow a Purchase

Current snapshot

Monthly AP Aging Summary

Summarize month-end payables exposure by supplier, category, and risk rating.

Row grain: One month-end and supplier grouping (name, category, risk rating).
Period basis: Calendar month-end open payables, with payments limited to that cutoff.
Process: Procure-to-Pay
Practice: Lesson 8: Follow a Purchase

Monthly month-end

Interpret this report

Discussion questions

Which supplier groups carry the largest open balances?
Does the aging profile suggest normal payment timing or growing strain?
How might AP behavior interact with cash flow and inventory availability?
Does AP aging suggest deliberate working-capital management or payment strain?
How should AP behavior be interpreted alongside AR?

Suggested analysis

Compare current versus past-due AP by month-end.
Highlight suppliers with large balances and high-risk ratings.
Relate AP aging changes to operating cash flow and working-capital movement.
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.

Row grain: One open supplier invoice at each month-end.
Period basis: Calendar month-end; invoices and payments are limited to that cutoff.
Process: Procure-to-Pay
Practice: Lesson 8: Follow a Purchase

Monthly month-end

Interpret this report

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.

Production and Planning

Compare forecasts, work-center utilization, and planned capacity before investigating operational pressure.

Connect the evidence: Manufacturing · Production tables · Manufacturing cost practice · Production cost case

Forecast Error and Bias by Collection and Style Family

Review where forecast quantities systematically overstate or understate actual order demand by portfolio group.

Row grain: One collection and style family.
Period basis: Whole-file forecast quantities compared with whole-file order quantities; no aligned weekly or monthly cutoff.
Process: Manufacturing
Practice: Lesson 9: Follow Manufacturing Costs

Current cumulative view

Interpret this report

Discussion questions

Which collections or style families appear most over-forecasted or under-forecasted?
Does forecast bias seem concentrated in a small part of the portfolio?
How could forecast bias feed directly into stockout or capacity risk?

Suggested analysis

Compare forecast quantity, actual order quantity, bias, and absolute error.
Focus on portfolio groups with the largest absolute error.
Relate forecast misses to coverage or expedite pressure.

Monthly Work Center Utilization

Compare scheduled and available hours to evaluate manufacturing capacity usage by month.

Row grain: One calendar month and work center.
Period basis: Calendar-date month; operations aggregate to center/day before joining daily available capacity.
Process: Manufacturing
Practice: Lesson 9: Follow Manufacturing Costs

Monthly

Interpret this report

Discussion questions

Which months show the highest capacity pressure?
Does utilization look stable, seasonal, or consistently tight?
Which work centers would you want to investigate next?

Suggested analysis

Compare utilization trends by month and work center.
Highlight periods that appear persistently near capacity.
Use the result to frame the need for capacity planning detail.

Rough-Cut Capacity Load vs Available Hours

Compare planned rough-cut load to available hours by work center and week.

Row grain: One work center and weekly planning bucket.
Period basis: Bucket start and end dates; sums planned load and uses one available-hours value per center/week.
Process: Manufacturing
Practice: Lesson 9: Follow Manufacturing Costs

Weekly planning bucket

Interpret this report

Discussion questions

Which weeks or work centers are over capacity versus merely tight?
Is planned load concentrated in a small number of work centers?
How might over-capacity weeks affect service and labor decisions?

Suggested analysis

Compare planned load, available hours, and utilization percentage by week.
Flag work centers repeatedly labeled over capacity.
Tie weekly planning pressure back to monthly utilization.

People and Payroll

Follow headcount and time through earnings, people cost, cash payments, liabilities, and payroll controls.

Connect the evidence: Payroll · Payroll and time tables · Hours-to-payroll practice · Staffing and payroll case

Headcount by Cost Center and Job Family

Review workforce structure by cost center, job family, and employment status.

Row grain: One cost center, job family, job level, and employment status.
Period basis: End-state Employee attributes, not historical month-end headcount. Tenure uses termination date or the query's fixed 2030-12-31 fallback.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Current snapshot

Interpret this report

Discussion questions

Which cost centers and job families carry the largest share of headcount?
Does the workforce mix align with the operating pressure shown elsewhere in the pack?
Where might management worry about staffing imbalance or concentration?

Suggested analysis

Compare headcount concentration across cost centers and job families.
Look for structural differences between support and operating functions.
Use the result to frame workforce-risk follow-up questions.

Labor and Headcount by Work Location Job Family and Cost Center

Compare workforce structure, people cost, approved hours, and direct labor by work location, cost center, and job family.

Row grain: One work location, cost center, and job family.
Period basis: Whole-file payroll, approved time, and labor totals alongside end-state Employee attributes; not a monthly trend.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Current cumulative view

Interpret this report

Discussion questions

Which locations or job families combine high people cost with high approved or direct labor hours?
Where does workforce structure appear operationally heavy or light?
Which organizational slice looks most important for deeper payroll analysis?

Suggested analysis

Compare headcount, gross pay, approved hours, and direct labor hours by grouping.
Look for groupings where total people cost is high but direct labor support is low.
Use the result to connect payroll interpretation to operating structure.

Payroll Expense Mix by Cost Center and Pay Class

Review payroll register totals by pay month, cost center, and pay class before moving into ledger-only expense analysis.

Row grain: One pay month, cost center, and pay class.
Period basis: PayrollPeriod PayDate month; payroll-subledger totals, not ledger posting month.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Monthly

Interpret this report

Discussion questions

Which cost centers and pay classes carry the largest payroll totals?
Does payroll mix appear concentrated in a small part of the organization?
What would management want to explain about the current payroll profile?

Suggested analysis

Compare gross pay, net pay, and employer burden across cost centers and pay classes.
Highlight areas where employee count and payroll cost do not move together cleanly.
Use the result to decide which workforce group deserves deeper follow-up.

Payroll and People Cost Mix by Cost Center Job Family and Level

Compare payroll concentration to current workforce structure by cost center, job family, job level, and pay class.

Row grain: One cost center, job family, job level, and pay class.
Period basis: Whole-file payroll totals alongside end-state Employee attributes and headcount; no monthly filter.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Current cumulative view

Interpret this report

Discussion questions

Which job families or levels drive the most people cost within each cost center?
Where do headcount concentration and payroll concentration diverge?
Which workforce group would management scrutinize next?

Suggested analysis

Compare end-state headcount to employees with payroll by workforce grouping.
Highlight groups with high total people cost but relatively small headcount.
Use the output to frame organizational and pay-mix questions.

Absence Rate by Work Location and Job Family

Compare monthly absence pressure by work location and job family, with paid and unpaid absence separated.

Row grain: One month, work location, and job family present in rostered hours.
Period basis: RosterDate and AbsenceDate calendar months; absence hours are compared with scheduled, reassigned, or absent roster hours.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Monthly

Interpret this report

Discussion questions

Which work locations or job families show the highest absence pressure?
Does paid versus unpaid absence change the interpretation?
How might absence patterns explain overtime or payroll irregularities elsewhere?

Suggested analysis

Compare absence rate, hours absent, and paid versus unpaid absence by month.
Focus on workforce groups with persistent absence pressure.
Relate absence trends to overtime or hourly pay support questions.

Overtime Approval Coverage and Concentration

Review where overtime hours concentrate by work center and how consistently those hours carry approvals.

Row grain: One work-date month and work center, including a missing-center group.
Period basis: TimeClockEntry WorkDate month with positive total overtime; linked approval coverage is not proof of authorization outside the file.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Monthly

Interpret this report

Discussion questions

Which work centers carry the most overtime?
Where do overtime hours and missing approvals appear together?
Does overtime look concentrated in a few operational hotspots?

Suggested analysis

Compare overtime totals, approval coverage, and missing approval counts by month and work center.
Identify recurring work centers with meaningful overtime and weak approval coverage.
Use the result to connect staffing pressure to control follow-up.

Punch to Pay Bridge for Hourly Workers

Trace hourly payroll from raw punches through approved time, labor allocation, and pay by employee and payroll period.

Row grain: One hourly employee and payroll period.
Period basis: Payroll-period start and end dates; independently aggregated punches, approved time, labor, and pay.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Payroll period

Interpret this report

Discussion questions

How closely do punch counts, approved hours, labor hours, and pay align?
Which hourly employees or periods appear hardest to explain?
Where would you expect follow-up between attendance review and payroll review?

Suggested analysis

Compare punch count, approved clock hours, labor hours, and pay by employee and payroll period.
Flag cases where labor support or pay appears disproportionate to approved time.
Use the bridge to identify whether a payroll issue looks operational, accounting, or control-related.

Hourly Payroll Hours to Paid Earnings Bridge

Bridge approved hourly time, labor support, paid earnings hours, and payment timing by employee and pay period.

Row grain: One hourly employee payroll register.
Period basis: Payroll-period approved hours and earnings, with scheduled PayDate and first actual payment date.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Payroll period

Gross to Net Payroll Review

Trace payroll registers from gross pay to withholdings, employer burden, and net pay by employee and pay period.

Row grain: One employee payroll register.
Period basis: Each register's payroll period and scheduled PayDate; actual payment is a separate event.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Payroll period

Interpret this report

Discussion questions

Which employees or cost centers show the largest gross-to-net spread?
How much of the payroll picture sits in employee withholdings versus employer burden?
Which status or approval patterns would merit additional review?

Suggested analysis

Compare gross pay, employee withholdings, employer burden, and net pay by period.
Distinguish employee deductions from company-side payroll cost.
Use the result to frame the later cash and liability discussion.

Payroll Cash Payments and Remittances

Compare employee net-pay cash outflows to payroll-liability remittances by month.

Row grain: One fiscal year and fiscal period.
Period basis: Actual employee-payment and liability-remittance date months, aggregated separately.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Monthly

Interpret this report

Discussion questions

Do employee payments and remittances move in the same periods or with visible lag?
Which month shows the highest total payroll cash outflow?
How should management interpret remittance timing versus payroll register timing?

Suggested analysis

Compare net-pay cash to tax and benefits remittances by fiscal period.
Identify periods where remittance mix changes meaningfully.
Relate cash outflow timing back to liability movement.

Payroll Liability Rollforward

Track payroll-liability account movement and ending balances by fiscal period.

Row grain: One fiscal period and payroll-liability account.
Period basis: Posted fiscal-month movement with a running credit-minus-debit liability balance.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Monthly

Interpret this report

Discussion questions

Which payroll-liability accounts carry the largest ending balances?
Do liabilities appear to clear regularly or build up over time?
Which liability type would management or audit monitor most closely?

Suggested analysis

Compare debit, credit, net increase, and ending balance by account and period.
Highlight accounts with recurring positive buildup.
Read the rollforward together with payroll cash remittances.

Payroll Control Review

Review payroll approval, payment-timing, and register-integrity exceptions across payroll periods.

Row grain: One payroll register and potential-control issue.
Period basis: Whole-file register review; EventDate follows the relevant approval date, scheduled pay date, or first payment date.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Exception review

Interpret this report

Discussion questions

Which payroll-control issue types appear most frequently?
Which exception would create the greatest trust problem in payroll reporting?
What would you inspect next for a flagged employee or pay period?

Suggested analysis

Group findings by issue type and payroll period.
Compare exception timing to the gross-to-net and cash reports.
Use the result to prioritize control follow-up.

Paid Without Clock and Clock Without Pay Review

Review hourly payroll lines without approved clock support and approved clock entries that do not flow into pay.

Row grain: One unmatched hourly pay line or approved clock entry.
Period basis: Whole-file support comparison; EventDate is the scheduled pay date for pay rows or work date for clock rows.
Process: Payroll
Practice: Lesson 10: Follow Hours into Payroll

Exception review

Interpret this report

Discussion questions

Which exception direction appears more operationally serious in this dataset?
Are the exceptions isolated to a few employees or spread across periods?
What source-table evidence would you trace next?

Suggested analysis

Separate paid-without-clock findings from clock-without-pay findings.
Compare affected periods to the punch-to-pay bridge and overtime coverage.
Use the result to define a focused attendance or payroll audit follow-up.

Controls and Exceptions

Scope cross-process approval, segregation-of-duties, and exception reviews; investigate flags before drawing conclusions.

Connect the evidence: Process responsibilities and controls · Source traceability · BPMN and controls workshop · Exceptions and controls case

Approval and SOD Review

Review approval assignments, same-user conflicts, and segregation-of-duties issues across source documents.

Row grain: One flagged document and review condition.
Period basis: Whole-file screening using each document's request, approval, or posting date; no as-of cutoff.
Process: Journals and Close
Practice: BPMN Process and Internal Control Workshop (extension after a verified trace)

Exception review

Interpret this report

Discussion questions

Which approval or same-user conflicts appear most concerning?
Are control issues concentrated in particular processes?
How might these conflicts create operational or financial risk?

Suggested analysis

Group findings by source-document process area.
Highlight recurring approval-role conflicts.
Use the result to decide whether deeper audit review is needed.

Potential Anomaly Review

Run a broad control-screening report that surfaces anomalies across journals, purchasing, sales, and payments.

Row grain: One flagged document and potential-issue type.
Period basis: Whole-file heuristic screening; event date depends on the document type, without a common cutoff.
Process: Journals and Close
Practice: BPMN Process and Internal Control Workshop (extension after a verified trace)

Exception review

Interpret this report

Discussion questions

Which anomaly families appear most meaningful operationally?
Are the exceptions isolated or repeated across processes?
Which anomalies would you escalate first and why?

Suggested analysis

Group anomalies by process area and exception type.
Compare operational exceptions with the supply and capacity reports in this pack.
Use the broad screen to define one focused audit follow-up.