Statement of Activity (SOA) Reconciliation Resources

Overview

The resources listed below can help you interpret ChartField values, data relationships, and University business processes related to Statement of Activity reconciliation. An Additional Information column contains the navigation path and links to documents/web pages that provide an explanation of the resource and/or step-by-step procedures to obtain and use it.

OGS Department Group Scope Values

Resource Description Additional Information
Valid Value reports Lists active values for a particular ChartField (e.g., Account, Class, Department, and Fund), including detailed descriptions, and usage information.

Reporting Tools > GL Reports

My LINC procedures provide instructions to run any report, including the SOA:

ChartField pages Look up descriptions and other information for a specific ChartField value. 

Set Up Financials/Supply Chain > Common Definitions > Design ChartFields

Locating ChartField Values and Descriptions step-by-step procedure.
Tree Viewer Look up ChartField relationships (e.g., DeptID groups) for University organizations. 

Tree Manager > Tree Viewer

Multiple trees exist. Each displays a different way to group a ChartField value for business purposes at the University. For example, use the Program tree to get a list of your organization’s Program values.
ChartField Converter Translates a ShortCode into its equivalent ChartField combination.

The Converter also does a “reverse lookup” (i.e., lists ShortCodes for a specific DeptID or Project/Grant value).
M-Pathways Converter:
Set Up Financials/Supply Chain > Common Definitions > Design ChartFields
Using the ChartField Converter step-by-step procedure.

Web ChartField Converter: http://www.mais.umich.edu/fin/web_converter.html

Wolverine Access Resources

Resource Description Location Additional Information
WebNow system Review supporting documentation that has been imaged for online/upload journals or PO vouchers (e.g., justification memos, vendor invoices, etc).

Wolverine Access

University Business > WEBNOW

You must have the FN View Departmental role to use WebNow.
M-Reports system Management reports display data based on your Statement reconciliation efforts (e.g., Unit-Defined commitments, journal entries, etc.) Wolverine Access

University Business > Reporting > M-Reports

M-Reports access is granted automatically to Principal Investigators, Single Administrative Points of Contact (SAPOCs) and Department Managers. Check with your departmental Financial UL to determine if you need access.
Predefined Reports Directory Lists the reports available in the University’s reporting environments
(i.e., M-Pathways, BusinessObjects and M-Reports); describing their purpose, location, and parameters.
M-Reports

https://mreports.umich.edu/MReports/ReportsLibrary/ReportList.aspx

Financial Operations Web Site Resources

Resource Description Location Additional Information
Valid Account List List of active Account values beginning with 4, 5, and 6 and their definitions. It also shows if you can use an Account value with a particular Fund in a ChartField combination.

Accounting Operations menu

http://www.finance.umich.edu/system/files/ValidAccount.xls

ChartField Requests Provides instructions to add or change ChartField (e.g., Department) and ShortCode values for your unit or project/grant. Shared Services Center eForms menu

http://ssc.umich.edu/eForms

Journal Entries Links to instructions for correcting erroneous transactions on the SOA. Accounting Operations menu

https://finance.umich.edu/finops/accounting/journals

Journal Upload Templates Download the latest basic and macro-enabled versions of the Journal Upload Template for PC or Mac. Accounting Operations menu

https://finance.umich.edu/finops/accounting/journals

Find Your Sponsored Programs Coordinator Enter your Dept ID in the interactive Excel spreadsheet to locate the Sponsored Programs coordinators for your department Accounting Operations menu

https://finance.umich.edu/programs/coordinator-by-department

Retroactive Salary Transfer Guidelines Explains the procedure for correcting erroneous PYW, PYB, and PYM journals Payroll menu https://finance.umich.edu/finops/payroll/resources/salarytransfers
Policy & Procedure for Retroactive Payroll Transfers Explains the policy and procedures for adjusting payroll data after the pay period. Payroll menu https://finance.umich.edu/finops/payroll/resources/salarytransfers
Payroll Web site Use to obtain policy and procedural information regarding payroll transactions. Payroll menu https://finance.umich.edu/finops/payroll

Procurement Services Web Site Resources

Resource Description Additional Information
Procurement Services Web site Use information on this site to obtain policy and procedural information regarding all types of procurement transactions.

http://procurement.umich.edu/

Travel & Expense system (Concur) Use information on this site to obtain policy information related to University travel and expense.

http://procurement.umich.edu/travel-expense

ITS Administrative Computing Web Site Resources

Resource Description Location Additional Information
Real-Time Financials(RTF)  web pages “Real-Time Financials” is an on-going effort to improve financial reporting and increase effective use of the University’s centralized financial systems.

System Overviews menu

Data > Analytics & Reporting > Real-Time Financial
RTF Toolkit – provides various options for university financial reporting
https://its.umich.edu/data/analytics/real-time-financials/toolkit
RTF Consulting – learn how to best utilize the RTF Toolkit and other University reporting options through free collaborative services.

https://its.umich.edu/data/analytics/real-time-financials/documentation
Unit Defined Commitments Web pages Contains documentation to learn how to use M-Pathways to enter and track financial commitments important to your department or project/grant that are not necessarily captured elsewhere in the General Ledger. System Overviews menu

Data > Analytics & Reporting > Real-Time Financials > Toolkit > Unit-Defined Commitments

https://its.umich.edu/enterprise/analytics/real-time-financials/toolkit/unit-defined-commitments
Reporting Budget Ledger web pages Learn how to use M-Pathways to upload and report budget data for non-sponsored financial activity. System Overviews menu

Data > Analytics & Reporting > Real-Time Financials > Toolkit > Reporting Budget Ledger

https://its.umich.edu/data/analytics/real-time-financials/toolkit/reporting-budget-ledger
Accounts Receivable & Billing Web pages Provides a high-level explanation of the Accounts Receivable & Billing modules.  Contains links to presentations and report samples. System Overviews menu

Administrative Systems > M-Pathways > Financials & Physical Resources > Accounts Receivable & Billing

https://its.umich.edu/enterprise/administrative-systems/m-pathways/financials-physical-resources-systems/accounts-receivable-billing-module

Additional Resources

ITS sends an email to the Month-end Close Notification User Group announcing the dates the Accounting Period closes and complete report data is available. You can receive this email notification by self-enrolling on the University of Michigan Online Directory (https://mcommunity.umich.edu/). Enter monthendclosenotification in the Directory’s Search field to locate the user group record.