Create consolidation periods in a batch

The Define Periods in Batch page allows you to create multiple consolidation periods at the same time. This is useful when you need to consolidate your budgets in batches.

To access the Define Periods in Batch page, click Group > Periods > Define Periods in Batchtab.

Page layout

The Define Periods in Batch page is organized into two main sections: Period Configuration and Carry Forward Settings.

Period Configuration

The Period Configuration section defines the time range and properties of the consolidation period being created.

Field	Description
From Year / To Year	The start and end years for the batch of consolidation periods.
From Month / To Month	The start and end months for the batch. Select a month from the drop-down list.
Interval	Defines how the periods are created. Options are: 1: Monthly, 2: Bi-monthly, 3: Quarterly, 4: Tri-annually, 6: Semi-annually, 12: Yearly.
Category	The data category for the consolidation periods (for example, Actuals, Budget).
Version	The version number for the consolidation periods.
Description	A description of the consolidation periods.
Currency	The group currency used for the consolidation periods. Select from the drop-down list.
Decimals	The number of decimal places used to display values.
Closing date	The closing date for the consolidation periods.
First journal entry	The first number used for journal entries. This number increments for all adjustments, regardless of the journal they belong to. This allows you to refer to any adjustment by its number alone.
Active	When selected, the consolidation period is active and available for use.
Locked	When selected, the consolidation period is locked. A locked period is available for review only; no data can be modified. You can enter an explanation in the field next to this option.
Reference period	The consolidation period used as the source for copying structures and data when creating new periods.
Parent Company	The parent (holding) company for the new consolidation period. Select from the drop-down list.

Carry Forward Settings

The Carry Forward Settings section defines how adjustment data is handled when creating new consolidation periods. It is divided into three subsections: Local Bundle, Local Adjustments, and Consolidated Adjustments.

Local bundle

• Not to copy — bundle data is not copied to the new period.

• Copy all amounts — all bundle data is copied to the new period.

• Copy only Equity and Participations — only equity and participation data is copied.

• Transfer of reserves — allows inter-group transfers from one period to another when creating new periods during the year.

Local adjustments

• Not to copy — local adjustment data is not copied to the new period.

• To copy — local adjustment data is copied to the new period.

• To carry forward — local adjustment data is carried forward to the new period.

Consolidated adjustments

• Not to copy — consolidated adjustment data is not copied to the new period.

• To copy — consolidated adjustment data is copied to the new period.

• To carry forward — consolidated adjustment data is carried forward to the new period.

Schedule

The Schedule field - set the date and time at which the new period batch is created and executed.

Create quarterly consolidation periods

1. Under the From parameters, enter the Year , and in the Month field, select the starting month of the quarter .

2. Under the To parameters, enter the Year, and in the Month field, select the ending month of the quarter.

3. In the Interval field, select 3: Quarterly to generate three months of quarterly data.

4. In the Category field, select the BUD (Budget) data category.

5. Complete the remaining fields as needed. Refer to the field descriptions above for guidance.

6. When you have entered all required information, save your input to create the consolidation periods.