IMPORTANT:

The CU-Data reporting system is being upgraded to Cognos 12.0.3 on Thursday evening, August 15, 2024. 

  • Stay up to date on changes and trainings via the CU-Data Upgrade website, our OUC News, and our m-Fin blog.
  • As a reminder of what to look forward to with Cognos 12: You will see a number of enhancements to the CU-Data User Interface (UI). Some of the menu items that you regularly use for m-Fin reports will move to different locations on the home screen ... but they will all still be there, just arranged in a more streamlined menu. Note that the m-Fin reports themselves have not changed. Learn more about the upgrade here.

m-Fin Reports are financial reports created in CU’s Cognos software and accessed through the CU-Data system in the portal.

You can run m-Fin reports in CU-Data if you have a fiscal role on a SpeedType or if you have access to the Finance System.  Log in to your campus portal and on the CU Resources Home tab, click the CU-Data tile.

= Features a Mastering m-Fin mini-webinar recording

Monthly Financial Review Reports

Run these reports each month to reconcile your SpeedTypes. Watch a video about the 5 key m-Fin reports.

  • m-Fin Operating Summary - A one-page-per-SpeedType report that shows the available balance calculation, as well as revenue and expenditures by various account levels. Includes assets and liabilities, if relevant to fund type.​
  • m-Fin SpeedType Summary - A simple one-line-per-SpeedType report showing budget, actuals, encumbrances, and available balance for a given period.
  • m-Fin SpeedType One-Liner - A one-line per SpeedType report showing budget (with a breakdown of continuing vs. temporary budget), actuals, and encumbrances. 
  • m-Fin Financial Detail - An itemized list of all transactions for revenue, expense, and balance sheet accounts. Can be run for a customized list of account codes. 
  • m-Fin Financial Detail II - An itemized list of all transactions for revenue, expense and balance sheet accounts, with additional features and options not available in m-Fin Financial Detail. Can be run for a customized list of account codes. 
  • m-Fin Outstanding Encumbrances - An itemized list of all expenses committed but not yet incurred for a given SpeedType or purchase order
  • m-Fin Resource Deficit & Abnormal Balance - Lists SpeedTypes with negative cash balances or positive net assets. Shows account codes with abnormal balances (i.e., debit accounts with credit balances or credit accounts with debit balances). 

Revenue and Expenditure Reports

Run these reports to track revenues and expenditures for your SpeedTypes. Drill down on blue highlighted amounts to see the detail behind transactions or balances.

Summary Reports

  • m-Fin Operating Summary - A one-page-per-SpeedType report that shows the available balance calculation, as well as revenue and expenditures by various account levels. Includes assets and liabilities, if relevant to fund type.
  • m-Fin Revenue and Expenditure Summary - Summarized balances for revenue and expenditure accounts by SpeedType.
  • m-Fin Revenue and Expenditure Total - Aggregate revenue and expenditure account totals by Org, fund type, or a designated group of SpeedTypes, with page breaks by fund.
  • m-Fin Expenditure Type Summary – A summary by expenditure types (salaries and wages, benefits, operating expenses, and travel) for a given SpeedType. Also displays pie charts of expenditures-to-date.
  • m-Fin Expenditure Type - Summarized expenditure categories within a fiscal year, aggregated by Org and grouped by fund.
  • m-Fin Actuals by Fiscal Year - Summarized account range totals for an Org or customized group of SpeedTypes by fiscal year. This report includes a summary of Budget-Actual-Encumbrance (BAE) totals.

Transaction Detail Reports

  • m-Fin Financial Detail - An itemized list of all transactions for revenue, expense, and balance sheet accounts. Can be run for a customized list of account codes. 
  • m-Fin Financial Detail II - An itemized list of all transactions for revenue, expense and balance sheet accounts, with additional features and options not available in m-Fin Financial Detail. Can be run for a customized list of account codes. 

One-Liner Reports

  • m-Fin SpeedType Summary - A simple one-line-per-SpeedType report showing budget, actuals, and available balance for a given period.
  • m-Fin SpeedType One-Liner – A one-line per SpeedType report showing budget (with a breakdown of continuing vs. temporary budget), actuals, and encumbrances. 
  • m-Fin Budget to Actual - A one-line per SpeedType report showing budget, actuals, and encumbrances. Includes continuing and temporary budgets for each SpeedType.

Org-Level Reports

  • m-Fin Tree Zoom II - A top-down analysis of expenditure actuals, with the ability to drill to descending Org and account trees.
  • m-Fin Org Expenditures by Month - Totals for expenditure types by month, for a single Org, for a designated length of time.

