Worksheet
The Spend to Revenue Worksheet
Map every line item in your software portfolio to one of six revenue impact categories. The same model Clarus CFO uses internally on the ROI dashboard.
The Question Every CFO Asks
What does this software actually do for the business? You can answer it for the line item that costs the most. You can probably answer it for the next two or three. Past that, the answers collapse into "the team uses it" or "we have always had it."
The Spend to Revenue Worksheet is a structured way to push past those answers. Every line item maps to one of six categories with a defined relationship to revenue. The mapping is not a quantitative ROI calculation; it is a qualitative classifier that tells you whether a particular dollar is buying revenue, enabling it, protecting it, or running operations.
Once every line is classified, the picture is usable. Finance leadership can see what fraction of software spend goes to which band. Procurement can prioritize negotiations on the highest-band categories. The board deck answers a real question.
The Four ROI Bands
The six categories collapse into four ROI bands:
- Direct: revenue is harder to attribute later. You cut these tools and the revenue team starts missing quarters.
- Enabling: the team productivity layer. You cut these and everyone gets slower.
- Compliance: the cost of being allowed to operate. You cut these and you cannot sell, cannot raise, or get sued.
- Operating: back office and experimental. You cut these and operations get harder, but revenue does not move for several quarters.
Healthy SaaS portfolios sit at roughly 35-40% Direct, 25-30% Enabling, 10-15% Compliance, 15-25% Operating. Numbers outside these bands do not necessarily indicate a problem; they indicate a question worth asking.
How to Classify a Line Item
Take any line item from your AP system and ask the four questions in this order:
- Does the revenue team use it to source, close, or retain? If yes, Direct. CRM, sales engagement, conversation intelligence, customer success: Direct.
- Does the customer touch it, or does the product depend on it in production? If yes, also Direct. Cloud infrastructure, observability, support tooling: Direct.
- Does every employee use it to do their job? If yes, Enabling. Collaboration, document storage, AI assistants: Enabling.
- Is a regulator, auditor, or buyer requiring it? If yes, Compliance. Vanta, cyber insurance, legal hold: Compliance.
Anything that does not fit those four buckets is Operating (back-office) or Experimental (pilots and bets).
How Clarus CFO Uses This Internally
Clarus CFO ships a ROI dashboard at /cfodashboard/roi that runs the same classification on your portfolio. Each subscription gets tagged to one of the six categories at upload (or via a single review pass if uploaded earlier without tags). The dashboard then shows:
- The per-band spend total and percentage of portfolio.
- The blended ROI estimate (configurable per band; defaults from industry benchmarks).
- Per-team rollup color-coded green / amber / rose by ROI band.
- Vendor-level drill-through with the trailing-quarter spend trend.
The same tagging surfaces in the recommendations engine: a shelfware seat in a Direct-band tool ranks higher than the same shelfware in an Operating-band tool, because the dollar there is buying outcomes, not optionality.
Running the First-Time Pass
For a portfolio of 50 to 200 line items, a single afternoon classification pass is enough. The first pass is the hard one; after that, new items get tagged at upload and the worksheet stays current automatically.
- Export your AP system's last twelve months of software spend into a spreadsheet.
- Add a Category column. Use the six categories from this article.
- Walk every line. For ambiguous lines, default to the band one level lower than your gut says.
- Sum spend per category and per band. Compare against the healthy-portfolio bands above.
- Identify the three biggest mis-classifications: tools where the band you assigned is lower than what the team would say. Those are usually the right targets for renewal-time right-sizing.
The Six Categories
Each card includes the definition, common examples, and the ROI band it lands in.
Direct Revenue Engine
DirectTooling that the revenue org runs against to source, close, and renew. Spend ties to bookings within one to two quarters of use.
- CRM (Salesforce, HubSpot)
- Sales engagement (Outreach, Salesloft)
- Conversation intelligence (Gong, Chorus)
- Demand gen (intent data, ABM platforms)
- CPQ and quote-to-cash
Product and Customer Experience
DirectTooling that the product team builds with or that customers touch directly. Spend ties to retention, expansion, and product velocity.
- Cloud infrastructure for the product
- Observability and APM (Datadog, New Relic)
- Support platforms (Zendesk, Intercom)
- Customer success (Gainsight, Catalyst)
- In-app analytics (Amplitude, Mixpanel)
Team Productivity Enablers
EnablingTools every employee touches and could not work without. Spend ties to team output across all functions.
- Collaboration (Slack, Microsoft Teams, Google Workspace, Microsoft 365)
- Document storage (Google Drive, OneDrive, Dropbox)
- Project management (Jira, Linear, Asana, Notion)
- Endpoint security and SSO
- AI assistants (Cursor, GitHub Copilot, Anthropic, OpenAI)
Compliance and Risk
ComplianceTooling required because a regulator, an auditor, a buyer, or a board says it is. Spend ties to your ability to sell, raise, or operate.
- Audit and compliance platforms (Vanta, Drata, Secureframe)
- Cyber insurance
- Legal hold and e-discovery
- Privacy and consent management
- SOC 2 and ISO 27001 audit fees
Back-Office Operations
OperatingTooling that runs the company's internal operations: finance, HR, IT, facilities. Spend ties to operational throughput, not directly to revenue.
- Accounting and ERP (NetSuite, QuickBooks)
- HRIS and payroll (Rippling, ADP, Gusto)
- Expense management (Brex, Ramp, Airbase)
- IT asset management
- Subscription and SaaS management (this category itself)
Experimental and Strategic
OperatingPilots, evaluations, and bets. Spend is not yet justified by results; the question is whether to convert to one of the prior categories or shut down.
- AI-feature pilots not yet in production
- New-market data tooling
- Prototype-stage research subscriptions
- Vendor pilots
Want to See It in Action?
Book a working session and we will walk through your spend, recommendations, and renewal pipeline.