Docstoc

EIA-Monthly-Closing-Schedule,-20082009-(xls)---University-of-

Document Sample
EIA-Monthly-Closing-Schedule,-20082009-(xls)---University-of- Powered By Docstoc
					Endowment & Investment Accounting (EIA) - Monthly Closing Schedule - FY 2008-09
Step XX XX 01 Activity Please refer to the EIA FY 2007-08 Closing Schedule for monthly closing dates for July 2007 Please refer to the EIA FY 2007-08 Closing Schedule for monthly closing dates for August 2008 Prepare and post journal for forward funding of UCRP benefits payments and expenses. Review and verify adequate balances in sub code 9 are available in member funds. Bruce Maudlin Last working day of the month that is being closed. Run Advances in EIAS and post entries. 1st working day EIA Pool Cutoff All campuses, UCOP departments submit journals to EIA daily Last day to submit all EIAS journals pertaining to previous month to EIA 3rd working day, except as noted Review and post journals including those from other offices 3rd working day of the following month, except as noted OTR receives SS custody feed, reviews SS control reports and posts to EIAS 4th working day General Ledger cutoff 4th working day Request Prelim ENR table update Load Prelim ENR table update (fndatr, glpool) 4th working day Run STIP process in EIAS: Reconcile STIP investments, Income, Realized and Unrealized Gain/Loss with OTR Post STIP $Day income distribution to EIAS 4th - 6th working day Reconcile pool funds (GEP, HIP and UCRP), CAM fund and UCRSP investment funds (Savings, Equity, etc.) Reconcile all other assigned GL accounts 4th (Preliminary) to 6th (Final) working day Deadline to submit UCLA journals to UCOP for processing 5th working by 12 noon, except as noted Run Pool Processing: Post income distribution, administration fees and buy/sells to EIAS: TRIP , UCRP, GEP and HIP 6th working day General Ledger - CLOSED 6th working day, except as noted Request Income Estimate processing and ENR table update Run Income Estimate processing and load ENR table update (all tables) 6th working day Produce Pool Rate Schedule Upload schedule to EIA Campus Services Web Site 7th working day Prepare UCRP Pool Income Distribution schedule and forward to Bob Yastishak/OTR 7th working day Endowment cash (GEP and HIP to enter) available in EIAS for OTR access 7th working day Produce EIA Statements for UC Foundations and other affiliated organizations Upload Statements to EIA Campus Services Web Site 7th & 8th working day Produce campus reports: Pool Share and Market Value reports in Acrobat format Income Estimate Summary reports in Acrobat and Excel formats Upload reports to EIA Campus Services Web Site 7th & 8th working day CFS submission for EIAS and UCRS No later than the 8th working day Edit CFS submission and provide report(s) 9th working day Produce STIP $Day Quarterly Rate of Return and prepare letters 10th working day Review CFS submission errors 10th working day Required set-up changes in EIAS GL adjustments to correct erroneous transactions SS CAM feed: 14th working day State Street CAM worksheet received Format into e-journal, import into EIAS and post Please refer to the EIA FY 2008-09 Closing Schedule for monthly closing dates for June 2009 KW As Noted FA As Noted ALL As Noted ALL As Noted ALL KW KW ALL FA FA EIA Staff ALL ALL EIA Team ALL ALL Functional Office ALL ALL HR&B Campus ALL ALL 9/30 10/31 11/26 12/23 1/30 2/27 3/30 4/30 5/29 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09

02 03

JH ALL

OPS ALL

EIA EIA ALL

10/1 10/3

11/3 11/5

12/1 12/3

1/2 1/7 4th day

2/2 2/4

3/2 3/4

4/1 4/3

5/1 5/5

6/1 6/3

04 05 06 07 08

ALL

ALL

EIA OTR ALL EIA IR&C EIA/OTR ALL

10/3 10/6 10/6 10/6 10/6-10/8

11/5 11/6 11/6 11/6 11/6-11/10

12/3 12/4 12/4 12/4 12/4-12/8

1/7 4th day 1/7 1/7 1/7 1/7-1/12

2/4 2/5 2/5 2/5 2/5-2/9

3/4 3/5 3/5 3/5 3/5-3/9

4/3 4/6 4/6 4/6 4/6-4/8

5/5 5/6 5/6 5/6 5/6-5/8

6/3 6/4 6/4 6/4 6/4-6/8

09

ALL

ALL

EIA

10/6-10/8

11/6-11/10

12/4-12/8

1/7-1/12

2/5-2/9

3/5-3/9

4/6-4/8

5/6-5/8

6/4-6/8

10 11

ALL As Noted

ALL As Noted

EIA/CORP EIA

10/7 10/8

11/7 11/10

12/5 12/8

1/6 3rd day 1/12 7th day 1/12 7th day 1/12 7th day 1/12 1/12 1/12 1/12-1/13 1/12-1/13

2/6 2/9

3/6 3/9

4/6 4th day 4/8

5/7 5/8

6/5 6/8

12 13 14 15 16 17 18

ALL KW KW As Noted

ALL FA FA As Noted

ALL EIA IR&C EIA IR&C EIA OTR EIA IR&C EIA IR&C

ALL

10/8 10/8 10/9 10/9 10/9

11/10 11/10 11/12 11/12 11/12

12/8 12/8 12/9 12/9 12/9

2/9 2/9 2/10 2/10 2/10 2/10-2/11 2/10-2/11

3/9 3/9 3/10 3/10 3/10 3/10-3/11 3/10-3/11 OPS

4/8 4/8 4/9 4/9 4/9 4/9-4/10 4/9-4/10 JH/OPS SH/IA 4/10 SH/IA HG/FA 4/13 4/14 4/14

5/8 5/8 5/11 5/11 5/11 5/11-5/12 5/11-5/12 SH/IA HG/FA 5/12 HG/FA 5/13 N/A 5/14

6/8 6/8 6/9 6/9 6/9 6/9-6/10 6/9-6/10 HG/FA

10/9-10/10 11/12-11/13 12/9-12/10 10/9-10/10 11/12-11/13 12/9-12/10

19

As Noted

As Noted

EIA

10/10

11/13

12/10

1/13

2/11

3/11

6/10 JH/OPS 6/11 N/A 6/12 wkk 6/18

20 21 22

IR&C EIA EIA

10/13 10/14 10/14

11/14 11/17 11/17

12/11 12/12 12/12

1/14 1/15 1/15

2/12 2/13 2/13

3/12 3/13 3/13

23

AL

IA

EIA/SS CAM

10/20

11/21

12/18

1/22

2/20

3/19

4/20

5/20

XX

ALL

ALL

ALL

ALL

Functional Office Key: EIA Endowment & Investment Accounting IR&C Information Resources & Communications OTR Office of Treasurer of The Regents CORP General Accounting ALL EIA, OTR, CORP, External Finance, Human Resources & Benefits (UCRS), Mortgage Origination Program (MOP)

D:\Docstoc\Working\pdf\16adc00d-1404-4385-a4c9-29168fd8be02.xls Tab: Sept 08-May 09

Page 1 of 1

Printed: 11/27/2009


				
DOCUMENT INFO
Shared By:
Tags: EIA-M, onthl
Stats:
views:23
posted:11/28/2009
language:English
pages:1
Description: EIA-Monthly-Closing-Schedule,-20082009-(xls)---University-of-