By Month Reports

  • m-Fin BAE by Month - Summary –  Budget, monthly actuals, and encumbrances within a fiscal year for a SpeedType, with an optional Available Balance calculation.
  • m-Fin Expenditure Actuals by Month - Total – Aggregate monthly actuals for expenditure categories by Org, Fund Type, or for a customized group of SpeedTypes, with page breaks by fund. Final page includes an all-funds summary.
  • m-Fin Revenue and Expenditure Actuals by Month - Total - Aggregate monthly actuals for revenue and expenditure categories by Org, Fund Type, or for a customized group of SpeedTypes, with page breaks by fund. Final page includes an all-funds summary.
  • m-Fin Expenditures Cumulative by Month Charts - Summarized expenditure categories by month across fiscal years by SpeedType, Program or Project, displayed in the following graphs: Budget Minus Encumbrances and Prorated Budget.

Balance Sheet Reports

Run these reports to see information on balance sheet accounts, including assets, liabilities, and net assets.

Trial Balance Reports

Run these reports to ensure transactions are in balance and discover potential inaccuracies.

  • m-Fin Trial Balance Summary - Balance Sheet Summary and the Revenue and Expenditure Summary within one report, with page breaks by SpeedType. 
  • m-Fin Trial Balance Total - Aggregate balance sheet, revenue and expenditure account totals by Org, Fund Type, or for a customized group of SpeedTypes, with page breaks by fund. 

Account Number Reports

Run these reports to see total account code balances across SpeedTypes, Orgs, or fund types.

Project Reports

Run these reports to see detail specific to projects/restricted funds.

Summary Reports

  • m-Fin Award – A one page summary of the financial activity associated with an award, or group of awards, including project attributes, F&A rates, and direct vs F&A costs.
  • m-Fin Payments Received Org Overview – Payments received from granting agencies, summarized by each project within an organization.
  • m-Fin Project Financial Status – An  Available Balance Summary, an optional Assets and Liabilities Summary, a highly summarized Expenditures summary, an optional cumulative expenditures chart, and an optional salaries, wages, and benefits section, for a specific Project, with consolidated subclasses.
  • m-Fin Project LifeChart - Cumulative spending over time vs. budget for a given project.
  • m-Fin Project Fiscal Years - Spending (Direct vs. F&A) by fiscal year for one or more projects.
  • m-Fin Expenditures Sponsor by Fiscal Year – Spending by sponsor across fiscal years for a specified Org.

Transaction Detail Reports

  • m-Fin Project Actuals Detail – Expenditures on a project that have occurred before or after particular date of significance to the project. Shows all transfers booked on a project during a specified range of dates.
  • m-Fin Receivables Activity - Detailed receivables activity for a project, for any source code that is not from the revenue recognition process. Shows unusual receivables activity for a project.
  • m-Fin Receivables Transaction Finder - Search for a payment, by dollar amount, or project ID, from a project sponsor that was booked to the wrong FOPPS.
  • m-Fin Payments Received – Payments received from granting agencies.
  • m-Fin Sponsor Funding - All budget transactions for all projects under a specified Org.

One-Liner Reports

  • m-Fin Project One-Liner -  A one-line per Project report that includes project dates, F&A rate, and award information, as well as Budget, Actual, and Encumbrance amounts. Includes an extras prompt to view cash balances.
  • m-Fin Project Spending Trends - A one-line per Project report analyzing at the Project level, rather than the SpeedType level (for projects that have subclass). Shows projects that have patterns of accelerated spending that look like they might go over budget. The analysis is of the last seven months.
  • m-Fin Project SpeedType One-Liner – A one-line per Project report that includes start and end dates, F&A rate, budget, actuals, and encumbrances for multiple projects.

By Month Reports

  • m-Fin Award Expenditures by Month - Summarized expenditures for an award by month for any specified range of months, with an optional bar chart.
  • m-Fin Project Expenditures by Month – Summarized project expenditures by month for any specified range of months. Shows summarized project expenditures by month for the federal fiscal year (twelve months October through September).

Specialty Reports for Projects

  • m-Fin LOC Pool – Used to determine the letter of credit draws for a project
  • m-Fin OLT - Shows sponsored projects that spend over the maximum amount that can be billed from the sponsor. 
  • m-Fin Retired Projects Not Zero - Search for retired projects where balance sheet accounts have a debit or credit balance.
  • m-Fin ROL - Shows sponsored projects that have recognized revenues over the maximum amount sponsored.

