Expenses Troubleshooting

Hello,

Several people have contacted RCA and P2P concerning issues when charging a sponsored project. Most of the issues have been corrected by doing the following tasks:

  • For requisitions, configure your Favorite Charge to Account.
  • Enter an expenditure item date and budget date that is within the project period and task finish date.
  • For Faculty Funds, ensure there is an active budget created on the project.
  • For Faculty Funds Discretionary Task, charge to Task 2.2
    • Tasks are not chargeable if there is a subtask (i.e task 2 is not chargeable because task 2.2 is the chargeable task)
Posted in Announcements, Training | Leave a comment

Viewing Sponsored Project Expenses and Funding at the COA Level

For Sponsored Projects, the following funding sources are used to map the iO projects to the COA. The fund source mapping is based on the Award/Project Type and Task of the Project. Navigating on the Finance Dashboard and selecting the Award/Project Org and Fund Source to see the transactions.

Below are the Funding Sources for PPM Projects:

The Fund Source for Sponsored Projects are:

  • 040000 Federal-Direct
  • 041000 State & Local Gov – Fed Prime
  • 042000 Industry-Fed Prime
  • 043000 Other-Federal Prime
  • 045000 State & Local Gov – Direct
  • 046000 Industry-Direct
  • 047000 Other-Direct
  • 048000 Federal Pass Through

For Cost Share and University Award Projects, the Fund Source defaults to the values below. For Faculty Funds, the funding source is derived from each task on the Faculty Fund. To see the expenses that need to be funded for University Awards, Cost Share, and Faculty Fund projects, navigate to the fund balance report on the dashboard to see the expense and funding activity.

For Cost Share Projects, Deficit Projects, and Salary Cap Projects, the Fund Source is:

  • 012100 Cost Share

For University Awards, the Fund Source is

  • 012000 Internal Projects

For Faculty Funds, the Funding Sources are:

  • 010000 Faculty Discretionary
  • 010010 Faculty Start-Up
  • 010020 Faculty Non-Sponsored Research Funds
  • 010030 Faculty Retention

Navigating in the Finance Dashboard- Budget to Actuals

Enter the Period Name, Organization, and Fund Source to see the Budget to Actuals information. You can see the beginning fund balance on the fund balance report.

Fund Balance Report

This report shows the beginning balance by Fund Source for a particular Org. The Period Net shows the expense activity in the Period (September 2021) $2,305.50 for an Internal Award.

 

Posted in Training | Leave a comment

2 New FAQs

FAQ 1: What is the process for managing overspent awards in iO?

Once the award has ended, any expenses that are in excess of the award budget are transferred to a Deficit project. RCA will create the Deficit project as needed and move the total deficit amount there.  Please create a help desk ticket for this request.

FAQ 2: What is the process in iO to manage the residual balances of fixed price awards?

  1. Research and Cost Accounting (RCA) will confirm the final expenditure amounts with the PI / department administrator (DA). The DA will alert RCA when the sponsor confirms satisfactory completion of all deliverables.
  2. Full Facilities and Administrative costs (F&A) will be applied to the award prior to transferring the residual funds in order to ensure all F&A costs associated with the award are fully funded.
  3. The award project end date will be extended by 1 year to allow time for the funding to be spent by the department. F&A charging will also be turned off by RCA to ensure new expenses do not incur F&A.
  4. The funding remainder may be moved to the faculty’s faculty fund research task if there are no further expenses related to the project’s scope of work.

The procedure for residual funds has been updated on the RCA website. https://controller.rice.edu/rca-fixed-price-funds

These FAQs, and others, can be found at https://controller.rice.edu/rca-faqs

Nick

Posted in Policy and Procedure Updates | Leave a comment

Updated Non-Labor Cost Transfer Form

Hello,

We made a few changes to the form to better explain the data needs. Also included is an example of how to enter data for the converted labor costs. Another tab was added to the spreadsheet to aid in understand where to gather the data for the spreadsheet.

Please use the new form on your next cost transfers.

Nick

Posted in Policy and Procedure Updates | Leave a comment

Final Conversion Crosswalk

This is the final conversion crosswalk for historical data conversion through June 30, 2021.

Crosswalk for all Banner FOAPAL 8122021 A to D76999

Crosswalk for all Banner FOAPAL 8122021 D77000 to G

Crosswalk for all Banner FOAPAL 8122021 H to Z

Posted in General Accounting Blog Postings | 1 Comment

POETAF vs COA

Many of you have reached out to RCA with questions about what COA information you should enter when charging expenses to a project.  We discussed it with the experts, and we have an easy answer for you: the COA information is there as a pass-through only, so you don’t need to worry about it.

While the current Procurement: Order by Quantity or Amount job aid does indicate that a COA string is required to be entered for every purchase, including project-funded purchases, it fails to mention that the COA information will be overridden by any POETAF information entered.  P2P will work on getting the job aid updated to explain this aspect of the process.

So if you enter POET information for your purchases and a COA pops up, please leave it with whatever information defaults in there.  If you edit the COA information for any reason afterwards, it will override the POET information and your charge will not post to PPM.

Posted in Announcements | Leave a comment

University Award Procedure

University Awards

Rice‐funded awards that are made to faculty or staff through a competitive process (such as: Faculty Initiative Fund; Enhancing Rice Through Information Technology program; Shell Center; and similar seed funding programs managed by different units) will be established in iO as University Awards.

Each Rice‐funded award will have a unique Award number and be established in iO in the organization of the recipient. RCA establishes the award in iO. The recipient of the Award is responsible for ensuring the funding is transferred to their Org’s funding source. At the closing of the award, unspent funds will need to be returned to the funder of the award.

