Profitability Analysis Checklist
Quarterly profitability analysis run by a controller or fractional CFO for an SMB client. Walks the trial balance through revenue, cost, margin, pricing, and capital reviews, then produces a findings memo with named profit-improvement levers.
Engagement Setup and Data Pull
-
Confirm the analysis period and scope
Confirm with the client whether this is a single-quarter, trailing-twelve-months, or annual review, and whether segmentation is by product line, location, or customer cohort. Mismatched scope is the most common cause of rework — pin this down before pulling any data.
Collects list -
Pull the trial balance and P&L from the GL
Export the working trial balance, P&L (current period plus two prior comparatives), and balance sheet from QuickBooks Online, Xero, or Sage Intacct. Confirm the period is locked — analyzing an open period guarantees the numbers will shift under you.
Collects file -
Tie the trial balance to sub-ledgers
Tie A/R aging, A/P aging, inventory, fixed-asset roll-forward, and loan balances to the GL. Untied sub-ledgers signal an incomplete close — pause the analysis and flag with the client's bookkeeper before proceeding.
Revenue Analysis
-
Trend gross revenue across comparable periods
Pull at least eight quarters of revenue to separate seasonality from genuine trend. Note any month with a single customer concentration above 20% of revenue — that's a risk callout for the findings memo.
-
Segment revenue by product, service, or class
Use class tracking, location tracking, or item-level reports in QBO/Xero to break revenue into the dimensions the client manages by. If the COA is the only dimension and it isn't usable, note it as a recommendation rather than fighting the data.
-
Compare actual revenue to budget
Calculate variance to budget and to prior-year actual at the segment level. Flag variances above 5% of segment revenue or $25K absolute, whichever is smaller, for follow-up in the cost review.
Cost and Expense Review
-
Review COGS and gross-margin drivers
Decompose gross margin into price, volume, and input-cost components. For inventory businesses, confirm the COGS method (FIFO, weighted-average) hasn't changed mid-period — a method change masquerades as a margin shift.
-
Split operating expenses into fixed and variable
Walk the OpEx accounts and tag each as fixed (rent, salaries, software subscriptions) or variable (commissions, merchant fees, freight). The fixed/variable split feeds the breakeven analysis later in the engagement.
-
Flag non-operating and one-time costs
Pull legal settlements, severance, asset write-downs, PPP forgiveness, ERC adjustments, and any one-time professional-services spikes into a normalization schedule. Run-rate profitability without normalization is the most-cited error in client findings memos.
Margin and Variance Analysis
-
Calculate gross, operating, and net margins
Compute current-period and prior-period margins on both reported and normalized bases. Show both — the reported number is what the client sees on the P&L; the normalized number is the conversation.
-
Benchmark margins against industry data
Use RMA Annual Statement Studies, BizMiner, or IBISWorld for the client's NAICS code and revenue band. Cite the source and the size band in the memo — an unsourced benchmark is the first thing a CEO will challenge.
-
Investigate material margin variances
For any margin moving more than 200 basis points period-over-period, identify the underlying driver in the GL. Document whether the cause is structural (pricing, mix, vendor change) or one-time (refund, prepay timing).
Collects list -
Document root cause for each material variance
Build a one-row-per-variance workpaper: account, period-over-period dollar change, driver, supporting transactions, and recommended action. This becomes the appendix to the findings memo.
Pricing and Product Mix
-
Review pricing alignment with unit cost
For each major SKU or service line, confirm price covers fully-loaded unit cost plus target margin. Service businesses commonly underprice senior-staff hours when the bill rate hasn't moved with comp inflation.
-
Run breakeven by product line
Compute breakeven volume using the fixed/variable split from the OpEx review. Flag any product line operating below breakeven — these are the candidates for either a price increase or a sunset decision.
-
Evaluate discount and promotion impact
Pull the credit-memo and discount accounts. Quantify discount as a percent of gross revenue and compare to prior year — creeping discounts are a silent margin killer that the P&L hides because the topline still grows.
Capital and Cash Efficiency
-
Calculate ROI on major capital expenditures
Pull capex over the trailing 24 months from the fixed-asset roll-forward. Compare actual incremental EBITDA to the original investment thesis — if the client doesn't have a thesis on file, that's a finding in itself.
-
Review debt terms and covenants
Check interest rate, amortization, and any DSCR or fixed-charge-coverage covenants against current performance. Covenant breach risk is a profitability issue masquerading as a balance-sheet issue.
-
Analyze cash conversion and working capital
Compute DSO, DPO, and DIO for the period, and compare to prior year. A profitable P&L with deteriorating cash conversion usually means revenue quality is slipping — book without underlying receivables behavior is a yellow flag.
Findings and Client Delivery
-
Draft the findings memo with top profit levers
Lead with three to five named levers, each with estimated annualized impact in dollars and a clear owner. Avoid generic recommendations — "reduce overhead" doesn't move; "renegotiate the merchant-services contract for an estimated $18K annual savings" does.
Collects file -
Review the memo with the engagement partner
Partner walks every lever, challenges the math, and confirms the normalization adjustments. Address review notes before the client meeting — sending a memo with open partner notes erodes credibility fast.
-
Deliver report and capture sign-off
Walk the client through the memo live, capture decisions on each lever, and confirm next-quarter follow-up scope. Lock the working files in the client portal (TaxDome, SmartVault, ShareFile) and archive workpapers per firm retention policy.
Collects list Collects signature
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Profitability Analysis Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.