Quick Links

General Ledger Reports

Running WEB Reports

If you cannot scroll through pages/down the page of a WEB report, you may need to run the report in a different browser. IT Services recommends using Chrome. More information about supported browsers is available in the IT Knowledge Base.

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.


General Ledger Report Templates

GL Fund and Account Details WEB Report

File 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

File 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:
PDF icon 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

File 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

File 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]