Service

Revenue Analytics

Revenue analytics takes the top line apart. Price, volume and mix; new business, recurring, expansion and churn; product, channel, region and rep. One revenue number can move for four different reasons at once, and the only way to manage it is to see which of them is actually doing the work this quarter.

An office reception area
8 things this engagement covers, and a 9-step process.

Who it is for

Who this is for.

  • 8 things this engagement covers, listed below with what each one includes.
  • A 9-step process, the same one on every engagement.
  • 6 questions answered on this page.

Overview

A revenue number that grew eight percent tells you almost nothing on its own. Eight percent from a price increase behaves differently from eight percent from new logos, and both behave differently from eight percent that came from one large customer who may not renew. The decisions that follow, on pricing, hiring and cash planning, depend on knowing which it was.

Finalert builds that breakdown from your billing system and your CRM, cleans the records that make it unreliable, and reports it on a fixed cycle. You get cohort retention curves, a price against volume bridge and revenue by segment. Your commercial and finance leadership decide what to do about it.

Most of the answer already exists in your billing system and your CRM. It is usually unusable because customer records are duplicated, products are named three ways, credits are booked against the wrong period and closed-won opportunities never reconcile to invoiced revenue. We fix that first, then build the analysis on top of it.

Finalert builds revenue analytics for U.S. companies that need to know what their top line is made of. The core of the work is decomposition: splitting a period-over-period revenue change into price, volume and mix, so a flat quarter that hides a price rise offset by lost volume does not read as a quiet quarter. Alongside it we split revenue by source: new customers, the recurring base, expansion within existing accounts, contraction and churn, each as a dollar figure that adds back to the reported total.

The second half of the work is segmentation. Revenue by product or service line, by channel, by region, by customer size and by sales rep, each on the same basis and each with its own growth rate. Seasonality is measured rather than assumed, using enough history to separate a genuine repeating pattern from a run of good months. When a segment moves, the pack says how much of the total change it accounted for instead of leaving the reader to estimate.

Cohorts, retention and the shape of the base

Cohort analysis groups customers by the period they started and follows each group forward. That shows whether customers acquired this year are worth more or less than the ones acquired two years ago, when accounts typically expand, and when they leave. Gross and net revenue retention are calculated from the same cohort table rather than from a separate spreadsheet, so the numbers agree. For subscription businesses we track recurring revenue by month, with movement lines for new, expansion, contraction and churn.

Retention curves are where forecasting assumptions come from. A base that retains ninety cents of every dollar behaves differently from one that retains a hundred and ten with expansion, and the difference compounds fast. We report the curve by cohort, by product and by customer size, so a headline retention figure that looks healthy because a few large accounts grew does not hide steady attrition in the long tail beneath it.

Source data and what we do not do

None of this works on dirty data, so cleaning the source is part of the engagement rather than a prerequisite we assume. We de-duplicate customer records, reconcile CRM opportunities to invoiced revenue, standardize product and channel names, put credits and refunds back in the period they belong to, and separate one-time charges from recurring ones. Where a record cannot be resolved we flag it, size it, and report with the unresolved amount stated rather than buried in a segment.

We build and run the reporting. What to price, which channel to fund and which customers to chase are decisions your commercial and finance leadership own. Finalert does not sign tax filings, issue audit or attest opinions, give legal advice, or act as your accountant of record, and we do not set revenue recognition policy. The analysis reads the revenue your books already recognized; how it is recognized stays with your controller and your CPA.

What you get

What the engagement covers.

8 items

  • Price, volume and mix bridge

    A period-over-period revenue bridge that splits the change into price, volume and mix, in dollars, so a flat total that is hiding two offsetting moves becomes visible.

  • New, expansion, contraction and churn

    Revenue movement by source each period: new customers, growth inside existing accounts, downgrades and lost accounts, each adding back to the reported total without a balancing plug.

  • Cohort and retention curves

    Customers grouped by start period and followed forward, with gross and net revenue retention read off the same table by cohort, by product and by customer size.

  • Revenue by product and channel

    The top line split by product or service line, channel, region, customer size and rep, each with its own growth rate and share of the period's total change.

  • Recurring revenue reporting

    Monthly or annual recurring revenue tracked with movement lines, separated cleanly from one-time charges, pass-through costs and project work so the recurring base is not flattered.

  • Seasonality measurement

    Enough history analysed to tell a repeating seasonal pattern from a run of good months, so a forecast is not built on a quarter that always looks strong.

  • Billing and CRM data cleanup

    Duplicate customers merged, product names standardized, credits returned to the right period and CRM opportunities reconciled to invoiced revenue before any analysis is published.

  • Concentration and risk view

    Revenue by top customer, top product and top channel with the share each carries, so the exposure sitting inside a growing top line is stated rather than assumed away.

How it runs

How the work runs.

