Control Lists

You can set up control lists for:

Item Types

When a Preparer creates Reconciliation Detail Items, these are the types of items that can be created. You can add new Item Types.

NOTE: An Item Type cannot be deleted.

Stored Value: Text written to the Account Reconciliations tables when an item is added. The user does not see this.

Display Value: Item Type text that displays to the user when reconciling.

Description: Type of item added to a reconciliation.

  • Correction (BS) or Correction (IS): These items indicate an issue with the current balance in the GL and requiring a correction.

  • Explained: A manually entered item.

  • Statement: An item supported with an attached statement such as a cash account statement.

Active: By default, this is set to True. If False, these Item Types do not display when creating items.

Reason Codes

When you click Reject or Unapprove, you are prompted to provide a Reason Code for the change. You can edit the reason codes or add new ones.

Stored Value: Text written to the Account Reconciliations tables when a reason is added. The user does not see this.

Display Value: Reason Code text that displays to the user when entering a reason.

Active: By default, this is set to True. If False, these Reason Codes do not display when rejecting or unapproving.

Close Dates

Close Dates associate a Workflow Time Period with a specific day and time. The purpose of this is to pivot from this date and time to determine if someone is late with their assignments, regardless of their location.

NOTE: If the Close Dates are not set up for a given period, then the date is 1900/01/01 on the Reconciliations page.

WF Time: Workflow Time Period. Click the + button to add one record for each Workflow Time Period related to the Source Scenario.

NOTE: The list of Workflow Time periods is for the currently selected Workflow Year plus the following year. This includes all frequencies of time (half years, quarters, months). The Input Frequency properties of each scenario (for example, Monthly) must match.

Close Date Local (Day 0): Set to the date when the financial close starts for this Workflow Time Period.

Close Hour (0 Hour): Set to the hour of day for what local time the close starts. For instance, if this is 5:00 PM, set this as 17. Local time is determined by the time zone where your OneStream server is located.

Close Date UTC (Day 0, Hour 0): No entry is required because saving the record calculates the value. The Close Date Local (Day 0) and Close Hour (0 Hour) are converted to the UTC (Coordinated Universal Time, aka GMT/Greenwich Mean Time) equivalent for the purposes of comparing the current local time for when a Reconciliation Inventory item is due.

Aging Periods

Aging periods are used to review your detail item aging, in total, so you can determine which balances need to be written off. The aging period is automatically assigned to an item upon Save based on the calculated aging and the periods created. Aging periods are used in the Aging Pivot analysis report. Each start date must be unique.

Period Start Date: Click the + button to add aging periods. For example, if you enter 16 for a new period start date, the first period is 0-15 days and the next period is 16-30 days.

The default period start dates are:

  • 0: 0 to 30 days

  • 31: 31 to 60 days

  • 61: 61 to 90 days

  • 91: 91+ days

Attribute Columns

You can create up to three custom attribute columns to display in the Account Reconciliations page for users. They can be free-form text boxes or have a drop-down menu of values. These customized attribute columns will also display in the Inventory page and the Edit Reconciliation Attributes dialog box.

To add an attribute, first enter a display name and then select the Active check box for the attribute.

Display Name: Enter a name for the attribute to display on the Account Reconciliations page. This name must be unique.

Active: Select this check box to make the attribute visible on the Account Reconciliations page.

Dropdown: Select this check box to add a menu of values for users to select from.

Value: After you select the Dropdown check box for an attribute and save, the Dropdown Values section displays. Enter each value to display for users in a drop-down menu. Each value must be unique within that attribute.

IMPORTANT: Editing or removing active values that are in use may affect work in progress.