Defining Accounting Calendar

Accounting calendar determine the accounting period to which a financial transaction will be booked. The following points describe how the system determines a financial transaction's account period:

  • Every financial transaction references an accounting date and its contract
  • Every contract references a contract type
  • Every contract type references a GL division
  • Every GL division references an accounting calendar
  • The accounting calendar contains the cross reference between the accounting date specified on the financial transaction and related accounting period in your general ledger
CAUTION: This information must be the same as the information in your financial database.

To add or review an accounting calendar, choose Admin Menu, Accounting Calendar.

Description of Page

Enter a unique Calendar ID and Description for the calendar.

Enter the Number Of Periods for the calendar. Don't count the adjustment period, if you use one, or any special "system" periods.

Specify the Fiscal Year, each Accounting Period in that year, a Period Description, the Begin Date and the End Date.

When you enter begin and end dates, you can define monthly calendar periods or any fiscal period that matches your accounting calendar (weekly, bimonthly) as long as the begin and end dates of successive periods do not overlap. Every day of the year must be included in a period; do not leave gaps between period dates.

For each fiscal period, enter the Open From Date and Open To Date. These dates define when that particular business dates are open for posting financial transactions to that fiscal period. For example, you might calculate a bill on Sept 1 for usage recorded on 31 August. To post this financial transaction in the August period, you must keep it open through Sept 1.

As time passes, you will need to return to this transaction to manually enter ensuing years. You can enter several years at a time or incorporate the task into end-of-year system maintenance.

Where Used

Follow this link to open the data dictionary where you can view the tables that reference CI_​CAL_​GL