Moving annual total (MAT) adds up sales over a rolling year, commonly the latest 52 completed weeks in weekly FMCG reporting. Year-to-date (YTD) adds up sales from the start of the reporting year to the same cutoff. Use MAT to track a full seasonal cycle and YTD to see how the current year is progressing. Compare each with its own matching period a year earlier.
How to calculate moving annual total (MAT)
Choose the last complete reporting week and add its sales to sales from the preceding 51 weeks. If the historical figures stay the same, you can update MAT by adding the newly completed week and subtracting the oldest week in the previous total. For a monthly report, MAT commonly uses the latest 12 completed months.
Updated 52-week MAT = Previous MAT + Newly completed week’s sales − Sales from the week that rolled out
For year-over-year MAT growth, calculate a second 52-week total ending at the comparable reporting week a year earlier. Use the retail calendar that defines comparable trading weeks for the report.
How to calculate year-to-date (YTD) sales
Add sales from the first week of the reporting year through the same completed cutoff week. A weekly report at Week 36 uses Weeks 1 to 36 of the current reporting year. Compare that total with the matching weeks in the prior reporting year. State whether the report follows a fiscal or calendar-based reporting year.
MAT vs YTD in the same FMCG sales report
A food brand reviews net retail sell-out through Week 36. The example uses Monday-to-Sunday ISO reporting weeks. The current cutoff is Sunday, September 6, 2026. The comparable cutoff is Sunday, September 7, 2025. Both reports cover the same store group, and the sales figures are illustrative US dollar amounts.
| Measure | Prior window | Prior sales | Current window | Current sales | YoY growth |
|---|---|---|---|---|---|
| MAT (52 weeks) | 2024 W37 to 2025 W36 | $1,000,000 | 2025 W37 to 2026 W36 | $1,067,000 | +6.7% |
| YTD (36 weeks) | 2025 W01 to W36 | $660,000 | 2026 W01 to W36 | $627,000 | −5.0% |
MAT growth is ($1,067,000 − $1,000,000) ÷ $1,000,000 = +6.7%. YTD growth is ($627,000 − $660,000) ÷ $660,000 = −5.0%.
The final 16 weeks of 2025 contributed $440,000 to current MAT, compared with $340,000 from the final 16 weeks of 2024 in prior MAT. That $100,000 gain across the earlier blocks more than offsets the $33,000 decline in the current YTD comparison. The difference between the two MAT totals is $67,000.
When to use MAT and when to use YTD
- Use MAT for the annual trend. A rolling year gives each view a full cycle of seasonal sales. It is useful for annual category reviews or changes that take several months to show up. Older weeks can keep MAT positive even after current sales start to weaken.
- Use YTD for progress against the current-year plan. Compare actual sales with the budget for the same elapsed weeks and with the matching prior-year period.
If the two measures point in different directions, look at a shorter window such as the latest four or 13 complete weeks. Check whether the change is concentrated in certain products or outlets and whether distribution, prices or availability moved during those weeks.
How to handle a 53rd week and missing weeks
Align 52-week and 53-week reporting years
At the end of the 53-week ISO reporting year in this example, full 2026 YTD includes Weeks 1 to 53. A fixed 52-week MAT ending that week includes Weeks 2 to 53. Keep the reported YTD total and label the comparable growth calculation separately. One approach is to compare Weeks 1 to 52 in both years and show Week 53 sales on their own. If your retail calendar restates the weeks to align trading days or holidays, use that mapping and label the periods accordingly.
Check for incomplete or unreported weeks
If the latest week is only partly reported, use the latest complete week as the cutoff and align the prior-year periods to match. For a missing historical week, recover the data and rerun the totals. Until then, flag the affected window as incomplete and hold the affected growth figure. If the gaps are limited to certain outlets, a separately labeled view can use the outlets with complete data in both periods.
State the week-ending dates, number of weeks and whether the report measures sales value or volume. Check that both periods cover the same products, channels and outlet scope. For more on how coverage shapes FMCG reports, see TrendBox’s guide to retail measurement for traditional trade.
Frequently asked questions
Is MAT the same as LTM or rolling 12 months?
MAT and last twelve months (LTM) match when both refer to the same 12 completed months and use identical sales definitions. A 52-week MAT spans 364 days. Label the window explicitly when comparing weekly and monthly reports.
When do MAT and YTD show the same number?
They match when they cover the exact same reporting weeks and sales scope. At the end of a 52-week reporting year, both totals can cover Weeks 1 to 52.
Can I calculate MAT and YTD in Excel?
Yes. Keep one row per reporting week, with a consistent week-ending date and sales value for the scope you want. Use SUMIFS to sum sales between the chosen start and cutoff dates. For MAT, check that the window contains 52 consecutive reported weeks. For YTD, use the first week of the reporting year as the start.
Can MAT and YTD be used for volume and market share?
Yes. Sum sales units in the same unit of measure for volume. For market share, sum brand sales and total category sales for the chosen window, then divide the brand total by the category total. This weights each week by its category sales.
Put your reporting periods in market context
TrendBox connects retail sell-out with distribution, pricing and availability signals that help teams investigate changes in sales. See how these measures fit together in TrendBox’s guide to FMCG data analytics.
To discuss the category, outlet coverage and reporting periods your team needs, email TrendBox at info@trendbox.io.