E.3.3 Using a Fiscal Year Configuration with a 6-Month Duration
In this example, the FSI_FISCAL_YEAR_INFO/ LEDGER_CCY_AND_FISCAL_YR_INFO table holds the following values:
- Start Month = 4
- Fiscal Period = 6
Since in this example the Fiscal Period is 6 months, we are no longer dealing with a
Fiscal Year, but with two fiscal periods within a 12-month time span. In this fiscal
period example, there are two 6-month fiscal periods within the 12-month window
beginning April 2020. Just as in the previous 12-month fiscal year example, the months
for the two fiscal periods correspond to monthly buckets as shown in the following
table:
Table E-6 Monthly Data for Fiscal Period #1, 2020 and Fiscal Period #2, 2020
| YEAR_S value | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020 | Apr 2020 | May 2020 | June 2020 | July 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 |
Continuing with this fiscal period example, 2020 fiscal year YTD ranges are as shown in
the following table:
Table E-7 Fiscal Period-to-Date Data for Fiscal Period #1, 2020 and Fiscal Period #2, 2020
| YEAR_S value | YTD as of Month 01 | YTD as of Month 02 | YTD as of Month 03 | YTD as of Month 04 | YTD as of Month 05 | YTD as of Month 06 | YTD as of Month 07 | YTD as of Month 08 | YTD as of Month 09 | YTD as of Month 10 | YTD as of Month 11 | YTD as of Month 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020 | Apr 2020 | Apr 2020 to May 2020 | Apr 2020 to Jun 2020 | Apr 2020 to Jul 2020 | Apr 2020 to Aug 2020 | Apr 2020 to Sep 2020 | Oct 2020 | Oct 2020 to Nov 2020 | Oct 2020 to Dec 2020 | Oct 2020 to Jan 2021 | Oct 2020 to Feb 2021 | Oct 2020 to Mar 2021 |
Note that in this fiscal period example:
- The first calendar month of the first fiscal period is April 2020.
- The last calendar month of the first fiscal period is September 2020.
- The first calendar month of the second fiscal period is October 2020.
- The last calendar month of the second fiscal period is March 2021.
When performing year-to-date calculations where the fiscal period value is 6 months, OFSAA segments the financial year into two 6-month periods. “Year-to-Date” in the context of a multi-period fiscal configuration means “fiscal period-to-date”.