1099 Audit Report

The 1099 Audit Report shows any issues with the 1099 data that was created. The 1099 Audit Reports is intended to be used year-round to monitor 1099 vendors and transactions. If this report is run throughout the year, the changes necessary can be made when they are discovered rather than performing this task at year-end processing time.

To access the page, go to Financial Management > Year-End Processing > Vendor 1099 Processing and click the 1099 Audit Report icon.

Follow the steps below to create a 1099 Audit Report:

  1. Select the From Invoice Payment Date. This date is required. The first day of the current tax year is the default value.
  2. Select the To Invoice Payment Date. This date is required. The last day of the current tax year is the default value.
  3. Select the Report Includes value. This determines which type of audit report will be produced. The options are:
    • 1099 Vendors with Non-1099 Transactions Closed– This report shows any transactions that were entered as non-1099 transactions, but are associated with 1099 vendors. These are any transactions where a user cleared the 1099 Type and 1099 Box fields on the Invoice Entry screen. This also includes any vendors who were non-1099 vendors for part of the year, but were changed to 1099 vendors during the year. You need to verify that these transactions should be excluded from 1099 processing. Transactions shown on this report that should be included in the 1099 processing either need to be identified as 1099 transactions or need to be added to the 1099 form manually.
    • Non-1099 Vendors with 1099 Transactions Closed– This report shows any 1099 Transactions for vendors that are currently not identified as 1099 vendors. You should verify that the vendor should not be a 1099 vendor. If the vendor should receive a 1099, then change the vendor to have a default 1099 Type and 1099 Box. If you do not want the vendor to receive a 1099, either delete the vendor from 1099 List screen, or change the vendor’s invoice transactions so they are no longer 1099 transactions and then re-create the 1099 data file.
    • 1099 Transactions Applied to Non-1099 G/L AccountsClosed –This report shows any 1099 transactions that are charged to G/L accounts that are not set up as 1099 G/L Accounts. You are not required to identify the accounts as Subject to 1099, but it may be helpful in determining valid 1099 transactions.
    • Non-1099 Transactions Applied to 1099 G/L Accounts Closed– This report shows any non-1099 transactions that are charged to G/L accounts that are set up as 1099 Accounts.
    • Vendors with 1099 Transactions That Are Missing Tax ID Numbers Closed– This report shows any vendor who has 1099 transactions, but who does not have either a Federal Tax ID or Social Security number in Vendor Maintenance.
    • 1099 Transactions with Invalid Box TypesClosed– This report shows any 1099 transactions that currently contain a box type which is not valid.
    • 1099 Transactions Applied to APA Virtual Credit Card Payments Closed– This report identifies AP invoice items that have been flagged as 1099 but were paid by virtual credit card via AP Automation.
    • 1099 SSN Vendors Missing First Name Closed– This report assists with the setup for the IRIS transmittal file reporting. The IRIS formatting guidelines requires the recipient name on the file to be broken down into separate First Name, Middle Name, Last Name, Suffix fields for any vendor with a social security number (SSN) as their reporting tax ID. 

    In each case, the report displays the Invoice Number, Invoice Description, Invoice Date, Due Date, G/L Date, and Invoice Net Amount. For each invoice item for the vendor, it displays the Item Description, 1099 Type, 1099 Box, Quantity, Unit of Measure (U/M), the Amount per Unit, and the Total Amount. It also displays the invoice count and net total for each vendor, as well as a total count and total net amount for all the vendors on the report.

  4. Click Print to run the 1099 Audit Report.
  5. If you want to save the report criteria, click Save and provide a name for the report. Then click Print. The 1099 Audit Report is sent to myReports.
See Also

Vendor Invoice Maintenance

Vendor 1099 Processing

Accounts Payable 1099 Activity Report