University Controller's Office
Search
Banner Finance
 

Operational (Business) Activity Reports

Chart of Accounts Report

The Chart of Accounts is the numbering system used by Banner to capture financial transactions and facilitate retrieval of information and financial reporting.
The Chart of Accounts structure is composed of six elements: Fund, Organization, Account, Program, Activity, and Location (FOAPAL). Activity is currently not used at VCU.

The Chart of Accounts Detail report is designed to help business users understand the organizational hierarchy and the relationship among the organizational levels within this hierarchy. It also provides related fund and program information associated with all organizational levels. Based on their security clearance within the organization, business users can utilize this report at various levels. These levels are executive, senior management, major budget unit and department. Although the sub-department and organization levels are not given as options in the reporting parameter selection, they are still included in the report's results with their associated information. Click here for sample report. pdf

 

Education & General Programs by Organization Unit Report

This report is designed to provide summarized Educational and General program expenditure figures for major budget units in a given fiscal year and period. Each MBU is presented with its accumulated budget, year to date E&G expenditures, and the percentage of its E&G expenditure to the budget. The results are presented with Executive, Senior Management and Major Budget Unit organization levels. Click here for sample report. pdf

 

Expenses by Fund Type

This report provides summarized expenses for selected Fund Types (the source of funds) in a given fiscal year and period. Results are filtered by senior management level, major budget unit, department code or sub-department code. The fund types available for selection are educational and general, sponsored programs, FACR, auxiliary, restricted, unrestricted, financial assistance and hospital services. Click here for sample report. pdf

 

FGRBDSC Budget Status Fiscal Period

The FGRBDSC Budget Status Fiscal Period is the same report that users can view in ePrint with the additional option to run at four different organization levels: major budget unit, department, sub-department and organization code. Detail includes acccount, adjusted budget, current and year to date activity, budget reservations and available balance. Fiscal year, fiscal period, and preferred organization level are required parameters for this report. Click here for sample report. pdf

 

Fixed Asset Custodian List

The Fixed Asset Custodian report displays active custodians and assigned department(s) based on the organizational hierarchy selected. Results are filtered by executive level, senior management level, or major budget unit. Click here for a sample report. pdf

 

Gift Revenue Report Excluding 408112

This repot is a summary of year-to-date gift revenue with the exception of gifts in account 408112 (general foundation support). Users can select the fiscal year, fiscal period and organization level (MBU, department or sub-department). Report fields include: org code and description, account and account description and year-to-date activity through the selected fiscal period. Click here for a sample report. pdf

 

Invalid Transactions Report

This report identifies transactions that have posted to Banner with mismatched fund and program values. These values differ from the valid fund and program assigned to each account index/organization code. The report is designed to help departments monitor and correct these types of transactions. After identifying a fiscal year, users can select the organization hierarchy of senior management level, major budget unit, department or sub-department. Report results give full details of the invalid transactions including: fiscal year, Banner document number, account index, org description, fund, org code, program code, account, transaction amount, transaction date and posting period (month). Click here for sample report. pdf

 

Monthly Purchase Order and Invoice Activity Detail

The Monthly Purchase Order and Invoice Activity Detail report is designed to provide transaction detail for purchase orders and invoices in a given fiscal period for all organizations. Output includes vendor, purchase order and invoice detail. Business users may run this report at four different organization levels: major budget unit, department, sub-department and organization codes. Fiscal year, posting period (month), preferred organization level and it's related code, and whether to include both purchase orders and invoices or only purchase orders are required parameters to run this report. Click here for sample report. pdf

 

Non-Grant Organization Deficit Report

Non-Grant Organization Deficit Report is designed to present the budget deficits for organizations other than Grants. In order to run this report, business users must enter three parameters: Fiscal Year, Fiscal Period and selection type. Selection type allows users to run the report based on MBU, Department or Fiscal Manager's ID. Click here for sample report. pdf

 

Open Encumbrances

