Quick Links

General Ledger 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.

Submit a Report Request Form to modify an existing report or to request the creation of a new report.


General Ledger Report Templates

GL Fund and Account Details WEB Report

GL Fund and Account Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all General Ledger transactions for the specified fund and account for the requested period. Does not contain previous month balance forwards.

Report Help:
GL Fund and Account Details [.pdf]

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

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

Trial Balance Summary WEB Report

Trial_Balance_Summary CRYSTAL Report 

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Designed to look like the Banner client form FGITBSR with one main difference-displays a balance as of any fiscal period where FGITBSR is always today’s balance.

Report Help:
Trial Balance Summary [.pdf]

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

View Information [for Crystal Report]:
View: FG.Periodic.Balance.Sheet
View Help: Periodic Balance Sheet [.pdf]

Balance Sheet Summary WEB Report

Balance_Sheet_Summary CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays a summary of all balance sheet accounts for a Fund. Beginning balance, ending balance and variance are displayed. Data is grouped by Account Type and Account Code.

Report Help:
Balance Sheet Summary [.pdf]

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

View Information [for Crystal Report]:
View: FG.Periodic.Balance.Sheet
View Help: Periodic Balance Sheet [.pdf]

Fiscal Year Details (Actuals only) WEB Report

Fiscal_Year_Details_(Actuals_only) CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Contains transaction details impacting the YTD ACTUAL column for all periods in the fiscal year. Includes revenue (5 accounts), labour (6 accounts), expenditures (7 accounts) and transfers (8 accounts). Produced for 1B and 1C fund types that have been flagged for cut-off report distribution.

Report Help:
Fiscal Year Details Actuals Only [.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]