Research Administration Management (RAM) Reports
RAM Reports were developed through a partnership with the Office of Sponsored Programs (OSP) 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: 10/25/2022
What are 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
Personnel Monthly – Current month now split between posted salary and project salary
NEW Personnel Totals Tab
NEW Personnel Monthly Tab
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
Formatting Updates
- Changes to the header information view on all reports
- Financial info layout also now presents Account Category subtotals
Last updated: 12/15/2022
Video Guidance
- 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: 10/25/2022
How do I access RAM Reports?
Go the https://tarheelreports.unc.edu/ramreports/project/search/ 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 OSP RAM Reports webpage and submit your feedback or enhancement request.
How can I correct a budget on a project?
Contact SponsoredPrograms@unc.edu if you believe budget has been incorrectly loaded on a project. If you need to revise a budget, please submit a OSP 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 OSPBilling@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 OSPBilling@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.
What is the difference in Personnel Totals and Personnel Monthly?
Personnel Totals show the breakout of Salary and Fringe for both posted payment and projected payments.
Personnel Monthly show the total for each person listed on the project for past, current and future months.
Do the personnel tabs show all personnel assigned to that project?
If you are viewing the Award level data, then the personnel tabs show all personnel listed on the project.
If you are viewing Project specific data, then these tabs show information only for personnel associated with that specific project.
Last updated: 03/31/2020
Office of Sponsored Programs (OSP) Help
If you need assistance with a sponsored project transaction/request, please refer to the OSP Contact page for a list of all OSP email contacts and/or the OSP 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 OSP-Help) and most other general sponsored projects requests are sent to SponsoredPrograms@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.