AM SQL/Express 13 Sample Reports

The Vendor Reports help you focus on a variety of vendor-related data and provide pertinent information on your vendors including the applicable credit limits, discount rates, contacts, vendor addresses, vendor factors, and General Ledger distribution accounts.

Each of the Vendor Reports is especially designed to provide several options so you can generate data to the specific information needed. Read the information below to get a closer look at each of the Vendor Reports available in AccountMate.

Vendor Listing

The Vendor Listing lists all vendors set up in AccountMate. This report is useful in reviewing detail information about each vendor.

You can filter the report to include information only for the active vendors, only for the inactive vendors, only for the temporary vendors, only for the one-time vendors, or for all vendors. You can choose to generate this report only for the credit card vendors. You can further opt to show in the report the remarks specified in the vendor record -> Notepad tab.

Vendor Credit Limit and Discount Listing

The Vendor Credit Limit and Discount Listing provides information on the vendor's credit and discount arrangements with your company. In this report you can view the credit limits and discount rates that the vendors grant your company. You can use this report together with the Aging Report to help you analyze your credit standing.

You can filter the report to provide information for only the active vendors, only the inactive vendors, only the temporary vendors or all vendors regardless of their status.

Vendor Contact Listing

The Vendor Contact Listing shows vendor contact information. It serves as a quick reference list of your vendor contacts. This report is useful in identifying the vendor contact persons to communicate with and when mass mailings to vendor contacts.

You can filter the report to show contact information of only the active vendors, only the inactive vendors, only the temporary vendors or all vendors. You may also opt to show the remarks specified in the vendor record -> Notepad tab.

Vendor Additional Address Listing

The Vendor Additional Address Listing shows additional vendor addresses other than the main address shown in the vendor record -> Information tab. These additional vendor addresses are set up in the Vendor Address Maintenance window. This report supplements the vendor contact information in the Vendor Listing.

You can filter the report to display additional addresses of only the active vendors, only the inactive vendors, only the temporary vendors or all vendors.

Vendor Factor Listing

The Vendor Factor Listing provides information about the factors or those who act on the vendor’s behalf. Vendor factors are set up in the vendor record -> Factor (Pay to) field. This report can be used for reviewing information about the factors whom your vendors authorize to collect your payments.

Vendor GL Accounts Listing

The Vendor GL Accounts Listing shows information on the default GL Account IDs used for each vendor's transactions. This report is useful for reviewing and updating the default GL Account IDs assigned to each vendor record. You have the option to display in the report the authorized reference GL Account IDs associated with each vendor record.

Vendor Ledger Report

The Vendor Ledger Report provides information on invoice and payment transactions comprising your total accounts payable to the vendor. It lists the vendor's name and invoice numbers as well as the transaction amount, description, and reference. This report is useful in tracking and reviewing all vendor account activities for the specified date range.

You can filter this report to display only the invoice transactions, only the payment transactions, or both. You can also opt to include in the report the voided payments and voided invoices.

Vendor Report E-mail History

The Vendor Report E-mail History log shows certain individual special reports that AccountMate automatically e-mailed to each vendor. This log helps users review which special reports were automatically sent by AccountMate to the vendors, the date and time when the e-mails were sent, and whether the e-mails were successfully sent.

Recurring AP Invoice Report

The Recurring AP Invoice Report provides information on the recurring invoice templates that are set up in AccountMate. This report is useful in identifying the vendors for whom these recurring invoice templates are set up and in reviewing the templates' other important details.

You can filter the report to display only the 1099 recurring invoice templates, only the non-1099 recurring invoice templates, or both. You may further filter the report to include only those recurring invoice templates assigned with active status, only those assigned with inactive status, or both. You may also opt to show in the report the GL Account ID distribution that is set up for each recurring invoice template.