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 (#7)
Documentation :|: BEN Balances Report Documentation

Report Template #7: Fund View
Last Revised: 4/17/13

Report Template #7 is designed to present a balance sheet and income statement for a fund. Template #7 is used in producing the endowed fund (114) and gift fund (116) reports. The Template is divided into two parts: Part 1 defines the assets and liabilities of the fund for the balance sheet and Part 2 defines the revenue and expenses of the fund for the income statement.


  Report Row label Object Range Object Parent
Part 1: Balance Sheet
 1 Assets  
 2 Derived Cash 1111..9999 (see Note 1) C470
 3 Other Cash 1111..1149 C471
 4 Receivables 1200..1299 C472
 5 Prepaid Expenses/Deferred Charges 1300..1399 C473
 6 Inventories 1400..1499 C474
 7 Advances/Inter-Entity Due to/Due From 1500..1599 C475
 8 Loans Receivable 1600..1699 C476
 9 Investments (Fair Market Value):  
 10 Book Value - Orig Gift  
 11 Direct Holdings 1700, 1701, 1703 C477
 12 AIF 1710 C478
 13 University Fixed Income Fund 1720 C479
 14 University Equity Fund 1730 C480
 15 University Short Term Bonds 1740 C481
 16 Specially Managed Investments 1750 C482
 17 University High Yield Bond Funds 1760 C483
 18 Outside Managed Investments 1770 C484
 19 Other Investments, Treasurer 1780..1789 C485
 20 Total Book Value - Orig Gift Sum rows 11..19 C486
 21 Book Value - Spending Rule 1713 C487
 22 Realized Gains/Losses 1711, 1714, 1721, 1731, 1741, 1751, 1761, 1771 C488
 23 Unrealized Gains/Losses 1702, 1712, 1715, 1722, 1732, 1742, 1752, 1762, 1772 C489
 24 Total Investments (Fair Market Value): Sum rows 20..23 C490
 25 Plant Assets 1800..1899 C491
 26 Construction in Progress (CIP) 1900..1999 C492
 27 Total Assets Sum rows 2..8, 24..26 C493
 
 28 Liabilities    
 29 Accounts Payable, Accrued Exp, Reserves 2100..2499 C494
 30 Deferred Income 2500..2599 C495
 31 Deposits and Advances 2600..2699 C496
 32 Short-term and Long-term Debt 2700..2799 C497
 33 Due to/Due From (Agency) 2800..2899 C498
 34 Total Liabilities Sum rows 29..33 C499
 
  Net Assets Total Assets + Total Liabilities C500
Part 2: Income Statement
 1 Gift Revenue 4400..4401, 4406..4420 C864
 2 Indirect Cost Recovery (Gift Funds) 4402, 4405 C406
 3 Net Gift Revenue Sum rows 1..2 C501
 
 4 Investment Income 4700, 4710, 4716, 47250, 4730, 4740, 4750, 4760, 4770, 4780 C502
 5 Indirect Cost Recovery (Endowment Funds) 4790..4799 C507
 6 Net Investment Income Sum rows 4..5 C504
 
 7 Gains/Losses 4701..4708, 4711..4712, 4714..4715, 4717, 4721..4722, 4731..4732, 4741..4742, 4751..4752, 4611..4762, 4771..4772, 4781..4782 C505
 8 Spending Rule Income 4713 C503
 9 Other Income 4000..4179, 4181, 4194, 4200..4399, 4500..4699, 4178..4179, 4723..4729, 4733..4739, 4743..4749, 4753..4759, 4763..4769, 4773..4779, 4783..4789, 4800..4809, 4830..4990, 5283, 5509..5510, 5806..5809, 5811, 9400..9499 C506
 10 Reclassifications 4810..4819 C508
 11 Other Transfers 4709, 4820..4829, 4991..4992 C509
 12 Total Revenue Sum rows 3, 6..11 C510
 
 13 Total Expense 4180, 4182..4193, 4195..4199, 5000..5282, 5284..5508, 5511..5805, 5810, 5812..5999, 9500..9599 C511
 
 14 Net Change Total Revenue + Total Expense C512


Notes:

1. Derived cash is calculated as the:

(Sum of the project-to-date balances in each of the object codes listed) * -1.

window

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
spacer
spacer
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