Financial Reports

Base/Non-base Budget Report by Profit Center

[Download]  

Revised 11/19/2003 to correct a bug in the script that refreshes the available values in the School/Area list of choices. This report shows the current Base/Non-base budget and FYTD actuals by Cost Collector. Data is sorted by Profit Center and Admin Flag/Admin Flag type. It also shows the Budget vs FYTD actuals variance and the percent of budget used.

Maija Ahlquist

11/19/2003

Book Value Market Value Comparison

[Download]  

This report shows all Pool A endowment accounts and their current market values. This information is useful in donor relations and by departments for budget purposes. Departments can review unit changes as they occur, & with up-to-date unit balances, they can project expected income on the units for the next fiscal year.

04/12/1999

Closing Principal

[Download]  

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Gillian Emmons

06/15/1999

Funds Analysis

[Download]  

Revised 7/7/2004 to show Transfers correctly. Shows current pool units, beginning balance, gifts and other revenues, transfers, expenses, other charges, and ending balance by cost collector. Principal and expendable are shown in separate detail reports. Allows for selection by profit center and fiscal period and year. Includes internal orders and WBS in Fund range. A pivot tab shows the columns of the report in greater detail. For example, "expenses" can be broken down into salaries and wages, employee benefits, other direct expenses, indirect expenses, and drafts. This report was modified 6/1/2001 to exclude settlements, so that beginning balances will now match the SAP funds analysis report.

Gillian Emmons

10/14/2004

PC Volume

[Download]  

