CMP 102 02: Budget Activity Reports

Comptroller's Office Policies and Procedures Manual
Effective: 01/01/2000	Revised: 02/05/2007

CMP 102 02: Budget Activity and Expenditure Detail Reports

Purpose

To list the reports available for budget management at NAU.

Source

ITS/Comptroller's Office/University Policy

Discussion

The use of financial reports are vital tools for every NAU Business Manager. Beginning with FY 2007, financial reports are available to departments through Business Objects and the Data Warehouse (see Corporate documents within Business Objects) . Business Managers and other users of financial data should review budget reports at least monthly in order to get the status of their fiscal year budgets. Until historical data can be migrated to the Data Warehouse, financial reports prior to FY 2007 will be available via the Advantage web site (see links below).

Reports

Adv3 Report	Description	Web Address
Payroll Register (Payroll folder)	Shows current payroll gross amount paid for each employee. From Peoplesoft Payroll data	Business Objects
Payroll Data (Payroll folder)	Payroll expense information from Advantage after interface from Peoplesoft. Includes manual payroll adjustments	Business Objects
Status of Funds (Budget folder)	Daily Summarized expenditures and encumbrances compared to budget. Separate reports developed for state and local funds.	Business Objects
Open Encumbrance Report (Purchasing folder)	Displays outstanding open encumbrances. Report tabs include: Summarized, All Open Encumbrances, Monthly Detail, PD and PO, RQS, TA, and Raw Data.	Business Objects
Transaction Summary Report (General Accounting folder)	Displays transaction summary for the selected Department Unit(s). Report tabs include Summary, Summary by Sub-Unit, Budget Snapshot and Raw Data.	Business Objects
Transaction Detail (General Accounting folder)	Displays transaction detail for the selected Department Unit(s). Report tabs include Transaction Detail-Expenses, Expenses by Record Date, Expenses by Month, Transaction Detail-Revenue, Revenue by Record Date, and Raw Data.	Business Objects
Grant Reports (Grant folder)	Various transaction detail and summary reports for grant accounts	Business Objects
Adv2 Report	Description	Web Address
Payroll Register (Pay002)	Report of payees by department number for each pay period. Access restricted to authorized users.	Secured Access
Payroll Detail Report	Detail of payroll transactions including ERE and salary wages (interim "HBUD" report") by employee number. Access restricted to authorized users.	Secured Access
Inventory Lookup	Stock Number, Description and Cost of Stores Inventory	Publicly Available
SIGA Table Lookup	Signature Authority	Publicly Available
Status of Funds Daily	Daily Summarized expenditures and encumbrances compared to budget.	Publicly Available
Status of Funds Monthly	Monthly summarized expenditures and encumbrances compared to budget	Publicly Available
Summary Monthly Detail Report (the "8" report)	Detail of revenue and expense, includes encumbrances. By agency/orgn. Access restricted to authorized users.	Secured Access
Summary Monthly Agency/Orgn Report (the "9" report)	Summary of revenue, expense and encumbrances by revenue source and object code within agency/orgn. Previous fund balance information.	Publicly Available
Open Encumbrances Report (the "6" report)	Summary of open encumbrances by agency/orgn.	Publicly Available

Cross-Reference

For information relating to appropriation budget changes, see CMP 102-01, Appropriation Budget Changes.

NAU Home Page | Comptroller's Office Home Page | Back to Table of Contents
Email Webmaster