Setup of University Awards

For RCA to establish the University Award in iO, please provide the following information in a helpdesk ticket in iO:

  • PI Name
  • Project Manager
  • Award Participants
  • Award Title
  • Award Amount
  • Award Org
  • Start and End Date
  • Award Purpose (Research or Instruction)
  • Award Category (Basic, Applied, or Experimental research)
  • Field of Study
  • Award Agreement

https://controller.rice.edu/rca-university-awards

 

Posted in Policy and Procedure Updates | Leave a comment

Cost Transfer Procedure for Sponsored Projects

Good Morning,

The procedure for performing cost transfers in iO has been updated on RCA’s website. The information below can be found at this link https://controller.rice.edu/rca-cost-transfer

Cost Transfer Process in iO

The process for cost transfers in iO is dependent on the transaction source (converted or iO created) and the transaction type (labor and non-labor).

Cost Transfers for Costs Incurred Prior to July 1, 2021 (Both Labor and Non-Labor Converted Costs)

  • Converted costs will be managed in iO using the NON-LABOR COST TRANSFER FORM. For the costs to be transferred, a description of the cost transfer as well as the invoice information must be entered, as well as the current and new COA and POET accounting information. RCA will enter the information into the PPM Project Costs ADFDI template and upload into iO.
  • Converted costs cost transfers are to be requested by the Department Administrator and uploaded to BOX for processing.

Cost Transfers for Non-Labor Costs Incurred After July 1, 2021

  • Cost transfers for non-labor costs will be managed in iO using the NON-LABOR COST TRANSFER FORM. For the costs to be transferred, a description of the cost transfer as well as the invoice information must be entered, as well as the current and new COA and POET accounting information. RCA will enter the information into the PPM Project Costs ADFDI template and upload into iO.
  • Non labor cost transfers are to be requested by the Department Administrator and uploaded to BOX for processing.

Labor Cost Transfers for Costs Posted Beginning July 1, 2021

  • Labor cost transfers will follow the general iO process for Labor Distribution changes. For changes to sponsored projects entered 90 days after the end date of the original labor distribution, the following is required:
    • The field “Includes sponsored projects over 90 days:” must be marked “Yes” on the Labor Distribution form.
    • A comment must be entered on the form explaining the reason for the cost transfers.
    • Include the Department Chair as an Optional Approver on the LD template so the required department chair approval is obtained.
    • Labor cost transfers are to be requested by the Department Administrator and forwarded to Payroll for processing via Adobe Sign.
Posted in Policy and Procedure Updates | Tagged , , | Leave a comment

Balance Transfers in iO

For those who missed it, last week the Budget Office sent out the following information  about how to process balance transfers in the new system:

There is now a new interim transfer process for handling fund balance transfers, formerly called budget transfers.  This process entails completing an AdobeSign form that is routed for workflow approvals (see attached job aid) and posts in iO.  This process is for temporary (operating year) balance transfers between fund types or between departments.  You will need to contact the Budget Office for base (permanent) budget adjustments as they will not be processed using this interim process.

Important things to note:

  • All transfers will be processed as Year-to-Date entries in iO, using the Transfers – Inter/Intra Departmental account code (6800).
  • Because of the end-of-year carryover process for the Unrestricted General Operating fund (000000) and because unspent fringe benefits budgets do not carryover, the Budget Office will need to capture fund balance transfers associated with salary and fringe benefits accounts (including Faculty Academic Year Time transfers).
  • To capture the fringe benefits, the Adobe Sign form will contain a drop-down list of valid accounts (including faculty, staff, student, and fringe accounts) that will be written to a database file for use during the year-end analysis of carryover funds.
  • Use of Salary and Fringe accounts is only permitted on the Unrestricted General Operating fund (000000).
  • Faculty Academic Year Time transfers will require a separate action by the Project Administrators to update the PPM faculty/task budgets of any faculty receiving AYT funds.
  • Faculty fund transfers will be a two-step process.  First, there will need to be a transfer to the receiving department’s designated fund with the appropriate fund source code (Faculty Discretionary – 010000, Faculty Start-up – 010010, Faculty Non-Sponsored Research Funds – 010020, or Faculty Retention – 010030).  Second, a separate action by the Project Administrators will need to be performed to update the PPM faculty/task budgets for the faculty receiving the additional funds.

Job Aid:  AdobeSign iO Balance Transfer

Posted in Announcements | Leave a comment

Sponsored Projects Expenditure Types

We’ve had several departmental folks reach out to us asking what “account code” to use for their Sponsored Projects expenses in PPM.  I know we’re all used to having to enter an account code number as part of the FOAPAL in Banner.  However, in the iO system, we use expenditure types instead of account codes, and we no longer need to memorize the corresponding numbers.  Yay!

In PPM, Sponsored Projects expenditure types are broken down into 8 expenditure categories:  Salaries & Wages (S&W), Fringe Benefits (FRB), Tuition Remission (TUR), Other Direct Costs (ODC), Travel (TRV), Subawards (SUB), Equipment (EQP), and Facilities & Administrative Cost (F&A).  Each of those expenditure categories has multiple expenditure types associated with it.

So for example, if you want to charge lab supplies to a sponsored project, you would search for “supplies” in the expenditure type field and it will give you a list of all the ones that have the word supplies in them.  Then you just pick the one called ODC: Supplies Laboratory.

Please see the attached list for expenditure types allowed on Sponsored Projects.

ET List: Expenditure Types

Posted in Training | Leave a comment