The Analytical Ledger Review (ALR) includes both payroll and non-payroll transactions in the same report.
- Who reviews the ALR report?
- Report Sections
- High Risk Transactions (Supplies and Expenditures)
The Analytical Ledger Review (ALR - DS report 403) was designed to give fiscal officers an analytical review of the ledger and help highlight certain areas for review purposes. The ALR also gives the fiscal officer the ability to review ledger details (without running another DS report), review activity by consolidation and review budget to actuals. A button at the bottom of the report allows the fiscal officer to click and indicate they completed the ledger review for that account(s).
One of the biggest changes between the old General Ledger Review System (GLRS) and the ALR is there is no longer a transaction by transaction review. Therefore, it is essential that fiscal officers/delegates perform their due diligence when reviewing and approving transactions.
For more information on the new ledger review, visit the Ledger Review Process page.
Please note that the Time Benefits Roster (119)/PPP 6401 must be completed separately. The ALR does not provide these details. See the Time Benefits Roster checklist for more information.
2. Who reviews the ALR report?
The ALR report is reviewed monthly by fiscal officers. The report provides the following:
- Enables fiscal officers to review at a summary level that all of the transactions for their accounts appear to be reasonable rather than having to check off individual transactions.
- Comparison of month-to-month expenditures as well as comparison of budget-to-actual expenditures.
- Comparison with Same Fiscal Period from Previous Fiscal Year.
- Percent of expenditures versus budget.
- A list of transactions, first by Revenue object consolidations and then by Expense object consolidations .
3. Report Sections
Before you begin reviewing the ledgers, make sure you understand the purpose and restrictions on the account. Always make sure the charges posted to your account are allowable, reasonable and follow UC Davis policies and procedures, UCOP Policies, and federal and state regulations. For more information on accounts and funds, visit the Understanding Your Accounts and Funds page.
The following sections appear on the ALR Report:
- Revenue: Review to ensure all expected income/recharges have posted and there are no notable discrepancies. If you have cash operations, drill down to the details to ensure your cash transactions have not been greater than or less than was expected. In general, there should be no revenue posted to a general fund account.
- Salaries and Benefits: Review payroll transactions to ensure appropriate individuals are being charged to the account, no individual has been overpaid or unauthorized overtime has been charged. Bi-weekly employees will have three pay periods every six months, so make sure you budget accordingly.
- Supplies and Expenditures: This is broken into three sections to help in your review:
- 1. Recharge Activity including Feeds: Review recharges and follow up with the billing department if you have any questions or if the charges were not expected. Make sure you have adequate documentation and approvals for recharges that have been fed but not reviewed by your department before posting to the ledger.
- 2. High Risk Transactions: The transactions that are listed under high risk are those transactions that have a higher potential for misuse if not reviewed appropriately. If there is an unexpected fluctuation in these costs, make sure you understand why and are able to explain it. Transactions listed under services should be reviewed to ensure there is no conflict of interest with any sole source provider.
- Other Supplies & Expenses: These are all other expenses not listed in the above categories of supplies and expenses. Review this section and ensure the amounts are reasonable. You also want to pay closer attention to items that use the generic object code 8000. Some of these items may have more appropriate object codes that should be used.
- Equipment: This section separates your Capital Equipment from your supply/other type purchases. For contract and grant accounts, be sure the equipment is included in the approved budget. For self-supporting activity accounts, equipment should be in approved rate and assigned to depreciation (D) Custody Code to record monthly depreciation.
- Travel: Review travel expenses to verify they are allowable on your account. This is critical for School of Medicine departments where fiscal officers may not be the department approver.
- Preferred Booking Program Airfare transactions: These transactions should be approved prior to the traveler making any reservations in AggieExpense or directly through BCD travel. You must pay close attention to these charges as they do not route to anyone for approval before the charges post to your account. If you currently do not have a separate process to review the unreconciled transaction report (DS FIS421) you must review the details of these transactions in the ALR. Review transactions carefully to verify all travelers are within your unit or department. Review multiple transactions within a month or two month period to ensure the travel has been approved for a valid business purpose. No personal travel should be charged.
- Preferred Booking Program Local Hotel transactions: As with the airfare, these charges are directly charged to the ledger without further approval. These transactions are also charged to state travel object code 2000. Review the transaction to ensure they are appropriate in the account used and the charges are valid business expense. As with the airfare, please review the unreconciled transaction report (DS FIS421) to ensure transactions are reconciled in a timely manner.
- Catering charges: Currently all recharge activity from the campus catering unit is posting to the object code 2000. Please review these transactions to ensure the catering charges are all valid business expenses and they are reconciled timely. Once transactions have been reconciled, they will appear in an entertainment object code.
- All Other Consolidations: This section includes equipment depreciation, scholarships and fellowships, and indirect costs. The scholarships and fellowships category is common to Financial Aid, or FINA, accounts. This section may appear for contract and grant and self-supporting accounts, but not for generally-funded accounts.
- Additional Funds: This section contains your unallocated (SUB8) as well as your committed (COBL) and known (KOBL) obligations. There should only be budgets, no expenditures in this section. There should never be an overdraft in your obligation budgets. In the rare instance you have a budget overdraft in SUB8, clear the overdraft by fiscal year-end.
- Account Summary: The account summary gives the fiscal officer an overall view of the account by category. Just like all the sections above, the account summary provides the month-to-month comparison and balance to date amounts. Review all balances to ensure you will not be exceeding your budget.
- If you have concerns that you will be exceeding your budget, discuss with your MSO/Manager.
- Feeds Detail: The monthly feed activity provides a summary of all feeds that posted within your account whether it was a recharge or not. This section provides a summary by feed type as well as object code. Drill down to view the details for any charges that are unexpected or are significantly greater than the prior month's activity.
- High Value Transactions: This sections lists all non-payroll transactions that are $5,000 and higher, but can be set LOWER by user. Review all transactions but pay special attention to those transactions that have been fed into the ledger. Preferred Booking Program transactions are directly billed and do not have any system approvals prior to posting to the ledger and should be reviewed carefully.
- Disbursement Vouchers (DVs): Provides a summary of DV's paid by person and provides the details of each transaction. Review DV payments to ensure employees are not circumventing policies by purchasing their own goods/services and then asking for reimbursement. For information on purchasing practices, visit the Procurement & Contracting Services page on the Supply Chain Management site.
- Disbursement Voucher High Risk Transactions: displays DVs with Object 8000 or any of the following Payment Reason Codes:
- EDM (Employee Damage Payment)
- EER (Employee Reimbursement)
- HUM (Human Subject Payment)
- Disbursement Voucher High Risk Transactions: displays DVs with Object 8000 or any of the following Payment Reason Codes:
- Travel and Entertainment Details: Provides a summary of travel and entertainment transactions processed during the month. These are transactions that have been reconciled through AggieExpense and do not include any Preferred Booking Program airfare, local hotel, or catering service charges that posted in the month.
4. High Risk Transactions (Supplies and Expenditures)
The following display as High Risk Transactions (if applicable) in the Supplies and Expenditures section:
- Installment Payments
- Lease Payments
- Moving/Removal Expenses
- Non-cash Awards
- Purchasing Card Billing
- Research Subjects
Frequently Asked Questions
- Why is it important for me to review my ledgers?
General Ledger Review is the process of analyzing your department's ledger transactions to provide reasonable assurance that the charges and credits are valid. In addition, the reviewer verifies that transactions are appropriate and that they are compliant with all applicable policies and regulations. It is also a requirement of UCD PPM 330-11: Approval Authorization for Department Transactions.
It is our obligation to be good stewards of the university funds that have been entrusted to us. As a recipient of funds from a variety of sources, the university must demonstrate to public and private organizations, taxpayers, donors, and anyone else who provides us with funding that we are using the money as intended. Ledger review impacts the university's annual financial schedules and provides accurate information for further financial analysis to occur at higher departmental, divisional, school, and college levels.
If you have questions or concerns about transactions that have posted to your accounts please contact one of the following:
> Accounting & Financial Reporting
> Contracts & Grants Accounting
> Controls & Accountability
- Why do some of my accounts require the ALR to be reviewed and others don't?
- The ALR is required for the following accounts:
> Accounts that have financial activity during the fiscal period.
> Accounts that are overdrawn, even if there is no financial activity in the month.
> Expired accounts that have a budgetary entry.
Some accounts may not be required in the ALR for several months or all year due to the inactivity in the account. If there has been activity in the account and the ALR is still not required, please contact the A&FS Help Desk at email@example.com.
- Where can I find training on how to use the ALR?
- Log into the UC Learning Center and search on key terms ledger review to access and complete the 45-minute training.
- What are the other components of the new ledger review system?
For more information about the ALR, MLR, and QLR visit the new Ledger Review Process pages.
- Are there any best practices for the ALR?
- As you get comfortable with reviewing the ALR, you will create best practices for each individual account. Here are a list of best practices to get you started:
1. Review the ALR on a monthly basis as it is a requirement of UCD PPM 330-11: Approval Authorization for Department Transactions..
2. Make any corrections or adjustments to budgets before the fiscal period closes.
3. Review all sections and pay closer attention to new recharges/expenses that have not been charged in the past.
4. Understand the fund source of the account you are reviewing and ensure there are no unallowable costs.
5. Make sure that the purchasing card transactions that are posting to your account are not left in the default object code PCRD and they are changed to something that describes the purchase.
6. Download the information to excel to create quarterly or yearly expenditure comparison reports.
7. Make sure all of your accounts have active delegates, and those delegates understand their responsibility.
8. Review the Administrator's Responsibility & Resources Handbook.
9. Question expenditures you do not feel have adequate explanations or back-up.
10. Report any suspicious activity that may be considered improper governmental activities to your supervisor or directly to the Chief Compliance Officer. Visit Compliance and Policy for more information.