welcome to college of education research and budgeting
TRANSCRIPT
Welcome to College of Education Research and Budgeting Office
Information Session
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
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
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
1/23/2014 5
Facility and Administration (F&A)
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
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
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
1/23/2014 9
Simplified F&A Rate Calculation
NMSU College of Education F & A Distribution Schedule
1/23/2014 10
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
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.
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
1/23/2014 14
Banner Screen
1/23/2014 15
Output Example
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
1/23/2014 17
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1Open Internet Explorer to NMSU Homepage
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
1/23/2014 19
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)Click on Banner Information Lookup
1/23/2014 20
Allowing Internet Explorer/Banner to Open .CSV Files
Method 1 (continued)Click on Banner Account Code List
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
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
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
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
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
1/23/2014 26
Useful Banner Screens
1/23/2014 27
Useful Banner Screens
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.
1/23/2014 29
Tracking Log Option #1
1/23/2014 30
Tracking Log Option #2
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!