1 / 52

Post-Award Grant Financial Management Workshop

Post-Award Grant Financial Management Workshop. Sandy Ahne & Sharla Ashcraft Grant Accounting. URC Grants. U niversity R esearch C ouncil Grants Awarded by the University Research Council University funds appointed to faculty doing research Linda Lentz (450-5566)– budget administrator.

ebiles
Download Presentation

Post-Award Grant Financial Management Workshop

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Post-Award GrantFinancial Management Workshop Sandy Ahne & Sharla Ashcraft Grant Accounting

  2. URC Grants • University Research Council Grants • Awarded by the University Research Council • University funds appointed to faculty doing research • Linda Lentz (450-5566)– budget administrator

  3. Grant Funding Awarded Upon receipt of the award notification, send the grant agreement and other appropriate documentation to the Sponsored Programs Office (SPO). Sponsored Programs will: • Review the grant agreement • Obtain all necessary signatures • Send an award notice to the PI (Principal Investigator) and Grant Accounting

  4. Grant Funding Awarded Grant Accounting will: • Send an e-mail notification to the PI and administrative support with the following: • Banner Index # (and Matching Index # if applicable) • Banner Access Form (required to access grant budget in Self Service) – ATTACHMENT A • Request for PAF’s (Personnel Action Form) • Instructions for any cash match obligations • Schedule a meeting for NEW PI’s and/or administrative support • If an admin with Banner access to the grant leaves UCA or moves to another dept, please submit the Remove Banner Access Form (ATTACHMENT B) .

  5. Pre-Award Spending • If the awarding agency has a delay in sending the award documents but you have written documentation that the grant will be awarded, contact Sponsored Programs to initiate the Pre-Award Spending process. • The Request for Pre-Award Spending form (located on SPO website) requires the Dean’s signature acknowledging that IF the grant does not receive funding, the department will cover the pre-spent expenses. (ATTACHMENT C)

  6. UCA Policy on University Funds • All funds received must be processed immediately. • Funds must be deposited with the Student Accounts / Cashiering office within 24 hours of receiving the funds in the department. • Any grant award checks that are received in the department should be delivered to the Grant Accounting office, so the deposit can be made timely and accurately to the appropriate account.

  7. Viewing the Budget • My UCA • Self Service • Finance • Budget Queries • Budget Status By Account • Create Query

  8. Viewing the Budget Check mark these boxes. Then click continue.

  9. Viewing the Budget Fiscal year: 2019 Fiscal period: 14 Enter the index #. Click submit query (twice).

  10. Viewing the Budget Click on the amount in the YTD column to view the Detail Transaction Report.

  11. Viewing the Budget Detail Transaction Report

  12. Budget Organization • The Banner Finance Reports only contain information that has been posted by Accounting. • Suggested method to keep track of expenditures: • Keep a file with copies of invoices and receipts related to the grant. • Regularly verify expenses with Self Service’s Summary Report and move paid invoices/receipts to a paid file.

  13. Financial Responsibility • The PI is responsible for ALL financial obligations of their grant agreement. • Costs must be in line with the approved budget. • Costs must be within the dates specified in the grant agreement. If a No Cost Extension is needed, contact SPO. • Costs must be allowable, allocable and reasonable.

  14. Cost CriteriaUniform Guidance 200.403 • Allowable costs must be reasonable. • Reasonable costs are necessary for the appropriate and efficient performance and administration of the grant. • Reasonable costs are typically judged by what a “prudent person” would do given the circumstances when the decision was made. 2. Allowable costs must be allocable to the award. • Allocable means the costs are consistent with the relative benefit received by the program. • If the cost benefits both the award and other work, it can be distributed in proportions that may be approximated using reasonable methods. The full amount can’t be charged to the grant and be used for other projects.

  15. Cost CriteriaUniform Guidance 200.403 3. Know the limitations • The spending must be authorized, or at a minimum, not prohibited by Federal, State or Local laws and regulations. 4. Allowable costs must be adequately documented. • Without adequate documentation, the spending could be disallowed and the grant recipient required to pay back the money. 5. Must be consistent with policies and procedures that apply uniformly to both Federal and Non-Federal awards.

  16. Budget Changes • Changes to the approved budget generally require prior approval from the funding agency. • Budget requirements are typically stated in the grant agreement issued by the funding agency. • Some agencies allow budget modifications of 10 – 25% deviation per category while others aren’t so lenient. • If a modification is necessary, contact the Grant Accounting Office to discuss your budget situation before contacting the funding agency.

  17. Budget Transfer • A Grant Budget Transfer Form(ATTACHMENT D) must be completed when a budget adjustment is needed on a grant or matching (Cost Share) budget. • The Transfer Form requires the following signatures: • PI • Department Head • Dean • Provost Electronic budget transfers are NOT allowed for Grants.

  18. Grant Salaries – PAF’s • The following salaries paid from a grant require a PAF(ATTACHMENT E, F, G) • Faculty/staff • Anyone paid from a department AND a grant must submit a revised PAF to split the salary. • If a PI is being paid from one or more grants, a revised PAF must be submitted each time a grant ends. • Extra Help Employees (Account code – 660900) • Graduate Assistants (Account code – 640900) • Must be sent to Graduate Office and signed by Patti Hornor (852-2431) • UCA employees cannot be paid stipends – must be paid through payroll

  19. Grant Salaries – Student Workers • Refer to the UCA Student Financial Aid Office Guide for Processing Funding for Students (ATTACHMENT H) • For any students doing work directly associated with a grant, a Student Work Authorization Form(ATTACHMENT I) needs to be submitted. • For Grants, the fund and index numbers are the same. • Be sure to check the Grant Funds box. • Upon receipt, the Grant Accountant will verify the funds are available, sign and send to Financial Aid for approval • Contacts: • Kyana Smith (HR) – 450-3626 • Nancy Earney (Financial Aid) – 450-5155

  20. Salary Reports • After each pay period, HR will e-mail a salary report to the PI for any salaries paid out during that pay period. • Review the report to verify the correct personnel have been charged to the grant. • If there is a discrepancy, complete a Salary Report Discrepancy Form (HR website) online and alert your Grant Accountant immediately.

  21. Adjunct Replacements • An Adjunct Professor is someone who is hired by a college to teach but isn’t full time faculty. The Adjunct replaces the PI in one or more classes in order to free up time for the PI to work on the grant project. • Amounts needed to cover the cost of adjunct replacements for release time should be included in the budget of the grant award. • Adjunct replacements cannot be paid directly through the grant, because they are not doing any work FOR the grant. • Salary and fringe benefits for the adjunct replacement will be transferred to the department using the Salary and Fringe Expense Transfer account codes: 620990 Salary Expense Transfer 680490 Fringe Expense Transfer • A Grant Budget Transfer (ATTACHMENT D) form will need to be submitted to initiate the transfer process.

  22. Fringe Benefits • Fringe Benefit rates: • 31% of salaries during the academic year • 20% of salaries during the summer for 9 month faculty (May 16 – August 15) • 8% of salaries for Extra Help / Part-time employees • .3% of salaries for Student Workers / Graduate Assistants • If fringe benefits were not budgeted for a state employee, the fringe must be deducted from the total amount paid. • Example: $2,000 / 1.31 = $1,527 (salary for PAF) $ 473 (fringe) • Fringe amounts are not entered on the PAF.

  23. Common Salary Account Codes(ATTACHMENT J) • 610960 – Teaching on grant • 620900 – Replacement salary on grant • 620920 – Summer salary on grant • 620930 – Agency approved incidental pay (Overload pay) • 620940 – FT employment on grant • 620950 – Summer salary on Match • 620990 – Salary expense transfer • 630900 – Classified salary on grant • 630990 – Classified salary expense transfer • 640900 – Graduate assistant on grant • 650900 – Student help on grant • 680450 – Fringe benefits • 680490 – Fringe benefits expense transfer

  24. Grant Scholarships / Awards • Check with Financial Aid to determine the eligibility of a student to receive a grant scholarship or stipend. • The Grant Funded Scholarship/Stipend Form (ATTACHMENT K)must be filled out and submitted in order to process the funds through Financial Aid. If the student is a graduate student, send to Patti Hornor for verification before sending to Grant Accounting. • The Grant Funded Scholarship/Stipend Formcan be found on the Grant Accounting website. • Common account numbers: 710170 (Tuition Exp) & 750300 (Stipend – Other) • Refer to the UCA Student Financial Aid Office Guide for Processing Funding for Students (ATTACHMENT H)

  25. Purchasing Guidelines • All purchases made through a grant are subject to the same rules and guidelines as set forth by the UCA Purchasing Dept. Visit the Purchasing website for details regarding: • Professional Service Contracts • Contract Information • State Contracts • Purchasing Manual

  26. Grant Purchasing Options • Purchase Order • Submit a requisition, using the grant index and account number. • Check Banner prior to completing a PO to make sure there are funds in the line item. If not, complete a Grant Budget Transfer (ATTACHMENT D)prior to completing the PO to keep it from showing NSF. • Grant Accounting will approve or disapprove the requisition based on the grant budget, funds available, and Uniform Guidance guidelines. • Once approved, the purchasing process will follow the standard procedure for PO’s and payment of invoices.

  27. Grant Purchasing Options • University Credit Card / P-Card • Purchases that need to be charged to the grant can be made on the department’s P-Card, following the same P-Card Guidelines provided by Purchasing. • To transfer the charge from the department to the grant, complete a P-Card Reallocation form (ATTACHMENT L) and send to Grant Accounting with a copy of the invoice. • The PI must approve all charges as financial manager of the grant. • The P-Card Reallocation form can be found on the Grants website and is only to be used for grants. • A journal entry will be posted to move the charge to the proper index number.

  28. Grant Purchasing Options • Reimbursement • If a PI purchases supplies with personal funds, a requisition for reimbursement should be submitted. • Standard purchasing guidelines will apply for all reimbursements. • Email a copy of the receipt to the Grant Accountant. Approval of PO will not be granted until a copy is received. • Send original copy of the invoice to Purchasing.

  29. Cost Transfer • A Cost Transfer occurs when an expense that was charged to one fund is transferred to another. • A Cost Transfer Form (ATTACHMENT M) must be completed and submitted to Grant Accounting when correcting an expense. Please include the PO# and check # of the original charge. • Common example: The department paid for supplies that should have been charged to the grant.

  30. Office SuppliesUniform Guidance (2CFR 200) • Unallowable to be charged as a direct cost unless it can be documented that these items are ONLY used for grant purposes. • Includes: Computers (under $5,000), printers, monitors, fax machines, printer paper, toner cartridges, pens/pencils, legal pads, clips, rubber bands, post it notes, books, individual subscriptions to journals, notebooks, etc. (These would be indirect costs)

  31. Postage StampsUniform Guidance (2CFR 200) • Postage costs associated with the normal administration of a project are generally not allowable as direct charges to the project. (Ex. Routine correspondence with the sponsor, colleagues, and potential publishers and students) • Costs of overnight S/H are allowable assuming they are directly associated with the conduct of the project. • The latter can be directly assigned to a particular project with a high degree of accuracy.

  32. Travel • Employee travel expenses are reimbursed at current IRS rates. • Personal vehicle mileage will be reimbursed at $.42 per mile. • Meals with an overnight stay are reimbursed at actual cost up to the maximum per diem. First day and last day maximum is 75% of per diem. • Meals without an overnight stay are reimbursed at actual cost up to $38.25 when you are away from your official station more than 12 hours. Itemized receipts and a completed Day Travel Without Overnight Stay form must be attached to the TR-1. • Lodging requires a receipt showing a $0 balance from the hotel. • The complete Travel Procedures guide can be found on the Financial Accounting website under Travel.

  33. University Department Charges Departments can directly charge a grant for services – just let them know the Grant index number and account number. • Authorized departments include but are not limited to: • Motor Pool • Mail Services • Physical Plant • Phone Services • Printing Services (Copy Center)

  34. Common M&O Account Codes(ATTACHMENT J) • 710101 – Supplies & Services • 710110 – Printing & Stationary • 710115 – Advertising • 710117 – Promotional Materials • 710130 – Building rental • 710145 – Equipment rental • 713100 – Instructional supplies • 713200 – Health/Behavioral Science Lab Supplies • 715100 – Postage • 717100 – Individual Travel • 717110 – Group Travel • 717111 – Individual Travel (Student) • 717115 – Conference Travel • 718100 – Prof Services > $20,000 • 718125 – Prof Services < $20,000 • 719100 – Contract Food Service • 719200 – Food Purchases • 730200 – Equipment (Furniture)

  35. Important Reminders • When doing a blanket PO for supplies, etc, a PO must be completed for EACH grant. • For grants, the fund and index numbers are the same. • The Food Service Policy must be followed for food consumed on campus. • Do not personally pay for software, or equipment – prior approval is needed. • Office supplies can only be purchased through Staples (see supplies slide) • If an item has a warranty, do not purchase with personal funds and request reimbursement from UCA • Warranty is held by the original owner and will be voided when reimbursed • A University credit card or Purchase Order should be used in order for warranty to belong to UCA.

  36. Salary Certification • Salary Certification, formerly known as time and effort reporting, is the federally mandated method of certifying that the salaries and benefits charged to a federal grant are accurate. • The language and requirements in this federal regulation have gone through various modifications in order to provide more flexibility in the process and reduce the administrative burden. • The primary focus of the revised time and effort requirements is for strong internal controls to exist for the reporting of salaries and wages, ensuring that the payroll charged to various grants matches the actual time spent.

  37. Salary Certification • In place of the Time & Effort Reports that were sent out quarterly, the Grant Accounting office sends out Cumulative Project Payroll Confirmations(ATTACHMENT N) for each grant at the end of the Fiscal Year and at the end of the grant. • The Cumulative Project Payroll Confirmation should be reviewed and signed by the PI, verifying that the salary paid to each recipient does not exceed their proportionate share of work performed on the project. • Uniform Guidance requirements: • Time distribution records must be maintained for all employees whose salary is paid in whole or in part with federal funds or is used to meet a match or cost-share requirement for a grant. • Payroll allocations among grant awards cannot be based on budgeted distributions alone, but rather the allocation of salaries and wages among grant programs needs to be supported by actual hours worked. • If budgeted numbers are used to allocate salaries and wages, the entity’s system of internal controls should include an after-the-fact review of the grant.

  38. Facilities & Administrative Costs(F&A or Indirect Costs) • The F&A rate is the mechanism used to reimburse the University for the infrastructure support costs (overhead) associated with grant projects. • Examples of F&A: • Operating and maintenance costs such as utilities, security and custodial costs • Common administrative functions such as payroll and purchasing • Not all Awarding Agencies reimburse the University for F&A costs at the negotiated rate. In order for F&A to be excluded from a grant, it must be specifically disallowed by the Awarding Agency. • F&A is calculated and applied to the appropriate accounts on a monthly basis.

  39. Facilities & Administrative Costs(F&A or Indirect Costs) • The current UCA negotiated F&A rate with DHHS is 32.59% of salaries and wages. This rate is effective until 06/30/19. We are currently in the process of re-negotiating this rate for the next 5 year period. • USDE F&A rate is 8% of total modified direct costs. • F&A costs are distributed as follows: • 25% - University • 24% - Sponsored Programs • 20% - College • 20% - Department • 8% - PI (16XXXX) • 3% - Grant Accounting • The F&A Rate Agreement can be found on the Grant Accounting website.

  40. Invoices • ALL financial invoicing must be completed by the Grants Office. • Invoices will be completed and e-mailed to the PI for review. The PI will sign and return to Grant Accounting for submission to the Funding Agency.

  41. Financial Reporting • Grant Accounting will prepare and submit ALL financial reports and cash requests. • The financial report will be e-mailed to the PI for review and signature, and returned promptly. • Any financial data prepared by the PI must be submitted to the Grant Accounting Office for approval PRIOR to submission to an external organization.

  42. Cost Share / Match • Cost share occurs when a portion of the costs of the award are not paid by the Awarding Agency, but paid instead using resources within a department, school/college, or other party. • Grant Accounting sets up a separate index from the original grant, referred to as the Match Account (xxxMxx) • Funds are transferred from the department to the Match Account via a Grant Budget Transfer (ATTACHMENT D)form.

  43. Sub Awards • A sub award is a collaborative arrangement between a grantee institution (UCA) and another institution or organization (sub awardee) in support of the grantee’s research project. The sub awardee performs research activities on behalf of the grantee. • Funds from the grantee organization (UCA) must flow directly from the grantee to the sub awardee. • A blanket PO is created in order to process payments to the sub awardee. • The subaward index # is the grant index # with an “S” replacing the 4th digit (Ex. 223S30)

  44. Sub Awards • PI responsibilities: • Ensure that the sub award objectives are proceeding as planned and as described to the Awarding Agency. • Monitor the quality of work being submitted and identify issues that arise in a timely manner. • Monitor the budget. • Review and approve the invoice received from sub awardee. • Send the approved invoice to Accounts Payable for payment.

  45. In Kind Contributions • An In-Kind Contribution is another form of a match and represents any non cash donation of a good or service that can be given value and is used in achieving the project objectives. • An In-Kind Contribution may be in the form of real property, equipment, supplies, or other expendable property and the value of services directly benefitting the project. • A Documentation of In-Kind Cost Sharing (ATTACHMENT O)formmust be completed for any in-kind donation and sent to the Grant Accounting Office (form located on the Grant Accounting website).

  46. Grant Closeout Responsibilities • Near the grant end date, Grant Accounting will send the PI and administrative support a Notice of Project Closing (ATTACHMENT P). • Verify that all salaries have been paid correctly. • Submit new PAF for any person who received salary through the grant. • Review the budget for available funds. Check to see that all orders have been received and paid for by the end of the project period and no encumbrances remain. • Spending JUST to spend out the grant is not allowed. Spending during the last days of the grant will be closely scrutinized. Auditors are very suspicious of end of grant spending.

  47. Grant Closeout Responsibilities • If funds remain, contact Grant Accounting to return the funds to the funding agency. • If a No-Cost Extension is needed, contact Sponsored Programs PRIOR to the end date of the grant to request an extension. You will fill out a Request for No-Cost Extension (ATTACHMENT Q). • When grant work is completed, contact your Grant Accountant for the final financial report. • Complete the FINAL progress report and send a copy to Sponsored Programs and Grant Accounting for our files.

  48. Unacceptable Practices • Purchasing items simply to exhaust excess funds. • Assigning charges to a project with a remaining balance to avoid the loss of carry-forward funds. • Charging the budgeted amount (in contrast to the actual usage amount). • Charging an expense exclusively to a single award when the expense clearly has supported other activities. • Transferring an overdraft from one sponsored project to another, without sponsor approval.

  49. Grant Accounting Website Grant Accounting is under the Financial Accounting Department • Grant Accounting • Grant Forms • Monthly Newsletters (If you are not signed up to receive the Grant Accounting monthly newsletters, let us know and we will add you to the e-mail list.)

  50. Important Phone #’s • Sponsored Programs (split by colleges) • Suzanne Wiltgen - 450-5789 • Matthew Smith - 852-2410 • Purchasing - 450-3173 • Travel • Carissa Castleberry - 450-5024 • Jordan Kellybrew - 450-3620 • Pam Giblet - 450-3182 (Travel & AP) • Accounts Payable • Rae Mensah – 450-5028 (Various vendors) • Shelia Williams – 450-5025 (A – J) • Angela Haynie – 450-3245 (K - Z)

More Related