Blog · Board and management reporting
Trend analysis compares business results across consistent periods. Work through quarterly revenue, costs and margin, build the spreadsheet comparisons, and check that the trend agrees with the ledger.
Trend analysis compares the same business measure over consistent periods to show direction, pace and exceptions. Start with reconciled revenue and cost exports, state the comparison baseline, and examine amounts alongside rates. Higher revenue alone does not establish that business performance improved.
Write down the reporting scope: company, business units, currency, posting basis and period end. A sales trend based on invoice dates cannot be compared casually with a later report based on shipment dates. Keep discontinued units and acquisitions visible rather than silently changing the population.
Choose a baseline that answers the operating question. A fixed starting quarter shows cumulative movement. The matching quarter in the prior year offers a comparison at the same point in the annual cycle. Neither automatically removes calendar effects or differences in business conditions.
Use net revenue consistently. The SEC's financial statements guide explains the deduction of returns and allowances from gross revenue and the subtraction of cost of sales to reach gross profit. A trend assembled from gross sales in one period and net sales in another measures a definition change.
For consecutive monthly reporting, use the dedicated month over month analysis guide. Here the task is a broader review of performance across several comparable quarters.
Keep a raw worksheet with one row per posted sales line. Include transaction ID, posting date, net revenue, matched cost of goods sold, and business unit. Do not repeat a whole invoice's revenue on every product line. Check returns, duplicate IDs and unmatched costs before interpreting the series.
Assume the worksheet is named Raw, with posting date in B, net revenue in C and matched cost in D. On a summary sheet, put quarter start in H2 and the next quarter's start in I2. Revenue in B2 is:
=SUMIFS(Raw!$C$2:$C$10000,Raw!$B$2:$B$10000,">="&H2,Raw!$B$2:$B$10000,"<"&I2)
Cost in C2 uses the same date boundaries:
=SUMIFS(Raw!$D$2:$D$10000,Raw!$B$2:$B$10000,">="&H2,Raw!$B$2:$B$10000,"<"&I2)
The upper boundary excludes the next quarter and works with timestamps. Microsoft documents SUMIFS as summing cells that meet multiple criteria. Extend the ranges to include the entire export and keep every range aligned. Covirage is not affiliated with Microsoft.
Summing produces a result only for rows actually supplied. If cost comes from a separate ledger export, summarize revenue and cost independently to the same quarter and business scope; do not join a quarterly cost total onto every invoice row. Use financial data reconciliation to resolve a disagreement before comparing periods.
A US distributor supplies these quarterly summaries. They are illustrative business assumptions, not market benchmarks. Only the first three quarters of each year are included; the table does not splice a partial quarter into a completed series.
| Period | Net revenue (USD) | Cost of goods sold (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|
| 2025 Q1 | 900,000 | 630,000 | 270,000 | 30.0% |
| 2025 Q2 | 1,000,000 | 680,000 | 320,000 | 32.0% |
| 2025 Q3 | 1,100,000 | 737,000 | 363,000 | 33.0% |
| 2026 Q1 | 990,000 | 683,100 | 306,900 | 31.0% |
| 2026 Q2 | 1,150,000 | 805,000 | 345,000 | 30.0% |
| 2026 Q3 | 1,210,000 | 871,200 | 338,800 | 28.0% |
With the headings in row 1, gross profit in D2 and gross margin in E2 are:
=B2-C2
=IF(B2=0,"",D2/B2)
Fill down through row 7. Format E as a percentage. A blank margin for zero revenue needs review; it should not be presented as a measured zero margin.
For a fixed revenue index, put =B2/$B$2*100 in F2 and fill down. Q1 2025 is 100.0 and Q3 2026 is 134.4, rounded to one decimal: 1,210,000/900,000*100. Because Q4 is absent, label a chart with the actual periods rather than plotting these rows as equally spaced consecutive quarters. The time series analysis overview covers the broader structure of dated observations.
Compare matching Q3 periods first. Revenue increased by $110,000, or 110,000/1,100,000 = 10.0%. Cost increased by $134,200. Therefore gross profit changed by 110,000-134,200 = -24,200, matching 338,800-363,000. Gross margin fell from 33.0% to 28.0%, a decline of 5.0 percentage points.
Then compare the complete year-to-date scope:
| First three quarters | Revenue (USD) | Cost (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|
| 2025 | 3,000,000 | 2,047,000 | 953,000 | 31.77% |
| 2026 | 3,350,000 | 2,359,300 | 990,700 | 29.57% |
| Change | 350,000 | 312,300 | 37,700 | -2.19 percentage points |
Revenue growth is 350,000/3,000,000 = 11.67%; gross profit growth is only 37,700/953,000 = 3.96%. Calculate aggregate margins from total gross profit divided by total revenue. The margin change uses unrounded ratios; displayed percentages are rounded to two decimals.
This supports a specific question for commercial finance: why did cost grow faster than revenue? It does not establish supplier inflation, discounting or a product mix shift. Those explanations need the underlying product and customer rows. Broader changes in customer markets belong in market trend analysis, rather than being inferred from this company's sales alone.
Bring a dated revenue and cost export with the same business scope for each period. Covirage maps the columns, and its tools compute and check period totals, changes and rates; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See self-service analytics for the supporting business workflow.
Two periods establish a change, but they provide little evidence of a continuing pattern. Use enough history to see the business cycle and compare matching periods where seasonality matters. A short series should be described as a recent movement, with its limited history stated.
Trend analysis describes recorded results over time. Forecasting estimates future results using assumptions and a specified method. A rising historical series can support a planning discussion, but extending its line without accounting for capacity, demand and changing conditions is not a reliable forecast.
Use both because they answer different questions. Dollars show the size of a movement; percentages put it against its starting level. Add operating rates or margins where relevant, and retain the numerator and denominator so a rate change can be checked.