Compensation Reports

Run these reports to see information on salary and benefits by SpeedType, employee, or position number.

  • m-Fin Compensation Summary - Total compensation by employee/position, broken out between salary, benefits, and other. Includes the applicable benefits rate by position.
  • m-Fin Payroll Transactions - Detailed accounting for pay and benefits for an employee over a range of accounting periods. The final page displays the Compensation Summary.
  • m-Fin Position Budget – Comparison of position budget transactions to the actuals (payment) transactions. Shows the monthly payments (actuals) to each position over time.
  • m-Fin Position Budget II – Comparison of position budget transactions to the actuals (payment) transactions side-by-side. Shows SpeedType allocations for a position and the monthly payments (actuals) to each position.
  • m-Fin Position Budget - Actuals Detail – Shows detailed pay information for a given position and account code range over a set period of time.
  • m-Fin Payroll Accounting Period - Summarized payroll information for a specific accounting period, by SpeedType, sorted by employee.
  • m-Fin Payroll Fiscal Year - Summarized payroll information for a fiscal year, displayed by month, for a specific SpeedType, sorted by employee.
  • m-Fin Payroll Fiscal Year Detail - Detailed payroll information, for a fiscal year, displayed by month, for a specific SpeedType, sorted by employee.
  • m-Fin Personnel Roster and Departmental Budget - Position budgets by fund, Org, and SpeedType,  including continuing and temporary budget amounts and budgeted FTEs. Includes Job Codes and Descriptions.
  • m-Fin PET - Details of a Payroll Expense Transfer (PET). Search PETs by fiscal year, PET Operator, and PET Date.

Specialty Reports

Run these reports to see detail not available in traditional financial statements.

  • Advancement Intelligence - Unlinked Funds to Review - A list of CU Foundation Funds that are either unlinked to CU Gift Fund SpeedTypes or are linked to inactive CU Gift Fund SpeedTypes 
  • m-Fin LAUNCH - A menu of reports given a SpeedType, Org, or Project, recommending different reports to run for each fund type. 
  • m-Fin Accounting Summary - A one-line per SpeedType report showing net assets and liabilities at the beginning of the fiscal year and subsequent revenues and expenditures. Includes current cash balance.
  • m-Fin Accounting Summary by SpeedType - Summarized account code information for one or more SpeedTypes, displayed in columns. Shows total budget, actuals, and encumbrance information for one or more SpeedTypes, displayed in columns.
  • m-Fin Accounting Summary Fund 34 - A one-line per SpeedType report showing net assets and liabilities at the beginning of the fiscal year and subsequent revenues and expenditures for a Fund 34 SpeedType. Shows the available balance for linked CU Foundation funds.
  • m-Fin Audit Trail - A summation of account code balances for SpeedTypes for specified funds.
  • m-Fin ESP Transactions - Procurement Card transactions by cardholder name, with the ability to filter by vendor name.
  • m-Fin Gross Margin COGS - Revenue and cost of goods sold for an Org or SpeedType that sells inventory (such as a campus bookstore).
  • m-Fin NACUBO Expense Purpose - Budget, actual, and encumbrance expenditure amounts for an Org by expense purpose code.

Look-Ups (look up ChartField info rather than financial info

Run these reports to see ChartField information, rather than financial information.

  • m-Fin Account Tree List - Shows the account tree list at different levels.
  • m-Fin Fiscal Roles - Shows positions and individuals that have been assigned fiscal roles (e.g. program manager, project principal) for a specific SpeedType, Org or Position number. Each different fiscal role listing starts on its own page. Shows if a SpeedType Fiscal Staff role is an Approver, Reviewer, or Both.
  • m-Fin Fiscal Roles II - Shows fiscal role assignments by SpeedType (all roles listed under each). Report can be run by SpeedType or Org.
  • m-Fin Org Tree Lineage – Enter an Org code/node to see its organizational tree lineage. Includes the Officer, Principal, and Fiscal Manager for each Org.
  • m-Fin Org Tree List – Select an effective date, then filter through levels of the Org Tree down to a specific Org node. Add extras like Officer, Principal, and Fiscal Manager names and contact information.
  • m-Fin Source Code Lookup – Status and description for a specific Source Code.
  • m-Fin SpeedType List - An attributes list of active/inactive SpeedType(s).
  • m-Fin SpeedType Status - SpeedType status along with effective dates for all SpeedTypes under a specified Org.

CU-Data Query Studio