eReconciliation: Student Financial Detail

Overview

There are two methods in M-Pathways eReconciliation for viewing transaction detail for student financials/financial aid journals (i.e., those with a Journal ID Mask of SFN) for your department or project/grant.

  • Click SFN Detail to view the summary journal data with its transaction detail on one page for all of the student financials and/or financial aid transactions for the selected parameters.
  • From the SOA Detail page, click the link in the Expense column for a specific SFN journal to display the detail for only that Journal ID/Line.

Both methods provide similar information as the Aid Disbursement Detail report available through BusinessObjects or HEPROD. Review this document in its entirety to learn about both methods or click a link below to focus on a particular one. You can use either method to reconcile student financial transactions in eReconciliation.

Student Financial Detail – All transactions
Student Financial Detail – Individual transaction

Note: In M-Pathways, the Student Financial Detail page scrolls across your computer screen. The following screenshots are split into sections for clarity.

Navigation

NavBar > Navigator > General Ledger > eReconciliation > eReconciliation


Student Financial Detail Page – All transactions

Use this method if you like to reconcile all student financial transactions from one eReconciliation page. This method combines the summary data (e.g., Journal ID/Line) with the transaction detail to provide an “all-in-one” view.

Note: The sort order in the grid is: EmplID, Journal ID, Journal Date, and Account. This allows you to see the student financials data for each student at a glance. Click a column heading to change the sort order while viewing the data, if appropriate.

Student Financial Detail - left section of grid

Student Financial Details page

Letter
Field/Button
Description
A
Journal ID
An eight-digit, sequential, system-generated reference number for the journal transaction. A journal is a balancing set of accounting entries for a type of transaction that is posted to the General Ledger.
SFN journals are the student financial transactions including financial aid expenses, student fee revenues, Graduate Student tuition waivers, and other revenues and expenses related to student fellowships and scholarships.
B
Journal Date
Shows the transaction date of the journal. The date is based upon the accounting date of the payroll cycle that make up that journal.
C
Ln
The Line Number (Ln) shows where within the summary journal your specific department or project/grant information is found.
Note: If you contact the Student Financials Operations with a question about a journal in the Student Financial Detail page, please include the Journal ID, Journal Date, and Line Number.
D
ChartFields
ChartFields, such as Proj/Grt, Class, and Account shown in the picture above, are fields in the grid.
The ChartField values for a Journal ID/Line correspond to the ShortCode used for the student financials transaction. In the Student Administration system, student financials are processed with a ShortCode. In the General Ledger system, the ChartField combination is used. By examining the transaction’s ChartField combination, you can determine whether or not the student financials expense is correctly accounted for (i.e., belongs to that Department or Program).
To validate the ShortCode translation for these transactions, use the M-Pathways ChartField Converter.
E
Account Descr
The Account Description comes from the general text description of the Account value in M-Pathways. If you are unfamiliar with a specific Account value and its description, you can verify it by using the Valid Account Listing on the Financial Operations website. 
F
UG Monitored
UG Monitored* only applies to Sponsored Project/Grants.
G
Empl ID
Displays the employee identification number for the individual associated with the student financials transaction. This is a HE system assigned number that uniquely identifies a person at U-M. Commonly referred to as the UMID.
H
Name
Shows the individual who received the financial aid or was associated with the student financial transaction.
I
Item Term Description
Indicates the academic term to which the student financial transaction applies.

Student Financial Detail - right section of grid

Student Financial Detail page

Letter
Field/Button
Description
J
Item Type Description
Identifies the type of student financial transaction (often abbreviated).
K
Item Type
A code that represents a particular type of student financial transaction (e.g., financial aid expenses, graduate student tuition waivers).
L
Entered By
Displays the uniqname of the individual who entered the transaction in the HE system; often this is a “batch ID” indicating the transaction was processed by an automated system procedure.
M
Amount
Shows the amount that each individual received for this distribution of financial aid or the amount that the student paid (e.g., course fee). Negative amounts indicate a correction.
N
REC
The Reconciliation checkbox indicates whether the Student Financials line has been reconciled (checked) or not (unchecked).

Checking the REC box for the Journal ID/Line on the SOA Detail grid automatically checks the REC box(es) for the associated detail. If you check or uncheck a REC box on the Student Financial Detail page, the system automatically checks or unchecks the corresponding REC box for the Journal ID/Line on the SOA Detail page.

Note: If the Student Financial Detail page displays multiple rows of data with the same Journal ID/Line values, all the REC boxes must be checked for the Journal ID/Line to be considered reconciled (i.e., REC checkbox marked) on the SOA Detail page.  If one detail row is not marked as reconciled, the Journal ID/Line isn’t marked as reconciled.

O
Note
An Add link in this field allows you to enter a note for the transaction line. When the Student Financial Detail page is saved, the link changes to Update to show that a note has been entered. You can add, update, and remove notes as needed.
P
Unit Review
Indicates that the Student Financials line has been reviewed by the responsible campus unit. Checking the Unit Review box for the Journal ID/Line on the SOA Detail grid automatically checks the Unit Review box(es) for the associated detail. If you check or uncheck a Unit Review box on the SFN Detail page, the system automatically checks or unchecks the corresponding Unit Review box for the Journal ID/Line on the SOA Detail page.
Note: Applies only to Sponsored Project activity; the checkbox is disabled for all other transaction lines.
If the SFN Detail page displays multiple rows of data with the same Journal ID/Line values, the Unit Review boxes for each of those rows must be checked in order for the Journal ID/Line to be considered reviewed (i.e., Unit Review box checked) on the SOA Detail page. If one row of data is not marked as reviewed, the Journal ID/Line isn’t marked as reviewed.
Q
Exception Type
System assigned value based on auto-reconciliation rules. Used by the Shared Services Center to identify why a transaction could not be auto-reconciled.
R
Assigned Reconciler
Person assigned in the Shared Services Center to reconcile transaction.
S
Resolution Type
Field used to identify how a transaction needing to be reconciled was resolved.
T
Reason Code
Field used to determine why transaction was not “Confirmed as accurate” (not used for payroll transactions). Required when Resolution types of “Other” or “JE” are selected.
U
Status
Field used to identify the state of a transaction’s reconciliation.
V
Updtd ID
Last Updtd
The Update ID and Last Updated fields list the uniqname of the person who last updated reconciliation information (i.e., REC checkbox or Unit Review checkbox) for the transaction and when the update was done. These fields are populated when the Student Financials Detail or SOA Detail page is saved.

Student Financial Detail Page – Individual transaction

Clicking the Expense link for a specific SFN Journal ID/Line from the SOA Detail page displays the transaction detail for only that Journal ID/Line. 

Note: All fields in a "specific" detail view are the same as the SFN Detail view. See the field descriptions above for information.

Student Financial Detail – left-side view

Student Financial Detail left-side

Student Financial Detail – right-side view

Student Financial Detail right-side

See the following documents in the ITS catalog in My LINC for additional information about eReconciliation.  Locate the documents by searching from the My LINC home page using the keyword eReconciliation or navigate using the following catalog path:  ITS > Financials > General Ledger > Financial Reporting.

  • eReconciliation provides step-by-step instructions for using eReconciliation to reconcile your department’s or project/grant’s financial activity.
  • eReconciliation Reports provides step-by-step instructions for running and printing the SOA and transaction detail reports after completing your reconciliation effort.