3.8 Reporting

The Property Management Office (PMO) is responsible for authoring and filing the majority of financial and sponsor reports. They also ensure the reporting data is available for distributed users throughout campus.

Data for property reports is derived from various sources including Oracle financials (grants accounting, iProcurement, accounts payable, general ledger); Sunflower Assets (Web-based asset management system); PMO’s Material Tracking System (MTS) (a repository of data for government-owned material); and subcontractor reports.

In addition to the reports identified below, there is frequent need for additional reports.  Content and format is clarified between the PMO and the requesting organization.

Contact

Questions about this policy can be answered by:

Bachar, Ivonne M.

Director PMO

Property Management Office

(650) 723-9095

To report a broken link or send comments/suggestions about property management content, send email to:

pmo-dor-webmasters@lists.stanford.edu

1. Certificates of Completion (General)

In cases where a specific sponsor form is not stated, terms of an agreement may require a general certification of completion. In such cases, PMO prepares a final letter citing completion of a final reconciliation which confirms the following:

  • All accountable property has been disposed or transferred as authorized.
  • Accountable records have been adjusted and reflect zero balance.

Back to top

2. DOE Form 4300.3 – Semi Annual Summary Report of DOE-owned Plant and Capital Equipment

Data on this financial report reflects balances as of February 28 and August 31 of each year.  Reports are submitted to the cognizant property administrator, and are due not later than 45 days after the end of the reporting period and again at the completion of the contract.

Back to top

3. Grant or Contract Closure Report (Certificate of Completion)

A grant or contract closure report is the final property management report prepared for a sponsored project. They are primarily used for contracts, but may also be required by the sponsor on grants or other types of agreements. When sponsors require a specific format, it is defined in the terms and conditions of the agreement. In cases where no specific format or content is defined, PMO prepares a final letter certifying the completion of the agreement. In either instance, the intent of the report is to certify that all accountable property has been disposed or transferred as authorized and the associated property records have been adjusted to reflect a zero balance.

Back to top

4. IRS Form 8282 – Donee Information Return

This form has limited use by Stanford as it pertains to donated equipment. It is used, if required by the terms or type of equipment donation, to report information to the IRS about the disposition of certain charitable deduction property when the property was disposed of within 3 years of the donor having contributed the property to the university. When needed, PMO prepares the IRS 8282. It is completed in accordance with the Department of the Treasury, Internal Revenue Service instructions. The Director of PMO and the University Tax Director are authorized to sign these forms on behalf of the University; departmental personnel or faculty have not been delegated this authority.

Back to top

5. IRS Form 8283 – Non-Cash Charitable Contributions

The IRS form 8283 form is used to report information about non-cash charitable contributions made to Stanford University. Upon request from the donor, PMO prepares the IRS 8283 form for gifts of capital equipment. The forms are completed in accordance with IRS instructions. The Director of PMO and the University Tax Director are authorized to sign these forms on behalf of the University; departmental personnel or faculty have not been delegated this authority.

Back to top

6. Listing of Accountable Property (General)

Based on the terms and conditions of the sponsored agreement, a listing of all property acquired during the period of performance may be required at its conclusion. This may include property to which Stanford or the sponsor holds title, depending on the requirements of the agreement.

Data on these reports reflect balances in one of the following manners:

  • as of September 30
  • as stated in the agreement
  • the completion date of the agreement, whichever is first during the fiscal year being reported

Back to top

7. Loss, Damage or Destruction Report

This report is used to notify the sponsor or appropriate university personnel of an incident which resulted in the loss, damage, or destruction of property.

If the items affected are government-owned property accountable to a federal contract, a report of notification is submitted to the cognizant property administrator. It is prepared in accordance with FAR52.245-5 or as otherwise stated in the terms of the agreement.

If the items affected are government-owned property accountable to a federal grant, a report of notification is submitted to the cognizant property administrator. It is prepared in accordance with OMB Circular A-110 Section 34(f)4, or as otherwise stated in the terms of the agreement.

If the items are owned by Stanford University, the report is prepared in accordance with PMO policies.

In all cases, incidents of loss, damage, or destruction shall be investigated and documented. Department or project management staff will ensure adequate measures are taken to mitigate future similar occurrences.

Back to top

8. NASA 1018 – Report of Government–owned/Contractor-held Property

