Report - RF 1099 Payment

Description

Purpose

The Research Foundation (RF) 1099 Payment report displays details of miscellaneous income payments to U.S. citizens and resident aliens who:

Were set up with a 1099-MISC type of independent contractor, royalty recipient, rent recipient and participant stipend recipient in the supplier file.
Have an invoice distribution over the threshold amount coded as 1099-MISC.

You may request four different sorts for this report, depending on the output you want:

Supplier Detail
Supplier Summary
Income Tax Type Detail
Income Tax Type Summary

Frequency

At the end of each calendar year, central office submits 1099-MISC information to the Internal Revenue Service (IRS) for each supplier set up with a 1099-MISC supplier type in the supplier file and whose invoice distribution over the threshold has the proper 1099-MISC code. To provide correct year-end reporting information, corrections and updates to the supplier set up may be required before year's end.

Setting Report Parameters

The RF 1099 Payment report can be sorted by supplier or income tax type, with output as a summary or detailed report. The following table describes the required and optional parameters needed to run the report:


Parameter	Description (click in the field to see the List of Values)
Required Parameters
Group By		The kind of report you want to run. Select Type to sort the records by income tax type or select Supplier to sort the records by 1099-MISC supplier.
Reporting Method		The amount of detail you want in the report. Select Detail or Summary.
Begin Payment Date		The start date of the report based on Payment Date, not Invoice Date.
End Payment Date		This defaults to the current date.
Tax Reporting Entity		This defaults to Research FDN of SUNY.
Optional Parameters
Income Tax Region		Select State from the List of Values.
Payer Name Source		Leave this field blank.

Understanding the Output

The RF 1099 Payment report is sorted by location if you selected Supplier in the Group By field, or by MISC code if you selected Type in the Group By field. Information about the supplier (i.e., the entity receiving miscellaneous income payments), including supplier and supplier site information, is stored in Oracle's supplier file. The following tables describe the output of each of the reports.

Supplier Detail and Summary Reports

Notes: Information that only appears on the detailed report is marked as such in the column heading.

Column Heading	Description of Column
Location:	The three-digit code and name of the operating location for which you are running the report.
Supplier Name:	The name of the business or person providing goods or services.
Reporting Name:	The name that will appear on the 1099. This field is obtained from the Tax reporting region of the supplier file.
Supplier Num:	The number assigned to the supplier.
Address	The address of the supplier site.
Tax Reporting Site:	The site name in the supplier file; this should be 1099.
Invoice Number (detail report only)	The accounts payable (AP) invoice number.
Invoice Date (detail report only)	The date on the invoice from the supplier.
Income Tax Type	The type of MISC income.
Invoice Amount (detail report only)	The total dollar amount invoiced by the supplier.
Taxable Payment Amount	The dollar amount of reportable (i.e., taxable) income to the supplier.
Related Payment Document Num (detail report only)	The name that will appear on the 1099. This field is obtained from the Tax reporting region of the supplier file. The document number of the payment made to the supplier. For Example: check number
Payment Date (detail report only)	The date payment was made to the supplier.
Award	The number of the award charged with the expenditure (i.e., payment to the supplier).
GL Class	This field is for central office use only.
Project	The number of the project charged with the expenditure (i.e., payment to the supplier).
Total for Tax Type (detail report only)	The total dollar amount reportable for a type of MISC income within a supplier.
Total for Supplier	The total dollar amount reportable for the supplier.

Income Tax Type Detail Report

Column Heading	Description of Column
Region:	This field is NOT used by the Research Foundation.
Region Code:	This field is NOT used by the Research Foundation.
Income Tax Type:	The type of MISC income.
Supplier Name:	The name of the business or person providing goods or services.
Reporting Name:	The name that will appear on the 1099. This field is obtained from the Tax reporting region of the supplier file.
Supplier Num:	The number assigned to the supplier.
Tax Reporting Site:	The site name in the supplier file; this should be 1099.
Invoice Number	The accounts payable (AP) invoice number.
Invoice Date	The date on the invoice from the supplier.
Invoice Amount	The total dollar amount invoiced by the supplier.
Distribution Total of Income Tax Type	The dollar amount of reportable (i.e., taxable) income to the supplier.
Payment Total of Income Tax Type	The dollar amount of reportable (i.e., taxable) income to the supplier.
Related Payment Document Number	The document number of the payment made to the supplier. For Example: check number
Payment Date	The date payment was made to the supplier.
Total for Supplier	The total dollar amount reportable for the supplier.
Total for Tax Type	The total dollar amount reportable for a type of MISC income within a supplier.

Income Tax Type Summary Report

Column Heading	Description of Column
Region	This field is NOT used by the Research Foundation.
Region Code	This field is NOT used by the Research Foundation.
Income Tax Type	The type of MISC income.
Distribution Total of Income Tax Type	The dollar amount of reportable (i.e., taxable) income to the supplier.
Payment Total of Income Tax Type	The dollar amount of reportable (i.e., taxable) income to the supplier.
Number of 1099 Suppliers	The number of 1099 suppliers for each MISC type.
Total for Region	The dollar amount of reportable (i.e., taxable) income.
Total (all Regions)	The dollar amount of reportable (i.e., taxable) income.
Total Number of unique 1099 suppliers:	The total number of 1099 suppliers that received payments over the threshold.

Helpful Tips

Operating locations should have a procedure in place for monitoring and reviewing Oracle input so that accurate data is maintained throughout the year. Although tax reporting is a corporate payroll responsibility, data is stored in the Accounts Payable (AP) business area of Oracle. Payments for miscellaneous income coded for 1099-MISC reporting must be monitored to ensure that the data is correct and that any necessary adjustments are made in a timely manner.
For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request window.

Effective Date: 4/3/2009 9:38:40 AM