Vendors Reports are ran to provide information on the invoices made from and for Vendors. These reports can then be exported from the system for tax purposes or to process payments through an outside company.
To access My Reports, click on the 'My Reports' Tab in any module. When the main Reports screen opens, it will default to your 'Favorites', or any report that you previously starred. Hover over and click 'Vendors' on the header; this will then display all of the Vendors Reports.
Make one of these reports a favorite by clicking the Star icon to the left of the report name and it will be saved as a favorite in the 'Favorites' tab.
Security and Report Access
Vendors Reports can be accessed by Users who have been given Report Roles by their system administrator.
If you aren't able to view these reports, it's most likely because you don't have security access. Speak with your system administrator to give you access to running or viewing these reports.
The following reports are available on the 'Vendors' tab:
1096 Prep 2020 - Lists the totals of returns from 1099 Vendors throughout the 2020 year. This can be helpful to view before printing the 1096 Printable Form - 2020.
1096 Printable Form - 2020 - Downloads the information needed to print onto the 1096 Tax Form.
1099 Export 2020 Tax Year - Exports 1099 data by Form Type, which can then be imported into an online system so your 2020 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 2020 Printable Form - Downloads the information needed to print onto the 2020 1099-INT Tax Form.
1099-MISC 2020 Printable Form - Downloads the information needed to print onto the 2020 1099-MISC Tax Form.
1099-MISC Form 2019 - Downloads the information needed to print onto the 2019 1099-MISC Tax Form.
1099-NEC 2020 Printable Form - Downloads the information needed to print onto the 2020 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.
Tax1099.com Export 2019 - Exports all of the information needed for a 1099 Tax Form in the desired format for Tax1099.com 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.