1. Setting Up and Configuring Account Reconciliation
  2. Setting Up Reconciliation Compliance
  3. Configuring Reconciliation Compliance
  4. Defining System Settings
  5. Configuring Date and Time Settings

Configuring Date and Time Settings

Use the Date and Time configuration settings to set a global time zone for the service, due dates, cutoff time for Transaction Matching adjustments, and other date/time settings.

Due Date Reminder Notifications are emailed to preparers and reviewers in these conditions:

  1. Responsibility for reconciliations changes to the preparer or reviewer.

  2. A due date is missed.

  3. A due date is approaching for reconciliations. (You must configure the number of days in advance of the due date. See the next procedure.)

    Note:

    When choosing a time-zone that follows daylight savings, the system will include an additional one hour beyond the time set during daylight savings. If you prefer not to add this additional hour, the Service Administrator can set the Reconciliation Due Time and/or Transaction Matching Adjustment Cutoff Time one hour earlier during daylight savings.

Notifications pertaining to the conditions 1 and 2 require no additional configuration and are sent based on information contained within the reconciliations.

To define date and time settings:

  1. From Home, click Application, then Configuration and then Settings.
  2. On System Settings, select Date and Time.
  3. In Service Time Zone, select the time zone for your service. This global setting determines the time zone used for settings such as reconciliation open time, reconciliation due time, and Transaction Matching adjustment cutoff time. For example, if you set Service Time Zone to (UTC-8:00) Los Angeles – Pacific Time (PT) and set Reconciliation Due Time to 8:00 PM, reconciliations will be due by 8:00 PM Pacific Time of the day on which a reconciliation is due.

    Note: The Automated Maintenance Window is not be impacted by the Service Time Zone. It uses its own time zone setting in the Tools > Daily Maintenance.

  4. In Reconciliation Open Time, select the time of the day that the service performs the daily task of opening reconciliations.

    The selected time is in the time zone set by Service Time Zone. If you set the open time to Midnight, the reconciliation opens at 12 AM of the set day. If the user’s time zone is different from the service time zone, the corresponding time in the user’s time zone is displayed to the right of this field.

  5. Select the end of the day for late reconciliations in Reconciliation Due Time. The selected time is in the time zone set in Service Time Zone. For example, if you set the service time zone to Pacific Time and Reconciliation Due Time to 6:00 PM, a reconciliation whose due date is 16 June will be due at 6:00 PM Pacific Time on 16 June. If you set the due time to Midnight, the due date is 11:59:59 PM of that day.

    If the user’s time zone is different from the service time zone, the corresponding time in the user’s time zone is displayed to the right of this field.

  6. In Reconciliation Due Reminder, enter the number of days before a due date to send reminder notifications.

    If the user’s time zone is different from the service time zone, the corresponding time in the user’s time zone is displayed to the right of this field.

  7. In Transaction Matching Adjustment Cutoff Time, select the time of the day before which Transaction Matching adjustments must be created so that their Adjustment Accounting Date is set to the current date. Adjustments created after the cutoff time will be created with an Adjustment Accounting Date set to the next day. This applies to both manually and automatically created adjustments.

    This setting works in conjunction with Service Time Zone.

    For example, if Service Time Zone is set to Eastern Time and Transaction Matching Adjustment Cutoff Time is set to 8:00 PM, any adjustments created before 8 PM, Eastern Time, on a day will have the Adjustment Accounting Date set to the current date. Adjustments created after 8:00 PM, Eastern Time, on a day will have the Adjustment Accounting Date set to the next day.

  8. In Transaction Matching Journal Export Date Format, select the format used for date columns when you create an Export Journals job to export adjustments or transactions as journal entries.

    If no selection is made for this setting, the default format used is MM/dd/yyyy.