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
- Navigate to: General or Property Revenues > Accounts Receivable > Inquiries and Reports > Reconciliation report
- Click Define.
- Enter the Report Parameters:
- Enter the Report Year which should be the GL year being reconciled.Â
- 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.Â
- Report GL Effective Date Range can be used to narrow the time period being reconciled even further.Â
- 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
- Enter the necessary account segments for the account(s) being reconciled in the Account Search section.
- Click Accept.
- Click Calculate.
- 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