finance-reports-key-terms Key Terms  finance-reports-faqs  FAQs finance-reports-submit-question Submit Question  newreportrequest New Report Request finance-reports-document-pdf Download as PDF 

Report & MenuDescriptionWhat Does It Help Me Do?Available Training
Finding Budget BalancesBack to top ^
InfoPorte: Ledger Rollup Tabs
ConnectCarolina RPT: Budget Balances Query

  • NC_CPS_KK_SOURCE-SUM
  • Shows available balance, pre-encumbrance, encumbrance, and expense.
Source: Commitment Control ledgers
  • Monitor your available balance for State, F&A and Trust funds.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_SOURCE_ACCT_SUM
  • Shows same as above by account and account description.
Source: Commitment Control ledgers
  • Monitor your available balance for State, F&A and Trust funds by account.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_SOURCE_FUND_SUM
  • Shows available balance, pre-encumbrance, encumbrance, and expense by fund and fund description.
Source: Commitment Control ledgers
  • Monitor your available balance for State, F&A and Trust funds.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_SOURCE_FUND_DEPT
  • Shows available balance, pre-encumbrance, encumbrance, and expense by fund and department.
Source: Commitment Control ledgers
  • Monitor your available balance for State, F&A and Trust funds by fund and department.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_STATE
  • Shows current State Commitment Control balances and includes State_Rev and State_Par ledger groups.
Source: Commitment Control ledgers
  • Monitor your available balance for State funds including at the State parent ledger level.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_DEPT_SUM
  • Shows Commitment Control balances by department on State, F&A and Trust funds.
Source: Commitment Control ledgers
  • Monitor your available balance for State, F&A and Trust funds by department.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_FAMODET_DEPT2
  • Shows balances for FAMODET ledger group. Shows first two digits of department code.
Source: Commitment Control ledgers
  • Monitor your available balance for FAMODET funds.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_FAMODET_DEPT3
  • Shows balances for FAMODET ledger group. Shows first three digits of department code.
Source: Commitment Control ledgers
  • Monitor your available balance for FAMODET funds.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_FAMODET_DEPT4
  • Shows balances for FAMODET ledger group. Shows first four digits of department code.
Source: Commitment Control ledgers
  • Monitor your available balance for FAMODET funds.
ConnectCarolina RPT: Budget Balances Query
  • NC_CPS_KK_FAMODET_DETAILS
  • Shows balances for FAMODET ledger group displayed with full department code.
Source: Commitment Control ledgers
  • Monitor your available balance for FAMODET funds with view of full department codes.
ConnectCarolina RPT: Revenue & Expense Query
  • NC_CPS_LEDGER_KK_AMOUNTS
  • Shows revenue and expense activity YTD totals.
Source: GL Actuals ledger
  • Monitor revenue and expense activity for State, F&A, Trust, and OSR funds.
  • Note: For OSR, filter by Project ID.
ConnectCarolina RPT: Revenue & Expense Query
  • NC_CPS_LEDGER_KK_AMOUNTS_2
  • Shows the above with program and cost codes.
