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
GL Fund and Account Details CRYSTAL Report
Description and Prompting Query Fields
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.
Prompting Query Fields:
- Fiscal year
- Ending fiscal period
- Fund code
- Account code
View Information [for Crystal Report]:
View: FG.Transaction.Det.Incl.Genl
Trial Balance Summary WEB Report
Trial Balance Summary CRYSTAL Report
Description and Prompting Query Fields
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.
Prompting Query Fields:
- Fiscal year
- Fiscal period
- Fund code
View Information [for Crystal Report]:
View: FG.Periodic.Balance.Sheet
Balance Sheet Summary WEB Report
Balance Sheet Summary CRYSTAL Report
Description and Prompting Query Fields
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.
Prompting Query Fields:
- Fiscal year
- Fiscal period
- Fund code
View Information [for Crystal Report]:
View: FG.Periodic.Balance.Sheet
Fiscal Year Details (Actuals only) WEB Report
Fiscal Year Details (Actuals only) CRYSTAL Report
Description and Prompting Query Fields
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.
Prompting Query Fields:
- Fiscal year
- Ending fiscal period
- Fund code
View Information [for Crystal Report]:
View: FG.Transaction.Det.Incl.Genl