Office Expense Monthly Budget Sample

Document Sample
Office Expense Monthly Budget Sample Powered By Docstoc
					How to Read Your Monthly
 Grant Budget Reports…



       Prepared by the Office of Budget
          & Sponsored Operations
       Cumulative Excel Report

Purpose of this report:

 This report compares the actual
 expenses to the budget of the award.




             Prepared by the Office of Budget &
                  Sponsored Operations
 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.
           Prepared by the Office of Budget &
                Sponsored Operations
               Sample Cumulative Excel Report
                                                                           Awarded
                                                                           Budget +
                                                                           amendments



 Grant
Account
 Inf o.                                                                             Begin &
                                       Awarded
                                                                                     End
                                        Budget
                                                                                    Dates of
                                                                                     Grant




  Expense
categories –
 These vary
by contract




                                                                            Remaining
                                    Approved changes to
                                                             Expenditure      Balance
                                          budget
                                                               column

                        Prepared by the Office of Budget &
                             Sponsored Operations
      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.
             Prepared by the Office of Budget &
                  Sponsored Operations
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.




          Prepared by the Office of Budget &
               Sponsored Operations
                Sample Transaction Detail Report
                                                                                 Overall
                                                                                Awarded
                                                                                 amount
                                                                                excluding
                                                                                indirects

  Itemized
                                                                                          Grant
 transactions                                                                           expiration
                                                                                          date

Expense
category




                         Prepared by the Office of Budget &   Continued on next slide
                              Sponsored Operations
Sample Transaction Detail Report
          continued…




        Prepared by the Office of Budget &     Overall remaining amount of award, if negative
                                             amount $ left to spend, if positive $ amount in deficit
             Sponsored Operations
     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@kennesaw.edu).


                       Prepared by the Office of Budget &
                            Sponsored Operations
      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.


                  Prepared by the Office of Budget &
                       Sponsored Operations

				
DOCUMENT INFO
Description: Office Expense Monthly Budget Sample document sample