How to run the AR GL Reconciliation Report

Description of Issue
  • Would like to know how to run the AR/GL Reconciliation Report.
  • There is a variance between the Accounts Receivable and General Ledger that needs to be found. 
  • Which reports should be run to reconcile the AR with the GL? 
  • Useful tool for finding variances between AR and the GL.
Context
  • Accounts Receivable
  • General Ledger
  • Reconciliation Report (arssrsrl)
  • SSRS
Cause

Need a report that helps find variances between the AR and GL. 

Resolution
  1. Navigate to: General or Property Revenues > Accounts Receivable > Inquiries and Reports > Reconciliation report
  2. Click Define.
  3. Enter the Report Parameters:
    1. Enter the Report Year which should be the GL year being reconciled. 
    2. Enter the Report Period Range to define how many periods to include on the report. It is recommended to run the report for a single period or as few periods as possible, instead of a full year. 
    3. Report GL Effective Date Range can be used to narrow the time period being reconciled even further. 
    4. Treat Account(s) as defines the type of GL account being reconciled. Select the appropriate account type for the account being reconciled: Accounts Receivable, Revenue, or Deferred Revenue
  4. Enter the necessary account segments for the account(s) being reconciled in the Account Search section.
  5. Click Accept.
  6. Click Calculate.
  7. Click Launch Report.
Additional Information

If additional assistance is required, please contact the appropriate Accounts Receivable Support Team: How to determine the correct Accounts Receivable support team to assist with an issue