reporting package preparation and standard practices criselle espiritu, analyst, fs / sfsr alyssa...
TRANSCRIPT
Reporting Package Preparation and Standard Practices
Criselle Espiritu, Analyst, FS / SFSR
Alyssa Kanzaki, Accountant, FS / SRB & Capital Projects
Lily Wang, Director, FS / MAPO
Chancellor’s Office
April 24, 2015
Learning Objectives
• Prepare the Year-end System (YES) reporting package in TM1 web. • Apply the standard practices to reporting package
preparation• Respond to the Systemwide Revenue Bond (SRB)
fluctuation analysis questions and answers in TM1
April 2015 Year-End GAAP Training 2
Year-end System (YES) Reporting Package Preparation
• Overview• Accessibility• Logistics• Deadlines• Reference• Contacts
April 2015 Year-End GAAP Training 3
YES Reporting Package Preparation - Overview• The Year-end System (YES) reporting package is a
comprehensive financial statement using TM1 application database• Consists of input sheets for the basic financial statements
and underlying footnotes for campuses and discretely presented component units
April 2015 Year-End GAAP Training 4
YES Reporting Package Preparation – Overview (cont.)• The primary purposes of completing the TM1 YES reporting
package are: To gather financial information from all campuses and
discretely presented component units including the Office of the Chancellor (CO) for the preparation and consolidation of the annual California State University’s (CSU) financial statements.
To gather information for the purposes of preparation and consolidation of the Schedule of Expenditures of Federal Awards (SEFA) for the CSU Single Audit report.
April 2015 Year-End GAAP Training 5
YES Reporting Package Preparation – Overview (cont.)
to satisfy the Prepared by Client (PBC) requirement for the financial statement audit
April 2015 Year-End GAAP Training 6
YES Reporting Package Preparation - Accessibility• YES reporting package is accessed through TM1 web• Limited to 3-5 users per campus depending on the size of
the campus• Primary users are the campus GAAP coordinators• Discretely presented component units do not have access
but their information must be provided to the campus GAAP coordinator for input
April 2015 Year-End GAAP Training 7
YES Reporting Package Preparation – Accessibility (cont.)• To obtain access to YES in TM1, the manager must send
an email request to add a GAAP coordinator to [email protected]
• Once access is granted, the new user will receive an email notification with the necessary information to access YES
• To request termination of access of employees no longer with the campus, the manager must send an email to SFSR.
April 2015 Year-End GAAP Training 8
YES Reporting Package Preparation - Logistics
April 2015 Year-End GAAP Training 9
YES Reporting Package Preparation - Deadlines
The deadlines related to the YES reporting package (versions 1, 2, and 3) can be found in the audit master timeline.
April 2015 Year-End GAAP Training 10
YES Reporting Package Preparation – Deadlines (cont.)
April 2015 Year-End GAAP Training 11
YES Reporting Package Preparation - Reference
April 2015 Year-End GAAP Training 12
• http://cofulwwstm1.co.calstate.edu/tm1web/TM1 Web
• http://calstate.edu/SFSR/Workshops/index.shtml, 2014-2015 | GAAP | Select drop down “Master Timeline”
Audit Master Timeline
• https://csyou.calstate.edu/Employee-Resources/training/financial-services-training/Pages/tm1.aspx
Recorded TM1 Presentation
YES Reporting Package Preparation – Reference (cont.)
April 2015 Year-End GAAP Training 13
YES Reporting Package Preparation - Contacts
• For technical questions such as issues with access, username and password, contact:
Lily Wang, [email protected]• For all other questions such as information entered in the
input sheets, contact:
SFSR Team, [email protected]
April 2015 Year-End GAAP Training 14
Standard Practices
Used by SFSR team when reviewing the campus reporting packages
Campuses can apply these standard practices for reporting package preparation
Listing of standard practices can be found in Chapter 7 of the GAAP Manual
April 2015 Year-End GAAP Training 15
SRB – Fluctuation (Flux) Analysis
Chapter 16 – GAAP Manual
April 2015 Year-End GAAP Training 16
SRB Q & A Logistics
April 2015 Year-End GAAP Training 17
Select Campus
SRB Q & A Logistics
April 2015 Year-End GAAP Training 18
Select Program
SRB Q & A Logistics
April 2015 Year-End GAAP Training 19
Download to Excel
SRB Variance Q & A- Reference
April 2015 Year-End GAAP Training 20
• http://cofulwwstm1.co.calstate.edu/tm1web/TM1 Web
• August 3, 2015 - Legal Flux Information Available• August 25, 2015 – Responses RequiredKey Dates
• https://csyou.calstate.edu/Employee-Resources/training/financial-services-training/Pages/tm1.aspx, select TM1 SRB Q & A Form
Recorded TM1 Presentation
SRB Legal Flux Analysis- Contacts
• For technical questions such as issues with access, username and password, contact:
Lily Wang, [email protected]• For all other questions regarding variance worksheets,
contact:
Alyssa Kanzaki, [email protected]
or
Terri Williams, [email protected]
April 2015 Year-End GAAP Training 21
