/
How to run the AR GL Reconciliation Report
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
Related content
There was no AR Activity linked to this Journal for this Effective Date message in the AR GL Reconciliation Report
There was no AR Activity linked to this Journal for this Effective Date message in the AR GL Reconciliation Report
More like this
Which reports should be used to reconcile the Accounts Receivable with the General Ledger
Which reports should be used to reconcile the Accounts Receivable with the General Ledger
More like this
Why should the Accounts Receivable Aging Report not be used for Reconciliation
Why should the Accounts Receivable Aging Report not be used for Reconciliation
More like this
Aging Report with AR Fund Summary
Aging Report with AR Fund Summary
More like this
Reconciliation Report contains error Subreport could not be shown
Reconciliation Report contains error Subreport could not be shown
More like this
Run a Report for All Bills Within a Year and Specific Accounts Receivable Category
Run a Report for All Bills Within a Year and Specific Accounts Receivable Category
More like this