Skip to main content

For Research Administrators

microscope rocket beaker books

This page contains information to help research administrators as they use ConnectCarolina and InfoPorte to support principal investigators who are doing sponsored research at UNC.

PI Dashboard in Infoporte has transitioned to RAM Reports.    Detailed information about RAM Reports can be found on the RAM Reports webpage and guidance document.

Click the buttons below for more details:

Cash Advances Reference Card

This reference card provides information about category codes, account codes, naming conventions and frequently used scenarios for cash advances.

Open the Reference Card

Working With Cash Advances Guide

This guide provides information about working with cash advances, including how to create a campus voucher for a cash advance and how to create a cash advance settlement journal.

Open the Guide

Webinar for Cash Advances

This webinar explains the cash advance process as of March 2015, and how to work with cash advances.

Open the Slides Watch the Webinar

This webinar, recorded at the Research Symposium in 2016, provides people who manage contracts and grants with important information, including how to find:

  • Open requisitions, purchase orders, and unposted vouchers
  • Voucher payments
  • Sponsor payments
  • Payroll accounting rows
  • Cash balances
  • Budget balances.

Watch the webinar | Review the slides

Use the tabs below to find out more information about the reports that are available for reviewing financial information for contracts and grants in ConnectCarolina

Grant Profile Tab
The Grant Profile Tab in InfoPorte provides an overview of grant, including project start and end dates, primary investigator, project status, budget, expenses, encumbrances, and projected earnings.
Grant Details Tab
The Grant Details Tab in InfoPorte shows more detailed information than the Grant Profile tab, including award number, sponsor information, and personnel details.
Budget Overview Inquiry
The Budget Overview Inquiry in ConnectCarolina shows expense totals and available balance by budget chartfield strings in real-time. It breaks out spending totals by pre-encumbrance, encumbrance and expense; and let’s you filter on project and source.
OSR GL Expense and Budget Report
The OSR GL Expense and Budget Report in ConnectCarolina shows expenses and budget balances for a grant based on expenses that have posted to the GL Actuals ledger.

.

GL Activity Tab
The GL Activity Tab in InfoPorte can be used to monitor your OSR projects for any expenses reported to outside agencies based on actuals reflected on GL actuals ledger.
C&G Expenditures – Summary
The C&G Expenditures – Summary Report in InfoPorte displays all contract and grant expenses for the selected period, department, project, or source and is summarized by Project ID, Expenditure Group and Expenditure Type for contracts and grants.
C&G Expenditures – Account Level
The C&G Expenditures – Account Level Report in InfoPorte displays all contract and grant expenses for the selected period, department, project, or source at the detail level by Project ID, Expenditure Group and Expenditure Type for contracts and grants.
Payroll Accounting Report
The Payroll Accounting Report in InfoPorte shows payroll expenses by financial accounting date for reconciliation and grants billing.
OSR GL Expense and Budget Report
The OSR GL Expense and Budget Report in ConnectCarolina shows expenses and budget balances for a grant based on expenses that have posted to the GL Actuals ledger.
Comprehensive Financial Summary
The Comprehensive Financial Summary Report in InfoPorte shows fund and cash balances for OSR funds.
OSR Invoice Listing Report
The OSR Invoice Listing Report in InfoPorte shows all invoices sent to sponsors since the beginning of a project based on transactions posted to the General Ledger. You can also see the balance of your project’s budget.
OSR Payments Report
The OSR Payments Report in InfoPorte displays all AR payment transactions that have hit a cash account for that project which include AR Direct Journals, AR payments, AR worksheet items and AR maintenance trasactions.
OSR Contract Closeout Report
The OSP Contract Closeout Report, found in InfoPorte on the OSP Financial Reporting Tab, is used to facilitate Award/Contract closeout systematically. This report will serve as a tool to ensure all OSP close out processing, status validation, and other reconciliation processes have been completed successfully.

The queries below are available for reviewing financial information for contracts and grants in ConnectCarolina RPT:

  • NC_CPS_AR_DJ_PMTS_BY_PROJECT – Shows OSP deposits via direct journal. There is no associated invoice.
  • NC_CPS_AR_OSR_PAYMENTS_BY_PROJ – Shows invoice generated to sponsor and payment received.
  • NC_CPS_AR_OSR_OPEN_ITEMS – Shows invoice generated to sponsor and payment not received.
  • NC_CPS_KK_PROJECT_SUM – Shows available balance, pre-encumbrance, encumbrance, and expense on OSP funds.
  • NC_CPS_KK_PROJECT_DATA – Shows all OSP projects with chartfield strings and Commitment Control end date.
    Note: The query NC_KK_PROJECT_DATA in ConnectCarolina Query Viewer contains the project end date.
  • NC_CPS_KK_WRONG_PROJECT_QRY – Identifies non-cost sharing OSP balances for projects that have a department that is outside the Grants Project-Department range.

Use the buttons below to get more information about how salary projections are calculated in ConnectCarolina.

Open the Reference Watch the Webinar Open the Slides
Help | help.unc.edu | 919-962-HELP