Introduction to USC Accounting Tools

1

• Introduction to USC Accounting Tools

2
Whats the Difference?

• Data Warehouse
• On Demand
• IMS (Accounting Menu)
• Accounting Services Intranet
• Access General Ledger Summary Reporting

3
Data Warehouse

• http//datawarehouse.sc.edu/
• Management Reports
• General Ledger Summary Monthly
• Object Code Summary
• Revenue Report
• Reference Reports
• Chart of Accounts
• Object Code Listing
• Account Descriptions
• Account Listing by Responsibility Code
• Detail Reports
• Transaction Detail
• Vendor and Travel Detail

4
Data Warehouse (contd)

• Financial Cubes
• Allows users to set parameters
• Multiple time periods
• Training available through UTS
• Help desk 777-1800

5
On Demand

• Existing reports
• Does not allow for user manipulation (look only)
• Training and interface available through CSD
• Call 777-1800

6
IMS (Accounting Menu)

• Limited information available
• Not user-friendly
• Old, yet reliable
• Updated nightly
• Instructions available through Accounting
  Services.
• Call 777-2602

7

• IMS (Accounting Menu) and On Demand require the
  same user ID and password!

8
Accounting Services Intranet

• https//image.admin.sc.edu/
• User friendly
• Allows user to set parameters
• Can export data to Excel
• Can drill through to source document
• Fast
• Updated nightly

9
Accounting Services Intranet (contd).

• New.GL Dashboard feature
• E-mail alerts
• Use your network ID password
• Training videos available through website

10
General Ledger Summary Reporting

• Retrieval of summary information
• User sets parameters for data requested
• Display options
• Information dating back to FY 92/93
• Allows for saving report settings

11
GL Summary (contd).

• Download from Intranet
• Select Accounting Tools
• Select Accounting Report Tools
• Watch GL Reporting training videos
• Select download
• Icon will appear on desktop

12
BD System

• User submits BDs electronically
• Many checks/balances built into the system
• Download from
• https//image.admin.sc.edu/
• Network user ID password

See handout!
13

• Questions?