Blog · Board and management reporting · Finance and FP&A teams
A financial year defines the annual period used to report a business's results. See how fiscal and calendar years differ, map transactions to reporting periods, and check a worked annual comparison.
A financial year is the annual reporting period used to group a company's revenue, expenses and other financial activity. It may match the calendar year or run on another approved fiscal calendar. For analysis, the actual period dates matter more than the year label.
In business reporting, financial year and fiscal year refer to the annual reporting cycle. A calendar year runs from January 1 through December 31. For US tax purposes, the IRS distinguishes calendar years, fiscal years and 52–53-week tax years; choosing or changing a tax year can involve requirements beyond the reporting comparison discussed here.
For management analysis, use the company's approved reporting calendar. A year ending September 30 can contain activity from October of the previous calendar year. A weekly reporting calendar needs explicit week boundaries, including any additional week.
Revenue and expenses accumulate over those dates. A balance sheet measures balances at a date, as the SEC's financial statement guide explains. Add monthly revenue to obtain annual revenue; do not add monthly cash balances to obtain year-end cash.
Ask accounting for a calendar with period start, period end, fiscal year, fiscal quarter, fiscal period and close status. Keep the date labels explicit. In this example, FY2026 ends on September 30, 2026, and starts on October 1, 2025.
An export should retain the posting date, account, entity, amount and original row identifier. Use posting dates for the ledger comparison. An invoice or shipment date can support a separate operational view, but label that difference.
For a conventional October-to-September monthly calendar, a posting date in A2 maps to the fiscal ending year and period with these spreadsheet formulas:
=YEAR(EDATE(A2,3))
=MOD(MONTH(A2)-10,12)+1
The first formula moves the date forward three months before extracting the year. The second assigns October to period 1 and September to period 12. Use the approved calendar lookup instead for a weekly calendar or irregular reporting period.
For checks across reporting systems, financial data reconciliation covers matching sources and explaining differences; calendar mapping is one input to that work.
An illustrative US distributor reports on an October-to-September calendar. Its ledger export has been mapped to the following closed quarters. Expenses include all operating expenses for this example; operating profit is revenue minus those expenses. All amounts are USD.
| Fiscal year | Fiscal quarter and dates | Revenue (USD) | Expenses (USD) | Operating profit (USD) |
|---|---|---|---|---|
| FY2025 | Q1: October 1–December 31, 2024 | 2,400,000 | 2,100,000 | 300,000 |
| FY2025 | Q2: January 1–March 31, 2025 | 2,600,000 | 2,300,000 | 300,000 |
| FY2025 | Q3: April 1–June 30, 2025 | 2,800,000 | 2,450,000 | 350,000 |
| FY2025 | Q4: July 1–September 30, 2025 | 3,200,000 | 2,750,000 | 450,000 |
| FY2025 total | October 1, 2024–September 30, 2025 | 11,000,000 | 9,600,000 | 1,400,000 |
| FY2026 | Q1: October 1–December 31, 2025 | 2,700,000 | 2,300,000 | 400,000 |
| FY2026 | Q2: January 1–March 31, 2026 | 2,900,000 | 2,500,000 | 400,000 |
| FY2026 | Q3: April 1–June 30, 2026 | 3,100,000 | 2,650,000 | 450,000 |
| FY2026 | Q4: July 1–September 30, 2026 | 3,600,000 | 3,050,000 | 550,000 |
| FY2026 total | October 1, 2025–September 30, 2026 | 12,300,000 | 10,500,000 | 1,800,000 |
The comparison formula is:
Year-over-year change = (Current financial-year amount - Prior financial-year amount) / Prior financial-year amount
| Measure | Calculation | Result |
|---|---|---|
| Revenue growth | (12,300,000 - 11,000,000) / 11,000,000 | 11.82% |
| Expense growth | (10,500,000 - 9,600,000) / 9,600,000 | 9.38% |
| Operating profit growth | (1,800,000 - 1,400,000) / 1,400,000 | 28.57% |
| FY2025 operating margin | 1,400,000 / 11,000,000 | 12.73% |
| FY2026 operating margin | 1,800,000 / 12,300,000 | 14.63% |
Percentages are rounded to two decimal places after calculation. Revenue grew faster than expenses, so operating profit and margin increased. The dates establish that both annual comparisons cover equivalent fiscal quarters.
For a transaction sheet with dates in A, revenue in B and expenses in C, the FY2026 revenue formula is:
=SUMIFS(B:B,A:A,">="&DATE(2025,10,1),A:A,"<"&DATE(2026,10,1))
Use the same formula with C:C for expenses. The exclusive upper boundary also works when the date column includes timestamps.
The quarterly revenue totals must equal the annual ledger revenue control: $11,000,000 for FY2025 and $12,300,000 for FY2026. Expense totals must tie the same way. Revenue less expenses must equal summed quarterly operating profit: 11,000,000 - 9,600,000 = $1,400,000 and 12,300,000 - 10,500,000 = $1,800,000.
Check that every source row maps to exactly one fiscal period. Unmapped dates, overlapping boundaries and blank dates need explicit exception counts. Keep annual total rows out of the transaction input so they are not added a second time.
Compare matching quarters before extrapolating a recent month. The worked run-rate and seasonality example explains that separate question. Use the financial KPI guide to keep the definitions of the measures being compared consistent too.
Bring your ledger export and approved period calendar; Covirage maps the columns, and its tools compute and check revenue and expenses on the supplied fiscal basis. The external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for finance teams for the supporting workflow.
Only when it runs from January 1 through December 31. A business can report on another fiscal cycle, such as October through September. Always check the dates on the statements instead of assuming the year label identifies a calendar year.
FY2026 identifies a fiscal year using the company's naming convention, commonly the year in which the period ends. For an October-to-September calendar using that convention, it runs from October 1, 2025, through September 30, 2026. Confirm the dates because labels alone can be ambiguous.
Compare the same completed fiscal periods in both years. Identify the reporting cutoff and exclude unfinished periods unless both sides use a clearly stated equivalent cutoff. Keep any extra week visible rather than assuming similarly labeled quarters contain the same number of days.
The controller or designated accounting owner should approve fiscal period boundaries and close status. FP&A uses the approved calendar for plans and comparisons, while operating teams map their activity to it. Document exceptions so different reports do not silently assign transactions to different periods.