Fiscal Patterns

A fiscal pattern is used to define date formats and calculations in relation to your how your organization has defined its fiscal calendar. Fiscal patterns divide fiscal years into periods (usually quarters), and then define the number of weeks for each of the three months that fall within. All fiscal patterns rely on a fixed calendar date from which all past and future dates and calculations are based. However, a fiscal pattern's start date and a fiscal calendar's start date do not need to be identical. Fiscal patterns generally do not account for one or two days per year (depending on leap years); an additional week is periodically added to the final month (typically January) to account for the extra days.

The format for defining a fiscal pattern is a comma delimited row of 12 digits (or 13, if your organization's fiscal calendar has 13 periods). Commas separate each quarter in the fiscal year. Rows separate each fiscal year. Each digit in a row represents the number of weeks in a month for the position of the month in the fiscal pattern. The number of weeks in a month used in the fiscal pattern should match the number of weeks that have already been defined for each month in your organization's fiscal calendar.

Common methods of defining a fiscal pattern include:
Some examples:

When a fiscal pattern is applied to your organization's fiscal calendar, users will be able to view the date range defined by the fiscal pattern in areas where fiscal dates are visible, such as in the Financials tab in the Projects module. Hovering over a date column in a grid will show the date range that is being used to define the fiscal year being shown. For example:

Viewing fiscal patterns in the Financials view.

Add fiscal pattern

Add a fiscal pattern that is based on your organization's fiscal calendar.

To add a fiscal pattern

  1. From the application toolbar, click Setup, and then select System Settings.
  2. Select the Financial Settings tab.
  3. From the Fiscal Pattern Start calendar, select the day upon which the fiscal pattern will begin.
  4. Under Fiscal Pattern, enter the pattern format.
  5. Click Save.