Source: GL Actuals ledger
  • Monitor revenue and expense activity by program and cost code for State, F&A, and Trust funds.
    Finding Fund Balances and Cash BalancesBack to top ^
    ConnectCarolina RPT: Fund Balance Query
    • NC_CPS_FUND_BAL_ALL
    • Shows fund balance broken out by all chartfield strings – fund, source, department, and project.
    Source: GL Actuals ledger
    • Look up a fund balance for Trust funds and some OSR funds (clinical trials and capitalized grants).
    • Not as helpful for State and F&A ledger groups because they don’t have beginning and ending fund balances.
    • Note: If the query returns multiple rows per source, you’ll need to sum the rows to get a total fund balance.
    ConnectCarolina RPT: Fund Balance Query
    • NC_CPS_FUND_BAL_DPT
    • Shows fund balance rolled up by department.
    Source: GL Actuals ledger
    • Look up a fund balance for Trust funds.
    • Not as helpful for State and F&A ledger groups because they don’t have beginning and ending fund balances.
    • Note: If the query returns multiple rows per source, you’ll need to sum the rows to get a total fund balance.
    ConnectCarolina RPT: Cash Balance Query
    • NC_CPS_CASH_BAL_ALL
    • Shows cash balance broken out by all chartfield strings.
    Source: GL Actuals ledger
    • Look up a cash balance for Trust funds and some OSR funds (clinical trials and capitalized grants).
    Note: If the query returns multiple rows per source, you need to sum the rows to get a total cash balance.
    ConnectCarolina RPT: Cash Balance Query
    • NC_CPS_CASH_BALL_DPT_SUM
    • Shows cash balance rolled up by department.
    Source: GL Actuals ledger
    • Look up a cash balance for Trust funds.
    Note: If the query returns multiple rows per source, you need to sum the rows to get a total cash balance.
    ConnectCarolina RPT: Trial Balance Query
    • NC_CPS_TB_DETAILS
    • Shows trial balance for all chartfield strings in search.
    Source: GL Actuals ledger
    • Look up a trial balance for State, F&A, Trust and OSR funds.
    Note: For OSR, filter by Project ID.
    ConnectCarolina RPT: Trial Balance Query
    • NC_CPS_TB_SOURCE_FUND
    • Shows trial balance by fund and source.
    Source: GL Actuals ledger
    • Look up a trial balance for State, F&A, Trust and OSR funds.
    Note: For OSR, filter by Project ID.
    ConnectCarolina RPT: Trial Balance Query
    • NC_CPS_TB_DETAILS_SOM
    • Shows trial balance for all chartfield strings in search for the School of Medicine (SOM).
    Source: GL Actuals ledger
    • Look up a trial balance for State, F&A, Trust and OSR funds.
    Note: For OSR, filter by Project ID.
    Reconciling Back to top ^
    ConnectCarolina RPT: Source and Project Charges Query
    • NC_CPS_KK_WRONG_SOURCE QRY
    Identifies Trust and Trust_Rev balances that are on departments that are not within the Dept-ID attribute range.
    • Identify and review other departments using your sources and projects.
    Reviewing GrantsBack to top ^
    ConnectCarolina: OSR GL Expense and Budget Report
    • NC_OSR_GL_P1

    • NC_OSR_GL_C1

    Finance Menu > Reporting Tools > BI Publisher > Query Report Viewer
    • Shows expenses and budget balances for a grant based on expenses that have posted to the GL Actuals ledger.
    Source: GL Actuals ledger
    • Monitor your expenses and budget balances for grants.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_AR_DJ_PMTS_BY_PROJECT
    • Shows OSR deposits via direct journal. There is no associated invoice.
    • Manage payments for contracts and grants.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_AR_OSR_PAYMENTS_BY_PROJ
    • Shows invoice generated to sponsor and payment received.
    • Manage invoice and payments for contracts and grants.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_AR_OSR_OPEN_ITEMS
    • Shows invoice generated to sponsor and payment not received.
    • Manage invoice and payments for contracts and grants.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_KK_PROJECT_SUM
    • Shows available balance, pre-encumbrance, encumbrance, and expense on OSR funds.
    Source: Commitment Control ledgers
    • Manage your available balance for OSR projects.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_KK_PROJECT_DATA
    • Shows all OSR projects with chartfield strings and Commitment Control end date.
    • Note: The NC_KK_PROJECT_DATA in PRD contains the project end date.
    • Monitor OSR project data.
    ConnectCarolina RPT: OSR Payments
    • NC_CPS_KK_WRONG_PROJECT_QRY
    • Identifies non-cost sharing OSR balances for projects that have a department that is outside the Grants Project-Department range.
    • Monitor OSR project data.
    Working with Edit ErrorsBack to top ^
    ConnectCarolina Query Viewer: Edit Error Query
    • NC_PO_EDIT_ERRORS
    • Shows purchase orders with edit errors such as combo edit errors.
    • Also shows purchase orders with match exceptions.
    • Identify purchase orders that are held up with errors so you can troubleshoot the problem.
    ConnectCarolina Query Viewer: Edit Error Query
    • NC_AP_EDIT_ERRORS_VOUCHERS
    • Shows vouchers with edit errors such as combo edit errors.
    • Also shows vouchers with match exceptions.
    • Identify vouchers that are held up with errors so you can troubleshoot the problem.
    Note: For instructions on resolving voucher errors, see the Voucher Matching and Error Troubleshooting Query reference located here: ccinfo.unc.edu/training/resource-documents/
    ConnectCarolina Query Viewer: Edit Error Query
    • NC_GL_JOURNAL_EDIT_ERRORS_DEPT
    • Shows campus journals with edit errors such as combo edit errors.
    • Identify campus journals that are held up with errors so you can troubleshoot the problem.
    ConnectCarolina Query Viewer: Edit Error Query
    • NC_AR_EDIT_ERROR
    • Shows deposits with edit errors such as combo edit errors.
    • Identify deposits that are held up with errors so you can troubleshoot the problem.
    Working with Budget ErrorsBack to top ^
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_REQ_DEPT
    • Shows requisitions with a budget error
    • Identify requisitions with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_PO_DEPT
    • Shows purchase orders with a budget error
    • Identify purchase orders with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_VOUCHERS_DEPT
    • Shows vouchers with a budget error
    • Identify vouchers with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_BUD_JRNLS
    • Shows budget journals with a budget error
    • Identify budget journals with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_JOURNALS_DEPT
    • Shows campus journals with a budget error
    • Identify campus journals with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_AR_MISCPAY
    • Shows deposits with a budget error
    • Identify deposits with budget errors so you can resolve them.
    ConnectCarolina Query Viewer: Budget Error Query
    • NC_KK_ERRORS_PAYROLL
    • Shows payroll lines with a budget error
    • Identify payroll lines with budget errors so you can resolve them.
    Working with Transactions in Unposted StatusBack to top ^
    ConnectCarolina Query Viewer: Unposted Transactions Query
    • NC_AP_UNPOSTED_VOUCHERS
    • Shows vouchers that haven't posted yet.
    Important: Be sure to check for edit and budget errors first before running this query.
    • Identify transactions that haven't posted yet so you can check if there are problems that need resolving.
    ConnectCarolina Query Viewer: Unposted Transactions Query
    • NC_GL_BUD_JRNL_NOT_POSTED_DEPT
    • Shows budget journals that haven't posted yet.
    Important: Be sure to check for edit and budget errors first before running this query.
    • Identify transactions that haven't posted yet so you can check if there are problems that need resolving.
    ConnectCarolina Query Viewer: Unposted Transactions Query
    • NC_GL_JRNL_NOT_POSTED_DEPT1
    • Shows campus journals that haven't posted yet.
    Important: Be sure to check for edit and budget errors first before running this query.
    • Identify transactions that haven't posted yet so you can check if there are problems that need resolving.
    Working with All RequisitionsBack to top ^
    ConnectCarolina Query Viewer: All Requisitions Query
    • NC_EP_REQ_STATUS
    • Shows all requisitions and their status, including their budget status.
    • Identify all requisitions with any issue holding up processing.
    Working with Approval WorklistsBack to top ^
    ConnectCarolina Query Viewer: Approval Worklist Query
    • NC_REQ_APPROVAL
    • Shows requisitions that haven't been approved.
    Note: Approvers need to be logged in as themselves in order for this query to show results.
    • Manage your transaction approval flow
    • Identify backlog of transactions needing approval
    ConnectCarolina Query Viewer: Approval Worklist Query
    • NC_VCHR_APPROVAL
    • Shows campus vouchers that haven't been approved.
    Note: Approvers need to be logged in as themselves in order for this query to show results.
    • Manage your transaction approval flow
    • Identify backlog of transactions needing approval
    ConnectCarolina Query Viewer: Approval Worklist Query
    • NC_JRNL_APPROVAL
    • Shows campus journals that haven't been approved.
    Note: Approvers need to be logged in as themselves in order for this query to show results.
    • Manage your transaction approval flow
    • Identify backlog of transactions needing approval
    Working with Voucher PaymentsBack to top ^
    ConnectCarolina RPT: Voucher Not Paid Query
    • NC_CPS_VCHR_NOT_PAID_UNCCH1
    • Shows vouchers that either have no lines paid, or only partial lines paid.
    • Manage accounts payable aging for State, F&A, Trust and OSR funds.

    Note: This query is also available to campus in PRD.
    ConnectCarolina RPT: Voucher Paid Query
    • NC_CPS_VCHR_PMNT_INFO_UNCCH1
    • Shows all vouchers that have been paid or partially paid.
    Note: If no lines on a voucher were paid, the voucher will not show in the query results. You need to use the Voucher Not Paid query above to see vouchers where no lines have been paid.
    • Review timeliness of payments to suppliers for State, F&A, Trust and OSR funds.
    Note: This query is also available to campus in PRD.
    Year End QueriesBack to top ^
    • NC_CPS_YE_DCB_CORRECT
    • Shows lines from Data Collect Batches.
    • You can select which lines you need to correct for year end. These are mostly interdepartmental billings.
    • NC_CPS_YE_DEPT_MAP
    • Shows department mapping.
    • You can select lines you need to correct for year end. This is for correcting the Dept, Program, or Cost Code chartfields. Fund, Source, and Account should remain the same.
    • NC_CPS_YE_PCD_CORRECT
    • Shows lines from PCard transactions.
    • You can select which lines you need to correct for year end. The Account code should not be changed.
    • NC_CPS_YE_AP_VOUCHERS
    • Shows lines from PO and Non-PO Vouchers.
    • You can select which lines you need to correct for year end. The Account code should not be changed. PO vouchers that are State waivered cannot be corrected through a Journal Import.
    • NC_CPS_YE_TRUST_CASH
    • Shows trust fund cash balances.
    • You can select trust funds with cash deficits to correct.


    Key Terms

    Available Balance
    • Represents the budget amount available for a particular budget period.
    • Driven by budget checking.
    • Based on Commitment Control ledgers (state, F&A, trust, OSR)
    Fund Balance
    • Represents the total net worth of a fund
    • Represents total assets minus total liabilities.
    • Driven by the GL journal posting process.
    • Based on GL Actuals Ledger.
    Cash Balance
    • Represents a summary of all cash accounts.
    • Driven by the GL journal posting  process. Based on the GL Actuals Ledger.
    Commitment Control (KK)
    • UNC budgeting control ledgers(State, F&A, Trust, OSR, program & cost codes)
    GL Actuals
    • Actuals in UNC’s general ledger and official book of record


     FAQS

    GENERAL

    Click to read General FAQs

    Q: Does the information in ConnectCarolina automatically update to InfoPorte?

    A:  Transactions entered in ConnectCarolina appear in InfoPorte the next day, not immediately. Some transactions — particularly payroll and some procurement transactions, such as canceling a purchase order — may not be available in InfoPorte until the following Monday (because they are processed over a weekend).

    Information about when the data was updated appears in the News section of the Portal page and is visible immediately after you login to ConnectCarolina.  If there is a delay with data updates, a message displays in the Daily Status section of the Portal page.

    Q: Is training offered for InfoPorte reporting

    A:  Yes, there are two classes: one on HR reports and one on Finance reports.  The training schedule includes upcoming dates and times for both the Financial Reporting for InfoPorte class and the HR/Payroll Reporting for InfoPorte class.  The schedule is located at ccinfo.unc.edu > Training> Training Schedule.  Access to InfoPorte is a prerequisite for these classes.

    FOR BUSINESS MANAGERS

    Click to read Business Manager FAQs

    Q: How can I determine my balance?

    A: Expenses never change, but sometimes it may seem like “the data doesn’t match.” Available budget balance will continue to change based on encumbrances, which are based on budget.  Your available budget balance will fluctuate throughout the month until the month is closed. You can use the InfoPorte Ledger Rollup Tabs to keep an eye on your available budget balance and spending during the month.  These tabs and other tools and their uses are described in the Finding Budget Balances section of the Financial Reporting Quick Reference Guide.

    A Budget Balances concepts document explains fluctuations of available budget balances in InfoPorte and the key related concepts.

    The Budgeting 101 document was recently updated and is an excellence source of budgeting overview info.

    Q: I want to see what transactions have not posted, are awaiting approval or are might be held up in processing.

    A: Check out the Working with Unposted Transactions section of the Financial Reporting Quick Reference Guide.  You can use the ConnectCarolina Query Viewer to run queries that will identify transactions that haven’t posted yet so you can check if there are problems that need resolving. The Approval Worklist Query identifies all requisitions with any issue holding up processing.

    FOR PRINCIPAL INVESTIGATORS

    Click to read PI FAQs

    Q: How can I see the remaining balance for my grant?

    A: The InfoPorte Grant Profile Tab can be used to review remaining balances and spot-check your grants’ remaining balances or grant end date. You can also view details for each project on the InfoPorte: Grant Details Tab.

    Paths for these reports and a catalogue of other grants-related reports can be found in the Reviewing Grants section of the Financial Reporting Quick Reference Guide. 

    FOR DEANS

    Click to read Deans FAQs

    Q: I need to review an income statement for our department. How do I access it?

    A: The InfoPorte SAS Income Statement allows you or your business manager to produce an income statement for a fund or a department.  This report shows operating and non-operating expenses. This can be found in the Running Income Statement section of the Financial Reporting Quick Reference Guide.


    Submit a Question

    • We need your email address to respond to your question