看片视频

Need Help?

General Ledger Reports

Running WEB Reports

If you are having issues running WEB reports using IE, please try Chrome or Firefox.

看片视频

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

File 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

File 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鈥檚 balance.

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

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

File 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

File 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

Back to top