A Appendix: Reconciliation List Select Column Definitions
This section provides definitions of the Reconciliation List select columns for the following dataset types that are referenced across the lists in the application:
Profile Dataset Types
This section describes definitions of the Profile dataset select columns.
The following table describes columns for Profile dataset types.
Table A-1 Profile Dataset Select Columns
Column Attributes | Definition |
---|---|
--Profile Segments Names 1-n |
'X' number of segments can be utilized |
--Custom Profile Attributes |
'X' number of profile attributes can be added |
Account ID |
Combination of Profiles Segments that makes the profile unique |
Account Type |
Account type is a user-configured list of values |
Active |
Active / inactive setting |
Auto Reconciliation Method |
Auto Reconciliation Method set |
Balance Range (High) |
High balance value set |
Balance Range (Low) |
Low balance value set |
Created By |
Name of user who created the profile |
Created On |
Date-time of profile creation |
Currency Bucket Default Currency (Entered, Functional, Reporting) |
Default currency |
Currency Bucket Enabled (Entered, Functional, Reporting) |
Enabled Currency Bucket (Yes/No) |
Days Until End Date |
Count of days between current date and end date |
Description |
Description |
Enabled Buckets |
Count of enabled currency buckets |
End Offset |
Sum of start offset and durations across all roles |
Enter Source System Balances |
Manual Balance Entry allowed (Yes/No) |
Enter Subsystem Balances |
Manual Balance Entry allowed (Yes/No) |
Group Profile |
Group Profile Set (Yes/No) |
Historical Rate |
Historical Rate Set (Yes/No) |
Last Updated By |
Name of user the profile was last updated by |
Last Updated On |
Profile last updated by date-time |
Match Balance Threshold (Number) |
Balance Comparison Match Threshold (Number) |
Match Balance Threshold (Percent) |
Balance Comparison Match Threshold (%) |
Match Type |
Match type the format is linked to |
Maximum Age Adjustments |
Age violation setting - adjustment |
Maximum Age Explanation |
Age violation setting - explanation |
Method |
Method the format is linked to |
Name |
Name of the profile |
Normal Balance |
Normal balance credit/debit setting |
Organizational Unit |
Assigned organizational unit |
Preparer |
Preparer name assigned |
Preparer (Actual) |
Preparer name that submitted the recon |
Preparer (Backup) |
Preparer (backup) name |
Preparer (Claimed) |
The reconciliation has been claimed by a Preparer (Yes/No) |
Preparer (Primary) |
Primary preparer from team who is currently assigned as Preparer for the Reconciliation. This can be:
|
Preparer Duration |
Duration set |
Preparer End Date |
End date set |
Preparer End Date (Actual) |
End date when role was completed |
Preparer Frequency |
Frequency set |
Process |
Process value set |
Rate Type |
Foreign exchange rate type set |
References (Count) |
Count of attached reference files |
Require Action By (Preparer) |
Team set as Any vs All |
Require Action By (Reviewer 1 - Reviewer 10) |
Team set as Any vs All |
Reviewer 1-10 |
Assigned reviewer |
Reviewer 1-10 (Backup) |
Assigned reviewer (backup) |
Reviewer 1-10 (Primary) |
Primary reviewer from team |
Reviewer 1-10 Duration |
Duration set for each role |
Reviewer 1-10 End Date |
End date set for each role |
Reviewer 1-10 End Date (Actual) |
End date when role was completed |
Reviewer 1-10 Frequency |
Frequency set |
Reviewer 1-10 Missing |
Assigned reviewing missing (Yes/No) |
Reviewer 1-10 Start Date |
Start date based on offset/durations set |
Reviewers (Count) |
Total count of assigned reviewers |
Risk Rating |
Assigned risk rating |
Rules (Count) |
Total count of rules directly on profile |
Schedule From |
Schedule from close or period end date |
Start Offset |
Start offset set |
Suggested Match Transactions Source (Count) |
Total count of source suggested matches |
Suggested Match Transactions Subsystem (Count) |
Total count of subsystem suggested matches |
Summary Profile |
Profile is a summary (Yes/No) |
Total Duration |
Count of days set to complete the recon |
Unmatched New Transactions Source System (Count) |
Total count of source new transactions |
Unmatched New Transactions Subsystem (Count) |
Total count of new subsystem transactions |
Unmatched Supported Transactions Source System (Count) |
Total count of unmatched supported source transactions |
Unmatched Supported Transactions Sub (Count) |
Total count of unmatched supported subsystem transactions |
Unmatched Transactions Source System(Count) |
Total count of unmatched source transactions |
Unmatched Transactions Subsystem (Count) |
Total count of unmatched subsystem transactions |
Valid |
Profile valid to create a reconciliation (Yes/No) |
Valid (Detailed) |
Profile detailed reason for Invalid |
Reconciliation Dataset Types
This section describes definitions of the Reconciliation dataset select columns.
The following table describes columns for Reconciliation dataset types.
Table A-2 Reconciliation Dataset Select Columns
Column Attributes | Definition |
---|---|
Account |
Name of the profile |
Account ID |
Combination of profiles segments that makes the profile unique |
Account Type |
Account type is a user-configured list of values |
Adjustments to Source System (Count) |
Total count of source adjustments |
Adjustments to Subsystem (Count) |
Total count of subsystem adjustments |
Aging Violation |
Aging Violation met (Yes/No) |
Aging Violation (Count) |
Total count of transactions with age violation |
Attachments Reconciliation (Count) |
Total count of attachments to reconciliation |
Attachments Total (Count) |
Total count of attachments to reconciliation & transactions |
Auto Approved (Level 1 - Level 10) |
Reconciliation was Auto Approved by Rule (Yes/No) |
Auto Reconciled |
Reconciliation was Auto Reconciled by Auto Reconciliation (Yes/No) |
Auto Reconciliation Method |
Auto reconciliation method set |
Auto Submitted |
Reconciliation was Auto Prepared by Rule (Yes/No) |
Balance Explanations (Count) |
Total count of balance explained transactions |
Balance Explanations Aging Violation |
Aging Violation met for Balance Explained transactions (Yes/No) |
Balance Explanations Aging Violation (Count) |
Total count of balance explained transactions with age violation |
Balance Range (High) |
High balance value set |
Balance Range (Low) |
Low balance value set |
Comments (Count) |
Total count of comments |
Created By |
Name of user who created the profile |
Created On |
Date-time of profile creation |
Currency Bucket Default Currency (Entered, Functional, Reporting) |
Default currency |
Currency Bucket Enabled (Entered, Functional, Reporting) |
Enabled Currency Bucket (Yes/No) |
Current Due Date |
Due date of active role |
Current Reviewer Level |
Reviewer level of active role |
Days Overdue |
Current date less overall end date (blank if not overdue) |
End Date |
End date set for last role on reconciliation |
End Date (Actual) |
End date when last role completed reconciliation |
Enter Source System Balances |
Manual Balance Entry allowed (Yes/No) |
Enter Subsystem Balances |
Manual Balance Entry allowed (Yes/No) |
Ever Been Late |
Has any Role Ever Been Late (Yes/No) If the Preparer was late, or any Reviewer was late, then Ever Been Late is set to Yes. |
Ever Been Late (Preparer) |
Has Preparer Role Ever Been Late (Yes/No) For example, assume that the Preparer was on time with the original submission. However, a Reviewer rejected the reconciliation and it is now reassigned to the Preparer. If the Reviewer was late, then Ever Been Late (Preparer) is set to Yes. |
Ever Been Late (Reviewer 1-10) |
Has each Reviewer Role Ever Been Late (Yes/No) For example, assume that Reviewer 1 was late. However, all other Reviewers completed on time and the reconciliation was approved within the end date. Ever Been Late (Reviewer 1) is set to Yes because Reviewer 1 was late. However, Late is set to No because all other Reviewers completed before the end date. |
Format |
Format name set |
Group Profile |
Group Profile Set (Yes/No) |
Historical Rate |
Historical Rate Set (Yes/No) |
Last Updated By |
Name of user the reconciliation was last updated by |
Last Updated On |
Reconciliation last updated by date-time |
Late |
Late when the current date is greater than the Due Date of the reconciliation |
Late (Preparer) |
Preparer is late when either of the following is true:
Once the Preparer submits the reconciliation, Late is set to No. If the Reconciliation is re-opened to the Preparer after their submission End Date, this attribute is set to Yes. Once the Preparer submits the reconciliation, Late is set to No. |
Late (Reviewer 1-10) |
Reviewer is late when the current date is greater than the Due Date for any Reviewer. If the Reconciliation is re-opened to the Reviewer after their End Date, this attribute is set to Yes. Once the Reviewer has approved, Late with Reviewer is set to No. Example: Assume that Reviewer 1 approves a reconciliation after the end date and the reconciliation is now assigned to Reviewer 2. While Reviewer 1 was late, both Late and Late with Reviewer 1 are set to Yes. After Reviewer 1 approves the reconciliation, the Late and Late with Reviewer 1 are set to No. However, the Ever Been Late and Ever Been Late with Reviewer 1 are set to Yes and continue to be set to Yes even after Reviewer 1 approves the reconciliation. |
Match Balance Threshold (Number) |
Balance Comparison Match Threshold (Number) |
Match Balance Threshold (Percent) |
Balance Comparison Match Threshold (%) |
Maximum Age Adjustments |
Age Violation setting - Adjustment |
Maximum Age Explanation |
Age Violation setting - Explanation |
Method |
Method the format is linked to |
My End Date |
End date for the role you have on the reconciliation |
My Role |
Role you have on the reconciliation |
Name |
Name of the profile |
Normal Balance |
Normal Balance Credit/Debit Setting |
Normal Balance Violation |
Actual balance loaded conflicts with normal Balance Credit/Debit Setting (Yes/No) |
On Time |
Active role End Date (Actual) is less than or equal to End Date (Yes/No) |
Organizational Unit |
Assigned organizational unit |
Period |
Name of period associated with the object |
Period Close Date |
Close date of period selected |
Period End Date |
End date of period selected |
Period Start Date |
Start date of period selected |
Preparer |
Preparer name assigned |
Preparer (Actual) |
Preparer name that submitted the recon |
Preparer (Backup) |
Preparer (backup) name |
Preparer (Claimed) |
The reconciliation has been Claimed by a Preparer (Yes/No) |
Preparer (Primary) |
Primary preparer from team who is currently assigned as Preparer for the Reconciliation. This can be:
|
Preparer Duration |
Duration set |
Preparer End Date |
End date set |
Preparer End Date (Actual) |
End date when role was completed |
Preparer Frequency |
Frequency set |
Process |
Process value set |
Rate Type |
Foreign exchange rate type set |
Reassignment Requested |
Reassignment Request Active (Yes/No) |
Rejections (Count) |
Total count of rejections across all reviewers |
Require Action By (Preparer) |
Team set as Any vs All |
Require Action By (Reviewer 1-10) |
Team set as Any vs All |
Responsible |
Name of active user for the reconciliation |
Reviewer 1-10 |
Assigned reviewer |
Reviewer 1-10 (Actual) |
Reviewer who approved the recon |
Reviewer 1-10 (Backup) |
Assigned reviewer (backup) |
Reviewer 1-10 (Primary) |
Primary reviewer from team |
Reviewer 1-10 Claimed |
The reconciliation has been claimed by a Reviewer (Yes/No) |
Reviewer 1-10 Duration |
Duration set for each role |
Reviewer 1-10 End Date |
End date set for each role |
Reviewer 1-10 End Date (Actual) |
End date when role was completed |
Reviewer 1-10 Frequency |
Frequency set |
Reviewer 1-10 Missing |
Assigned Reviewing Missing (Yes/No) |
Reviewer 1-10 Rejections (Count) |
Total count of rejections for by role |
Reviewer 1-10 Start Date |
Start date based on offset/durations set |
Reviewers (Count) |
Total count of assigned reviewers |
Risk Rating |
Assigned risk rating |
Rules (Count) |
Total count of rules directly on profile |
Source System Aging Violation |
Aging violation met for source (Yes/No) |
Source System Aging Violation (Count) |
Total count of transactions with age violation in source |
Start Date |
Start date |
Status |
Current status |
Status (Detailed) |
Detail current status |
Status (Icon) |
Icon representation of current status |
Subsystem Aging Violation |
Aging violation met for subsystem (Yes/No) |
Subsystem Aging Violation (Count) |
Total count of transactions with age violation in subsystem |
Summary Profile |
Profile is a summary (Yes/No) |
Total Duration |
Count of days set to complete the recon |
Transactions (Count) |
Total count of transactions |
Variance Explanations (Count) |
Total count of variance explanations |
Variance Period |
Prior period for which current period is compared to |
Balance Dataset Types
This section describes definitions of the Balance dataset select columns.
The following table describes columns for Balance dataset types.
Table A-3 Balance Dataset Select Columns
Column Attributes | Definition |
---|---|
Adjusted Source System (Entered, Functional, Reporting) |
End Balance less Adjustments = Adjusted Balance |
Adjusted Subsystem (Entered, Functional, Reporting) |
End Balance less Adjustments = Adjusted Balance |
Adjustments to Source System (Entered, Functional, Reporting) |
Amount total of adjustments to source |
Adjustments to Subsystem (Entered, Functional, Reporting) |
Amount total of adjustments to subsystem |
Balance Exists |
Source or subsystem balance has been loaded into any bucket |
Balance Exists (Source System) |
Source balance has been loaded into any bucket |
Balance Exists (Subsystem) |
Subsystem balance has been loaded into any bucket |
Balance Explanations (Entered, Functional, Reporting) |
Amount total of balance explanation transactions |
Difference (Entered, Functional, Reporting) |
Source and subsystem end balance difference |
Last Balance Load |
Date-time of last balance loaded |
Last Balance Loaded By |
Name of user who last loaded a balance |
Period Activity (Entered, Functional, Reporting) |
Previous period end balance less current period end balance |
Prior Period Balance (Entered, Functional, Reporting) |
End balance from prior period according to "Prior Period" setting on Period configuration |
Source System Balance (Entered, Functional, Reporting) |
Source balances loaded |
Source System Balance (Default Currency) - Entered, Functional, and Reporting |
Source system's single numeric balance for all currencies in a currency bucket. |
Source System Count of Currencies (Entered, Functional, Reporting) |
Count of unique currencies loaded into the source system |
Source System Less Matched In Transit (Entered, Functional, Reporting) |
Matched in transit total |
Source System Less Unmatched (Entered, Functional, Reporting) |
Less unmatched total |
Source System Less Unmatched Supported (Entered, Functional, Reporting) |
Less unmatched supported total |
Subsystem Balance (Entered, Functional, Reporting) |
Subsystem balances loaded |
Subsystem Balance (Default Currency) - Entered, Functional, and Reporting |
Subsystem's single numeric balance for all currencies in a currency bucket. |
Subsystem Count of Currencies (Entered, Functional, Reporting) |
Count of unique currencies loaded into the subsystem |
Unexplained Difference (Entered, Functional, Reporting) |
Amount of unexplained difference |
Variance Explanations (Entered, Functional, Reporting) |
Total amount of variance explanations |
Variance Period Balance (Entered, Functional, Reporting) |
Variance period balance loaded |
Transaction Dataset Types
This section describes definitions of the Transaction dataset select columns.
The following table describes columns for Transaction dataset types.
Table A-4 Transaction Dataset Select Columns
Column Attributes | Definition |
---|---|
Action Plan |
Action plan value set |
Action Plan Attachments (Count) |
Total count action plan attachments |
Action Plan Close Date |
Action plan close date set |
Action Plan Closed |
Action plan closed (Yes/No) |
Action Plan Comments (Count) |
Total count action plan comments |
Age |
Days between transaction date and period-end date. If Action Plan is enabled, Age is days between Transaction Date and Action Plan Close Date. |
Amortization |
Transaction is amortizing (Yes/No) |
Amortization End Date |
End date of amortization schedule |
Amortization Method |
Amortizing method set |
Amortization Start Date |
Start date of amortization schedule |
Amortization Start Period |
Start period for amortization schedule |
Amortized/ Accreted Amount (Entered, Functional, Reporting) |
Amount amortized for selected period |
Amount (Entered, Functional, Reporting) |
Remaining amortized amount for selected period |
Amount Overridden (Functional, Reporting) |
Transaction foreign exchange calculation override (Yes/No) |
Attachments (Count) |
Total count of attachments for transaction |
Carried Forward |
Transaction was copied forward from previous reconciliation (Yes/No) |
Child Account |
Child account associated with transaction |
Close Date |
Close date for transaction |
Comments (Count) |
Total count of comments |
Flag |
Reviewer flag set (Needs Attention/OK) |
Half-Month Convention |
Amortizing half-month convention set |
Journal ID |
Unique ID of the enterprise journal |
Journal Name |
Name of the enterprise journal |
Journal Workflow Status |
Workflow status of the Journal in Enterprise Journals |
Journal Posting Status |
Posting status of the enterprise journal (Posted or Not Posted) |
Journal Posting Message |
Message returned from ERP after posting |
Last Updated By |
Name of user that last updated one or more of the transaction attributes Short Description, Long Description, Transaction Date, Close Date. |
Last Updated On |
Transaction last updated by date-time for one or more of the transaction attributes Short Description, Long Description, Transaction Date, Close Date. |
Long Description |
Value of long description |
Number of Periods |
Count of periods in amortizing schedule |
Original Amount (Entered, Functional, Reporting) |
Amortizing transaction original amount |
Rate Used |
Exchange rate used for transaction translation |
Remaining Periods |
Amortizing transaction remaining periods on schedule |
Short Description |
Value of short description |
Sub-Segment |
Sub-Segment ID associated with the transaction |
Transaction Date |
Date of transaction |
Type |
Transaction type (Adjustment to Source/Sub, Balance Explanation, Variance) |