PI Non-Sponsored Statements: Transaction

The transaction detail section provides the detail by item for the expenses on the summary page for the current period. The current reporting period (period/fiscal year) can always be found in the right page footer.

What is included?

• Expense related detail

What is excluded?

• Revenue detail
• Payroll detail
• Commitment detail

The Header Section provides identifying information about the non-sponsored cost object from SAP Master Data such as:

• Fund Center
• Funded Program
• PI for Funded Program (this is the name of the Faculty member that receives the report, this is updated by [email protected])
• Responsible Person (this data is based on SAP Master Data and must be updated using the Master Data Request Tool, it is not related to the report distribution)
• Business Area
• Fund
• Fund Type
• Function Group
• Financial Function

Updates to a more meaningful name are allowed as it pertains to the fund center or funded programs. The department should use the Master Data Request Tool in SAP to initiate the change process.

If an update is approved all SAP applications using this data will also be updated.

A. Class 

• First column on the transaction detail report
• Field shows Text only
• High level group combines similar G/L accounts together (for example: Contractual Services)
• Total for “class” will tie in with the summary page “current period” column

B. GL Account 

• Second column on the transaction detail report
• Field shows Text only
• Like GL Accounts are grouped together as a “class” (For example: Equipment Lease, General Contractual Services, Waste Removal and Exchange Services are all part of the Contractual Services class)

C. Item Text 

• Third column on the transaction detail report
• Provides detailed text concerning transaction
• Field shows Key only

D. Vendor 

• Fourth column on the transaction detail report
• Field shows Text only
• Field is populated only when applicable

E. Reference Doc # (SAP document number) 

• Fifth column on the transaction detail report
• Field shows Key only
• FI Document # | Type Reference sheet

F. Posting date

• Sixth column on the transaction detail report
• Field shows Key only
• This field will only contain ‘Current Period’ dates

G. ‘Current Period’ Amount

• Seventh column on the transaction detail report
• In this example: the report was run for Period/FY: 06/2017 (December, 2016)

The example below reconciles the summary page with the transaction detail and provides detail for each expense

This report has omitted several items so it provides the user with only pertinent data elements to properly reconcile the account.

Sub-report Exclusions

• Revenue detail
• Payroll detail
• Commitments