Dates in iO

Expenditures associated with Sponsored Projects, Faculty Funds and Capital Projects created and managed via PPM in iO have multiple associated dates.  These dates allow for tracking of costs from both a compliance and financial reporting perspective.

Expenditure Item Date

The Expenditure Item Date is the date that a transaction occurs.  For sponsored projects, the Expenditure Item Date of a transaction must be within the period of the grant in order to comply with the terms of the award.   Expenses with an expenditure item date outside of the project period will fail to post on the project in iO.

Creation Date and Accounting Date

A transaction’s Creation Date is the date the transaction is loaded into PPM, while the Accounting Date is the date the transaction is recorded in the General Ledger (GL).  These dates are used for financial management and reporting purposes.  These dates may differ depending on the timing of the accounting process for each module.

Example:

Assume that following completion of a business trip, a staff member has created and submitted an expense report, and all of the approvals (departmental and central) are completed as of June 15.  Assume also that the related accounting processes for both PPM and the GL are run on June 15.

If this report contains an expense of $300 for an airline ticket that was paid via credit card on May 15, then the Expenditure Item Date for that $300 in travel expense will be May 15.  However, the Creation Date and Accounting Date for that $300 travel expense will be June 15, as that is the date the accounting process for the expense was completed.

Posted in Training | 1 Comment

PPM Basics for Sponsored Projects Administrators

Because there’s so much new terminology and information we’re all having to learn, I thought it would help if we had one place to list some of the basic concepts of Project Portfolio Management (PPM).  Please keep in mind that this presentation is not all-inclusive and is only meant to be an overview of PPM for departmental research administrators.  The presentation will most likely be updated from time to time as we determine what information is most helpful for PPM users.

Presentation:  PPM basics

Posted in Training | Leave a comment

iO FAQs

iO Frequently Asked Questions

Posted in General Accounting Blog Postings | Leave a comment

Crosswalk from Banner to iO

Crosswalk from Banner to IO codes

Posted in General Accounting Blog Postings | Leave a comment

Faculty Funds-How Tasks Work

Faculty funds – relationship to Banner, how tasks work

Posted in General Accounting Blog Postings | Leave a comment

Link to Faculty Funds Blog Posting from Crystal Davis

Faculty Funds project numbers

Posted in General Accounting Blog Postings | Leave a comment

Financial Management Guidebook

Shared per request of iO Change Management Team

The Financial Management Guidebook and Chart of Accounts (CoA) Quick Reference Guides (QRGs) are now available to you on the imagineOne website under the Chart of Accounts Redesign menu. These resources will provide you with an opportunity to support your learning and think about the way we do business as we approach go-live July 1, 2021.

The Financial Management Guidebook is intended to serve as a reference document for financial administrators across campus as we transition from the Banner FOAPAL to the Oracle CoA. The Guidebook contains an overview of and instruction on use of the CoA and will provide direction on key concepts of fund and program management along with transaction level description and examples. The QRGs, on the other hand, highlight a handful of key concepts from the Guidebook in a simple, summarized format for quick reference.

You can also find recordings of the imagineOne Roadshows and that will provide you with an opportunity to see how the new CoA works in practice and help prepare you for training. If you have questions surrounding the Guidebook or QRGs, please reach out to the imagineOne Project Team at  imagineOne@rice.edu.

Posted in Training | Leave a comment

iO RCA Updates June 30 (Sent via listserv)

Hello,

On the eve of iO go live, I wanted to take this opportunity to provide information regarding many changes that may impact your organization.

  1. RCA accountant responsibilities are now managed by Org (Dept). Attached is the new assignment list. The new assignment list is also on our website.
  2. Please use the new iO HR/Finance helpdesk for all your correspondence with RCA. Navigate to this page for instructions on how to use the helpdesk. The configured RCA categories in the helpdesk are:
    1. New Faculty Fund Projects
    2. Cash Management Questions
    3. Budget Revisions
    4. University Awards (U funds)
    5. General Questions
  3. Advanced Spending procedures have been updated on RCA’s website. PLEASE READ
  4. Faculty Fund procedures have been created and posted on RCA’s website. PLEASE READ
  5. June activities will begin to be entered in iO on July 5th, in this order:
    1. New Awards
    2. Date Extensions
    3. Other Amendments
    4. Budget Revisions
  6. Patience- Please be patient with us as we catch up on June activities while also learning iO. We will continue to provide the same excellent customer service that you have come to expect from RCA.
Posted in Policy and Procedure Updates | Leave a comment

New Subaward Process in iO (Sent via listserv on July 15)

Hello,

We are pleased to announce the new subaward process. RCA will now be creating requisitions (reqs) and P2P will be creating the purchase orders to manage subawards in iO. New subawards issued by SPARC after 05/31/21 will need a requisition and purchase order created, but unlike Banner, they will not be set up as separate projects in iO.

All existing subawards were converted from Banner as separate projects, and we are working diligently to create requisitions for them.  The available balance of the subaward subfund in Banner will be the new requisition budget amount in iO.  We are prioritizing the creation of reqs for invoices that are ready to be paid.  If you get a notification to approve a requisition, please do so, otherwise a purchase order will not be created, and you will not be able to pay your invoice.  Refer to this job aid on how to process your invoices.

For the approval of new subaward invoices in iO, a subaward workflow has been set up in AdobeSign to quickly route a subaward invoice from RCA to the Project Manager for review and the PI for approval.

The following steps outline the subaward process (https://controller.rice.edu/rca-faqs):

  1. SPARC sends draft subaward agreement to RCA
  2. If necessary, RCA requests that P2P create a new supplier
  3. RCA creates and submits requisition based on draft agreement, which is routed to the Cost Center Manager. The Project Manager is entered as the requestor.
  4. Cost Center Manager approves requisition
  5. P2P creates PO based on approved requisition
  6. RCA provides PO number to SPARC to be included in final subaward agreement
  7. Subawardees are instructed to submit invoices to subinvoices@rice.edu, which is monitored by RCA
  8. Invoices are logged and entered into AdobeSign by RCA, which sends the invoice to the appropriate approvers (including PI)
  9. Project Managers are responsible for getting PI signature/approval on the invoice
  10. Project Manager will complete receiving process in iO
  11. P2P will process invoice for payment
Posted in Policy and Procedure Updates | Leave a comment

Farewell to Marissa

Marissa Gonzalez, Research Accountant III, is departing Rice University to work at Stanford University. Marissa’s last day is this Friday, July 30th.

Marissa began working in the Controller’s office, in RCA. in 2017. Since then, Marissa has continued to grow and develop into a very strong sponsored projects accountant. She was often relied upon by the departments and her peers in RCA for her extensive knowledge and experience in sponsored projects. Marissa could always be counted on to complete her work responsibilities without fail. Marissa’s calm demeanor, hard work ethic, and positive attitude will certainly be missed as well.

We are sincerely grateful in Marissa’s dedication and hard work she has given to our office and the University. We wish Marissa good luck in her new role!

Posted in Announcements | Leave a comment