A sales decline tells you what changed. It does not tell you which accounts deserve attention, or how much of the comparison comes from a shorter selling period.
The example below is entirely synthetic. It is an illustration, not a customer case study or a claim of recovered revenue.
1. Reconcile the account bridge
Suppose revenue falls from $22,500 to $16,900: a $5,600 decline, or 24.9%. Separate the movement into three parts:
New accounts: +$3,000
Absent accounts: -$6,000
Retained accounts: -$2,600
These add to -$5,600. That reconciliation matters: a review that lists only lost accounts misses retained-account deterioration and positive offsets.
“Absent” means positive revenue in the prior period and zero in the current period. It does not prove churn. Check missing orders, export completeness, account-ID changes and purchase timing before drawing that conclusion. Likewise, “new” can include a reactivated account.
2. Compare revenue per working day
If the prior period has 20 working days and the current period has 18, daily revenue is $1,125 versus about $938.89. The per-day decline is 16.5%, compared with the raw 24.9% decline.
Both figures are useful. Raw change explains the dollars; the daily comparison accounts for the supplied day counts. Neither calculation explains holidays, weather, seasonality, product mix or the cause of a customer decline. Use an operating calendar that fits the business.
3. Build a review queue
Start with the largest dollar declines. Distinguish meaningful established accounts from small accounts using an explicit prior-revenue threshold. Measure concentration against gross account declines before positive offsets; using the net decline as the denominator can mislead.
For each priority account, record the evidence to check, the responsible person and the next review date. Investigate order volume, pricing and mix before assigning a cause. An account queue is a starting point for investigation, not an automated sales recommendation.
4. Check the input before trusting the story
Use complete, comparable periods, consistent account identifiers and one currency. Duplicated rows, renamed accounts and missing exports can distort the bridge. Revenue Review accepts nonnegative amounts; if your source contains negative credits, use a workflow that handles them rather than deleting credits to force a result.
Try the workflow
Focalvera Revenue Review is a $49 one-time downloadable browser tool for two-period customer CSV analysis. It includes the account bridge, working-day comparison, filters and CSV/JSON exports. Your CSV is processed locally in the browser. Requirements and limits are on the product page:View Revenue Review — $49
Focalvera / One Fortitude LLC. Product support: sales@focalvera.com.