Survival Guide
  U H Home Search University of Houston
 
University of Houston Human Resources
 HOME
Survival Guide Home
 
 FINANCE
Accounts Payable
Baseline Standards and Cash Handling
Budget Journals
Business Continuity Planning
Credit Card Services
Getting Started
Gifts/Endowments
GL Journal Entries
Grant Reports
Misc. Responsibilities
Property Management
Purchasing
Reports
Requests/Work Orders
Tax Information
Understand Cost Centers

Finance Forms
 
 HUMAN RESOURCES
Benefits
Employment
HRIM
New Hire Orientation
PCD
Ethical Conduct of
Employees

Human Resource Forms
 
 PAYROLL
Direct Deposit
Direct Deposit and P.A.S.S
Hard Check Distribution
Payroll Deductions
Payroll Encumbrances
Payroll Reconciliation
Run Trial/Final Payroll
Suspense/Reallocations
Time and Effort
University Pay Glossary
University Pay Statement
Verification Report
W4s and P.A.S.S.
Payroll Forms



Reports
Running Reports - Leave Server Name Blank
Schedule a Report
Deleting Run Controls
Deleting Reports
Paper SCR Requirements
Report Matrix
Monthly Checklist
Fund Equity Report
Negative Fund Equity Report
Unbudgeted Fund Equity Report
Budget Summary Report
Expenditures by College/Division Queries
Department Verification Report
Downloading HR Reports to Excel
Late Payment Interest Query
Unposted Vouchers by Department Query
Open Commitment Query
Unposted GL Journals Query
Purchase Requisitions Not Completed Query
Budget Journals Not Approved Query
Reviewing HR Actions Query
Report Distribution


Expenditures by College/Division Queries

Purpose
Useful to review expenditure totals by college/division at the departmental level.


Navigation

  • Reporting tools


  • Query


  • Query Viewer


  • The following queries are available:


  • EM_Long_Distance


  • EM_Overtime


  • EM_Travel_Exp


  • These queries will enable the user to review expense totals by department for each type of expense.


  • The parameters are the same for each query: Business Unit=00730; Department=The VP or Dean Department ID—for College of Education it would be H0058; Fiscal Year=Current Fiscal Year; From Accounting Period=1 (or the period interested in); To Accounting Period=1 (or period of interest).


  • Click OK


  • The results may be downloaded to Excel if necessary.


  • The user has successfully reviewed the total expense by type for a college/division.


  • ________________________


    View Sample Journal