The NASA 1018 report is prepared for property accountable to NASA contracts, grants, or cooperative agreements in accordance with NASA FAR Supplement 1845.7101, as listed in the terms and conditions of each agreement. Additions, deletions, and changes of reporting categories, are based on transactions recorded in the property management system of record or as reported to Stanford by sub-recipients.

When applicable, submission is made using the NASA Electric Submission System (NESS). There are two primary schedules for submission: (1) Annual, for which the report data reflects balances as of September 30 and is submitted no later than October 15 or as otherwise directed by the cognizant administrative contracting officer or the sponsor; or (2) Quarterly, which would apply only in specific cases as cited in the accountable contract. The quarterly report is not applicable to grants or cooperative agreements. In both cases, negative reports are required.

If any changes to the data are discovered following submittal of the report, the cognizant administrative contracting officer or the sponsor are contacted to discuss the change (as appropriate) and reporting thereof.

Back to top

9. Physical Inventory Reports

The physical inventory process utilizes various reports. The majority of reports are interim data for purposes of facilitating the physical inventory process and subsequent reconciliation.

Final results for each inventory event are reported to the University department to which the property is accountable. They are provided within 30 days of the completion of the reconciliation period.

Final inventory results for property accountable to sponsored projects are reported within 30 days of after the completion of the reconciliation period, unless otherwise required either by the Office of Naval Research or the sponsor. Almost exclusively, reports of physical inventory for property accountable to federal contracts are reported on an award-by-award basis. The content and format of sponsor inventory reports is defined by terms and conditions of the sponsored project or as defined by the designated administrative contracting officer for the project.

Back to top

10. SF Form 1428 – Inventory Schedule “B”, Report of Excess Personal Property

This report provides a list of excess property on a contract-by-contract basis. By submitting the inventory schedules, Stanford is requesting disposition instructions for government-owned property from the cognizant property administrator or designee. Project personnel are responsible for identifying when government property is no longer needed by Stanford for use on the contract to which it is accountable, nor on any other sponsored project. Disposal instructions provided to PMO are communicated to the Department Property Administrator (DPA) who is responsible for ensuring they are acted upon in a timely manner. When they are completed, the property records are adjusted as needed.

Back to top

11. 533 Financial Management Report

This financial management report is required by NASA. It may be required quarterly, monthly, or both per the terms of the agreement. The 533 is used primarily as a budget forecasting tool and is not intended to be used as a property management report.

The Office of Sponsored Research informs the project management personnel when this report is required. It is the responsibility of the project management personnel to define the steps used in preparing this report for each contract and to submit the report(s) to the sponsor in a timely manner. Data for the report is derived from the Stanford University financial systems.

Back to top

12. Indirect Cost Negotiation Reports

PMO provides various property reports to the Cost and Management Analysis group with the Office of Research Financial Compliance and Services, for use in support of indirect cost negotiations for the university. Data for these reports may be derived from one or more of the data sources identified at the beginning of this chapter.

Back to top

13. Additional Property Management Reports

Other routine reports, not previously discussed, are used in the course of day to day property management at Stanford. They are used in an as-needed, often ad-hoc basis to meet the needs of conducting general property management related business.

The most utilized reports are contained primarily in the Oracle Business Intelligence-Enterprise Edition (OBIEE) reporting system, as well as in the ReportMart 3 platform. Below is a list of the reports in each reporting platform:

OBIEE DPA Reports:

  • FIN_PMO_286_DPA_Comprehensive_Report
  • FIN_PMO_288_DPA_Unmatched_Report
  • FIN_PMO_292_Equipment_Depreciation_Forecast_Report
  • FIN_PMO_294_Stanford Equipment Record
  • FIN_PMO_296_Award_Management_Report

ReportMart 3 Reports:

  • FIN_PMO_196_CEET (Capital Equipment Expenditure Transactions) Report
  • FIN_PMO_198_Fabrication_Exp Report
  • FIN_PMO_199_Non_Capital_Exp Report

For instructions in accessing OBIEE reports, refer to the OBIEE Tutorial in Section 5.1 of the Property Management Manual.  Instructions for ReportMart 3 reports can be found in the Help files that are affiliated with each report number listed. 

The Sunflower property management database also has a menu of various reports that are used for day to day property management functions.  Instructions for Sunflower reports can be found in the Sunflower User Guides: Reporting in Sunflower and Exporting Reports to Excel.

Back to top

Go to PM Chapter: