Fiscal calendar

The fiscal calendar defines fiscal periods, such as Q1 2015 or July 2015.

In the Configuration tab of the workbench, you specify the month and date when your fiscal new year begins and the fiscal period unit: a quarter or a month.

When you import expenses to the General Ledger Staged Data [itfm_gl_data_staged] table, the system creates a record for each fiscal period during which an expense occurred, and for the entire fiscal year where there is a fiscal quarter with an expense. For example, if the fiscal new year starts on January 15, 2014, an expense in the staged general ledger was incurred every quarter that year, and you selected quarter for the fiscal period unit, the system generates these records:
  • FY14: the calendar record spanning the entire year, January 15, 2014 to January 14, 2015. FY14 Q1: the period spanning January 15 to April 14, 2014.
  • FY14 Q2: the period spanning April 15 to July 14, 2014.
  • FY14 Q3: the period spanning July 15 to October 14, 2014.
  • FY14 Q4: the period spanning October 15 to January 14, 2015.

You can also manually generate a fiscal calender.