may 21, 20071 year end/month end reports year end training may 21, 2007
Post on 20-Dec-2015
213 views
TRANSCRIPT
May 21, 2007 1
Year End/Month End Reports
Year End TrainingMay 21, 2007
May 21, 2007 D. Brothwell, CPSLO 2
Summary
• SAM-6 Final Budget Report (CSUSAM06)• SAM-7 CSU Trial Balance (CSUGL007)
– CSUGL005 – Trial Balance by SCO/CSU Fund• With PS Detail or Without (Account Detail)
– CSUGL006 – Trial Balance by SCO/CSU Fund• With PS Detail or Without (Account & Fund Detail)
– SAM18 – Open Liability Report Series– Open PO Activity Report
May 21, 2007 D. Brothwell, CPSLO 3
SAM 6 – Final Budget Report
• Report of Revenue and Expense by CSU Fund– Options:
• Show detail at the FIRMS Object Code Level• Show detail by FIRMS Program Code
– Must be run in CSU Business Unit
• Show detail by FIRMS Program Group– Must be run in CSU Business Unit
• Can be run based on specific value for:– CSU Fund– Program Code– Program Group
May 21, 2007 D. Brothwell, CPSLO 4
SAM 6 – Final Budget Report
• Recommended Uses– When run with FIRMS Object Code
Detail in the CSU Business Unit• Review for negative expenditures
– When run in CSU Business Unit with Program Code = to 1100• Review for Reimbursed Activity = zero
– When run in Campus Business Unit• Review for appropriation deficits• Review for reverting appropriations
May 21, 2007 D. Brothwell, CPSLO 5
Sample SAM 6 Run Controls
Insert FY and
Accounting Period
Insert CSU Fund to limit the report or
leave blank for all
May 21, 2007 D. Brothwell, CPSLO 6
Sample Sam 6 - Output
May 21, 2007 D. Brothwell, CPSLO 7
SAM 7 – Trial Balance
• Trial Balance by CSU Fund• Can be run for all State Funds or all
CSU Funds• Can be run for a specific State Fund
or a specific CSU Fund• Prints the SCO fund level
information first – followed by the CSU Fund level information
May 21, 2007 D. Brothwell, CPSLO 8
SAM 7 – Trial Balance
• Recommended Uses– Review of abnormal balances– Review the encumbrance amounts
reported as Accounts Payable
May 21, 2007 D. Brothwell, CPSLO 9
SAM 7 – Trail Balance – Run Control
Insert FY and
Accounting Period
When the “Pre-close” is checked the report will display the Fiscal Year input AP 0-12, when it is NOT checked it will display AP 0 from the Future Fiscal Year
Input specific
values or the range for all
values
May 21, 2007 D. Brothwell, CPSLO 10
Sample Sam 7 - Output
May 21, 2007 D. Brothwell, CPSLO 11
CSUGL005 – Trial Balance by SCO/Fund Run Control
May 21, 2007 D. Brothwell, CPSLO 12
CSUGL005 – Trial Balance by SCO/CSU Fund
May 21, 2007 D. Brothwell, CPSLO 13
CSUGL06 – Trial Balance by SCO/CSU PeopleSoft Fund
Checking this box will display BOTH
the Fund and Account Detail
May 21, 2007 D. Brothwell, CPSLO 14
CSUGL06 – Trial Balance by SCO/CSU and PeopleSoft Fund
May 21, 2007 D. Brothwell, CPSLO 15
“NEW” Sam18 Reports (Not the old ones)
• Available in release 060
May 21, 2007 D. Brothwell, CPSLO 16
Sam 18 Reconciliation Summary – Run Control
May 21, 2007 D. Brothwell, CPSLO 17
SAM 18 Open Liability Report Series
• These reports are used to reconcile to the SCO Accounts Payable State GL 3010 (FIRMS Object Code 201001)– The detail is made up of both actuals and
encumbrances– The reports run off
• AP Sub System - Actuals• PO Sub System - Encumbrances• GL – Both actuals and encumbrances
May 21, 2007 D. Brothwell, CPSLO 18
Sam 18 – Reconciliation Run Control (CSUGL018, 19 & 20)
May 21, 2007 D. Brothwell, CPSLO 19
SAM 18 Recon – SCO/CSU Fund Output
May 21, 2007 D. Brothwell, CPSLO 20
If this amount does not equal the recon summary, then the GL open liability needs to be run for the
same account as a journal has been processed
May 21, 2007 D. Brothwell, CPSLO 21
Summary of SAM 18 Reports
May 21, 2007 D. Brothwell, CPSLO 22
Open PO Activity Report – Run Control
May 21, 2007 D. Brothwell, CPSLO 23
Open PO Activity Report – Run Control
Open PO Activity vs All PO Activity
Can be run as format CSV,
then imported into excel for easy sorting
May 21, 2007 D. Brothwell, CPSLO 24
Output of Open PO Activity Report
May 21, 2007 D. Brothwell, CPSLO 25
SAM 6 Open Encumbrance Total
$54,255.34
May 21, 2007 D. Brothwell, CPSLO 26
Open PO Activity “dump” to Excel
Microsoft Excel Worksheet