Quick Links

Month End Reports

Instructions for logging in to reports and exporting data is available on the Running Web & Crystal Reports page.
Crystal Reports software is not required to run the web report templates.


Month End Report Templates

Monthly Grant Details WEB Report

Monthly Grant Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2010-11-18

Description:
Displays all monthly Grant related transactions and prior month balance forwards for a specified calendar year and calendar month. Current month transactions and inception to date totals are displayed. Note that all details originating from MMP transactions have been condensed. The report will balance with the Banner form FRIGITD or Budget Queries for Fund Holders in Minerva.

Report Help:
Monthly Grant Details [.pdf]

Prompting Query Fields:
- Calendar year
- Calendar month
- Fund code

View Information [for Crystal Report]:
View: FG.Grant.Balances.Trans.Det
View Help: Grant Balances Transaction Details [.pdf]

Monthly Fund Details WEB Report

Monthly Fund Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-02-18

Description:
Displays all current month transactions and prior month balance forwards for a specified fiscal year and fiscal period. Current month totals and year to date totals are displayed. Note that all details originating from MMP transactions have been condensed. The report will balance with the Banner form FGIBDST or Budget Queries for Fund Holders in Minerva.

Report Help:
Monthly Fund Details [.pdf]

Prompting Query Fields:
- Fiscal year
- Fiscal period
- Fund code

View Information [for Crystal Report]:
View: FG.Balances.Transaction.Det
View Help: Balance Transaction Details [.pdf]

Monthly Payroll Details WEB Report

Monthly Payroll Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all Payroll related transaction details for a specified fiscal year and fiscal period.
Current month totals are displayed by Account code.

Report Help:
Monthly Payroll Details [.pdf]

Prompting Query Fields:
- Fiscal year
- Fiscal period
- Fund code

View Information [for Crystal Report]:
View: FG.Payroll.Distribution
View Help: Payroll Distribution [.pdf]

Endowment Fund Details WEB Report

Endowment Fund Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Contains the Endowment Fund transaction details for a given fiscal year It includes account code beginning with 3 and 4. The current fund balance is calculated.

Report Help:
Endowment Fund Details [.pdf]

Prompting Query Fields:
- Fiscal year
- Fund code

View Information [for Crystal Report]:
View: FG.Transaction.Det.Incl.Genl
View Help: Transaction Details - Include General Ledger [.pdf]

Trust Fund Details WEB Report

Trust Fund Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Contains the transaction details for a given fiscal year and fiscal period range starting from 00 to queried fiscal period. It includes revenue (5), salary (6), expenditure(7) and transfer (8) accounts as well as fund balance accounts (4).

Report Help:
Trust Fund Details [.pdf]

Prompting Query Fields:
- Fiscal year
- Ending fiscal period
- Fund code

View Information [for Crystal Report]:
View: FG.Transaction.Det.Incl.Genl
View Help: Transaction Details - Include General Ledger [.pdf]