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) |
Preparer who has claimed from the team |
|
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) |
Preparer who has claimed from the team |
|
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 |
Reviewer who has claimed from the 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 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) |