210 likes | 390 Views
** Happy New Year ** Preparing your Campus for Year-End Close. Amy Ahearn and Lorissa Cheney, MAPO Chancellor’s Office Year-End Legal Training April 17, 2014. PO Rollover – Run Control. CSU Year End Processing > Year End Processes > PO Rollover. PO Rollover – PO Rollover Verification.
E N D
** Happy New Year **Preparing your Campus for Year-End Close Amy Ahearn and Lorissa Cheney, MAPO Chancellor’s Office Year-End Legal Training April 17, 2014
PO Rollover – Run Control • CSU Year End Processing > Year End Processes > PO Rollover Year-End Legal Training
PO Rollover – PO Rollover Verification • Query the Ledger_KK table • Select the following fields & criteria listed below • BU • Fund • Ledger = KK_DTL_ENC • Account • Fiscal Year = the new fiscal year ex: 2014 • Period = 0 • Monetary Amount (sum) <> = 0.00 Year-End Legal Training
PO Rollover – PO Rollover Verification Year-End Legal Training
Activate Fund Balance Accounts Year-End Legal Training
Chartfield Value Sets - update • Chartfield value sets are used in the closing rules. They combine your fund trees w/the fund balance accounts. Update them thru the end of your fiscal year. Year-End Legal Training
Chartfield Value Sets – cont. Year-End Legal Training
Closing Rule update Year-End Legal Training
Closing Rule update – cont. Year-End Legal Training
Closing Rule update – cont. Year-End Legal Training
Closing Rule update – cont. Year-End Legal Training
Closing the Ledger Year-End Legal Training
Verifying Ledger Close Year-End Legal Training
Copying Trees • Copy Chartfield Trees to establish CF Trees in the new Fiscal Year Year-End Legal Training
Copying Trees – cont. • Copy Chartfield Trees • Add DW_cf name is you’d like to see tree in the DW • Update the Effective date - • First day of new fiscal year • Last day of new fiscal year Year-End Legal Training
Copying Trees – cont. • New tree – should be valid Year-End Legal Training
Year End SAM99 Submission • Verify: • Update Fiscal Year • Accounting Period 12 (or closed period for test) • Accr Rev Tape box checked • Year End Tape box checked Year-End Legal Training
Year End SAM99 Submission – cont. Prior Lessons Learned: • Use correct naming convention: FISCAL.D041714A.AGYACR (Day of actual SAM99 submission to SCO) • Verify Prior Year Accrual File has been loaded into PeopleSoft (if applicable). • Run SAM99 “TEST” report for a closed period. • File should not be opened prior to saving as .ACYACR file. • Use WS_FTP (PRO or LE) to transmit file to SCO • Files will not be accepted after 2 pm by the SCO • Send approved notification email to SCO Year-End Legal Training
Appendix_24_Year End Close Checklist Year-End Legal Training
Contact Information: Amy Ahearn (562) 951-4620 aahearn@calstate.edu Lorissa Cheney (562) 951-4626 lcheney@calstate.edu Year-End Legal Training
www.calstate.edu Year-End Legal Training