Financial Monitoring and Reports

Banner and Cognos

Self Service Banner (SSB), Banner ePrint reports, and Cognos are the tools in place to help you manage your research budget. Information on interpreting both SSB and ePrint can be found on the Banner Finance Help page via your MyNEU Services and Links tab.

Cognos is a business analytics tool that provides users with a single, self-service portal to access and produce reports, dashboards, and ad hoc queries. Data feeds from COEUS and Banner Finance overnight. Please visit the Cognos website to obtain additional information.

How do I get Banner access?

You may already have Banner access based on your position and role within your department. In the event that you do not have access to Banner Finance, you can request access through the Financial Planning, Strategy, and Analytics Office. The instructions and forms to request Banner Finance access can be found here.

Cognos: Commonly used reports:

This report shows a record of all current and historic research funds (fund type 28 and 29) which fall within your fund-org security, the associated inception-to-date (ITD) budget, and select fund and grant-level demographic information. There are no prompts for this report, as it always runs the data as of the current date.

This report shows the expenses for a research (fund type code of 28 or 29) grant or fund for a selected time period. There is both a summary page, which summarizes the expenses at a fund level and grant level, and a detail page, which shows the transactions roll up to the total expenses on the summary page. Various demographic data at both the fund and grant level are also included for reference.

This report shows the amount paid by employee for the funds which are included in your fund/org security (not limited to research funds), similar to the existing FIN0032 – Payroll Distribution Report (both Banner and Workday versions). In this report, Banner data (December 31, 2021 and earlier) and Workday data (January 1, 2022 and later) are combined into single output table.

This report (similar to the ePrint report FZRB090 Budget Statement – Inception to Date) shows the budget, expenses, commitments, and available balance for one grant through a selectable start date and end date. The data is categorized by account groupings (salaries and wages – temp/PT, salaries and wages – fully benefited, direct costs, and exclusions) for easy analysis, and is aggregated at both the grant and fund level. Select grant-level demographic data is also included for reference.

The report combines budget-to-actuals data (ITD budget, period actuals, ITD actuals, ITD commitments, and budget balance remaining) with select AR data (billed amount, unbilled amount, hold amount, open AR amount, and payments and transfers) by fund based on a selected fiscal year and period. Select grant-level and fund-level demographic information is also included for reference.

This report shows a summary of the invoices/AR booked in Banner for one or more selected grants and/or PIs. The billing and payment entries associated with the grant(s) are also shown on a separate tab. Select grant-level demographic data is also included for reference.

This report shows grant-level or fund-level AR summary including total expenditures, billed, unbilled, hold, and payments. Expense transaction detail by invoice and payment details are included in two additional tabs. Various demographic data at both the fund-level and grant-level are also included for reference.

ePrint: Commonly used reports:

A daily status report of your Fund from the start of the award through the prior business day. Report contains the current authorized budget (“Adjusted Budget”), actual expenditures, commitments, and available balance. Direct/Indirect cost totals, Principal Investigator name, Project Short Title, and budget/project start and end dates are also included.

A monthly status report of your Fund from the start of the award through the month selected. Reports are available after the monthly financial close and contain the same demographic information as the FZRBD90 Daily Budget Statement.

Includes a list of open commitments for personnel costs and purchase orders such as supplies, subcontracts, equipment, etc.

Includes all inception to date payroll disbursements for a given Fund. Please note, the report does not include associated Fringe Benefit costs.

Last Updated on December 16, 2022