m-Fin PROJECT FINANCIAL STATUS

Area charts show expenditures as an area and budget as a line, cumulative over the life of the project. Area charts show expenditures as an area and budget as a line, cumulative over the life of the project.

 

Do you like m-Fin OPERATING SUMMARY?  Want something like it that is specifically for projects?  Try m-Fin PROJECT FINANCIAL STATUS, available now in Cognos QA. [10-Jan-2014 migrated to production.]  It's in the new folder Finance > Project Reports.   Here are some specifics about this new report.

The output

It's for projects only.  This report is not meant for programs and in fact will not run for them.

It consolidates subclass.  There is one page for each project regardless of how many subclass there are.

The negative available balance stop sign The negative available balance stop sign

 

It provides an AVAILABLE BALANCE SUMMARY.  This section is like the one in m-Fin OPERATING SUMMARY.  It shows a stop sign if available balance is negative.

It provides an optional ASSETS AND LIABILITIES section.  This section is like the one in m-Fin OPERATING SUMMARY except that the user controls whether it appears.

It provides a highly summarized EXPENDITURES section.  This section is similar to m-Fin EXPENDITURE TYPE SUMMARY. Instead of individual account codes, there is just one row each for salary, benefits, operating, travel, and F&A.

It provides an optional cumulative expenditures chart.  This chart depicts the accumulation of expenditures over time for the entire life of the project. If there is any activity booked in accounting periods that are after the period of the project end date this will be shown with a different, lighter color.

It provides an optional SAL, WAGES, AND BEN section.  This section shows the names of all people paid by the project.

It sorts the output pages by project end date.

The prompting

Use the PROJECT ID prompt to run one project at a time.  When you are ready to run your next project id you can key it in and hit enter without returning to the prompt page.  This is like m-Fin TRIAL BALANCE SUMMARY's single speedtype mode, but for project numbers instead.

To run for a PI you must select the PI name.  Click on it to make it white on blue. To run for a PI you must select the PI name. Click on it to make it white on blue.

Use the PROJECT PRINCIPAL NAME prompt to run all projects for a PI.  Enter the first four letters or so of the PI's last name and hit your enter key (or click the Search button if you are a devoted mouse enthusiast).  Select the desired PI from the search results.  Because this is a single-pick prompt, you simply select the PI name - there is no Insert button.

Use the AWARD CODE prompt to run all projects for one or more award codes.  Instead of keying in the entire award code string you can key in just part of it and select the appropriate search mode under the Options link.  If you want a space character to be used in your search string, enclose the string in double-quotes.  For example, to find all award codes that start with "1 R" enter this into the keywords box with the double-quotes. Because this is a multi-pick prompt you can run the report for several awards that go together, like when there is a slightly different award code for each year.

The prompts interact.  Examples:  If you use the PROJECT END DATE prompt to eliminate projects that ended a long time ago they are eliminated not only from the output, but also from the PI and AWARD CODE search prompt results.  If you select a PI name, the AWARD CODE prompt searches only that PI's projects.

Both of the chart offerings are area charts.  Area charts are like line charts, but the area under the line is colored in.  This helps the visual juxtaposition of expenditures against a budget line.  The classic chart comes with axis and legend labeling.  The micro chart does not.  It is the same information but takes up less space.

Comments

Kathy Illian
This is perfection. Thank you for also adding the current FY pay columns - for our department this is a truly one-stop shop report for projects. Thanks so much!!
Carl
A new version has been published to Cognos QA with org prompt, page sort prompt, and ar type prompt. Also, for clinical trials the cumulative expenditures area chart now has a cumulative cash received line. This functions much like the budget line does in the non-clinical trial projects, providing context for the cumulative expenditures. The micro version of this chart has been moved into the ASSETS AND LIABILITIES report section, and so is visible only when that section appears. The budget version of the micro chart remains in its same location, in the EXENDITURES report section.
Kathy Illian
Carl - it would be helpful to have the number of days left for the project budget end , more so than for the project.
Carl
Ok we are putting in an org prompt. I expect Org will be used for larger runs to pdf rather than for on-demand on-screen use of the report, so two other things need to come with it: a page sort prompt and an accounts receivable type prompt. This way we can get, say, all clinical trials for an org, sorted by PI.
Kathy Illian
LOVE LOVE LOVE this report! Thank you sooooo much. Wish list:): run by org. Thanks!

Add new comment