E.3.1 Using a Fiscal Year Configuration with a 12-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 = 12
Since the fiscal period in this example is 12 months, therefore, we can refer to the
fiscal period like a fiscal year. In this fiscal year example, the months for the fiscal
year correspond to monthly buckets as shown in the following table:
Table E-2 Monthly Data for Fiscal Year 2020
YEAR | 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 |
For this fiscal year example, the first calendar month of the 2020 fiscal year is April 2020, and the last calendar month of the 2020 fiscal year is March 2021.
Continuing with this fiscal year example, 2020 fiscal year YTD ranges are as shown in the
following table:
Table E-3 Year-to-Date Data for Fiscal Year 2020
YEAR | 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 | Apr 2020 to Oct 2020 | Apr 2020 to Nov 2020 | Apr 2020 to Dec 2020 | Apr 2020 to Jan 2021 | Apr 2020 to Feb 2021 | Apr 2020 to Mar 2021 |