Skip to main content

RAM Reports were developed through a partnership with the Office of Sponsored Research (OSR) and Information Technology Services (ITS) to provide an improved tool to manage sponsored project financials.

RAM Reports provides both campus and central offices with the same view of financial data to improve transparency and streamline processes with sponsored projects financial monitoring and reporting. Click on the icon below to go to RAM Reports.

Last updated: 03/31/2020

What is RAM Reports?

RAM Reports deliver financial information via an enhanced reporting tool and offer a more robust experience managing sponsored projects financials. The information in RAM Reports is pulled just as Infoporte, directly from ConnectCarolina and RAMSeS and data is one day behind what you see in ConnectCarolina. Future enhancements to add functionality to RAM Reports are already in progress to further assist in this endeavor.

Highlights of RAM Reports:

 

  • provides intuitive navigation and ease of searching,
  • easy to view and read report formats,
  • access to both project and award financials,
  • ability to drill into detailed expense transactions, and
  • all reports are downloadable to Excel
 
OSR Ram Report Video Link
 

Effective 09/09/2020

NEW Accounts Receivable Views with access to AR Reports

  • New Award “AR” tab provides a summary list of all invoices
  • RAM Reports Award AR Tab
  • AR Invoice views will include direct links to attachments in the RAMSeS Billing Tab
  • RAM Reports AR Invoice Tab

Direct Link to ConnectCarolina (CC) Voucher Summary Page

  • In Transaction Details, a direct link to CC voucher attachments is available
  • RAM Reports Transaction Detail Direct Link
  • Reminder: attachments are only available in CC for 90 days

Formatting Updates

  • Changes to the header information view on all reports
  • Financial info layout also now presents Account Category subtotals
  • RAM Reports Formatting Changes image

Last updated: 09/11/2020

OSR RAM Reports Guidance Cards

Video Guidance

Project Search


Award Summary


Award Account Summary


Award Transactions


Award Summary: Invoices


Award AR Activities


Project Account Summary


Project Summary


Project Transactions


Last updated: 09/09/2020

How do I access RAM Reports?

Go the https://ramreports.unc.edu and login with your Onyen credentials. On the very first time only, you will need to accept the terms of use conditions before entering the tool.

Who has access to view financial information in RAM Reports?

Campus users with a valid Onyen will be able to login to RAM Reports and view all project/award data.

How can I provide feedback or request more functionality for the tool?

Click on the “Give Feedback” tab on the OSR RAM Reports webpage and submit your feedback or enhancement request.

How can I correct a budget on a project?

Contact ResAdminOSR@unc.edu if you believe budget has been incorrectly loaded on a project. If you need to revise a budget, please submit a OSR Budget Revision Form.

Does the Cost-Share category show all cost-share for the award or project I am viewing?

No, cost-share transactions that display in RAM Reports are only UNC entered cost-share.

Why is the Voucher ID for a transaction not linking to the ConnectCarolina page?

All vouchers are deleted from ConnectCarolina after 90 days, so if the voucher is over 90 days there will be no link in the RAM Report.

Why do I not see my invoices in RAMSeS?

  • If the invoice was a Letter of Credit (LOC), then there will be no invoice in RAMSeS.
  • If the invoice is older than November 2017, it may not be in there, you can email OSRBilling@unc.edu for assistance.
  • If the invoice is was issued in the past 5 business days, it may not be in there, you can email OSRBilling@unc.edu for assistance.

Why cannot I not see the AR tab in my project search?

The AR tab is only available on the Award pages, it will not show up on the Project pages.

Last updated: 03/31/2020

Office of Sponsored Research (OSR) Help

If you need assistance with a sponsored project transaction/request, please refer to the OSR Contact page for a list of all OSR email contacts and/or the OSR ServiceNow page for assistance submitting a help ticket. In general, if you have a request for a ConnectCarolina budget override, you want to submit a help ticket via ServiceNow (routed to OSR-Help) and most other general sponsored projects requests are sent to ResAdminOSR@unc.edu.

Information Technology Services (ITS) Help

If you have technical issues using RAM Reports (i.e., financial info not downloading to Excel or hyperlinks not clickable or going to the correct page), please submit a help ticket via ServiceNow.