Cognos Reporting System Training

Getting Started

Before you can use the Reporting System, you must be granted access to the Cognos m-Fin Reports. After you receive access, you then log in to the reporting system via your campus portal.

Once you are logged in, the following resources may help you navigate the Cognos Reporting System.

m-Fin Reports

Monthly Financial Report Review Reports

  • M-Fin SpeedType Summary - Shows the available balance as of the close of business for the previous business day.
  • M-Fin Operating Summary - Shows the SpeedType Summary available balance calculation. Also includes the Revenue and Expenditure Summary, and additionally an Asset and Liability Summary if it is relevant to financially managing the FOPPS.
  • M-Fin Outstanding Encumbrances - Shows an itemized list for all financial expenses committed but not yet occurred for a given SpeedType.
  • M-Fin Financial Detail - It shows an itemized list of all transactions for revenue/expense and balance sheet accounts. Can be used in the reconciliation process.
  • M-Fin Abnormal Balance - Shows either a Resource Deficit Report or an Abnormal Account Balance Report, or both. The Resource Deficit Report displays SpeedTypes with either a negative cash balance or positive net assets, and the Abnormal Account Balance Reports shows accounts with abnormal balances (i.e., debit accounts with credit balances or credit accounts with debit balances).

Revenue and Expenditure Reports

Expenditure Type Reports

  • M-Fin Expenditure Type Summary - Shows a summary by expenditure types (salaries and wages, benefits, operating expenses, and travel) for a given SpeedType.
  • M-Fin Expenditure Type - Shows summarized expenditure categories within a fiscal year, subtotaled by org and grouped by fund.
  • M-Fin Expenditures Cumulative by Month Charts - Shows summarized expenditure categories by month within a fiscal year, by SpeedType, Program, or Project, in the following graphs: Budget Minus Encumbrances and Prorated Budget.

Balance Sheet Reports

  • M-Fin Balance Sheet Summary - Shows the summarized balances for balance sheet accounts (assets, liabilities, and net assets). Provides page breaks by SpeedType.
  • M-Fin Balance Sheet Total - Shows the summarized balances for balance sheet accounts (assets, liabilities, and net assets). Provides page breaks by fund.

Trial Balance Reports

Account Number Reports

Budget Reports

  • M-Fin Budget to Actual - Shows a traditional budget-actual-encumbrances report with one line per SpeedType, and can separate the continuing and temporary budget for each SpeedType.

Specialized Reports

  • M-Fin Accounting Summary Report - Shows the net assets and liabilities at the beginning of the fiscal year, and subsequent revenues and expenditures. Also shows current cash balance.
  • M-Fin Audit Trail - Shows a summation of account code balances for SpeedTypes for specified funds.
  • M-Fin Fiscal Roles - Shows positions and individuals that have been assigned fiscal roles (e.g. program manager, project principal) for a specific SpeedType, Organization Code, Organization Node, or Position Number. Note: This report does not display budgets, actuals, or encumbrances.  Each different fiscal role listing starts on its own page.
  • M-Fin Journal Entry Approver Incompatible Access - Shows journal entries having the same approver as creator, run by user.
  • M-Fin K Exhibit - Shows a project's net assets as of the beginning of the fiscal year and then subsequent revenues and expenditures, sorting and subtotaling by codes that represent granting agencies.
  • M-Fin NACUBO Expense Purpose - Shows the National Association of College and University Business Officers (NACUBO) groups for each program and project.
  • M-Fin Accounting Summary by SpeedType: Shows summarized account code information, or total budget information, for multiple SpeedTypes, displayed in columns.

m-Fin Prompt Pages

Entering SpeedTypes/FOPPS Components

m-Fin Look-Ups

Look-Ups

m-Fin Project Reports

Project Reports

  • M-Fin Award Code: Shows a one page summary of the financial activity associated with an award.
  • M-Fin Payments Received - Shows payments received from granting agencies for Clinical Trials.
  • M-Fin Payments Received Org Overview - Shows payments received from granting agencies for Clinical Trials, summarized by each project within an organization.
  • M-Fin Project Financial Status: Shows an Available Balance Summary, an optional Assets and Liabilities Summary, 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 One-Liner: Shows the financial basics for a project(s) in a one-line presentation.
  • M-Fin Project Spending Trends: Shows an analysis of a Project at the Project level, rather than the SpeedType level (for projects that have subclasses).
  • M-Fin Receivables Activity: Shows detailed receivables for a Project, for any Source Code that is not from the revenue recognition process.
  • M-Fin Receivables Transaction Finder: Shows search results for a payment, by dollar amount, or Project ID, from a Project sponsor that was booked to the wrong FOPPS.

m-Fin Payroll Reports

Payroll Reports

  • M-Fin Compensation Summary - Totals pay by position.
  • M-Fin Payroll Transactions - Lists the detail accounting for pay and benefits for an employee over a range of accounting periods you specify. This detail is then summed into a compensation summary on the final page.
  • M-Fin Position Budget Report - Shows position budgets compared to payments, and monthly payments to each position over time.
  • M-Fin Payroll Accounting Period: Shows summarized payroll information for a specific accounting period, by SpeedType, sorted by employee.
  • M-Fin Payroll Fiscal Year: Shows summarized payroll information for a fiscal year, displayed by month, for a specific employee or SpeedType (sorted by employee).
  • M-Fin Payroll Fiscal Year Detail: Shows detailed payroll information, for a fiscal year, displayed by month, for a specific employee or SpeedType (sorted by employee).

m-FIN Cognos Query Studio