Accounts Payable reports detail transactions and other information for the purchases that you make. Accounts Payable forms are documents you fill out and send to your vendors including checks and purchase orders.

1099 Vendor Report

The 1099 Vendor Report lets you preview the 1099 forms you will submit to the IRS for your company's 1099 vendors. The report lists the following information:

Vendor ID and Vendor Name

1099 Type - K (Card & Network Transactions), INT (Interest), MISC, or MISC/NEC (Miscellaneous/Nonemployee compensation)

1099 Box and Description

Date of vendor transaction

Transaction Amount and Total

Lower Limit Met? for this vendor

How to run the 1099 Vendor Report

1099 Vendor Report Options

Click the Options button to determine the data that appears on the report. For this report Sage 50 displays the following options:

• Dates: Choose the year on which the report will be based; you can choose from the two currently open fiscal years.
• Sorting: You can sort by vendor ID, vendor name, or 1099 type.
• Summarize Report: Select this check box to print the report in summary rather than detail format.
• Filter Using Default Lower Limits: Select the check box if you want to use the default lower limits for 1099 vendors. The federal government determines lower limits.

Adjust Limits: If you want to manually set the lower limits that Sage 50 will use to filter the report, deselect the check box, and then click the Adjust Limits button. This will open the 1099 and 1096 Forms - Lower Limits window, where you can change the limits.

Aged Payables Report

The Aged Payables report shows outstanding payables, broken down by aging categories and computed by invoice date or due date (which you select in Vendor Defaults).

How to run the Aged Payables Report

Go to Reports & Forms, Accounts Payable, Aged Payable.

Aged Payables Report Options

Select the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 offers the following filter options:

• Dates: You can select to show this period, today, or a date within the open years.

Cash Disbursements Journal (Report)

The Cash Disbursements Journal lists in journal format all payments (checks) made to vendors and customers. This includes checks written in either the Payments or the Write Checks window.

How to run the Cash Disbursements Journal (Report)

Go to Reports & Forms, Accounts Payable, Cash Disbursement Journal.

