Querying Fund/Grant Balances & Transactions

To view the available balance, posted transactions, and financial statements of a Fund or Grant, the following resources are available:

  • Minerva Finance (Fund) Administration menu
  • Banner Finance module forms
  • Web/Crystal report templates.

General Information for Fund and Grant queries

Typically, a fund is linked to a grant for one or both of the following reasons:

  • The fund runs on a different year from the University's fiscal year of May 1-April 30
  • The fund requires inception-to-date instead of year-to-date reporting

In order to accommodate the different reporting needs for funds and grants, various forms and tools have been created.

The table below lists the best tools to use when querying funds and grants through Banner and Minerva > Finance (Fund) Administration menu options.

Action Application Menu option/form (non-grant) menu option/form (grant)
I need to see my Available Balance

Minerva > Finance

 
 

Banner

Budget Query for Fund Holders

Balance displayed on the first screen
(view the How To Use Minerva page)


FGIBDST
(view the How To Use Banner page)

Budget Query for Fund Holders


Balance displayed on the first screen
(view the How To Use Minerva page)


FRIGITD
(view the How To Use Banner page)

I need to see a list of my Transactions

Minerva > Finance

 

 

Banner

Budget Query for Fund Holders

Drill down (click) on the appropriate account code
(view the How To Use Minerva page)


FGIBDST

Select the appropriate account code (row) and select Options > FGITRND
(view the How To Use Banner page on FGIBDST)
(view the How To Use Banner page on FGITRND)

Budget Query for Fund Holders

Drill down (click) on the appropriate account code
(view the How To Use Minerva page)


FRIGITD

Select the appropriate account code (row) and select Options > FRIGTRD
(view the How To Use Banner web on FRIGITD)
(view the How To Use Banner web on FRIGTRD)

I need to see Transaction details

Minerva > Finance

 

 

 


Minerva > Finance

 

 


Banner

 

 

 

 

 

 


Banner

Budget Query for Fund Holders
 

Drill down (click) on the appropriate account code and document number
(view the How To Use Minerva page)


View Documents

Must have a document number
(view the How To Use Minerva page)


FGIBDST

Select the appropriate account code (row) and select Options > FGITRND
Transactions (documents) for the selected row will be displayed
Select the appropriate document (row) and select Options > Query Document [By Type]
(view the How To Use Banner page on FGIBDST)
(view the How To Use Banner page on FGITRND)


FOIDOCH for Purchase requisition, Purchase order, Invoice and Cheque documents
FGIDOCR for IDC, Deposit and Journal documents

Must have a document number
(view the How To Use Banner page on FOIDOCH)
(view the How To Use Banner page on FGIDOCR)

Budget Query for Fund Holders

Drill down (click) on the appropriate account code and document number
(view the How To Use Minerva page)


View Documents

Must have a document number
(view the How To Use Minerva page)


FRIGITD

Select the appropriate account code (row) and select Options > FRIGTRD
Transactions (documents) for the selected row will be displayed
Select the appropriate document (row) and select Options > Query Document [By Type]
(view the How To Use Banner page on FRIGITD)
(view the How To Use Banner page on FRIGTRD)


FOIDOCH for Purchase requisition, Purchase order, Invoice and Cheque documents
FGIDOCR for IDC, Deposit and Journal documents

Must have a document number
(view the How To Use Banner page on FOIDOCH)
(view the How To Use Banner page on FGIDOCR)

I need to see my monthly statement

Minerva > Finance

 

 


Web / Crystal Report Templates

Financial Statements > FZRG0021 - Monthly Fund Details

(view the How To Use Minerva page)


Month End Reports > Monthly Fund Details

(more information)

Financial Statements > FZRG0049 - Monthly Grant Details

(view the How To Use Minerva page)


Month End Reports > Monthly Grant Details

(more information)

To view a listing of Funds/Grants you have access to, complete with balances & contact information for your Fund Administrators:

  • Log in to Minerva or to myMcGill
  • Go to the Finance (Fund) Administration Menu
  • Click on the Financial Statements option
  • Open the Summary of Free Balances by User Security FZRG0055 statement

 

For questions or help in using any of these resources, contact the Finance Help Desk:
fishelp.acct [at] mcgill.ca (Email) / 514-398-3463