1 / 27

Data Warehouse for GAAP Reporting

Data Warehouse for GAAP Reporting. Amy Ahearn, MAPO and Kelly Cox, Accounting Chancellor’s Office Year-End GAAP Training April 18, 2014. Data Warehouse. Changes Overview New Functionality Tips & Tricks. Data Warehouse 11G Changes. Look & Feel Navigation Change in nomenclature

badrani
Download Presentation

Data Warehouse for GAAP Reporting

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. Data Warehousefor GAAP Reporting Amy Ahearn, MAPO and Kelly Cox, Accounting Chancellor’s Office Year-End GAAP Training April 18, 2014

  2. Data Warehouse • Changes Overview • New Functionality • Tips & Tricks Year-End Legal Training

  3. Data Warehouse 11G Changes • Look & Feel • Navigation • Change in nomenclature • Added functionality & tools Year-End Legal Training

  4. Look & Feel Changes • Recent shows the last 6 reports run in clockwise order Year-End Legal Training

  5. Navigation • Navigation is now a dropdown menu Year-End Legal Training

  6. Nomenclature • ‘Apply’ has replaced ‘Go’ on each of the pages • ‘Reset’ will reset to last applied values, default values or will clear all values Year-End Legal Training

  7. Nomenclature – cont. • ‘Customization’ replaces ‘Default’ Year-End Legal Training

  8. Added Functionality & Tools • Can sort any column • Breadcrumb Navigation Year-End Legal Training

  9. Added Functionality & Tools – cont. • Enhanced Search functionality • By unchecking ‘Match Case & changing the criteria to ‘Contains’- maximum results Year-End Legal Training

  10. Added Functionality & Tools – Pivots • Users have the ability to create pivots in reports & drill downs • Right Click • Or Drag & drop Year-End Legal Training

  11. Added Functionality & Tools – Sections • Users have the ability to create sections in reports & drill downs • Right Click • Or Drag & drop Year-End Legal Training

  12. Added Functionality & Tools – Include column • Users have the ability to include columns into reports & drill downs • Right Click to & select column(s) to include *there are some limitations – i.e. you cannot add in calculated fields available in other views on the same report. Static fields (i.e. CF, Jrnl ID’s, etc) work well Year-End Legal Training

  13. Added Functionality & Tools – Exclude column • Users have the ability to exclude columns on reports & drill downs • Users can save reports that have included/excluded columns • Drill downs cannot be saved as defaults as they are dynamic • Included columns can be used as pivots/sections & saved • Drill downs cannot save pivots/sections Year-End Legal Training

  14. PBC 94 Accounts Payable Lead sheet • Purpose: To provide analysis by Net Asset Category for the GAAP acct 712101 • FIRMS-GAAP→ GAAP Summary • Report Filters: • Fiscal Year 2013 • Period Between 0 – 998 • Account : 712101 • Columns: • Account • Account Fdescr (drill on Acct) Year-End Legal Training

  15. PBC 94 Accounts Payable Lead sheet **Lead Sheet Summary Report (PBC #22 – Report CSUFS169) is tied to the DW GAAP Summary** Year-End Legal Training

  16. PBC 94 Accounts Payable Lead sheet • New view: SCO and CSU Fund. Problem seen between 881 and 891. Amount ties to Original Schedule Year-End Legal Training

  17. PBC 139 Auxiliary Enterprise Expense • Purpose: To create the actual PBC detail listing of the components of auxiliary enterprise expenses. • FIRMS-GAAP→ GAAP Actuals • Report Filters: • Fiscal Year 2013 • Period Between 1 – 998 • Program Code: 20 • Account : 722001-722006 Year-End Legal Training

  18. PBC 139 Auxiliary Enterprise Expense • Download data results to be submitted to KPMG as PBC 139 • But FIRST! Tie it out… • PIVOT by Account • Tie out to Lead Sheet Summary (Report CSUFS167) Year-End Legal Training

  19. PBC 139 Auxiliary Enterprise Expense Year-End Legal Training

  20. PBC 139 Auxiliary Enterprise Expense • FIRMS-GAAP→ GAAP Summary by Fiscal Year • Added Columns: • Class Fdescr • Acct Descr (drill on Acct) • Prog Fdescr Year-End Legal Training

  21. PBC 46 Cash Leadsheet • Purpose: To create the actual PBC cash lead sheet. • FIRMS-GAAP→ FIRMS Summary (3 Columns) • Report Filters: • Fiscal Year 2013 • Period: 12 • FOC: 101004 & 101006 (which includes both cash and cash equivalents, current and non-current) Year-End Legal Training

  22. PBC 46 Cash Leadsheet – Legal Balance Year-End Legal Training

  23. PBC 46 Cash Leadsheet – GAAP ADJ • Purpose: To create the actual PBC cash lead sheet with GAAP Adjustments • FIRMS-GAAP→ GAAP Actuals • Report Filters: • Fiscal Year 2013 • Period: 998-998 • Acct: 711101 & 711201 (which includes both cash and cash equivalents, current and non-current) Year-End Legal Training

  24. PBC 46 Cash Leadsheet – GAAP ADJ Year-End Legal Training

  25. PBC 46 Cash Leadsheet-Final • Populate data results(Legal balance and GAAP ADJs) on Cash Leadsheet to be submitted to KPMG as PBC 46 • But FIRST! Tie it out… Lead Sheet Summary (Report CSUFS167) Year-End Legal Training

  26. PBC 46 Cash Leadsheet-Final Year-End Legal Training

  27. www.calstate.edu Year-End Legal Training

More Related