RCAM GL Reconciliation Report

The report is divided into two primary components:

• RCAM GL Condensed, the default landing view after prompt selection. Designed for high-level reconciliation, it enables users to quickly identify discrepancies such as total amount variances, mismatches between RCAM entry and GL transaction data, and RCAM entries without corresponding GL transactions.
• RCAM GL Details, an expanded view for deeper analysis. This view includes additional GL columns (e.g., Journal Header, Transaction Description, Journal Created By Name Full, F-P-F-F-A) to support investigation of amount variances and data mismatches.

Together, these views support the reconciliation of RCAM commitments to GL activity and facilitate the resolution of any discrepancies.

This report answers the following questions:

• Have all RCAM entries been fully transferred to the General Ledger?
• What are the Source and Destination chartstring details for resource commitments my unit has made (Financial Unit, Project, Fund, Function, Account)?
• Which of my RCAM entries do not have matching GL transactions (missing GL transaction, amount variance, name mismatch)?
• Are there lumped GL transfers or reversals associated with a specific commitment(s)?

• The RCAM GL Reconciliation Report displays “Pushed” resource commitment records and the associated General Ledger data.
• Data availability is governed by row-level security. Users will only see Financial Units for which they have approved access.
• The report allows the user to search for records by CTID and Commitment Name.
  • Partial values are accepted in search fields.
  • Search fields are not case-sensitive.
• The report displays current values tied to a record, as processed in the RCAM by the prior business day.
  • The report does not provide real-time data, but any changes processed in the RCAM should be reflected by the following business day.
  • Prior year data is available in the reports, though only currently stored values are reflected (i.e., no audit trail capability).
• Prompt selections entered by the user can be viewed on the ‘Parameters’ tab. Prompt selections entered by the user apply to both the ‘RCAM GL Condensed’ tab and ‘RCAM GL Details’ tab.
• The ‘Variance Description’ column returns the following values:
  • MATCH, exact match between RCAM Total Amount and GL Transaction Signed Amount, including chartstring alignment
  • Mismatch – Amount, mismatch between RCAM Total Amount and GL Transaction Signed Amount
  • Mismatch – Name, mismatch between RCAM ID/Name and GL Transaction Description
  • No Matching GL Transaction, RCAM record exists with no corresponding GL transaction

Respond to Prompts

Upon launch, the report displays a Prompt page where results can be filtered via one or more optional prompts. If no prompt selections are made, the report will return all records the user has access to based on row-level security assignments.

Accounting Period - Select the Accounting Period(s) from the list.

Resource Commitment ID - Wildcard search and partial values accepted.

Resource Commitment Name - Wildcard search and partial values accepted.

Resource Commitment Record Scenario Type - Select the Record Scenario Type from the drop-down.

Fiscal Year - Select the Fiscal Year from the drop-down.

Resource Commitment Pushed By Name Full - Search and select any Pushed By Name from the prompt.

Financial Unit L3 Code and Name - Search and select any Financial Unit L3 from the prompt.

Financial Unit L4 Code and Name - Search and select any Financial Unit L4 from the prompt.

Financial Unit Code and Name - Search and select any Financial Unit from the prompt.

Project Code and Name - Search and select any Project from the prompt.

Fund Code and Name - Search and select any Fund from the prompt.

Function Code and Name - Search and select any Function from the prompt.

Once all Prompt selections are complete, click Finish to generate the report.

RCAM GL Condensed:

RCAM GL Details:

To filter by ‘Variance Description’ values, click on any ‘MATCH’ value shown in the column.

Once the ‘MATCH’ value is selected in dark blue highlight, click on the Filters icon and choose between:

• Include MATCH
  • Returns values = MATCH.
• Exclude MATCH
  • Returns values = Mismatch – Amount, Mismatch – Name, No Matching BAM Transaction

Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.