Research Administration Management (RAM) Reports
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:
NEW Monthly Report Tab
- The new “Monthly Report” tab is available on award and project summary pages.
- Can pull either Summary or Detail reports as PDF or CSV
NEW Personnel Views with Personnel Tab
- The new “Personnel” tab is available on award and project summary pages.
- The Tab presents personnel expense data that can be filtered by category
- The amount for each entry links to the transaction details
Note: The RAM reports Personnel tab is currently designed and intended to provide a listing of Salaries, Fringe Benefits, and Stipends paid from the award or the project depending on the view selected. It is not currently designed to display budgeted or projected salaries, fringe, or stipends.
NEW Accounts Receivable Views with access to AR Reports
- New Award “AR” tab provides a summary list of all invoices
- AR Invoice views will include direct links to attachments in the RAMSeS Billing Tab
Direct Link to ConnectCarolina (CC) Voucher Summary Page
- In Transaction Details, a direct link to CC voucher attachments is available
- Reminder: attachments are only available in CC for 90 days
- Changes to the header information view on all reports
- Financial info layout also now presents Account Category subtotals
Last updated: 08/17/2021
- Accessing Transaction Data and F&A Rate
- Checking F&A Exclusions
- Searching for Data From Previous Periods
- Award-Project Overview
- AR Tab Introduction
Last updated: 09/09/2020
How do I access RAM Reports?
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.