GAAP Reports from CFS Common Code Modifications MP2 Presented by: Lily Wang AUDIT

1. GAAP Reports from CFS Common Code Modifications MP2 Presented by: Lily WangAUDIT

2. Agenda • GAAP Reports Menu Selection • GAAP Reports Statement of Net Assets • GAAP Reports Journal Detail Report • GAAP Reports Ledger Detail Report • CMP/CSU/GAP Ledger Comparison • CSU_ UNRECON_CHK_CSH_BAL Query • AP Check Register • CSU_GAAP_OVERRIDE Query • Reporting Solution Table Year-End GAAP Training

3. GAAP Reports Menu Selection • Report names have been updated to closer match actual name of the report. Enhanced Year-End GAAP Training

4. Statement of Net Assets Enhanced • CSUFS168 – Statement of Net Assets • Current year income is added to each net asset category. • No longer need to run a post-close to see the post-close net asset category balances. • Natural classification accounts previously suppressed appear on statement • Trial Balance Summary and Trial Balance Detail will agree to statement. • Easily identify balances that need to be eliminated for GAAP. Year-End GAAP Training

5. Statement of Net Assets • Natural classification accounts previously suppressed Year-End GAAP Training

6. Statement of Net Assets Statement of Net Assets Statement of Revenues and Expenses Year-End GAAP Training

7. Journal Detail Report New • Journal Detail Report • Current CMS delivered GAAP reports are static and do not allow campuses to download, filter and sort data. • This report will output to a CSV file format and can be saved as Excel. • Allow campuses to slice and dice the data for research and analysis. • Great for researching “Journal Lines Not Found” on the Trial Balance Leadsheet Summary and Detail Reports. Year-End GAAP Training

8. Journal Detail Report CSU State & SW Reporting > Campus Reports > Journal Detail Report Year-End GAAP Training

9. Journal Detail Report 723005 is Interest Expense and should not be in program group 07 Oper & Maint of Plant. Year-End GAAP Training

10. Ledger Detail Report New • Ledger Detail Report • Current CMS delivered GAAP reports are static and do not allow campuses to download, filter and sort data. • This report will output to a CSV file format and can be saved as Excel. • Allow campuses to slice and dice the data for research and analysis. • Great for fluctuation analysis Year-End GAAP Training

11. Ledger Detail Report CSU State & SW Reporting > Campus Reports > Ledger Detail Report Year-End GAAP Training

12. Ledger Detail Report Prior Year Current Year Year-End GAAP Training

13. CMP/CSU/GAP Ledger Comparison New • CMP/CSU/GAP Ledger Comparison • External audit requires each campus to provide a comparison of the CMP/CSU/GAP business unit ledger balances for periods 1-12 to ensure population of data is complete in the GAP Ledger. • Baseline report across CSU to meet external audit Prepared by Client request. • PDF report Year-End GAAP Training

14. CMP/CSU/GAP Ledger Comparison CSU State & SW Reporting > Campus Reports > Trial Balance by Campus Ledger Year-End GAAP Training

15. CMP/CSU/GAP Ledger Comparison Year-End GAAP Training

16. CSU_UNRECON_CHK_CSH_BAL Query New • CSU_ UNRECON_CHK_CSH_BAL Query • Created to assist with the external audit preparation -- Reclassification of Net Cash from short-Term Investments. • May also be used for monthly bank reconciliation. • Identifies outstanding AP Checks by Net Asset Category and CSU fund. Year-End GAAP Training

17. CSU_UNRECON_CHK_CSH_BAL Query Reporting Tools > Query > Query Viewer Year-End GAAP Training

18. CSU_UNRECON_CHK_CSH_BAL Query Year-End GAAP Training

19. CSU_UNRECON_CHK_CSH_BAL Query Year-End GAAP Training

20. AP Check Register New • AP Check Register • Requested by external auditor to perform a search for unrecorded liabilities. • Baseline report across CSU to meet external audit Prepared by Client request. • PeopleSoft delivered check register is bulky and results in a report that wastes paper. • CSU SQR report is formatted and sorted to produce an efficient report. Year-End GAAP Training

21. AP Check Register Accounts Payable > Reports > Payments > CSU Check Register Year-End GAAP Training

22. AP Check Register Year-End GAAP Training

23. CSU_GAAP_OVERRIDE Query • CSU_GAAP_OVERRIDE Query • Created to identify chartfields that have been assigned override values for GAAP derivation. Year-End GAAP Training

24. CSU_GAAP_OVERRIDE Query Reporting Tools > Query > Query Viewer Year-End GAAP Training

25. CSU_GAAP_OVERRIDE Query Year-End GAAP Training

26. CSU_GAAP_OVERRIDE Query FNAT value 836 Year-End GAAP Training

27. Reporting Solution Table • CSU_R_APYMT_CMP – CMP AP Payment Transactions • Created to meet GAAP audit requirements. New Year-End GAAP Training

28. Reporting Solution Table Year-End GAAP Training

29. Resources • Year-End Training Website (PowerPoint) • http://www.calstate.edu/SFSR/Workshops/index.shtml • FAST-ED Portal (Audio Recording) • https://coweubr101.calstate.edu/portal/page/portal/IP_SITE_74 • CFS Website • http://cms.calstate.edu/06_Projects-Initiatives/06F_FISPROJ_CFS/CMS_06F_00_CFS_Home.asp Year-End GAAP Training

30. Resources Year-End GAAP Training