DARTS : Department Budget and Actuals by Fiscal Year and Accounting Period - USM Academic Affairs

Report Purpose

This report is the same as the parent page report, but is specific to departments within USM Academic Affairs.

For any chosen Academic Affairs department at USM, this query returns current budget and year-to-date actual expenditures by month, and includes a year-to-date total based on the accounting period requested.

 This query is a useful tool to quickly review Fiscal Year Budgets when:

• Comparing budget to monthly expenditures
• Aggregating expenditures to date based on the month or Accounting Period selected (valid to date for current month expenditures posted)

The Query has prompts for Fiscal Year, Accounting Period, and Department (Financials DEPTID - the Prompt Table is extensive, it uses a "Begins with" string, so can be limited easily by campus or range).

This query works for a single department; the logic will work for multiple departments, institutions, or any field or combination of fields in the GL Chart of Accounts. It is useful for anyone looking for a current snapshot of their department's expenditures.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

UMS_DTS_CHART_OF_ACCTS_ACAD_AF

Report Type

Query

Prompts Required

Data Fields Generated

Tables Used

• UM_GLQ_REPRTING - Ledger Data