Fiscal year quarterly revenue report, built on your own calendar
The short answer
A fiscal year quarterly revenue report groups revenue by your company's fiscal quarters in place of calendar quarters. Set the fiscal year start and week pattern, such as a 4-5-4 retail calendar, map every transaction date to its fiscal week, then total revenue by fiscal quarter for two years side by side.
Why it matters
Calendar quarters split the holiday season, Black Friday weeks and back-to-school differently each year, so quarter-on-quarter comparisons drift. Reporting on the fiscal calendar lines up the same trading weeks every year and matches the numbers finance reports to the board.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a furniture retailer with a fiscal year ending on the Saturday closest to January 31. It applies a 4-5-4 calendar and counts revenue after discounts and returns.
- Q1: $41.8 million, against $39.6 million
- Q2: $44.3 million, against $45.1 million
- Q3: $43.0 million, against $40.2 million
- Q4: $58.7 million, against $56.9 million
What the data shows
Q3 grew 7%, the strongest quarter, and Q2 was the only quarter down.
What it means
The Labor Day sale falls inside Q3 in both years, so the fiscal view compares like with like. A calendar-month report would split the sale and blur the result.
What to do
Use the fiscal view for board reporting and look into the Q2 decline by category.
Any 53-week year is flagged with a 52-week comparison beside it. Would you like Q2 broken down by category?
Frequently asked questions
What is a 4-5-4 retail calendar?
A 4-5-4 calendar splits each quarter into months of four, five and four weeks, so every month starts on the same weekday and covers whole weeks. Retailers use it to compare the same trading days year on year. Every five or six years it adds a 53rd week to stay aligned with the seasons.
Why do fiscal and calendar quarter revenue differ?
The quarters cover different weeks. A fiscal Q4 that ends in late January includes post-holiday returns and clearance, while calendar Q4 stops on December 31. Comparing one against the other mixes trading periods, which is why finance and marketing reports often disagree on the same quarter.
How do I compare revenue by quarter across a 53-week year?
Show the 53-week figure as reported, then add a 52-week version that removes the extra week, usually the last week of the year. Compare growth on the 52-week basis. Without the adjustment, the longer year shows roughly two percentage points of growth that did not come from customers.