Creating financial calendar

What you can do in this page

Glossary

Basics of using a typical web page

Using Online Help

This page allows you to create a new financial calendar. Tell me more.

The “Create Financial Calendar page" appears.

The system displays the following:

Company Name

The name of the company for which the financial calendar is being created.

Status

The status of the financial calendar. It must be “Active”.

Financial Year Code

A unique code identifying the financial year (Alphanumeric, 10). Mandatory.

Description

The textual description of the financial year (Alphanumeric, 40). Mandatory.

 

Zoom facility available

Start Date

The date on which the financial year begins (Date Format). Mandatory.

Note: If a financial year exists before this the system will default the last date of the previous financial year + 1.

End Date

The date on which the financial year ends (Date Format). Mandatory.

Note: The date entered in this field must be after the date entered in the “Start Date” field.

Frequency

Use the drop-down list box to select the frequency in which the financial periods must be created. You can select from “Half-yearly”, “Quarterly”, “Monthly” or “Fortnightly” or “Customized”.

Note: If “Half-yearly”, “Quarterly”, “Monthly” or “Fortnightly” is selected, the system automatically calculates start date and end dates of the financial periods. If “Customized” is selected the start dates and end dates of the financial periods must be entered.

The system calculates and retrieves the start dates and end dates of the financial periods in the “Financial Period Details” multiline.

Note: At least one financial period must be defined for a financial year.

Financial Period Code

A unique code identifying the financial period for the financial year (Alphanumeric, 10). Mandatory.

Description

A textual description of the financial period (Alphanumeric, 40). Mandatory.

The system displays the following:

Start Date

The date on which the financial period begins.

Note: The system displays the start date of the financial year by default in the first row of the multiline In the subsequent rows of the multiline the system displays the start date as the end date on the previous financial period + 1.

End Date

The date on which the financial period ends (Date Format). Mandatory. The end date must be later than the start date.

Note: The date entered in this field must not be after the end date of the financial year.

Legacy Date

Use the drop-down list box to set whether the financial period is a legacy period from “Yes” and “No”.

 
  •  Yes – indicates that the financial period is a legacy period. This means that the migration from the old system to the new system has happened in the middle of the financial year and this period has already been completed in the earlier system.

 
  •  No – indicates that the financial period is not a legacy period. This means the financial period is yet to begin.

Note: If “Yes” is selected for a financial period all the preceding financial periods must also have legacy dates.

If “No” is selected for a financial period, the subsequent financial periods must also not have legacy dates.

The status of the calendar is updated as “Active”.

The system displays the following:

Created By

The login ID of the user who has created the calendar.

Created Date

The date on which the calendar was created.

To proceed, carry out the following

 

 

 

 

 

 

 

Creating financial calendar – An overview

Activity overview

You can define a financial year by providing the year start date and the end date. You can also divide the year into financial periods. The duration of the financial period is based on the business requirements of the user. In any case the system allows you to calculate the financial periods based on the frequency that has been selected. You can divide a financial year into financial periods in the standard frequencies as half-yearly, quarterly, monthly or fortnightly. You can also divide the financial year into financial periods based on your requirements, the start and end dates of these financial periods must also be defined. While using the standard frequency for the financial periods, the end date of a financial period will always be assumed as the starting date of the next financial period Refer Example 1. A financial period must always end on the last day of a calendar month irrespective of the fact that the start of the financial period is in the middle of the month Refer Example 2. The status of the newly created financial period is updated as “Active”. If you are migrating from the earlier system in the middle of a newly defined financial year, you can set the financial periods that have been completed as legacy dates.

Companies under the same business unit must have the same financial calendar. You can attach the calendar that has been created first by a company in the business unit to all the other companies that fall under the same business unit Refer Example 3.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EXAMPLES

Example 1:

For a financial year “FY1” that starts on 01st of January ’01 and ends on 31st of December ’01 that is to have a “Quarterly” frequency, the system divides the financial period as outlined below:

Financial Period

Start Date

End Date

FP1

01/01/01

31/03/01

FP2

01/04/01

30/06/01

FP3

01/07/01

30/09/01

FP4

01/04/01

31/12/01

 

 

 

 

 

 

 

 

 

 

 

 

 

Example 2:

For a financial year “FY2” that starts on 15th of January’02 and ends on 31st of December’02 that is to have a “Half-Yearly” frequency, the system divides the financial period as outlined below:

Financial Period

Start Date

End Date

FP1

15/01/02

30/06/02

FP2

01/07/02

31/12/02

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Example 3

“Company A” and “Company B” form a part of “Business Unit 1”. “Company A” has a financial calendar “FY01” defined for the year 1st January ’01 to 31st December ’01. Then the same calendar must be attached to “Company B” also. “Company B” will not be able to create a financial calendar for the same year.

In the subsequent year if “Company B” has defined a financial calendar “FY02” for the year 1st January ’02 to 31st December ’02 before “Company A”, this calendar must be attached to “Company A”. “Company A” will be not be able to create a financial calendar for the same year.

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this page

Generate financial periods

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Generate financial periods

You can generate financial periods for the financial year by selecting a frequency. Based on the frequency selected the system will generate the financial periods along with the start dates and end dates.

The system generates the financial periods based on the selected frequency.