Defining Linkages Between Schedules and Statements

While statements are fairly standard in format, the same cannot be said for schedules. Therefore, depending on the layout of the schedule, the method to define the linkages in schedules varies, depending on whether the schedule is a standard schedule or a Do-It-Yourself schedule.

Like statements, a schedule can be either a source for statements and other schedules, or a target for statements, other schedules and notes. However, template authors only need to define the schedule when it is the source.

Do-It-Yourself schedules typically do not have a one-to-one format relationship with the statements to which they are linking. Most statements present current and prior year in four-column or eight-column (in the case of IFRS) layouts. Because they are so dissimilar, it is necessary to define the meaning of each column of the schedule.

Prerequisites

To define linkages in schedules, you must have created these schedules as content.

Defining Linkages in a Standard Schedule

The following instructions enable you to define a linkage for a standard four-column (GAAP) or eight-column (IFRS) schedule.

Procedure

  1. Open the Schedules Library document.
  2. Select the content that is based on the Generic Schedule.
  3. Double-click the Link to field.
  4. Select the appropriate subtotal or total that appears in the dialog.
  5. Click OK.

By default, these schedules are created as manual linkage sources. When they are defined by template authors, end users can manually link in client files. Alternatively, choosing the Automatic type and selecting the appropriate Map or Group number will automatically link the schedule to the line in the statement.

Results

The selected total line is now a source and can be used to link to another schedule or statement.

Defining Linkages in a Do-It-Yourself Schedule

Do-It-Yourself schedule layouts can vary from schedule to schedule, so it is necessary to define the fields in the schedule that represent the source data.

Procedure

  1. Open the Schedules Library document.
  2. Select the Do-It-Yourself schedule that is being customized.
  3. Double-click on the Link to field, or right-click on the schedule name and select Custom Linkage.
  4. In the definition screen, in the Number of Additional Linkage Points field, type the number of additional linkage points. This represents the number of columns in the source Do-It-Yourself schedule.
  5. In the Description field, type a meaningful name. This is the name end users will see if they manually create the link in the financial statements.

  6. In the Additional Linkage Points section, click in the first field then click the corresponding cell in the schedule below. This is defining the column layout for the schedule. Repeat this for each data point that is to be linked.

    Note: The Simple Linkage check box associates tables with matching column layouts by automatically selecting the columns that should be linked to each other. For example, if you have a five-column schedule that you want to link to a five-column statement, the Simple Linkage option should be used.

  7. When all linkage points have been defined, click OK to close the linkage window.

By default, these schedules are created as manual linkages. When they are defined by template authors, end users can manually link in client files. Alternatively, choosing the Automatic type and selecting the appropriate Map or Group number will automatically link the schedule to the line in the statement.

Results

The Do-It-Yourself schedule linkage source is defined.