Should revenue be reported by the date the lead came in or the date the job was invoiced?
By lead date for marketing decisions and by invoice date for financial ones, and you need both. Lead-date cohort reporting attaches revenue to the spend that created it, which is the only honest way to judge a channel, but recent periods stay incomplete. Invoice-date reporting closes cleanly and reconciles to accounting, but blends revenue produced by several months of spend.
Two calendars, both correct
Invoice-date revenue answers what the company earned in a month. Lead-date revenue answers what a month's demand and spend eventually produced. They will never match for the same month, and expecting them to is the source of a surprising number of arguments.
The confusion is worse in businesses with long estimate cycles, because the two calendars can diverge by a full season. A strong month of lead generation in spring may show up in summer's invoices, which makes spring look weak and summer look brilliant on a single-calendar report.
The practical tell that a company has never resolved this: two people in the same meeting quoting different revenue for the same month, both correct, neither able to explain the other's number. That is a basis mismatch, not a data quality problem.
The incompleteness problem, and how to present it
Cohort reporting has one unavoidable weakness: the newest cohorts are not finished. Their revenue keeps climbing for weeks, so any snapshot understates them. If that is not shown explicitly, every recent period looks like a decline.
Show cohort age and historical maturity alongside the number, so a reader knows a fourteen-day-old cohort is not comparable to a ninety-day-old one. This is the same maturity discipline described in revenue intelligence, and it is what keeps a dashboard from producing a false alarm every Monday.
What breaks when you pick one and forget you did
- Invoice-date only. Channel performance becomes unmeasurable. Spend and revenue in the same month describe different customers.
- Lead-date only. Nothing ties to accounting, the totals never agree with the books, and finance stops trusting the report.
- Silently switching. The worst option. A report that changes basis between views produces numbers that cannot be reconciled by anyone, including the person who built it.
A layout that keeps both usable
Run financial summaries on invoice date and label them as such. Run channel and source analysis on lead date and label those too. Publish a single reconciliation line showing total invoiced revenue for the period and total revenue attributed to cohorts, with the difference explained by timing rather than hidden.
This dual view is not extra work once it lives in the data layer instead of in exports. It is standard practice in the reporting we build on top of field service systems and job management platforms, because both audiences need to trust the same underlying records.
Topics: cohorts · reporting periods · attribution · accounting · dashboards
Have a version of this question about your own business?
The useful answer usually depends on which systems you run and how they're connected. That's a conversation, not a blog post.