The first cycle is mostly data work. Once the source is clean and the definitions are agreed, the reporting repeats on a fixed calendar. Here is the sequence we run, from the first look at your billing data through to the quarterly reset.

  1. 01

    Source system review

    We look at your billing platform, your CRM and your ledger together, and list where revenue records disagree between them before promising any analysis. It sets the scope honestly.

  2. 02

    Customer and product master cleanup

    Duplicate accounts are merged, product and service names are standardized to one list, and a hierarchy is agreed so segments roll up the same way every period.

  3. 03

    Revenue definition sheet

    Recognized revenue, bookings, billings, recurring and one-time are each defined in writing with your controller, because the same word means different things to sales and to finance.

  4. 04

    CRM to ledger reconciliation

    Closed-won opportunities are reconciled to invoiced and recognized revenue, and the gaps are listed by cause in the first pass rather than written off as a system difference.

  5. 05

    Cohort table build

    Customers are grouped by start period and their revenue is laid out forward by month, which becomes the single source for every retention figure we publish.

  6. 06

    Decomposition model build

    The price, volume and mix bridge is built and tested against two or three prior periods until it reconciles to the reported revenue change without a balancing figure.

  7. 07

    First pack and walkthrough

    We walk the first output through with your finance and commercial leads, check every segment total back to the ledger, and correct anything that reads ambiguously.

  8. 08

    Monthly refresh and commentary

    After close we refresh the bridge, the segments and the cohort table, then write what moved and why, and issue it on the agreed delivery date each period.

  9. 09

    Quarterly cohort and definition review

    Each quarter we revisit the cohort curves, the segment hierarchy and the definitions, and change them deliberately, with the change dated and noted in the pack.

Our approach

How we approach it.

Revenue analysis fails in predictable ways: definitions that drift between quarters, a CRM nobody reconciles, and charts that describe the past without naming a cause. These are the working rules we apply to keep the output usable.

An office window overlooking a downtown skyline
Reconcile to the general ledger

Every revenue cut ties back to recognized revenue in your ledger for the period. If the segment detail and the trial balance disagree, we resolve it before publishing anything.

One definition of a customer

A customer, an account and a billing entity are not always the same thing. We agree which one the analysis counts, write it down, and then apply it everywhere.

Clean the source, not the chart

When a number looks wrong we fix the record that produced it. Adjusting a report to hide a data problem only moves the problem into next quarter.

Recurring separated from one-time

Implementation fees, hardware, pass-through costs and one-off projects are pulled out of the recurring base, so retention and growth rates mean what they appear to mean.

Size what you cannot resolve

Unmatched records and unallocated revenue are quantified and shown on the face of the pack. An unexplained remainder is reported, never spread across segments to make it disappear.

Reporting, not commercial decisions

We show what moved the revenue line and what the data supports. Pricing, channel investment and account strategy stay with your commercial and finance leadership.

Proof

What clients say, and what the work has done.

  • 110+ U.S. businesses served
  • 100% client satisfaction
  • 111 services we run

Finalert is an outstanding accounting, financial advisory and analytics company that delivers a wide range of services and solutions with the highest level of professionalism. Their expert team, with whom I have personally worked, possesses exceptional skills that enable customers to meet their financial and accounting needs seamlessly. Their dedication to excellence and customer satisfaction sets them apart, making them a trusted partner in the industry.

Wajdi Al MowafakDirector, Financial Business · Nonprofit
Recent engagement CWS Global Nonprofit & Humanitarian 50% faster month-end close Real-time grant and donor visibility Audit-ready compliance Read the case study

Questions

Common questions.

What finance and commercial leaders ask before handing revenue reporting to an outside team, and the answers we give before any work starts.

Where does the data come from?

From your billing or invoicing system, your CRM and your general ledger, read together. The ledger sets the total, billing supplies the transaction detail, and the CRM supplies the customer and opportunity attributes. We prefer read access to the systems over exported spreadsheets, because an export is a snapshot that stops being true the next day and cannot be re-run when a question comes back.

Our CRM data is a mess. Is that a problem?

It is normal, and it is the first part of the job. We de-duplicate accounts, standardize product names, reconcile closed-won opportunities to invoiced revenue and put credits back in the right period. Expect the first cycle to be mostly cleanup. Anything that cannot be resolved is quantified and shown on the pack rather than spread across segments to make the totals look tidy.

Can you do this if we are not a subscription business?

Yes. Cohorts and retention apply to any business with repeat customers, including distribution, professional services and field service. The price, volume and mix decomposition works anywhere you invoice units at a price. For project businesses we group by client rather than by contract month, and report repeat rate and average order value instead of recurring revenue.

How is this different from a sales dashboard?

A sales dashboard reports pipeline and bookings from the CRM. Revenue analytics reports recognized revenue from your ledger, reconciled back to it, and explains what moved it. The two rarely agree at first, and the difference is usually the useful part: it shows where bookings are not converting to invoiced revenue and how long that conversion takes.

How often do we get it?

Monthly after your close is signed, with a fuller cohort and retention review each quarter because those curves do not move meaningfully in thirty days. Weekly bookings or billings views are possible where the source data supports them, but we would rather publish monthly numbers that reconcile than weekly numbers that need a caveat every time.

What is not included?

We do not set revenue recognition policy, sign tax filings, issue audit or attest opinions, give legal advice, or act as your accountant of record. We also do not make the commercial calls. We report what the revenue is made of and what moved it; pricing, discounting and account strategy stay with your commercial and finance leadership.

About Revenue Analytics

Ready for numbers you can build on?

Talk to a Finalert consultant about your books, your reporting, or the decision you are trying to make.

110+ U.S. businesses served

What happens next

  1. A twenty-minute call An accountant on the line, not a salesperson.
  2. A scope and a price, in writing What the work covers, and what it costs.
  3. Onboarding on your schedule We start when you are ready, not before.

Monday to Friday, 8:00am to 5:00pm ET Cleveland and New York