Schedules, subschedules, and schedule details

Schedules are available if Financial Consolidation or Budgeting & Planning, or both are activated. Schedules categorize financial data. Schedule details provide detail of financial data. Schedule details are used, typically, to split data into movements, write-offs, or corrections.

Optionally, you can load a default set of schedules and schedule details. You can use these as they are, or adjust them to your requirements.

For each schedule, you can define schedule details and then assign schedules to accounts. Schedules and schedule details can be created, uploaded, or imported independently. However, to upload or import both the schedule details and the assignments, ensure that you import the schedules first, and then the details.

When you create a schedule, there is an option to use the opening and closing balance. If you select this option, system-generated Opening balance and Closing balance elements are created to enable the import or calculation of those balances.

A system-generated element is provided for currency translation differences.

Schedules can be grouped. These rules apply:

Schedules that use the same detail must not be grouped.
Details must not be added to schedule groupings.
Schedules that use the Use Opening/Closing balance option cannot be grouped with schedules that do not.

In Financial Consolidation, you can use Statistical Opening Balances to load your data into them and compare those values with the Opening Balance values that are generated by the Carry Forward Schedules process. For more information on Statistical Opening Balances, see "Schedules".

This table shows an example of a schedule and subschedule structure:


ID	Name	Description
A	Assets & Depreciations	Schedule
A1	Assets Gross Value	Default subschedule of schedule A
A1_OB	Assets Gross Value – Opening balance	System-generated schedule detail of subschedule A1
12	Increases	Predefined schedule detail of schedule A
A2	Depreciation	Subschedule of schedule A
B	Receivables	Schedule
C	Payables	Schedule
D	Accruals	Schedule
D_OB	Accruals – Opening balance	System-generated schedule detail of schedule D
E	Equity	Schedule

Note: Financial Consolidation does not have default schedule and subschedule details. System-generated details, such as A1_OB or A1_CB, are not considered default because users can define custom details.