A-to-Z Index

3030 - Reports

Effective Date: August 1, 2013

Table of Contents:

    .100 General
    .200 Report Descriptions
      .210 Summary Financial Report
      .220 Monthly Detail Report
      .230 Monthly Exception Report
      .240 General Ledger Activity Report

.100 General

The Office of Finance is responsible for maintaining the University's Financial Information System (PeopleSoft Finance) and for disseminating appropriate information to the Campus community. Financial Reports can be run from the Finance System at any time for those that have access to the system. 

Responsible departmental personnel may request security access to the system and their department number(s) by completing the online "IS Access Request”.  Upon receipt of a completed "IS Access Request", IT Training will contact the new requester to schedule the required training prior to gaining access to the system.

Should you have questions concerning completion of the form or obtaining access to the system, contact Finance System Security @ sealkh@jmu.edu or x87078.

The following subsections provide detailed descriptions of the information included on the Summary Financial Report and the Monthly Detail Report.

.200 Report Descriptions


.210 Summary Financial Report

This report provides monthly and year to date revenue and expenditure transactions for each organization by account code. It also provides both original and revised budget by account code and calculates budget balance before and after encumbrances.
Sub-totals are provided for:

  • Personal Service Expenses and Personal Service Recoveries
  • Non–Personal Service Expenses and Non–Personal Service Recoveries
Total are provided for:
  • Revenues
  • Personal Services
  • Non–Personal Services
  • Total Expense and Recoveries combined for the organization

THE "HEADER" SECTION:

Report Title: James Madison University, Summary Financial Report.

Time Period of the Report: For the Period Ending – Month, Day, Year.

For Department: The report is for the Department Number/Name listed here. Department Numbers are provided in numerical sequence by Department Number and in alphabetical sequence by Department Name.

THE BODY OF THE REPORT:

Account: Revenue, Expenditure Account code and or Recovery. Expenditure Account Code definitions are available in Section 2015 and Revenue Account Code definitions are available in Section 2020 of these procedures.

Description: The description of the revenue and/or expenditure account code.

Original Budget: The beginning budget for the current fiscal year.

Revised Budget: The beginning budget adjusted by budget revisions approved and processed through the date of the report.

Revenue/Expenditure, Current Month: Current month's revenues, if applicable, and expenses recorded as of the report date.

Revenue/Expenditure, YTD: Revenue, if applicable, and expenditures recorded through the current month, for the fiscal year.

.220 Monthly Detail Report

The monthly detail report lists all budget, revenue, and expenditure transactions recorded in the Finance System for the reporting month. Transactions are listed individually by Revenue and Expenditure account code and include a brief description of the code. Totals are provided for each Account Code and for All Revenue Codes, Personal Service Expenses, and Non-Personal Service Expenses. A grand total is provided for All Expense Codes and a net total (difference between revenues and expenditures) for the Department. The total for each account code is automatically transferred to the Summary Financial Report.

THE "HEADER" SECTION:

Report Title: James Madison University, Monthly Detail Report.

Time Period of the Report: For the Period Ending, Month, Day, Year.

For Department: The Department Number and Name.

Manager Name: The title of the person responsible for the Department number listed on the report.

Report ID: JGL0001

Page. Number of pages in this report.

Run Date: The date the report was run.

Run Time: Time the report was run.

THE BODY OF THE REPORT:

Date: The date transactions were posted to the FIS.

GL Jrnl ID: General Ledger Journal Identification number of the transaction listed.

SRC: Source of the transaction, either Procurement (PO), General Accounting (GA), or Accounts Payable (AP).

Sub ID: A second Identification number, the Voucher No. for vendor payments or PO No. for purchase orders.

Description: A brief description of the transaction and/or the name of the payee, vendor or deposit certificate number.

Budget Amts: Amounts of original and budget revision transactions.

Actual Amts: Actual amounts of individual transactions posted.

 

.230 Monthly Exception Report (formerly known as the Cross Period Posting Report)

This cross period posting report provides a summary of transactions that are processed in a given month but posted to the ledger in a previous month.

THE "HEADER" SECTION:

Report Name:  JGL0009

Report Date: The date the report was run.

Manager Name: The title of the person responsible for the Department number listed on the report.

Report Title: James Madison University, Cross Period Posting Report.

Time Period of the Report: For the Period Ending, Month, Day, Year.

For Org: The Department Number and Name.

Page No. Number of pages in this report.

Run Time: Time the report was run.

THE BODY OF THE REPORT:

Journal Date: The date transactions were processed.

Posted Date: The date transactions were posted to the FIS.

GL Jrnl ID: General Ledger Journal Identification number of the transaction listed.

SRC: Source of the transaction, either Procurement (PO), General Accounting (GA), or Accounts Payable (AP).

Sub ID: A second Identification number, the Voucher No. for vendor payments or PO No. for purchase orders.

Description: A brief description of the transaction and/or the name of the payee or vendor.

Actual Amts: Actual amounts of individual transactions posted.

 

.240 General Ledger Activity Report

The monthly report lists all accounts posted to the department/organization in the Finance System for the reporting month. Transactions are listed individually by Revenue, Expenditure, Liability and Cash account code. Total Activity, Ending Balance, and Expended Balance are provided for each account code.

THE "HEADER" SECTION:

Report ID:  GLS7002

Bus. Unit: JMDSN - James Madison University

Ledger: ACTUALS - Actuals Ledger

For Fiscal Year: The fiscal year of this report.

Period: Month to Month period of this report.

Dept: The Department/Organization Number is listed here.

Currency Code: This will always be USD (US Dollars).

Report Title: PeopleSoft GL - General Ledger Activity.

Page No. Number of pages in this report.

Run Date: Date the report was run.

Run Time: Time the report was run.

THE BODY OF THE REPORT:

Curr: Currency Code, which will always be USD for US Dollar.

Journal Date: The date transactions were posted to the FIS.

Journal ID: The journal number or PO number for that transaction.

Seq Line: Sequence line number for that posting.

Dept: Department number of the transaction.

Account: The account the transactions were posted to the FIS.

Program:  The program code associated with department.

Debit: The amount charged to the account for that transaction.

Credit: The amount credited to the account for that transaction.

Balance: The net balance of the account for the month.