University of Pennsylvania
Business Enterprise Network
BEN Financials Home
Frequently Asked Questions
Advisories
Closing Schedules
Logging On
Desktop/Printer Standards
Documentation
Training
Security Access
Enhancement Requests
Financial Systems
Document/Forms
Feedback


U@Penn


University of Pennsylvania
Suite 318 Franklin Building
3451 Walnut Street
Philadelphia, PA 19104
215.746.4357 (Phone)
215.898.0817 (Fax)

Penn Home Penn A-Z Directories Calendar Maps
 
Business Enterprise Network

[ BEN Financials ]

7. Report Templates
Documentation :|: BEN Balances Report Documentation

7.0 General Information
Last Updated: 2/27/2004

Report Templates were created to provide consistency in presenting revenue and expenses across all customized reports that display financial balances. There are six major versions of the templates with several additional variations. The six major templates are:

Template #1A RCM Revenue and Expense, All Funds
Template #1C RCM Revenue and Expense, to be used when reporting exclusively on Grants & Contracts (and URFs)
Template #3 Principal Investigator View
Templates #5A and 5C RCM Highly Summarized Views
Template #7 Designated Fund View
Template #10: Capital Projects

The template determines the order of the rows (e.g., revenue followed by expense, salaries followed by employee benefit expense), the group of object codes to be included in each labeled row (e.g., the row labeled "Travel and Entertainment" includes object codes 5200 through 5219), and the level of sub-totaling.

Consistency is accomplished by using the same template in all reports requiring a specific view. For example, Template #1C is the Grant View. Most of the Grant reports use Template #1C.


The following table indicates what Templates are used for each of the standard General Ledger reports.

Report Template(s) Used in Rpt
100.ORG: Summary By CNAC/ORG/FUND 1A
101.ORG: Summary By CNAC/ORG/FUND/PROG 1A
102.ORG: Summary G&C/URF By CNAC/ORG/FUND 1C
103.ORG: Summary G&C/URF By CNAC/ORG/FUND/CREF 1C
104.ORG: Summary By CNAC/ORG/FUND/CREF 1A
106.ORG: Summary By CNAC/ORG/FUND/PROG/CREF 1A
114.ORG: Endowed FUND Summary Report 7, 5A
115.ORG: Grant FUND Summary Report 5C
116.ORG: Gift FUND Summary Report 7, 5A
130.ORG: PI Report By CNAC/ORG/FUND 3
132.ORG: List Of Terminated Grant And Contract Funds None
133.ORG: List Of Grant And Contract Funds Due To Close None
134.ORG: Summary Of Final Expenditures Report (SFER) 4
137.ORG: Grant/Contract Budget Period Summary Report 4A
150.ORG: Detail By CNAC/ORG/FUND none
151.ORG: Detail By CNAC/ORG/FUND/CREF none
152.ORG: Detail By CNAC/ORG/CREF none
153.ORG: Detail By CNAC/ORG/FUND/PROG none
155.ORG: Detail Extract none
156.ORG: Detail By CNAC/ORG/FUND/PROG/CREF none
160.ORG: Account Analysis With Payables Detail none
163.ORG: Open Encumbrance Report none
200.SCH: School/Center YTD Revenue & Expense Summary 5A
201.SCH: School/Center PJTD Revenue & Expense Summary 5C
202.SCH: School/Center (01xxnn) YTD Revenue & Expense Summary 5A
205.SCH: Surplus/Deficit Report 5A
209.SCH: Capital Projects Budget And Cash Position Summary 10A
210.SCH: SCH/CTR YTD REV/EXP Summary By Object Group 1A
211.SCH: SCH/CTR PJTD REV/EXP Summary By Object Group 1C
212.SCH: SCH/CTR (01xxnn) YTD REV/EXP Summary By Object Group 1A
219.SCH: Capital Projects Revenue And Expense Detail 10B
240.SCH: Detail By CNAC/CREF none
300.BUD: Budgetable Amount - Operating Gifts none
301.BUD: Budgetable Amount - Grants/Contracts none
302.BUD: Budgetable Amount - Endowments none
304.BUD: Negative BBA ORG/FUND YTD none
305.BUD: Negative BBA ORG/FUND/CREF YTD none
306.BUD: Negative BBA ORG/FUND/CREF PJTD none
315.BUD: Posted Budget Journal With Exceptions Report none 

Comptroller Spotlights

GL Object Codes FY2018
Concur Expense Type/Object Code Matrix (2018)
FY2017 Closing Instructions
FY17 Closing Calendar QRG
Guide to Year-End Closing
School Closing Summary Template

BEN Offices

BEN Deposits
BEN Financials
Office of the President Home Page Penn A-Z Directories Calendar Maps
 
 
Copyright © , University of Pennsylvania
3451 Walnut Street, Philadelphia, PA 19104 · 215.898.5000
Copyright Information | Contact Us | Privacy Policy


Penn Home
Visit Penn's website