Shows the activity for a fiscal year-to-date for a profit center, by GL account or GL account group (the same as SAP cost element group). There are five columns in the report: Total fiscal year to date activity, research, funds (sponsored), funds (non sponsored), general operating, and other. This query has tabs showing different levels of summarization, from the highest (principal, revenues, and expenses) to the most detailed (by GL account). There is also a tab which shows the Cost Collectors which make up each column. A bar chart shows total expenses, revenues, and principal changes, by cost collector type (that is, research, funds sponsored, funds non sponsored, general operating, and other.

Gillian Emmons

06/15/1999

Academic Funds

[Download]

One part of four reports for instruction & unsponsored research.

10/13/1999

Academic General

[Download]

One part of four reports for instruction & unsponsored research.

10/13/1999

Administrative Budget Forecast Program Template

[Download]

NOTE: Modified 12/31/2002 to enable users to run the query at any time without having to download a new version each quarter. This query was developed by CAO in cooperation with the Budget Office. It is designed to provide Administrative Units with the details behind the templates provided in October, 2001 for use in forecasting revenues and expenses. Users can select their "Budget Authorization Group" (or BAG) and run this query to see the cost centers and balances used in the template already provided. Alternately, the user can select a subset of their cost centers, so as to develop information for the template by "program", or other meaningful subset of the cost collectors in the BAG. Cost Collectors beginning with 1710000, where carryforward budgets are recorded, are excluded from this query in the Limits.

12/31/2002

Department Heads, Lab and Center Directors

[Download]

One part of four reports for instruction & unsponsored research.

10/13/1999

Fund Descriptions

[Download]

NOTE: REPORT REVISED 4/19/2002: the original version did not return fund cost collectors that did not have a Fund Description; the revised template will return fund cost objects with and without Fund Descriptions. This report shows Principal and Expendable cumulative and FYTD amounts for invested funds. It includes Pool Units and a Description of the fund's purpose. There are two report tabs: (1) a pivot sorted by Funding Class Description, Pool Code and Cost Collector ID, and (2) a Detail report sorted by Fiscal Period and Pool Code.

Gillian Emmons

04/19/2002

Funds Available

[Download]

Shows cumulative expenses, cumulative revenues, and authorized totals by PI for a specific profit center or a group of profit centers. The definition of Funds Available is: the authorized total for all sponsored cost collectors, and cumulative revenues for non-sponsored cost collectors. "Funds Available" is calculated and compared to cumulative expenditures plus current commitments.

Gillian Emmons

01/25/2001

Funds Reporting

[Download]

***REVISED 8/11/2004 (reports re-formatted to fit on one page)***For a selected FY and DLC, this query groups FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month. There are five report tabs: a pivot and a detail report for funds controlled by the Department Head; the same two reports with Faculty Controlled funds also shown; the fifth report shows the admin flag, category code, pool code and supervisor for all cost collectors in the DLC.

Maija Ahlquist

08/11/2004

Invested Funds Report

[Download]

This is a new Invested Funds Report, replacing the original report which required manual updating of formulas for market value and projected earnings. This report shows principal, cumulative revenue & expenses, pool units, FYTD expenses, balances with and without commitments, projected market value and projected earnings. It also adjusts for the deflection on fellowship and scholarship cost collectors, which pay higher dividends. There is one detail report sorted by Pool Code and Funding Class Description. Report modified 6/1/2001 to exclude settlements, so that beginning balances will match the SAP funds analysis report.

Maija Ahlquist

06/01/2001

PC Volume by Cost Collector (GL 30)

[Download]

Displays the FYTD revenue and expenses for each individual cost collector in a profit center. This report includes subtotals for the following types of cost collectors: Balance Sheet, Cost Centers, Funds, Endowment, Other Invested, and WBS.

Robert Davine

06/02/1999

Summer Reclassification

[Download]

One part of four reports for instruction and unsponsored research.

10/13/1999

Closing Principal

[Download]  

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Gillian Emmons

06/15/1999

Quarterly Report Cost Center Budget Reconciliation

[Download]  

This query contains the logic the Budget Office uses to determine the position of a department in preparation for fiscal year end close: what amount can be carried forward (for an academic department) or what overruns must be funded, prior to the final close-out of the department's general and auxiliary cost centers. To calculate the department's position, it is assumed that RA and Research Telephone cost centers will be fully funded to the extent of the net expenses. Faculty Controlled (FC) cost center surpluses are deferred, to reflect the over- or under-expended position of the department.

06/11/2003

Final Research Expenses

[Download]

For a profit center or a profit center range, this query shows the fiscal year and cumulative activity for research projects (WBS Elements greater than 5000000). Settlement activity is excluded. Selection is for profit center and fiscal year. Closing periods are not shown because there is no activity on research accounts after period 12.

Gillian Emmons

06/15/1999

Fiscal Year Comparison of Research Expenditures

[Download]

***REVISED 11/19/2001*** This report shows a Department's Research Expenditures by Sponsor for a selected number of Fiscal Years (data is available from FY1997 forward).

Maija Ahlquist

11/19/2001

Fiscal Year Research Expenditures

[Download]

***REVISED 2/19/2002***This report shows a Department's Research Expenditures by Sponsor and GL Account for a selected Fiscal Year.

02/19/2002

Primary & Secondary Research Volume, All

[Download]

This version of the "classic Brown Book" fiscal year volume report for Departments will bring back authorized totals and unexpended balances for all cost collectors, whether or not they had fiscal year activity. It is a much longer report than the Primary & Secondary Research Volume, FY only report. There are several tabs including a Summary of primary and secondary volume, Master Data by Supervisor, Detail by Supervisor and Expense Type, Secondary Volume by Master Project Number, and On and Off Campus volume of Supervisor and Expense Type. NOTE: This report will ask you to select your department three times. If you report on only one department, the limit can be changed from variable to fixed after your initial selection. Also, the report can be run for only one Department at a time (secondary volume for one department is primary for another).

Maija Ahlquist

11/19/2001

Primary & Secondary Research Volume, FY only

[Download]

Modified 9/8/2005 at the request of CAO to bring back wbs elements with fiscal year activity OR master project not terminated.This version of the "classic Brown Book" fiscal year volume report for Departments will bring back fiscal year amounts, including authorized totals and unexpended balances, for those cost collections which had fiscal year activity. If you wish to see unexpended balances for cost collectors which had no fiscal year activity, you should use the Primary & Secondary Research Volume, All report. There are several tabs including a Summary of primary and secondary volume, Master Data by Supervisor, Detail by Supervisor and Expense Type, Secondary Volume by Master Project Number, and On and Off Campus volume of Supervisor and Expense Type. NOTE: This report will ask you to select your department three times. If you report on only one department, the limit can be changed from variable to fixed after your initial selection. Also, the report can be run for only one Department at a time (secondary volume for one department is primary for another).

Maija Ahlquist

09/08/2005

Research Expenditures by Sponsor

[Download]

Modified 9/8/2005 to update for a GL Account category name change.This is the classic Brown Book Section V report. This report can be run from fiscal year 1999 forward. It will not return accurate data for earlier fiscal years. There are two report tabs. One shows Master Data detail with FY amount, Authorized Total and Unexpended Balance for all cost collectors that had fiscal year activity. The other shows fiscal year activity by expense type (Salaries, EB, Operating, F&A), sorted by Sponsor, Agreement Type, and On/Off Campus.

Maija Ahlquist

09/08/2005

Research Expense by Sponsor & Agreement Type Curr

[Download]

This report is identical to the Research Expense by Sponsor & Agreement Type History but can be used for the current fiscal year. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Maija Ahlquist

10/12/2006

Research Expense by Sponsor & Agreement Type Hist

[Download]

REVISED 10/12/2006 to include reports by Primary Sponsor as well as Direct Sponsor This report is identical to the Research Expense by Sponsor & Agreement Type Current but should be used for closed fiscal years. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Maija Ahlquist

10/12/2006

Transaction Report for Closing Period 13

[Download]

This report is for all cost collectors in a Profit Center. It lists all transactions for closing periods 13, 14, 15, and 16. The results and detail report list document type, document number, fiscal period, cost collector and name, GL account and name, line item text, and actual amount.

Gillian Emmons

07/01/1999

PO Commitments

[Download]  

This is an excellent query to review the purchase orders created for your cost objects on a particular day, or to troubleshoot commitment inaccuracies caused by mismatches between quantities ordered and invoiced. This query shows purchase order quantities and dollar amounts, the related paid invoice quantities and dollar amounts, and the remaining committed open PO quantities and dollar amounts, by purchase order line item. The user can choose PO commitments by Cost Collector, Purchase Order date, or Supervisor. There is a detail report tab by purchase order number, and one by vendor.

05/30/2000

Commitment History

[Download]

Report showing historical commitments for a cost collector as of a user-specified date in the past. Criteria are Cost Collector Id and Calendar Date.

03/14/2000

Commitments by Cost Collector

[Download]

Lists all open commitments, including blanket orders, by Cost Collector.

09/24/1999

Commitments w/o Blanket Orders by Cost Collector

[Download]

Lists all open commitments by Cost Collector. Does not include blanket orders.

09/24/1999

Cost Collector Balances

[Download]

For a Profit Center, reports on balances for all cost collectors. Two detail tabs are used; one sorts by supervisor (Supervisor Report), the other sorts by Cost Collector Type (Cost Center, Internal Order, and WBS Element/Project).

04/02/2001

Cost Collectors

[Download]

Selects and displays information for individual cost collectors. Each cost collector's information appears on one screen.

Robert Davine

03/24/1999

Cost Collectors by Parent

[Download]

Selects and displays parent account and all children accounts, both open and closed.

Robert Davine

03/24/1999

Cost Collectors by Profit Center

[Download]

Selects and displays all open cost collectors for entire profit centers. Includes two sort orders: by cost collector type and cost collector ID and by Supervisor, cost collector type and cost collector ID. Also contains a section specifically for downloading and exporting to another application.

Robert Davine

07/19/1999

Cost Collectors by Supervisor

[Download]

Selects and displays open cost collectors by supervisor.

Robert Davine

03/24/1999

Cardholder Information

[Download]

This report gives information about credit card holders in your department, including monthly and transactional spending limits and contact information for cardholders and verifiers.

09/01/2000

Procurement Card Spend Analysis

[Download]

Several reports showing Procurement Card spending by Merchant, Cost Object, Cardholder, Verifier.

04/26/2007

Swept Credit Card Charges by Profit Center

[Download]

REVISED 4/26/2007 to add several new reports. Report to review Swept Credit Card Charges, including nine reports by cardholder, cost object, Profit Center, Vendor, and a report showing posted vs. swept charges.

04/26/2007

Base/Non-base Budget Report by Profit Center

[Download]  

Revised 11/19/2003 to correct a bug in the script that refreshes the available values in the School/Area list of choices. This report shows the current Base/Non-base budget and FYTD actuals by Cost Collector. Data is sorted by Profit Center and Admin Flag/Admin Flag type. It also shows the Budget vs FYTD actuals variance and the percent of budget used.

Maija Ahlquist

11/19/2003

Book Value Market Value Comparison

[Download]  

This report shows all Pool A endowment accounts and their current market values. This information is useful in donor relations and by departments for budget purposes. Departments can review unit changes as they occur, & with up-to-date unit balances, they can project expected income on the units for the next fiscal year.

04/12/1999

Closing Principal

[Download]  

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Gillian Emmons

06/15/1999

Cost Object Changes

[Download]  

Two views of cost object changes with an easy to use EIS interface. (1) Displays changes on an individual cost object over the life of the cost object. Fields available are: Authorized Total, Supervisor, Addressee,Term Code, Start-End Dates, Costing Sheet, Key, Profit Center and Expiration Date. (2) Displays changes to DLC cost objects over a specified time period. Fields available are: Costing Sheet, Key, Authorized Total, Term Code, and Term Dates.

Robert Davine

05/03/2004

Funds Analysis

[Download]  

Revised 7/7/2004 to show Transfers correctly. Shows current pool units, beginning balance, gifts and other revenues, transfers, expenses, other charges, and ending balance by cost collector. Principal and expendable are shown in separate detail reports. Allows for selection by profit center and fiscal period and year. Includes internal orders and WBS in Fund range. A pivot tab shows the columns of the report in greater detail. For example, "expenses" can be broken down into salaries and wages, employee benefits, other direct expenses, indirect expenses, and drafts. This report was modified 6/1/2001 to exclude settlements, so that beginning balances will now match the SAP funds analysis report.

Gillian Emmons

10/14/2004

Master Data Changes for a Cost Object

[Download]  

For a selected cost object (WBS, Cost Center or Order), shows selected master data values at the end of each month from the inception of the cost object. Master data fields shown are: Supervisor, Addressee, start date, end date, term code, and (WBS) authorized total (in the first pivot report); and costing sheet, F&A key, EB key, lab allocation key, and (WBS) authorized total (in the second pivot). This query can be used to monitor cost object changes as an alternative to receiving 001 forms ("Notice of Cost Object Change") by e-mail.

Robert Davine

02/13/2004

PC Volume

[Download]  

Shows the activity for a fiscal year-to-date for a profit center, by GL account or GL account group (the same as SAP cost element group). There are five columns in the report: Total fiscal year to date activity, research, funds (sponsored), funds (non sponsored), general operating, and other. This query has tabs showing different levels of summarization, from the highest (principal, revenues, and expenses) to the most detailed (by GL account). There is also a tab which shows the Cost Collectors which make up each column. A bar chart shows total expenses, revenues, and principal changes, by cost collector type (that is, research, funds sponsored, funds non sponsored, general operating, and other.

Gillian Emmons

06/15/1999

Administrative Budget Forecast Program Template

[Download]

NOTE: Modified 12/31/2002 to enable users to run the query at any time without having to download a new version each quarter. This query was developed by CAO in cooperation with the Budget Office. It is designed to provide Administrative Units with the details behind the templates provided in October, 2001 for use in forecasting revenues and expenses. Users can select their "Budget Authorization Group" (or BAG) and run this query to see the cost centers and balances used in the template already provided. Alternately, the user can select a subset of their cost centers, so as to develop information for the template by "program", or other meaningful subset of the cost collectors in the BAG. Cost Collectors beginning with 1710000, where carryforward budgets are recorded, are excluded from this query in the Limits.

12/31/2002

All Funds Statement

[Download]

Modified 7/22/2009 to change the label above the step 4 dropdown box to clarify that a department (which may be one or more profit centers) is being chosen. Compares Revenue and Expense by Cost Object Category for a specified fiscal period and the corresponding fiscal period of the previous fiscal year. A summary dashboard shows changes to Revenue and Expense, Pool A Book Value Market Value, MTDC amounts, organized research proposals, and FTE headcount by cost obejct category. There are also standalone reports for each of the above.

Maija Ahlquist

07/22/2009

Cost Collector Balances

[Download]

For a Profit Center, reports on balances for all cost collectors. Two detail tabs are used; one sorts by supervisor (Supervisor Report), the other sorts by Cost Collector Type (Cost Center, Internal Order, and WBS Element/Project).

04/02/2001

Cost Collector Expenses and Final Balance

[Download]

For a profit center or a profit center range, this query returns the period 12 balance for each cost collector, the activity in each of the closing periods (13, 14, 15, and 16), and the final balance in that cost collector. Settlement activity is excluded. This query does not include research cost collectors. For Fund Accounts in Pool A, only expendable balances are shown. The final fiscal year totals and the final cumulative totals are shown in separate detail reports.

Gillian Emmons

06/15/1999

Cost Collectors by Profit Center

[Download]

Selects and displays all open cost collectors for entire profit centers. Includes two sort orders: by cost collector type and cost collector ID and by Supervisor, cost collector type and cost collector ID. Also contains a section specifically for downloading and exporting to another application.

Robert Davine

07/19/1999

Cost Sharing Change Form

[Download]

Revised 12/21/05. For a selected master project number, produces a form for DLC administrator to enter changes to the cost sharing plan for submission to and entry by OSP into Coeus.

12/21/2005

Cost Sharing Commitments by DLC

[Download]

Revised 12/21/2005 By master project number, displays all of a DLC's cost sharing commitments made as a condition of the award.

12/21/2005

DACCA Checklist Report

[Download]

Displays a list of DACCAs for a fiscal year for a DLC. It can be used to determine which months should have DACCAs so that a DLC knows whether it has verified a complete set for the auditors. It has three views: by month; by supervisor and cost object; by supervisor and GL account.

Robert Davine

11/14/2003

Department Head Role Cost Objects

[Download]

NOTE: Do not use this query if you do not hold the Department Head reporting role, normally given only to AOs (FOs with additional approval); you will not receive the correct data. For Admin Flag FC, this query finds all supervisors linked to a specified DLC by at least one cost object, and finds all cost objects supervised by those supervisors.

Maija Ahlquist

04/23/2008

Department Head Role Cost Objects with Totals

[Download]

NOTE: Do not use this query if you do not hold the Department Head reporting role, normally given only to AOs (FOs with additional approval); you will not receive the correct data. For Admin Flag FC and a specified fiscal period, this query finds all supervisors linked to a specified DLC by at least one cost object, and finds all cost objects supervised by those supervisors. There is one report sorted by Supervisor and Profit Center, showing Available Total, Current Month, FYTD, and Cumulative Expenses, and Unexpended Balance for each Cost Object.

Maija Ahlquist

04/23/2008

Fund Balances for Department Administrators

[Download]

This report shows to fiscal year to date activity and budget in all cost centers (general), and the fund balances, fiscal year to date activity, and budget for all sponsored and non-sponsored funds for Departments. The "Administrative Flag" is also shown -- a new field which describes whether the cost object us under the control of the department.

Gillian Emmons

10/02/2000

Fund Descriptions

[Download]

NOTE: REPORT REVISED 4/19/2002: the original version did not return fund cost collectors that did not have a Fund Description; the revised template will return fund cost objects with and without Fund Descriptions. This report shows Principal and Expendable cumulative and FYTD amounts for invested funds. It includes Pool Units and a Description of the fund's purpose. There are two report tabs: (1) a pivot sorted by Funding Class Description, Pool Code and Cost Collector ID, and (2) a Detail report sorted by Fiscal Period and Pool Code.

Gillian Emmons

04/19/2002

Fund Descriptions and Restrictions

[Download]

For invested funds, shows Pool Code, Pool Units, Treasurer's Report code, Fund Description, Fund Restriction and cumulative and FYTD amounts. One report sorted by Funding Class Description and three pivots, Fund Description, Fund Restriction, Fund Master Data.

Gillian Emmons

01/31/2007

Funds Available

[Download]

Shows cumulative expenses, cumulative revenues, and authorized totals by PI for a specific profit center or a group of profit centers. The definition of Funds Available is: the authorized total for all sponsored cost collectors, and cumulative revenues for non-sponsored cost collectors. "Funds Available" is calculated and compared to cumulative expenditures plus current commitments.

Gillian Emmons

01/25/2001

Funds Reporting

[Download]

***REVISED 8/11/2004 (reports re-formatted to fit on one page)***For a selected FY and DLC, this query groups FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month. There are five report tabs: a pivot and a detail report for funds controlled by the Department Head; the same two reports with Faculty Controlled funds also shown; the fifth report shows the admin flag, category code, pool code and supervisor for all cost collectors in the DLC.

Maija Ahlquist

08/11/2004

Funds Reporting Detail, Funds

[Download]

For a selected FY and DLC, this query displays by cost collector the Funds FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month.

12/18/2003

Funds Reporting Detail, Pool A

[Download]

For a selected FY and DLC, this query displays by cost collector the Pool A FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month.

12/18/2003

Funds Reporting Detail,General

[Download]

For a selected FY and DLC, this query displays by cost collector the General FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month.

12/18/2003

Invested Funds Report

[Download]

This is a new Invested Funds Report, replacing the original report which required manual updating of formulas for market value and projected earnings. This report shows principal, cumulative revenue & expenses, pool units, FYTD expenses, balances with and without commitments, projected market value and projected earnings. It also adjusts for the deflection on fellowship and scholarship cost collectors, which pay higher dividends. There is one detail report sorted by Pool Code and Funding Class Description. Report modified 6/1/2001 to exclude settlements, so that beginning balances will match the SAP funds analysis report.

Maija Ahlquist

06/01/2001

Non-Invested Funds

[Download]

For a profit center or a profit center range, this report shows cost collectors in the fund range, subtotaled by Internal Orders and WBS Elements. Items shown are budget/funds available, FYTD expenses, cumulative expenses, and unexpended balance.

06/15/1999

OBFP Position Roster for FY Budgeting

[Download]

REVISED 3/3/2006. Users should download and use this new version. This report helps you to obtain the SAP Postion Data that allows you to complete the Position Roster that will become the baseline salary budget for the new fiscal year. Please contact your Budget Officer for further information.

03/03/2006

Overrun

[Download]

NOTE: REVISED 3/29/2002 to clarify that overrun with commitments amounts are calculated on non-blanket order commitments. For a profit center or profit center range, this report shows overrun cost collectors and identifies the overrun amount and overrun amount including non-blanket order commitments. Overrun amounts are calculated nightly in the warehouse, and both overrun amount and overrun with non-blanket order commitment amount are loaded with EB, allocation and overhead costs. The report has two views: by supervisor and by cost collector type.

03/29/2002

Research F&A Changes in Master Data

[Download]

For a DLC or DLCs, shows changes in F&A-related Master Data for Projects (Costing Sheet Procedure, Lab Allocation, EB, F&A) from one calendar period to another. There are two report tabs, both sorted by DLC and Project WBS. One report shows all changes between the two calendar periods specified, the other shows Rate History. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

07/13/2004

Research F&A Underrecovery - Coeus IDC Info

[Download]

**NEW VERSION 8/3/2009 to adjust for fiscal year.** For a DLC, displays Coeus IDC data for all research WBS elements that may incur F&A U/R (excluding training grants and Federal "Fixed Rate" competitive segments). This report will assist administrators in determining the source of funding for F&A U/R. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

08/03/2009

Research F&A Underrecovery Cost Center

[Download]

For a DLC's U/R Cost Center, the FYTD DTR entries are sorted and subtotaled by WBS. This report will assist administrators in determining the F&A U/R amount to be funded. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

09/29/2000

Research F&A Underrecovery JV

[Download]

For a selected month, the DW JV template will produce a partially completed JV to be downloaded, reviewed for accuracy, completed, and uploaded to SAP by the DLC administrator. The JV template includes entries to clear the U/R cost center's current month postings to cost elements 600316 (Adj F&A On to Spon Base/Rate) and 600317 (Adj F&A Off to Spon Base/Rate). Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for instructions on use of DW JV template.

Maija Ahlquist

08/08/2000

Statement by Profit Center

[Download]

For a Profit Center or group of Profit Centers, this report shows the Total Institute Budget, Amount, FYTD Amount, and Cumulative Amount by expense type and Cost Collector for any given month.

Robert Davine

06/02/1999

Transaction Report for Closing Period 13

[Download]

This report is for all cost collectors in a Profit Center. It lists all transactions for closing periods 13, 14, 15, and 16. The results and detail report list document type, document number, fiscal period, cost collector and name, GL account and name, line item text, and actual amount.

Gillian Emmons

07/01/1999

Balance Sheet Account DTR

[Download]  

For a GL Account or group of GL Accounts, this report shows the actual amount spent sorted by GL Account for any given fiscal period.

Mary-Ann Donofrio

05/22/2000

Detail Transaction (DTR)

[Download]

For a cost collector or group of cost collectors, this report shows the actual amount spent sorted by GL Account for any given month. It includes: Pivot Report: Actual Amount by GL Account; Detail Report: Document Date, Document Number, Purchase Order Number, Reference Document Number, Description; Document Type, Vendor and Actual Amount sorted by GL Account.

Robert Davine

06/02/1999

GL Account List

[Download]

This report has three tabs, listing all GL Account numbers in Profit Center Volume Report category order, Numerical Order, and Alphabetical order.

Gillian Emmons

09/01/2000

Monthly Actuals

[Download]

Report for a single cost collector which displays FYTD Actuals by GL Account in a month-by-month format.

12/16/1999

Statement by Cost Collector

[Download]

For a cost collector or group of cost collectors, this report shows the Total Institute Budget, Amount, FYTD Amount, and Cumulative Amount by expense type for any given month.

Robert Davine

06/02/1999

Statement by Profit Center

[Download]

For a Profit Center or group of Profit Centers, this report shows the Total Institute Budget, Amount, FYTD Amount, and Cumulative Amount by expense type and Cost Collector for any given month.

Robert Davine

06/02/1999

Summary Statement

[Download]

This Summary Statement is designed to let a user retrieve monthly statement information by cost collector for any fiscal period, current or historical. For WBS elements, it will bring back the correct authorized total and correct commitments for the fiscal period requested. If processed for a current unclosed period, it will show calculated costing sheet rates (EB and F&A costs) on commitments. There are two report tabs, one with and one without blanket order commitments. The report with blanket order commitments shows fiscal year blanket order commitments for cost centers; total blanket order commitments are shown for all other cost collector types.

Maija Ahlquist

11/01/2000

Financial Processing Status

[Download]

Report showing the process status (complete or not complete) of payroll, facilities, costing sheets and monthly settlements for any calendar period.

09/02/1999

PO Commitments

[Download]  

This is an excellent query to review the purchase orders created for your cost objects on a particular day, or to troubleshoot commitment inaccuracies caused by mismatches between quantities ordered and invoiced. This query shows purchase order quantities and dollar amounts, the related paid invoice quantities and dollar amounts, and the remaining committed open PO quantities and dollar amounts, by purchase order line item. The user can choose PO commitments by Cost Collector, Purchase Order date, or Supervisor. There is a detail report tab by purchase order number, and one by vendor.

05/30/2000

Department Analysis of Spending

[Download]

An easy to use dashboard with multiple reports enabling analysis of DLC spending by Vendor, GL Account, Partner / non-Partner,ProCard and ProCard Merchant.

Maija Ahlquist

04/25/2007

Procurement Status and History

[Download]

For a cost collector, displays purchasing detail, commitment amounts, and invoice amounts for open purchase orders by GL account.

09/28/1999

Vendor

[Download]

Lists vendors and includes the address, telephone, and fax information for each vendor.

05/01/1999

Master Data Changes for a Cost Object

[Download]  

For a selected cost object (WBS, Cost Center or Order), shows selected master data values at the end of each month from the inception of the cost object. Master data fields shown are: Supervisor, Addressee, start date, end date, term code, and (WBS) authorized total (in the first pivot report); and costing sheet, F&A key, EB key, lab allocation key, and (WBS) authorized total (in the second pivot). This query can be used to monitor cost object changes as an alternative to receiving 001 forms ("Notice of Cost Object Change") by e-mail.

Robert Davine

02/13/2004

Cost Collectors by Supervisor

[Download]

Selects and displays open cost collectors by supervisor.

Robert Davine

03/24/1999

Current and Pending Support

[Download]

Modified 9/11/2009 to add a flag for ARRA support. Current and Pending Support information from Coeus. User may report by Profit Center and/or by Investigator. Four pivot reports, Active support by Type (Organized Research, Pre- or Post-doctoral support, other), Active Support by PI, Pending support by Type, Pending support by PI, and one detailed Current and Pending Support by PI. NOTE: This document contains three queries, one for Current Support, one for Pending Support, and one to Combine the two. Use the "Process All" command to retrieve all data. The Current and Pending Support queries may also be processed separately.

Maija Ahlquist

09/11/2009

Detail Transaction (DTR)

[Download]

For a cost collector or group of cost collectors, this report shows the actual amount spent sorted by GL Account for any given month. It includes: Pivot Report: Actual Amount by GL Account; Detail Report: Document Date, Document Number, Purchase Order Number, Reference Document Number, Description; Document Type, Vendor and Actual Amount sorted by GL Account.

Robert Davine

06/02/1999

Final Research Expenses

[Download]

For a profit center or a profit center range, this query shows the fiscal year and cumulative activity for research projects (WBS Elements greater than 5000000). Settlement activity is excluded. Selection is for profit center and fiscal year. Closing periods are not shown because there is no activity on research accounts after period 12.

Gillian Emmons

06/15/1999

Fiscal Year Comparison of Research Expenditures

[Download]

***REVISED 11/19/2001*** This report shows a Department's Research Expenditures by Sponsor for a selected number of Fiscal Years (data is available from FY1997 forward).

Maija Ahlquist

11/19/2001

Fiscal Year Research Expenditures

[Download]

***REVISED 2/19/2002***This report shows a Department's Research Expenditures by Sponsor and GL Account for a selected Fiscal Year.

02/19/2002

Master Project Report

[Download]

For a Profit Center, displays a summary report for open Master Projects. Lower level WBS Elements (aka "children") are displayed under the master project and balance information is computed for each WBS Element as well as for the total project.

07/29/1999

Overrun

[Download]

NOTE: REVISED 3/29/2002 to clarify that overrun with commitments amounts are calculated on non-blanket order commitments. For a profit center or profit center range, this report shows overrun cost collectors and identifies the overrun amount and overrun amount including non-blanket order commitments. Overrun amounts are calculated nightly in the warehouse, and both overrun amount and overrun with non-blanket order commitment amount are loaded with EB, allocation and overhead costs. The report has two views: by supervisor and by cost collector type.

03/29/2002

Primary & Secondary Research Volume, All

[Download]

This version of the "classic Brown Book" fiscal year volume report for Departments will bring back authorized totals and unexpended balances for all cost collectors, whether or not they had fiscal year activity. It is a much longer report than the Primary & Secondary Research Volume, FY only report. There are several tabs including a Summary of primary and secondary volume, Master Data by Supervisor, Detail by Supervisor and Expense Type, Secondary Volume by Master Project Number, and On and Off Campus volume of Supervisor and Expense Type. NOTE: This report will ask you to select your department three times. If you report on only one department, the limit can be changed from variable to fixed after your initial selection. Also, the report can be run for only one Department at a time (secondary volume for one department is primary for another).

Maija Ahlquist

11/19/2001

Primary & Secondary Research Volume, FY only

[Download]

Modified 9/8/2005 at the request of CAO to bring back wbs elements with fiscal year activity OR master project not terminated.This version of the "classic Brown Book" fiscal year volume report for Departments will bring back fiscal year amounts, including authorized totals and unexpended balances, for those cost collections which had fiscal year activity. If you wish to see unexpended balances for cost collectors which had no fiscal year activity, you should use the Primary & Secondary Research Volume, All report. There are several tabs including a Summary of primary and secondary volume, Master Data by Supervisor, Detail by Supervisor and Expense Type, Secondary Volume by Master Project Number, and On and Off Campus volume of Supervisor and Expense Type. NOTE: This report will ask you to select your department three times. If you report on only one department, the limit can be changed from variable to fixed after your initial selection. Also, the report can be run for only one Department at a time (secondary volume for one department is primary for another).

Maija Ahlquist

09/08/2005

Proposal to Award Statistics

[Download]

Modified 9/11/2009 to add a flag for ARRA support to the query. Provides statistics, by Profit Center, on the number of sponsored research proposals submitted and awarded. Several reports showing both summary and detail information by PI, Sponsor, or Type (Organized Research, Predoctoral Fellowship, Postdoctoral Fellowship, Instruction & Department Research, and Other).

Maija Ahlquist

09/11/2009

Research Expenditures by Sponsor

[Download]

Modified 9/8/2005 to update for a GL Account category name change.This is the classic Brown Book Section V report. This report can be run from fiscal year 1999 forward. It will not return accurate data for earlier fiscal years. There are two report tabs. One shows Master Data detail with FY amount, Authorized Total and Unexpended Balance for all cost collectors that had fiscal year activity. The other shows fiscal year activity by expense type (Salaries, EB, Operating, F&A), sorted by Sponsor, Agreement Type, and On/Off Campus.

Maija Ahlquist

09/08/2005

Research Expense by Sponsor & Agreement Type Curr

[Download]

This report is identical to the Research Expense by Sponsor & Agreement Type History but can be used for the current fiscal year. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Maija Ahlquist

10/12/2006

Research Expense by Sponsor & Agreement Type Hist

[Download]

REVISED 10/12/2006 to include reports by Primary Sponsor as well as Direct Sponsor This report is identical to the Research Expense by Sponsor & Agreement Type Current but should be used for closed fiscal years. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Maija Ahlquist

10/12/2006

Research F&A Changes in Master Data

[Download]

For a DLC or DLCs, shows changes in F&A-related Master Data for Projects (Costing Sheet Procedure, Lab Allocation, EB, F&A) from one calendar period to another. There are two report tabs, both sorted by DLC and Project WBS. One report shows all changes between the two calendar periods specified, the other shows Rate History. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

07/13/2004

Research F&A Underrecovery - Coeus IDC Info

[Download]

**NEW VERSION 8/3/2009 to adjust for fiscal year.** For a DLC, displays Coeus IDC data for all research WBS elements that may incur F&A U/R (excluding training grants and Federal "Fixed Rate" competitive segments). This report will assist administrators in determining the source of funding for F&A U/R. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

08/03/2009

Research F&A Underrecovery Cost Center

[Download]

For a DLC's U/R Cost Center, the FYTD DTR entries are sorted and subtotaled by WBS. This report will assist administrators in determining the F&A U/R amount to be funded. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Maija Ahlquist

09/29/2000

Research F&A Underrecovery JV

[Download]

For a selected month, the DW JV template will produce a partially completed JV to be downloaded, reviewed for accuracy, completed, and uploaded to SAP by the DLC administrator. The JV template includes entries to clear the U/R cost center's current month postings to cost elements 600316 (Adj F&A On to Spon Base/Rate) and 600317 (Adj F&A Off to Spon Base/Rate). Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for instructions on use of DW JV template.

Maija Ahlquist

08/08/2000

Research Volume FYTD Report

[Download]

For a profit center or a profit center range, this report shows FYTD volume, cumulative expenses, and unexpended balance for all WBS elements. Limiting criteria are Profit Center, type of research project (Research, fund-sponsored or other) and fiscal period. Includes three reports, sorted by supervisor; supervisor and sponsor; and sponsor and supervisor; and a summary pivot report.

12/02/1999

WBS Elements That Expire Within 120 Days

[Download]

Shows the available total, expenditures to date, total commitment amount, and available balance for WBS Elements that have an expiration date of less than 120 days from the present.

07/13/1999

WBS Elements That Expire Within 30 Days

[Download]

Shows the available total, expenditures to date, total commitment amount, and available balance for WBS Elements that have an expiration date of less than 30 days from the present.

03/23/2000

WBS Hierarchy

[Download]

Displays FYTD and Cumulative activity for a multi-level WBS Hierarchy project. There are several detail reports, which summarize activity by levels 2, 3, 4 and 5, and also a pivot report which outlines the WBS Hierarchy structure for that project.

09/23/1999

Call Amount Report

[Download]  

An audit/control report that lets the user select the criterion (calls costing more than $25 etc) to view certain types of itemized calls.

08/28/2003

Call Length Report

[Download]  

An audit/control report that lets the user select the criterion (calls lasting more than 20 minutes, etc) to view certain types of itemized calls.

08/28/2003

Financial Review & Control Procedures Reporting

[Download]  

*NEW VERSION 12/3/2008* Updated to reflect changes in telephone billing.

* NEW VERSION 11/14/2003* Report for review and control procedures. Allows user to review and report, from one screen, on a variety of transactions (credit card, payroll exceptions, purchase orders, revenue, and others) by profit center, supervisor, or individual cost collector for a chosen fiscal period.

NOTE: The BrioQuery 6.6 version of this document combines BOTH the Financial Review and Control Procedures Report template and the Signoff Form. Revised 11/14/2003 to include all Partner Vendors when the Partner Vendor button is selected, and to include all document types when "All Transactions" is selected.

Robert Davine

12/03/2008

Call Amount Report

[Download]  

An audit/control report that lets the user select the criterion (calls costing more than $25 etc) to view certain types of itemized calls.

08/28/2003

Call Length Report

[Download]  

An audit/control report that lets the user select the criterion (calls lasting more than 20 minutes, etc) to view certain types of itemized calls.

08/28/2003

Extension Lookup

[Download]  

A report to look up activity on one five digit MIT extension.

08/28/2003

Research Telephone Charges by Supervisor

[Download]  

Shows itemized call charges by supervisor for WBS Elements. Also 2 more detail pages in more summarized form for a department level administrator.

08/28/2003

Telephone Charges by Extension

[Download]  

For a profit center, summarizes charges for each MIT extension by charge category & subcategory. Includes a detail section listing itemized charges by extension for distribution & reimbursement purposes. Also lists cost collector ID charged.

08/28/2003

Telephone DTR

[Download]  

Telephone detail transaction report for a profit center, sorted by cost collector. Two detail section, one for printing, one for on-screen viewing.

08/28/2003

Telephone DTR by Cost Collector

[Download]  

Telephone detail transaction report for a cost collector. Two detail sections: one for printing, one for on-screen viewing.

08/28/2003

Cost Collector Assignment

[Download]

Gives default cost collector assignments for a profit center; showing how telephone charges should be applied.

08/28/2003

Itemized Telephone Charges - International

[Download]

For a profit center, report showing itemized call charges to international locations. Full detail on calls is included, including time and date of call. This report includes countries not flagged by the International call flag in the Telephone Detail table (those countries like Canada whose country code startes with "1+").

08/28/2003

Visitor Parking Central

[Download]

Intended for use by Facilities and the Parking Office. Contains two queries. Thie first is built on a Visitor Parking Detail star and is intended to provide visitor parking statistics, with three pivot reports, one sorted by department, one sorted by date, status, and parking lot, and one sorted by parking lot and date. The second is built on a Financial Detail star and provides the detailed information about visitor parking charges on monthly statements, sorted by closed and open items. Users may process either query separately or use the "Process All" command to process both.

Maija Ahlquist

09/04/2007

Visitor Parking DLC

[Download]

Intended for use by DLC Financial Administrators. Similar to the Visitor Parking report for the central Parking Office but omits the reports sorted by Department and Parking Lot. Contains two queries. Thie first is built on a Visitor Parking Detail star and is intended to provide visitor parking statistics, with a pivot report sorted by date, status, and parking lot including visitor name and the name of the department contact. The second is built on a Financial Detail star and provides the detailed information about visitor parking charges on monthly statements, sorted by closed and open items. Users may process either query separately or use the "Process All" command to process both.

Maija Ahlquist

09/04/2007