Reconcile AR Transactions Ledgers to Accounts Receivable

To assist in the reconciliation of, or to get detail about, AR transactions a Business Objects report titled "UR_FIAR_FIN_Ledgers_AR_Payment_Trans" is available in Eddie under University Documents (UI2 Finance). In order to use this report, the Detail Code(s) associated with the C-FOAP, AR Rule Code1 and the Feeder Document number/s are required. If these are not known, they can be determined by using the crosswalk files available on this page. This is recognized by the Rule Code1 for the Related Detail Code.

Determine Detail Code and Rule Code 1

If the Detail Code(s) related transactions to be analyzed are unknown retrieve the crosswalk workbook for the term that corresponds to the finance period in question and determine the particular Detail Code(s). To use that workbook, see the related reference at C-FOAP to Detail Code Crosswalk. Record the related Detail Code/s and Rule Code 1s. The Detail Code/s will be required in the prompts for the Eddie/Infoview/Business Objects report. The Rule Codes may be helpful in the analysis.

In Eddie UI2 Finance reports select the report "UR_FIAR_FIN_Ledgers_AR_Payment_Trans" and refresh it. Using the prompts enter the Detail Codes and Document #s to be analyzed and run the report.

The report will return a list of transactions, by AR account, which up make the amounts recorded in the ledger for the Detail Codes and Accounts. Only initial transactions from AR can be analyzed this way, not transactions resulting from multiple re-applications of payments. Initial transactions are indicated by the Ledger Transaction Listing RUCL corresponding to RUCL1 in the C-FOAP to Detail Code Crosswalk.

C-FOAP to Detail Code Crosswalk

For ledger reconciliation purposes and ledger account analysis units need to know what AR Detail Codes are associated with what Chart, Fund, Organization, Account and Program (Fund and Account for GL transactions only). Banner and the EDW do not provide a means for the general user to accomplish this so University Bursar posts an Excel Workbook that enables units to crosswalk C-FOAPs to Detail Codes. Since the FOAPS behind term based detail codes can change with term updates, this crosswalk will be posted for the current and past academic year. It is updated and posted daily to currently reflect any additions or changes.

Any of the xWalks will return the correct C-FOAP for non-term based detail codes. Until familiar with Term Based usage and changing C-FOAPs check term based codes for multiple terms to be sure of correct C-FOAP for a given FY, Period, account reconciliation or analysis.

If the Detail Code/s related transactions to be analyzed are unknown retrieve the crosswalk workbook for the term that corresponds to the finance period in question and determine the particular Detail Codes. To use that work book see the related reference at Reconcile AR Transactions Ledgers to Accounts Receivable Record the related Detail Code/s and Rule Code 1s. The Detail Code/s will be required in the prompts for the Eddie/Infoview/Business Objects report. The Rule Codes may be helpful in the analysis. Workbooks are posted with Auto-Filter turned on therefore the user can filter by preferred various combinations of:

• Chart
• Fund
• Organization (if applicable)
• Account
• Program