Determine the fiscal quarter for a date given a fiscal year start month.
Shifting the month by the fiscal year start converts a calendar month into a fiscal one, then the quarter follows by division. The fiscal year label convention differs by organisation, so it is worth confirming. Mismatched fiscal calendars are a common cause of reconciliation errors when consolidating figures across subsidiaries in different countries.
Fiscal Quarter
Fiscal month = ((month − fiscal start + 12) mod 12) + 1; quarter = ⌈fiscal month ÷ 3⌉
Fiscal month = ((month − fiscal start + 12) mod 12) + 1; quarter = ⌈fiscal month ÷ 3⌉ Shifting the month by the fiscal year start converts a calendar month into a fiscal one, then the quarter follows by division. The fiscal year label convention differs by organisation, so it is worth confirming.
Mismatched fiscal calendars are a common cause of reconciliation errors when consolidating figures across subsidiaries in different countries.
This calculator takes 4 inputs: Date year, Date month, Date day, Fiscal year start month. The pre-filled defaults are a realistic starting point — replace them with figures from your own environment for a result you can act on.