The Real-Time Financials project was a collaborative effort between MAIS, Financial Operations, and University units to improve financial reporting. The project had multiple phases: Financial Estimate Data (Phase I), Transaction Frequency and Reporting Enhancements (Phase II-a), and eReconciliation (Phase II-b).
Phase I of the Real-Time Financials project was completed as of April 2007, with the addition of estimate data to the U-M Data Warehouse and the Project/Grant Budget Status Report (PBSR).
Phase IIa was completed as of January 2008, with the addition of Benefit Recharge Distribution (BRD) and Indirect Cost (IC) estimates to the U-M Data Warehouse, daily posting of Accounts Payable vouchers and journals to the General Ledger, and enhanced Unit Defined Commitment functionality.
Phase IIb was completed as of June 2008, with the implementation of eReconciliation (i.e., online Statement of Activity reconciliation) in the M-Pathways Financials & Physical Resources System.
In April 2007, the following estimate data joined the existing gross pay estimate data (available as of 2002) in the U-M Data Warehouse and became available in applicable financial reports.
Payroll, employee benefits, and financial aid expenses represent well over 70% of the direct expenses for most University units. The addition of this estimate data to the U-M Data Warehouse provides:
Real-Time Financials estimate data is also displayed in M-Reports. For more information, view the demo of the Sponsored Research Financial reports on the UM Business Intelligence Web site.
The University maintains a financial transaction processing schedule. This schedule represents the minimum frequency of activity to ensure that transactions are posted to the General Ledger by month-end close so that the data is available on the monthly financial reports. With M-Pathways you can submit, post, and reconcile transactions throughout the month (i.e., Accounting Period).
The following transaction processes were enhanced to allow posting, reconciling, and reporting to be timelier. Your unit's financial data will more closely reflect "real-time" activity and the decisions you make using that data will be more robust.
You can better leverage the M-Pathways system and improve your report data by examining your unit’s business processes for these financial transactions. ITS continues to partner with school/college administrators, service units, and central offices to identify opportunities that allow for the timelier posting of transactions to the General Ledger. Contact firstname.lastname@example.org for more information.
The following enhancements were made to the U-M Data Warehouse:
eReconciliation offers online Statement of Activity (SOA) reconciliation in M-Pathways. Click here to learn more.