Vendors Reports Overview

Vendors Reports provide information on invoices from and for vendors. These reports can then be exported from the system for tax purposes or to process payments through an outside company.

Navigation

1. To access My Reports, select My Reports in any module.
   The My Reports screen opens with the Favorites tab selected.

2. Select the Vendors tab to view Vendors reports. 

Reports that are marked as a favorite appear on the default tab of the My Reports screen. To mark a report as a favorite, select the star icon to the left of the report name.

Security and Report Access

Vendors Reports can be accessed by users who have been given Report Roles by their system administrator. 

If you are not able to view these reports, it is most likely because you don't have security access. Speak with your system administrator to give you access to running or viewing these reports. 

Reports

The following reports are available on the 'Vendors' tab:

1096 Prep - Lists the totals of returns from 1099 Vendors throughout the year. This can be helpful to view before printing the 1096 Printable Form.

1096 Printable Form - Downloads the information needed to print onto the 1096 Tax Form.

1099 Export - Exports 1099 data by Form Type, which can then be imported into an online system so your taxes can be done electronically.

1099 Review - Displays all of the 1099 Vendors for a specified period of time. This can be helpful to view before producing the 1099 Tax Form.

1099-INT Printable Form - Downloads the information needed to print onto the 1099-INT Tax Form.

1099-MISC Printable Form - Downloads the information needed to print onto the 1099-MISC Tax Form.

1099-NEC Printable Form - Downloads the information needed to print onto the 1099-NEC Tax Form.

AP Aging - Shows all the open AP Transactions, including credit memos that haven't been applied to an invoice yet, as of a selected date. The day ranges for current and past due invoices will be listed along with their invoice number.

ComData Export - Produces a listing of all open, unpaid invoices for Customer's who are signed up for ComData. This information can then be exported in the correct formatting and given to ComData for payment purposes.

CPX Buyer Export - Exports a listing of all Buyer Names and Buyer IDs used for R365 Payments.

Mineral Tree Export - Produces a listing of all open, unpaid invoices for Customer's who are signed up for MineralTree. This information can then be exported in the correct formatting and given to MineralTree for payment purposes.

Vendor Reconciliation-Detail - Runs all AP Transactions for a single Vendor as of a specific cut-off date and details out the expenses tied to multiple GL Accounts and/or Locations from one transaction.

Vendor Reconciliation - Summary - Runs all AP Transactions for a single Vendor as of a specific cut-off date and provides a quick view into the total amounts paid and due to a Vendor.