Transcript Year End/Month End Reports Year End Training May 21, 2007 May 21, 2007

Year End/Month End Reports
Year End Training
May 21, 2007
May 21, 2007
1
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
2
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
3
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
4
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
5
Sample Sam 6 - Output
May 21, 2007
D. Brothwell, CPSLO
6
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
7
SAM 7 – Trial Balance
• Recommended Uses
– Review of abnormal balances
– Review the encumbrance amounts reported as
Accounts Payable
May 21, 2007
D. Brothwell, CPSLO
8
SAM 7 – Trail Balance – Run
Control
Insert FY and
Accounting
Period
May 21, 2007
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
D. Brothwell, CPSLO
Input specific
values or the
range for all
values
9
Sample Sam 7 - Output
May 21, 2007
D. Brothwell, CPSLO
10
CSUGL005 – Trial Balance by
SCO/Fund Run Control
May 21, 2007
D. Brothwell, CPSLO
11
CSUGL005 – Trial Balance by
SCO/CSU Fund
May 21, 2007
D. Brothwell, CPSLO
12
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
13
CSUGL06 – Trial Balance by
SCO/CSU and PeopleSoft Fund
May 21, 2007
D. Brothwell, CPSLO
14
“NEW” Sam18 Reports (Not the
old ones)
• Available in release 060
May 21, 2007
D. Brothwell, CPSLO
15
Sam 18 Reconciliation Summary –
Run Control
May 21, 2007
D. Brothwell, CPSLO
16
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
17
Sam 18 – Reconciliation Run
Control (CSUGL018, 19 & 20)
May 21, 2007
D. Brothwell, CPSLO
18
SAM 18 Recon – SCO/CSU Fund
Output
May 21, 2007
D. Brothwell, CPSLO
19
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
20
Summary of SAM 18 Reports
May 21, 2007
D. Brothwell, CPSLO
21
Open PO Activity Report – Run
Control
May 21, 2007
D. Brothwell, CPSLO
22
Open PO Activity Report – Run
Control
Open PO Activity vs All
PO Activity
May 21, 2007
D. Brothwell, CPSLO
Can be run as
format CSV, then
imported into
excel for easy
sorting
23
Output of Open PO Activity Report
May 21, 2007
D. Brothwell, CPSLO
24
SAM 6 Open Encumbrance Total
$54,255.34
May 21, 2007
D. Brothwell, CPSLO
25
Open PO Activity “dump” to Excel
May 21, 2007
D. Brothwell, CPSLO
26