The Open Encumbrances report gives detailed information on all open purchase commitments. Users may run the report by organization code, department or sub-department or major budget unit. Click here for sample report. pdf

 

Personnel and Operating Expenditures Analysis

Summarized report by organization code for accumulated budget and related expenditures for personnel and operating expenditures.

Fiscal year, fiscal period, program (Educational & General, Sponsored Programs, FACR, etc.), and report criteria (MBU, department, sub-department) are necessary parameters to run this report. Click here for sample report. pdf

 

Purchase Card Monitoring Report

This report shows the charges made to the index by each purchase card. The last four digits of the card number are displayed along with the vendor name and amount. This is particularly useful for verifying that PCard logs match what was charged to Banner and that the vendors seem appropriate. The report can be configured to run by MBU, department, sub-department or organization code. Click here for sample report. pdf

 

Receiving Required

This handy report is used to identify purchase orders that have been matched with invoices, but require fiscal approvers to complete the receiving process in Banner. Report can be configured to run by executive level, senior management level, Major Budget Unit, Department or Sub-Department or simply by the Org Code (or Index). Click here for sample report. pdf

 

Revenues and Expenditures-Organization Detail

Summarized report by organization code that includes Revenue budget, current revenues, expenditure budget and current expenditures.

Fiscal year, fiscal period, organization level (Executive to sub-department levels), and program ((Educational & General, Sponsored Programs, FACR, etc.) are necessary parameters to run this report. Click here for sample report. pdf

 

Sub-department Report

This report can be considered as the summary version of Chart of Accounts report. Sub departments are presented with their codes and descriptions in the organizational hierarchy. Each sub department is presented with its all associated organization levels that are higher in the organizational hierarchy. These levels are executive, senior management, major budget unit and department. Click here for sample report. pdf

 

Sources and Uses Statement by Department/Sub-department

The Sources and Uses report provides an overview of a department’s or sub-department’s sources of funding and related expenditures. Report parameters include fiscal year and fiscal period. Users will need to know the numeric code associated with their department or sub-department.

Sources (revenues) and Uses (expenditures) are presented for all funds (Operating, Overhead, Unrestricted, Restricted, Sponsored Programs, Other, Pool Accounts and Hospital Services). Revenues and expenditures are summarized by type (Gifts, Investment Income, labor, supplies, equipment, etc). Click here for sample report. pdf

 

Sources and Uses Statement by MBU

This Sources and Uses report provides an overview of a major budget unit’s sources of funding and related expenditures. Report parameters include fiscal year and fiscal period. Users will need to know the numeric code associated with their major budget unit.

Sources (revenues) and Uses (expenditures) are presented for all funds (Operating, Overhead, Unrestricted, Restricted, Sponsored Programs, Other, Pool Accounts and Hospital Services). Revenues and expenditures are summarized by type (Gifts, Investment Income, labor, supplies, equipment, etc). Click here for sample report. pdf

 

Sources and Uses Statement by SML

This Sources and Uses report provides an overview of a senior management level’s sources of funding and related expenditures. Report parameters include fiscal year and fiscal period. Users will need to know the numeric code associated with their senior management level.

Sources (revenues) and Uses (expenditures) are presented for all funds (Operating, Overhead, Unrestricted, Restricted, Sponsored Programs, Other, Pool Accounts and Hospital Services). Revenues and expenditures are summarized by type (Gifts, Investment Income, labor, supplies, equipment, etc). Click here for sample report. pdf

 

Transaction Detail Report

Transaction detail report is designed to provide detail transaction information in a given fiscal period for all organizations. Transactions are presented chronologically with their description, amounts, associated rule class and document information, related organization code, organization description, account and account description. Business users may run this report at three different organization levels. These levels are: Major budget unit, department and sub-department.

Fiscal year, posting period (month), preferred organization level and its related code, and range for associated accounts (to see whether the transaction is associated with an expenditure, revenue or personnel costs accounts) are necessary parameters to run this report. Click here for sample report. pdf