The Vendor Expenses Reports screen provides access to the following reports:
§ Vendor Card: Displays payment information for all vendor transactions, and, by default, all vendors, although you can view transactions only for specific vendors. Transactions are characterized as payments, bill check payment, manual check payment, credit card payment, or 1099 amount.
§ Vendor List: Displays the number, name, address, and phone for each defined vendor, with a check box indicating whether a W-9 was supplied for the vendor. Similar to the on-screen Vendor List.
§ Vendor Profile Detail: Provides detailed information about each vendor, including the vendor's terms, 1099 and W-9 status, account code, EIN or SSN, etc., as well as the vendor's 1099 amount for the fiscal year end. Select the Only 1099s option to create a 1099 vendor report.
§ Accounts Payable Aging: Displays open payables based on a selected invoice date. Payables are grouped by due dates (1-30, 31-60, 61-90, and over 90 days from the invoice date). The summary report displays the total due each vendor, while the detail report also provides the details for each invoice. You can sort this report by vendor name or vendor number.
§ Vendor Register: Displays beginning and ending balances, and a summary of invoice and payment amounts for the selected date range.
§ Vendor Bills Summary: Displays a summary of all vendor bills for a specific vendor or all vendors.
To view the reports available from the Vendor Expenses Reports screen:
1. Select Vendor Expenses from the Reports menu to open the Vendor Expenses Reports screen.
2. Click the name of the report you want to view from the panel on the left.
The panel lists all of the available Vendor Expenses reports. When you select a report, the report criteria screen for that report appears.
The Vendor Card criteria screen is selected by default.
3. Enter the additional information requested for the specific report in the appropriate fields:
§ Vendor Card: Specify a vendor for the report in the Select Vendors field, select the Show Only 1099 Vendors option to view only 1099s, use the From and To fields to specify a date range, and use the radio buttons in the Sort By field to indicate whether to view Summary or Detail information.
§ Vendor List and Vendor Profile Detail: Use the drop-down list to specify a Fiscal Year End and use the radio buttons in the Show field specify whether to display All Vendors or Only 1099 vendors.
§ Accounts Payable Aging: Enter a date for the report in the As Of Date field, specify whether to display Summary or Detail information in the Show field, and use the options in the Sort By field to indicate whether to sort the report by vendor Name or by Number.
§ Vendor Register: Specify a vendor in the Select Vendors field and indicate a date range for the report using the From and To fields.
§ Vendor Bills Summary: Select a specific vendor from the drop-down list in the Vendors field or select All, and specify whether to sort the report by Name, Due Date, or Amount in the Sort By field.
4. Click the PDF, Excel, or Word button to indicate the output you want to generate.
Depending on the output format you choose, the file opens as a separate tab on your browser (PDF) or as a separate file (Word and Excel), from which you can save or print the report.
5. Click Archive to save the requested data to Cloud Cabinet.