How to Read Your Monthly Grant Budget Reports

1
How to Read Your Monthly Grant Budget Reports

2
Cumulative Excel Report

• Purpose of this report
• This report compares the actual expenses to the
  budget of the award.

3
How to Interpret the Cumulative Excel Report

• Look at the Uncommitted Balance" column, if the
  numbers in each row are positive, this is the
  amount remaining to spend by category. If
  negative, this is the amount overspent by
  category.
• Your "Net Income" (or Total) is the overall
  amount left to spend in your grant. This should
  be a positive number.

4
Sample Cumulative Excel Report
Awarded Budget amendments
Grant Account Info.
Begin End Dates of Grant
Awarded Budget
Expense categories These vary by contract
Remaining Balance
Approved changes to budget
Expenditure column
5
Transaction Detail Report

• Purpose of this report
• This report provides the Project Director an
  itemized transaction list of what has charged
  against the award.
• This report also gives the end date of the
  award.

6
How to Interpret the Transaction Detail Report

• Look at the very last row on the report titled
  "Total", this number should be negative, showing
  you have money left to spend.

7
Sample Transaction Detail Report
Overall Awarded amount excluding indirects
Itemized transactions
Grant expiration date
Expense category
Continued on next slide
8
Sample Transaction Detail Reportcontinued
Overall remaining amount of award, if negative
amount left to spend, if positive amount in
deficit
9
Notification of Monthly Reports

• The Project Director, College Business Affairs
  Manager and designated administrative support
  will be notified via email when the monthly
  reports are available.
• Monthly reports are available on the Spons Ops I
  Drive.
• To view your file follow the path below
• Click on My Computer
• Click on Shared on "Wiseowl" (I)
• Click on the folder named SponOps
• Click on your folder (only you, your Business
  Manger, and your administrative support will have
  access to your file)
• If you have issues accessing the I drive, please
  contact your College Business Affairs Manager for
  assistance. If the issues cannot be resolved,
  then you will need to contact the Service Desk
  (x6999 or service_at_kennesaw.edu).

10
Regarding Monthly Reports

• Please note indirects are not tracked or
  calculated on these monthly reports (Cumulative
  Excel and Transaction Detail).
• Indirects are awarded on a quarterly basis as
  they are earned.
• The Dean, Dept. Chair, Project Director, and
  College Business Affairs Manager will be notified
  via email of the quarterly indirects awarded.
• After awarding of the indirects, the College
  Business Affairs Manager and the Dean distribute
  and track the indirects.