Reconciliations List

Overview Dashboard

Compliance Dashboard

Worklist

Transactions with the same key attributes cannot be loaded.

The attribute is hidden from users.

Transactions are sorted by the attribute.

Values are required for the attribute.

You must select either Actual or Budget as the scenario for the data.

You cannot load data into reconciliations with a status of Closed.

Only users with the administrator role can run data loads.

If there is no change in the balance, the reconciliation is not updated.

Currency Code

Currency Bucket

Period

Reconciliation ID

Entity

Amount

You can manually match transactions only if the amounts are within the tolerance.

Transactions for which auto-matching rules did not find matches can be manually matched.

You must be a power user or service administrator to create manual matches.

You can create adjustments to balance a match set.

The Data Management data load fails.

You are prompted whether to overwrite the pre-mapped balances.

The balances loaded through Data Management overwrite the pre-mapped balances.

The reconciliation takes the balances loaded through Data Management and the pre-mapped balance load, and totals them.

SWIFT MT940

BAI

EDI

XML

Calendars are associated with periods and organizational units.

One period may have many calendars to reflect different date configurations for the period.

An organizational unit can be assigned many calendars to enable reconciliations for different financial dates.

Calendars set the dates and frequencies for each period.

They can control the records that you see in the list views.

They can be used by the rules engine.

They allow you to save columns to view records on the screen.

You can apply them against unmatched transactions.

In his User Preferences, John should select the Approve Reassignments option.

Add John to the Reassignment Approvers security group.

On the Reassignment Requests tab in System Settings, in the Allow Reassignment Request Approval By option, select Users.

On the Manage Users tab of the Access Control page, assign John the Reassignment Approvers role.

Changes made by the deleted member are reassigned to the primary member of the team for review and approval,

The reconciliation is flagged as invalid and needs to be re-created by the administrator.

Changes made by the deleted member are reverted and the deleted member is removed from the reconciliation as preparer.

Changes made by the deleted member are kept intact and the deleted member still appears as the original preparer.

It is excluded from the report

Unmatched Supported

Matched In Transit

Unmatched

Balance Comparison

Transaction Matching

Variance Analysis

Account Analysis

reconciliations with a single data source, like a clearing account

reconciliations that are typically zero balance accounts with low activity

reconciliations that have amortizing transactions

reconciliations with 2 or more data sources, like a cash or accounts receivable account

accounts with high volumes of data

Match types are exported to a .zip folder.

Import can update match types with Pending status only.

Match types are exported to comma-separated (CSV) files.

Import can update match types with Approved status only.

Source system

NZP

0

Include Null

Unexplained difference is zero

Balance is zero

Zero activity

Balance is normal

No transactions

Select the data source to adjust.

Select an Adjustment Type.

Enter an adjustment amount.

Enter a date for the adjustment.

Edit the due date in the reconciliations for the organizational unit.

Create a holiday rule and assign it to the organizational unit.

Create a calendar and assign it to the organizational unit.

Add a rule to the Rules tab of the profiles for the reconciliations.

In the Workflow tab of the reconciliations, select a backup preparer in the Backup Preparer field.

In User Preferences, change your status to Out of Office.

In the Actions menu of the reconciliations, select Request Reassignment.

Click the Release button in the reconciliations to release it to the other team members.