Transaction Matching Report Output Descriptions

Reconciliation Configuration Report

Output Columns	Descriptions
Account ID	The identifier associated with the reconciliation.
Name	The name of the reconciliation.
Match Type ID	The identifier associated with the match type.
Match Type Name	The name of the match type.
Preparer	Name of the active preparer for the reconciliation.
Description	The reconciliation description.

Match Type Configuration Report

Output Columns	Descriptions
Match Type ID	The identifier associated with the match type.
Match Type Name	The name of the match type.
# Data Sources	The count of data sources in the match type.
Status	The status of the match type.
Source Systems	The source system data sources.
Sub Systems	The subsystem data sources.
# Match Processes	The count of match processes in the match type.
# Rules	The count of rules created for the match type.
Description	The description of the match type.

Closed Adjustments Report

Output Columns	Descriptions
Account ID	The identifier associated with the reconciliation.
Name	The name of the reconciliation.
Adjustment Type	The adjustment type used when creating the adjustment.
Adjustment ID	The value used for ID attribute when creating the adjustment.
Adjustment Name	The value used for Name attribute when creating the adjustment.
Adjustment Description	The value used for Description attribute when creating the adjustment.
Source	The source to which the adjustment is posted.
Created Date	The date the adjustment was created.
Accounting Date	The accounting date of the adjustment.
Amount	The amount adjusted.
Reverse Status	Indicates whether this adjustment is a reverse adjustment.

Open Adjustments Report

Output Columns	Descriptions
Account ID	The identifier associated with the reconciliation.
Name	The name of the reconciliation.
Adjustment Type	The adjustment type used when creating the adjustment.
Adjustment ID	The value used for ID attribute when creating the adjustment.
Adjustment Name	The value used for Name attribute when creating the adjustment.
Adjustment Description	The value used for Description attribute when creating the adjustment.
Source	The source to which the adjustment is posted.
Created Date	The date the adjustment was created.
Accounting Date	The accounting date of the adjustment.
Amount	The amount adjusted.
Reverse Status	Indicates whether this adjustment is a reverse adjustment.

Reconciliation Status Report

Output Columns	Descriptions
Account ID	The identifier associated with the reconciliation.
Name	The name of the reconciliation.
Match Type ID	The identifier associated with the match type.
Match Type Name	The name of the match type.
Unmatched Transactions	The count of unmatched transactions.
Supported Transactions	The count of supported transactions.
Open Adjustments	The count of open adjustments.

Supported Transactions Report

Output Columns	Descriptions
Account ID	The identifier associated with the reconciliation.
Name	The name of the account.
Transaction Type	The support type used when supporting the transaction.
Transaction ID	The value used for the ID attribute when supporting the transaction.
Transaction Name	The value used for the Name attribute when supporting the transaction.
Transaction Description	The value used for the Description attribute when supporting the transaction.
Source	Data source of the transaction supported.
Amount	The net total of the amount in the support group.
# Transactions	The count of transactions in the support group.

Match Type Data Source Configuration Report

Because the report contains a large number of columns, the image above shows only some columns. It is recommended that you generate the report in Microsoft Excel format.

Output Columns	Descriptions
Match Type ID	The identifier associated with the match type.
Match Type Name	The name of the match type.
Match Type Description	The description of the match type.
Match Type Instructions	The instructions or explanation for users when using the match type.
Match Type Status	The status of the match type.
Data Source ID - Internal	The unique, system-generated, identifier of the data source.
Data Source ID	The identifier of the data source that is displayed in the Account Reconciliation User Interface.
Data Source Name	The name of the data source.
Use in Balance Report As	Valid values are Source System or Sub System.
Allow Transactions to be Deleted	Indicates if transactions can be deleted for this match type.
Allow Transactions To Be Split	Indicates if transactions can be split for this match type.
Data Source Attribute ID - Internal	The unique, system-generated, identifier of the data source attribute.
Data Source Attribute ID	The identifier of the data source attribute in the Account Reconciliation User Interface.
Data Source Attribute Name	The name of the data source attribute.
Data Source Attribute Type	The type of data source attribute.
Data Source Attribute Key	The key of the data source attribute.
Data Source Attribute Required	Indicates if the data source attribute is mandatory.
Data Source Attribute Calculation	Indicates if the data source attribute is a calculated attribute.
Data Source Attribute Accounting Date	Indicates if the attribute is the Accounting Date for the data source.
Data Source Attribute Balancing Attribute	Indicates if the attribute is the Balancing Attribute for the data source.
Data Source Attribute Allow Edit	Indicates if the data source attribute can be edited.
Data Source Attribute Default Value	The default value for the data source attribute.
Data Source Attribute List of Values	The list of values for an attribute of type List.

Match Type Rule Configuration Report

Because the report contains a large number of columns, the image above shows only some columns. It is recommended that you generate the report in Microsoft Excel format.

Output Columns	Descriptions
Match Type Name	The name of the match type.
Match Process ID - Internal	The unique, system-generated, identifier of the match process.
Match Process ID	The identifier of the match process.
Match Process Name	The name of the match process.
Number Of Data Sources	The count of data sources in the match type.
Source System Data Source	The data source that represents the source system.
Sub System Data Source	The data source that represents the subsystem.
Set Adjustment Accounting Date	The setting for Adjustment Accounting Date. Options are Match Type or Latest Accounting Date in the Match Group.
Rule Order Number	The number that represents the order in which the rule is run.
Rule ID - Internal	The unique, system-generated, identifier of the match rule.
Rule ID	The identifier of the match type rule.
Rule Name	The name of the match type rule.
Rule Description	The description of the match type rule.
Rule Type	The type of the match type rule.
Rule Match Status	The status of the match type rule. Options are Suggested or Confirmed.
Rule Active	Indicates if the match type rule is active or inactive.
Rule Filter Source	The name of the source system filter that is used to filter unmatched transactions required for the matching rule.
Rule Filter Sub	The name of the subsystem filter that is used to filter unmatched transactions required for the matching rule.
Rule Groups Source	The name of the source system group that is used to summarize transactions that will be used for the matching rule.
Rule Groups Sub	The name of the subsystem group that is used to summarize transactions that will be used for the matching rule.
Rule Condition Name	The name of the rule condition.