PBC Schedule 137 Detail Listing of Expenditures DW Report

June 2016

Detail Listing of Expenditures

The screenshots below describe the KPMG approved and required DW dashboard to be used to generate PBC schedule 137.

Select FIRMS GAAP Dashboard
Select PBC 137 Report page
Populate Report Filters:
·  Business Unit (xxCMP)
·  Fiscal Year
·  Period From/To 1-12*
·  Nat Class Fdescr = 722004
*Period 1-9 is submitted at interim audit (PBC 519). Period 10-12 is submitted at final audit.
Click Apply Filters /
Select Report View: Actuals Transactions /
Export Data to CSV Format /
Agree sum of DW Schedule 137 (Excel) Report for periods 1 to 9 (interim PBC 519) and DW Schedule 137 (Excel) for periods 10 to 12 Report (final PBC) total to Lead Sheet Summary Report total (PBC #22 – Report CSUFS169).
Once the two numbers agree, upload the Excel to PBC SharePoint site.
Note: CSU Fund field was added in FY 2014-15 to assist with identification and selection of SRB CSU funds. /

Troubleshoot Differences:
Leading causes of differences between PBC 137 report and Lead Sheet Summary Report are:
·  GAAP Override
·  FIRMS Remapping
A couple of tools to help you identify these two types of differences:
·  CSU_GAAP_Override_2 query. This query will return the PS account, FIRMS object code, the Natural Classification and the AAT Natural Class. See if the Nat Class & AAT Nat Class impact 722004.
·  CSU_GAAP_AAT_MAPPING_CHANGES query to help identify which FIRMS object codes have been remapped.
Once you have prepared the reconciliation and identified the causes, the detail amounts should either be added to the PBC 137 report or removed from the PBC 137 report to agree to the total on the GAAP summary trial balance before providing the PBC 137 report to the auditor.
Example on the right: /

Page 5 of 5