Accounts Payable Reports

Prints a list of active vendors, inactive vendors, temporary vendors or all categories of vendors, depending on the selection you make. You also have the option of sorting the report by the vendor number, vendor name, product type plus the AP code. The report includes the following detail for each vendor: vendor number, vendor name, AP code, product type, 1099 type, and other information determined by the Sort By and Additional Filter boxes selected.

Printing labels for vendors expedites sending out checks or other information that is important to your vendors. This process is made easy with this report. Vendor labels can be sorted by vendor numbers, names, product type, or AP code. You can also select the vendor status (all, active, inactive or temporary), and define the label type (number) that you will print the labels on. The following information is printed on each label: vendor name, vendor address (address 1 and 2, city, state, zip), and vendor number (if Print Vendor Number activated).

Prints information stored in each vendor's master record. Since the report prints all the history information from the master file, it is a good idea to activate the option that allows you to print each vendor record on a separate page. The report contains the following information: vendor ID number, vendor name, address, remit to information, contact name and information (telephone number, alternate telephone number, fax number, internet address, e-mail address, and BBS number), and general information (discount percentage, product type, GL expense code, customer number, credit limit amount, return dollar amounts, last check), due date calculation methods (days from the invoice date, discounts [allowed and taken], last dollar amounts, YTD dollar amounts), 1099-MISC information (Federal ID, 1099 type, pay type, current year revenue, last year revenue, User Defined Fields), and notes (special notes made pertaining to this vendor ).

Provides a list of vendors to whom the company owes money. Since it is important to effectively monitor what you owe to your vendors, this report provides a quick view of the aging status of your vendor accounts. You can run this report for one vendor or all of your vendors depending on your immediate need.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.   Click the Sample Report Thumbnail to see an example of a report that you can run.

Lets you view your total payables without aging. This provides a snapshot of your total liabilities by placing all dollar amounts into the current period rather than aging them.

The Cash Requirements Report is a summary of the items that will be due or past due in a specified date range. The report lists all credit transactions due for each vendor plus any debit transactions applied to each vendor.

Provides you with a list of vendors whose invoices have not yet been paid and are overdue for payment. The report lists the following by vendor for each invoice: transaction date, GL date, due date, original amount, amount remaining to be paid, total overdue for vendor, and other information determined by the additional filter field selected.

A prepaid invoice or liability is a payment usually paid in one lump sum, but expensed in several periods. The Prepaid Report prints all the prepaid invoices entered into your system, including those that have not been expensed. The AP Prepaid Report is sorted by vendor number, vendor name, and expense date. For each invoice it prints vendor number and name, invoice number, invoice or transaction date, due date, transaction type, discount allowed, description, GL expense account, expense date, quantity, cost per unit, extension of cost, and amount left remaining to pay.

A future liability is a liability that you know must be paid some time in the future. The Future Liability Report prints all future liability invoices that are due, including those that have not been expensed. The AP Future Liability Report is sorted by vendor number, vendor name, vendor status, and expense date. For each invoice it prints vendor number and name, invoice number, invoice or transaction date, due date, transaction type, discount allowed, stock description, GL expense account, expense date, quantity, cost per unit, extension of cost, and amount left to pay.

The Dated Invoice/Payment Report determines the total amount due in Accounts Payable at any specific time for a specified range of vendors. You can exclude zero-balance vendors and save time by not having to wade through pages of vendors to whom you don't owe anything. The report will still include vendors with whom you have either a debit or a credit balance.

The GL Expense Distribution Report provides a detailed outline of debit (or reversing credit) entries made to the General Ledger Chart of Accounts as the result of posting AP Invoice transactions. In most cases, the debit entries are made to expense, inventory, or discount accounts, but in certain cases they may go to other GL accounts.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

The AP History Report provides complete information on accounts payable history. For each vendor you will see all invoices, including individual invoice line items, the invoice number, purchase order number, transaction date, GL date, discount date, due date, expense date, stock number and description, discount amount, quantity, unit cost, extended cost amount, and the original amount. This report lets you do the following: audit each vendor's account at a glance, quickly view vendor payment records on screen, as well as in hard copy format. This lets you quickly answer vendors' questions regarding payments. Print in detailed, condensed, summary or detailed with notes format.

If you paid subcontractors during the year, the IRS requires that you submit 1099-MISC Forms. This option will print the form information on 1099-MISC computer forms. The 1099-MISC report lets you print test copies to ensure that the data will be placed correctly on the form before you start printing the actual forms. It will also let you print more than one copy if necessary. Both the Plain Paper and Preprinted 1099-MISC and 1096 forms have been tested using multiple printer and driver combinations. The best results were obtained using the HP1100 printer and the HP1100 driver. We recommend using the printer driver that comes with (or is recommended by) your specific printer manufacturer.

Lets you report your 1099s to the IRS on magnetic media (disk, tape, etc.).

Provides you with a tool to control your payables, and is also used to insure that your data files are in balance. The AP Control Report prints the total for each AP code by aging periods, and prints a grand total for all AP codes. One of the most useful aspects of this report is to catch discrepancies among the total due in the master file, the open invoice file, and the line detail file. The report computes the line details of each invoice and compares it to the total due for that invoice in the open invoice file. It also computes the total due for each invoice in the open invoice file (Open Item Total), and compares it to the total due in the vendor master file (Master Total). If there is a discrepancy among the files, a value other than zero will appear in the Net Difference column on the right side of the report. On the Control report you will see the following items by vendor: Open Item Total: This is the total amount of all outstanding invoices for the vendor; Master Total: This is the amount due, which is found in the Master Vendor Record, and should equal the Open Item Total; Net Difference: This value should always be zero. If it isn't, you may have a corrupt data file and should re-index your files. In addition to the invoice totals due for each vendor, the report will display the individual Debit and Credit Aging Totals listed by each of the aging periods established by the AP code.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.