RF Financial Report F208

Description

Purpose

The Research Foundation (RF) Financial Report F208 is a standardized reporting form used to report expenditures for a specified period to the sponsor when required by award terms. The RF Financial Report F208 is used when a sponsor specific form is not available. The availability of this report in the Oracle application eliminates the need to produce this information manually.

This report creates an expenditure profile for an award based on the reporting period selected and displays cash applied.

Frequency

This report can be run as needed.

Responsibilities with Access

People with the ORG OGM Billing Specialist responsibility are able to generate this report.

Setting Report Parameters

The following table describes the required and optional parameters to use to run the report:

Parameters

Description
(click in the field to see the List of Values)

Required Parameters

Award Number

Enter the award number.

Starting Period (MON-YYYY)

Enter the starting period (month-year) for the report.

Ending Period (MON-YYYY)

Enter the ending period (month-year) for report.

 

Note: For all final reports, please use the current month-year.

Report Type

Enter the type of report that is being produced: Final, Interim, or Quarterly.

Optional Parameters

Customer Address

Enter the customer address if the address is different from the default.

Award Amount

Enter the amount if the current award amount is different from the default.

Auth. Transfer from Prev. Year

Enter any carry forward amount from the previous year.

Expenditure Prev. Report

Enter any previously reported amounts.

Comments

Enter any comments that may be necessary to display on report.

Name

Enter the name if the name of the person authorizing the report is different from the default for your location.

Title

Enter the title if the title is incorrect for the default value or if the person authorized has been changed in the Name parameter.

Understanding the Output

The following table describes the report output:

Column Heading

Description of Column

Report Date

The date the report was created

Sponsor

The name of the sponsor

RF Award No

The award number assigned to the expenditures for the report

Sponsor Address

This address that defaults from the bill to address listed on the award

 

Note: The default can be changed by providing an alternate address in the Customer Address parameter.

Sponsor ID#

If populated, the identification number entered in the award as the number assigned to the funds by the sponsoring agency

Report Type

A value that identifies the type of report that is being sent to the sponsor

 

Select Final, Interim, or Quarterly from the list of values.

Report Period From and To

The requested beginning and ending period for report data

 

Important: If the ending date selected for the report period is past the award end date, the award end date will display on the report. However, all expenditures for the requested reporting period will produce.

Title of Project

A value that defaults from the award Long Name field

Under the direction of

A value that defaults to the Principal Investigator (PI) that is active on the award

 

Note: If the PI was changed during the report period or it is necessary to list names of co-principal investigators, a note should be put into the Comments section on the parameter screen.

Award Period From and To

The start date and end date entered in the award

Award Authorized for Expenditures - Provides subtotal and total of award funds for current and previous award periods.

Award

Total amount of award for sponsor.

 

Defaults to total award budget from RF Oracle business application.

 

Note: This figure can be changed by entry in the Award Amount parameter. If the total award budget in the RF Oracle business application reflects the carry forward amount from the previous year in which an entry should be made to override the amount.

Authorized Transfer from Previous Year

If populated, the remaining funds from the previous year, which are allowed by the sponsor to be carried over to the current year budget (carry forward amount).

Total Award Authorized Expenditures

Total amount authorized by sponsor for expenditures. This includes the current year award amount and any carry forward amount from the previous year.

Note: This value is equal to the sum of the Award line and the Authorized Transfer from the Previous Year line.

Cash Reconciliation - Summarizes the cash position on the award.

Total Award Authorized for Expenditures

The total amount of the award budget

Less: Cash Received to Date

The total amount of the cash receipts applied to the award

Balance

The remaining balance due from the sponsor on the award

Unexpended Award Balance

The remaining funds available in the total award budget for expenditures

 

The difference between the authorized award amount (award budget) and the total expended amount.

Expenditures - Displays breakdown of expenditures by budget line item with a total of all expenditures and unexpended award balance.

Salary and Wages

The salary and wage expenditures for the report period

Employee Benefits

The fringe benefit expenditures for the report period

Consultant

The consultant (independent contractor) expenditures for the report period

Equipment

The equipment expenditures for the report period

Supplies

The supply expenditures for the report period

Travel Domestic

The domestic travel expenditures for the report period

Travel Foreign

The foreign travel expenditures for the report period

Tuition and Fees

The SUNY and non-SUNY tuition and fees expenditures for the report period

Fellowships & Part. Support

The fellowships and participants support expenditures for the report period

Subaward

The subaward expenditures for the report period

Conference & Training

The conference and training expenditures for the report period

General Services

The general service (recharges) expenditures for the report period

Postage

The postage expenditures for the report period

Miscellaneous

The expenditures charged to the miscellaneous category for the report period

Subtotal of Direct Costs

The subtotal of all direct cost expenditures

F&A Cost

Rate

The indirect (F&A) costs charged to the award

The indirect cost rate to apply to direct cost expenditures

Total

The total direct and indirect cost expenditures charged to the award for the selected report period

Expenditure Previously Reported

If populated, the total expenditures previously reported to sponsor

 

Note: This field is populated by entry in the Expenditure Prev. Report parameter.

Total Expenditures

The grand total of award expenditures for the current and prior reporting periods

Unexpended Award Balance

The remaining funds available in the total award budget for expenditures

 

The difference between the authorized award amount (award budget) and the total expended amount

Comments and Signature

Comments

If populated, the free-form comments entered in the Comments parameter.

Certification

The affirmation statement attesting that the report and expenditures are true and within the provisions of the grant or contract

Signature & Title

A value that defaults to name and title of the individual listed as the authorized signatory for that award location in the AR Invoice Signature and Title table

 

Note: These fields can be changed by entry in the Name and Title parameters.

Helpful Tips

Effective Date: 3/14/2007 8:41:48 AM