Cash Disbursements Journal (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: You can sort by date, check number, account ID, vendor ID, vendor name, customer ID, or customer name.
• Summarize report: Select this check box to see a shortened version of the report.
• Shorten Description: This shortens the long description to fit in one column.

Cash Requirements Report

The Cash Requirements report shows by vendor how much you owe vendors at a given time.

How to run the Cash Requirements Report

Go to Reports & Forms, Accounts Payable, Cash Requirements Report.

Cash Requirements Report Options

Select the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 offers the following filter options:

• Date: You have the choice of reviewing outstanding balances for the Exact Date, This Period, or This Day. If you select the Exact Date, you can use the Date field to enter a date.
• Sort by: You have the choice of sorting the report by vendor ID, vendor name, invoice due date, or discount date.
• Summarize Report: Select this check box to summarize your balance with each vendor, rather than showing all transactions with each vendor

Check Register (Accounts Payable)

The Check Register lists all checks, including payroll checks. If you accept the default printing, the report includes all the checks printed (and unprinted) for the current accounting period. You can limit the checks on the report by check number or invoice number.

How to run the Check Register (Accounts Payable)

Go to Reports & Forms, Accounts Payable, Check Register.

Check Register (Accounts Payable) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: You can sort the report by date, check number, payee ID, payee name, or check amount.

Items Purchased from Vendors Report

The Items Purchased from Vendors report is a list of all purchases made from vendors. This includes purchases entered in the Purchases/Receive Inventory window, as well as direct purchases without invoices—ones entered on the Apply to Expenses tab of the Payments window. Use this report to reconcile vendor statements.

How to run the Items Purchased from Vendors Report

Go to Reports & Forms, Accounts Payable, Vendors Report.

Items Purchased from Vendors Report Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: You can sort by vendor ID and then by item ID, by vendor ID alone, or by vendor name. If your chosen method of posting transactions is Batch or SmartPosting, you will also be able to sort by transaction. See the Note below.

Note: If your current posting method is Batch or SmartPosting, you can choose to include all transactions, all posted transactions, or all unposted transactions. To select the types of transactions to include, select the Posted Trx filter.

Purchase Order Journal (Report)

The Purchase Order Journal lists purchase orders in journal format. Use this report to verify all PO's for a specific date range.

How to run the Purchase Order Journal (Report)

Go to Reports & Forms, Accounts Payable, Purchase Order Journal.

Purchase Order Journal (Report) Options

• Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:
• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: Sort by date, invoice number, or account ID.
• Summarize report: Select this check box to see a shortened version of the report.
• Shorten Description: This shortens the long description to one column.

Purchase Order Register (Report)

The Purchase Order Register lists the purchase orders for a selected date range.

How to run the Purchase Order Register (Report)

Go to Reports & Forms, Accounts Payable, Purchase Order Register.

Purchase Order Register (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: You can sort by date or vendor ID.

Purchase Order Report

This Purchase Order report lists purchase orders with line item detail including quantity ordered, quantity received, and quantity remaining.

How to run the Purchase Order Report

Go to Reports & Forms, Accounts Payable, Purchase Order Report.

Purchase Order Report Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: Sort by vendor ID, item ID, or purchase order number.
• Shorten Description: This shortens the transaction description to one column.

Purchase Journal (Report)

The Purchase Journal is a record of purchases and includes detail information about each line item.

How to run the Purchase Journal (Report)

Go to Reports & Forms, Accounts Payable, Purchase Journal.

Purchase Journal (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: Sort by date, invoice or credit memo number, account ID, vendor ID, or vendor name.
• Summarize report: Select this check box to see a shortened version of the report.
• Shorten Description: This shortens the long description to one column.

Vendor Ledgers (Report)

Vendor Ledgers lists vendors with detail transaction information as well as outstanding balances per vendor. The bottom of the report provides debit, credit, and balance totals.

Note: You can access a specially filtered version of the Vendor Ledgers report from two different sources:

The Maintain Vendors window. When you select an existing vendor in the window and then click the Current Balance arrow button, the Vendor Ledgers report appears for this vendor filtered to reflect outstanding balances as of the current (system) date.

Accounts Payable task windows. The following windows feature a Vendor Balance arrow button: Purchase Orders, Purchases, and Vendor Credit Memos. When you click the button, the Vendor Ledgers report appears for the displayed vendor filtered to reflect outstanding balances as of the current (system) date.

How to run the Vendor Ledgers (Report)

Go to Reports & Forms, Accounts Payable, Vendor Ledger.

Vendor Ledgers (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Date: You have the choice of All, Range, Today, This Period, This Quarter, This Year, and the week, month, period, quarter, and year to date. If you select range, you can enter a beginning and ending date.
• Sort by: Sort by vendor ID or name.
• Include Vendors with no activity and a zero balance: Select this check box if you want to include vendors with no activity and a zero balance for the selected date range. Clear this check box if you do not want to include these vendors on the report.

Vendor List (Report)

The Vendor List shows all vendor records that you have entered in this company.

How to run the Vendor List (Report)

Go to Reports & Forms, Accounts Payable, Vendor List.

Vendor List (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Sort by: You can sort by vendor ID or name.

Note: You can filter this report by customizable fields for customers.

Vendor Management Detail Report

The Vendor Management Detail report displays all purchase invoices, including payment information.

How to run the Vendor Management Detail Report

Go to Reports & Forms, Accounts Payable, Vendor Management Detail Report.

Vendor Management Detail Report Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Sort by: You can sort by vendor ID, vendor name, or vendor ID/invoice date.
• Summarize report: Select this check box to see a shortened version of the report.

Note: You can filter this report by customizable fields for customers.

Vendor Master File List (Report)

The Vendor Master File List is capable of showing all the vendor records that you have entered in this company. It differs from the Vendor List in that it displays more information.

How to run the Vendor Master File List (Report)

Go to Reports & Forms, Accounts Payable, Vendor Master File List.

Vendor Master File List (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Sort by: You can sort by vendor ID or name.

Note: You can filter this report by customizable fields for customers.

Vendor Transaction History (Report)

The Vendor Transaction History report displays all the purchase invoices for each vendor, along with related payments.

How to run the Vendor Transaction History (Report)

Go to Reports & Forms, Accounts Payable, Vendor Transaction History.

Vendor Transaction History (Report) Options

Click the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 displays the following filter options:

• Sort by: You can sort by vendor ID, vendor name, or vendor ID/invoice date.

Note: You can filter this report by customizable fields for customers.

• Print one vendor per page: Check this box to only print one vendor per page on the report.