IBIS Reports for Grant Accounting
Preset IBIS Grant reports are available in the State of Idaho Public Folders > Grant and Project Reporting.
Figure 1 - State of Idaho Public Folders
These include data from FY2005 forward and shows information posted to the Grant File.
Grant Program Income Report
Shows program income earned and expended for all Grants that have a program income amount for monitoring purposes.
Grant Purge Analysis
Grants not previously purged. The report is by Grant, regardless of the Phase involved. Instructions are included on the report. Grant Table – Shows all Phases for a specific Grant and their status on the Grant Control Table.
Cash Control File – The amount in the IBIS Cash Control file for the specific Grant/Phase.
0=on cash control at the Fund level
1=on cash control at the Grant level
2=on cash control at the Grant/Phase level
General Ledger Cash – The amount in the IBIS General Ledger file for the specific Grant/Phase.
0=on the general ledger at the Fund or Fund /Detail level
1=on the general ledger at the Grant level
2=on the general ledger at the Grant/Phase level
GL Nominal Accounts plus Fund Balance – The amount in the IBIS General Ledger file for the specific Grant/Phase. Includes GLs 4100-4950 plus GL 3000-3002, 3102, 3202. (Fund balances plus any GLs that will close to the Fund balance at FYE.)
Document File – The amount on the Document File that has the Grant/Phase on the document.
All other General Ledger Accounts – All other amounts in the IBIS General Ledger file for the specific Grant/Phase.
Grant Revenues and Expenditures
These reports are only valid for Grants that began in FY2005 or later.
Grant Revenue and Expenditure reports can be run for the full Grant period or any partial period selecting the month ‘from’ and ‘to’ area. They can be run for any or all Funds.
Reports are available at the following levels:
Indirect Cost Cash Transfers
Shows all Indirect Cost cash that has been ‘transferred out’ with TC 4I2 and the offsetting ‘transferred in’ with TC 4I3. The report includes transfers made between the federal grant and the state Fund(s). The total amounts transferred must always be zero.
Transaction Codes that post to Grants and/or Projects
Shows all of the transaction codes that post to the STARS Grant File and/or the Project File.
It is grouped by the fields on the Grant and Project Files showing which transaction codes post to the specific field. The report includes the title, whether the Grant and/or Project can be on the transaction (Grt Ind, Prj Ind), and if it posts to the Grant File and/or the Project File.
It shows information on the field that it posts to on these STARS files, as well as whether it posts a t ‘+’ or ‘-‘ to the file. (Reversals of these TCs would do the opposite.) These fields are used in IBIS Grant and Project reporting based on the STARS Grant and Project Files.
That a Grant or Project is allowed on the transaction does not determine whether it actually gets posted to the Grant or Project files. It must post to a field on these files.