![Page 1: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/1.jpg)
Welcome to College of Education Research and Budgeting Office
Information Session
![Page 2: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/2.jpg)
1/23/2014 2
Introduction • The purpose of this presentation is to
provide you with useful grant management/monitoring tools
• The following slides will touch on F & A, CAS templates, CSV file downloads, utilizing the “Extract data no key” option in Banner and some helpful Banner screens
![Page 3: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/3.jpg)
1/23/2014 3
Overview
• Grant management consists of many responsibilities
• Many of these pertain to Federal Regulations as well as University Policies to which all Sponsored Programs at NMSU must adhere
![Page 4: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/4.jpg)
1/23/2014 4
F & A • F & A (Facilities and Administration),
Indirect Costs, and Overhead are all interchangeable terms defining the same costs
• These are costs are incurred during daily operations of any institution or private business
![Page 5: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/5.jpg)
1/23/2014 5
Facility and Administration (F&A)
![Page 6: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/6.jpg)
1/23/2014 6
Which Expenses are in each Cost Pool?
• Direct Cost Pool– Instruction: Professors salaries, teaching
assistants, training– Organized Research: R&D costs separately
budgeted and accounted for including sponsored research and university research
– Other Sponsored Projects (OSP): Community service projects, workshops, non-federal drug studies
– Other Institutional Activities (OIA): Athletics, dinning halls, dorms, theaters
![Page 7: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/7.jpg)
1/23/2014 7
Which Expenses are in each Cost Pool?
• F&A Cost Pools– Depreciation: Building, capital improvements– Operations & Maintenance (O&M): Utilities,
janitorial, repairs, security, care of grounds– Library: Books and materials, librarians salaries– General & Administrative (G&A): President’s
office, Controller, Personnel & Payroll office, Legal, etc
– Departmental Administration (D&A): Academic dean’s offices, department chairs, administrative and clerical staff, phones (local), postage, office supplies
![Page 8: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/8.jpg)
1/23/2014 8
Which Expenses are in each Cost Pool?
• F&A Cost Pool (continued)– Sponsored Project Administration
(SPA): Pre-award office, contract & grants accounting office
– Student Services Administration (SSA): Admissions, bursar, registrar, catalogs, commencement, student health centers
![Page 9: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/9.jpg)
1/23/2014 9
Simplified F&A Rate Calculation
![Page 10: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/10.jpg)
NMSU College of Education F & A Distribution Schedule
1/23/2014 10
![Page 11: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/11.jpg)
1/23/2014 11
CAS Templates• CAS or Cost Accounting Standards were made law
by inclusion in the Office of Management and Budget Circular A-21. The Circular is available at http://www.whitehouse.gov/omb/circulars/a021/a021.html
• NMSU has developed an internal document to help readily identify all costs that require CAS justification
• Justification requires a reasonable explanation as to why that particular expense is necessary and how it ties into the scope of work for your project
![Page 12: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/12.jpg)
1/23/2014 12
CAS Template as Defined by our Office of Grants and Contracts
• What is a CAS Template?
• As a tool to help determine direct and F&A costs, NMSU created a CAS template. The CAS template is available at http://research.nmsu.edu/docs/GandC/castemp1.xls The CAS template was designed from the Disclosure Statement where direct and F&A charges are itemized. The template will have an asterisk (*) before each item that is normally an F&A charge. The asterisk is a reminder to the PI that a justification is required in order to charge the item as a direct cost. The template is used as a budgeting tool, and PIs are encouraged to use the template at the proposal stage to break out the costs and determine the charges that require justification.
![Page 13: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/13.jpg)
1/23/2014 13
Extracting Data from Internet Native Banner
• In most of the Banner screens you can extract data in the form of a CSV file.
• The following screens will guide you through the process
![Page 14: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/14.jpg)
1/23/2014 14
Banner Screen
![Page 15: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/15.jpg)
1/23/2014 15
Output Example
![Page 16: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/16.jpg)
1/23/2014 16
Formatting Data
• In most of the Banner screens you can extract data in the form of a CSV file.
• In order to manipulate the extracted data it is necessary to convert the CSV file to an Excel file
• Some computers are not already set to allow for the Banner extraction in to a CSV file. The following screens are directions to allow for this function
![Page 17: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/17.jpg)
1/23/2014 17
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1Open Internet Explorer to NMSU Homepage
![Page 18: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/18.jpg)
1/23/2014 18
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)Click on Faculty and StaffClick on Business Finance and HR Services
![Page 19: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/19.jpg)
1/23/2014 19
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)Click on Banner Information Lookup
![Page 20: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/20.jpg)
1/23/2014 20
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)Click on Banner Account Code List
![Page 21: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/21.jpg)
1/23/2014 21
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)In the file download window unselect “Always ask before opening this type of file.”Click Open
![Page 22: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/22.jpg)
1/23/2014 22
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)
• Logon to Banner and you should be able to open the .CSV files
![Page 23: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/23.jpg)
1/23/2014 23
Allowing Internet Explorer/Banner to Open .CSV Files
Method 2You must be an administrator to your PC to do this.On the desktop double click the My Computer icon.Select Tools, Click on Folder Options
![Page 24: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/24.jpg)
1/23/2014 24
Allowing Internet Explorer/Banner to Open .CSV Files
Method 2 (continued)Microsoft Select File Type tab
Scroll down to the XLC Excel Worksheet, click advanced
![Page 25: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/25.jpg)
1/23/2014 25
Allowing Internet Explorer/Banner to Open .CSV Files
Method 2 (continued)Unselect confirm open after downloadingClick OK
• Click CloseLogon to Banner and you should be able to open .CSV files
![Page 26: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/26.jpg)
1/23/2014 26
Useful Banner Screens
![Page 27: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/27.jpg)
1/23/2014 27
Useful Banner Screens
![Page 28: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/28.jpg)
1/23/2014 28
Sample Tracking Documents
• The following two documents may serve to assist you in tracking your expenses as they pertain to various sponsored activities.
![Page 29: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/29.jpg)
1/23/2014 29
Tracking Log Option #1
![Page 30: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/30.jpg)
1/23/2014 30
Tracking Log Option #2
![Page 31: Welcome to College of Education Research and Budgeting](https://reader033.vdocuments.us/reader033/viewer/2022053112/6291e007c2c4b4320e621e7d/html5/thumbnails/31.jpg)
1/23/2014 31
Conclusion
Please feel free to contact us at [email protected] with any questions, comments or requests for future meeting topics.
Together we can SUCCEED!