Quarterly Ledger Review (QLR)

The Quarterly Ledger Review (QLR) is completed on a quarterly basis in October, January, April, and July.

The Quarterly Ledger Review (QLR) looks and operates similarly to the MLR but is completed on a quarterly basis (October, January, April, July) by a member of the Dean's Office.

Contents:

  1. Intro
  2. Who can access the QLR when it is completed?
  3. What organization type codes complete the QLR?
  4. Other things to note about the QLR

1. Introduction

How does the report work? What information is included?

The QLR looks and operates similarly to the MLR but is completed on a quarterly basis (October, January, April, July) by a member of the Dean's Office.

The report includes the following information for each fiscal quarter composed of three fiscal periods (July-September, October-December, January-March, April-June). 

  • A list of overdue account reviews.
  • A list of accounts in overdraft as of the last fiscal period of that fiscal quarter.
  • High-risk transactions.
  • High-value transactions (default is $10,000 but can be set higher/lower as needed).
  • Summary of revenues and expenditures.
  • A review button to that you click to indicate you have reviewed the report.

The report shows the Current Quarter Expenditures, the Prior Quarter Expenditures, and the Same Quarter Expenditures from the previous fiscal year.

Top↑


2. Who can access the QLR when it is completed?

The QLR report, the Dean/VC Quarterly Ledger Review (405), is reviewed quarterly by a member of the Dean's Office (one of the persons listed in one of the Dean's Office fields in the Organization Management section of the Organization document). 

Top↑


3. What organization type codes complete the QLR?

The Organization Type Codes of V (Vice-Chancellor), S (School or College), and R (Central Managed Accounts) are those organization levels at which the QLR occurs.

Top↑


4. Other things to note about the QLR

  • QLR is using the Level 4 ORGs for sign-off.
  • Quarter 1 numbers don’t include beginning balances, they only include activity from July-Sept. (the balance-to-date will include the beginning balances).
  • Excel download is available for ALL the report options.
  • The high value transaction default has been set at $10K for review purposes. If the default is changed above $10K, the review button will not show.
  • The QLR uses the Organization structure at the end of the quarter. For example, if you are running it for the first quarter, it will use the org structure as of the close of September.
  • If there are changes to organizations or to the organizations associated with those accounts it may affect the drill downs for the Prior Quarter or the Prior Year.

Top↑