1 / 23

Chapter 4

Chapter 4. KPMG LLP. PeopleSoft 8.4 GL GAP Ledger Closing. Agenda. GAAP Configuration & Setup GAAP Closing GAAP Derivation GAAP Reports. Configuration & Setup. Update TableSet Control Define CF Value Sets – Closing Define Closing Rules. Update xxGAP TableSet Control.

benito
Download Presentation

Chapter 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 4 KPMG LLP PeopleSoft 8.4 GL GAP Ledger Closing

  2. Agenda • GAAP Configuration & Setup • GAAP Closing • GAAP Derivation • GAAP Reports

  3. Configuration & Setup • Update TableSet Control • Define CF Value Sets – Closing • Define Closing Rules

  4. Update xxGAP TableSet Control • PeopleTools > Utilities> Administration > TableSet Control > Record Group • For nVision change “Default” to GAP SetId

  5. FS_04 Detail & Summary Ledgers XxGAP FS_05 Accounts CSGAP FS_11 Sources XxGAP FS_15 Journal Templates XxGAP FS_20 Funds CSGAP FS_28 Programs CSGAP GL_02 Closing Definition XxGAP GL_11 CF Value Sets – Closing XxGAP Update xxGAP TableSet Control • Summary of updates to xxGAP

  6. Define CF Value Sets - Closing • Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Chartfield Value Sets > Set Up Chartfield Value Sets

  7. Define GAAP Closing Rules • General Ledger > Close Ledgers > Closing Rules

  8. Define GAAP Closing Rules • Year End Closing Options hyperlink • Note: Store P/L Reversal Entries must be on. GAAP Extract picks up 999 entries otherwise submission will be out of balance.

  9. Define GAAP Closing Rules • Close to Multiple Retained Earnings • Slide 6

  10. Define GAAP Closing Rules • Journal Options

  11. Define GAAP Closing Rules • Roll Forward Options

  12. GAAP Closing • GAAP specific Closing Rules • Run Year-End Close for xxGAP • Establishes GAAP Period 0 in next Fiscal Year • Run delivered GAAP Reports and compare to prior year reporting package

  13. GAAP Derivation • GAAP Monthly Derivation – Actuals • Journal Generate GAAP Journals • GAAP Adjustments • Accounting Period 998

  14. GAAP Reports • CSU CDIP > GAAP REPORTS • Statement of Expenses • Expenses – Lead Sheet Summary • Statement of Net Assets • Net Asset Lead Sheet – Summary • Net Asset Lead Sheet – Detail • Net Asset Lead Sheet – GAAP Adj

  15. GAAP Reports • Statement of Expenses (CSUFS166.sqr)

  16. GAAP Reports • Expenses – Lead Sheet (CSUFS167.sqr)

  17. GAAP Reports • Statement of Net Assets (CSUFS168.sqr)

  18. GAAP Reports • Net Assets – Lead Sheet Summary (CSUFS169.sqr)

  19. GAAP Reports • Net Assets – Lead Sheet Detail (CSUFS170.sqr)

  20. GAAP Reports • Net Assets – Lead Sheet GAAP Adj (CSUFS171.sqr)

  21. References • CDIP Configuration Guidehttp://cms.calstate.edu/T2_MFIS84Documentation.asp • CDIP Month & Year End Procedureshttp://cms.calstate.edu/T2fn84bp.asp

  22. References – Handout • CDIP GAAP Reporting – Hightlights

  23. Any Questions PY GAAP Financial Statements Faculty Payroll Accruals Prior Year’s Encumbrances PY GAAP Adjustments GAAP Reporting Manual Unexpended Appropriation Balance CWIP Other GAAP Adjustments Deferred Revenues Prepaids & Inventories Energy Leases Library Collections Self-Insurance Claims Capital Lease Obligations Compensated Absences Revenue Bonds

More Related