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.

7 sections 22 steps Collects data
1

Engagement Setup and Data Pull

  1. 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
  2. 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
  3. 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.

2

Revenue Analysis

  1. 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.

  2. 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.

  3. 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.

3

Cost and Expense Review

  1. 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.

  2. 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.

  3. 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.

4

Margin and Variance Analysis

  1. 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.

  2. 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.

  3. 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
  4. 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.

5

Pricing and Product Mix

  1. 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.

  2. 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.

  3. 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.

6

Capital and Cash Efficiency

  1. 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.

  2. 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.

  3. 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.

7

Findings and Client Delivery

  1. 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
  2. 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.

  3. 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.


Sections 7
Steps 22
Category Accounting
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Profitability Analysis Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.