Bank Reconciliation > Bank Reconcilition Reports

Checks by Payee Options - Allows you to print a list of checks by payee in a variety of ranges. Includes the ability to print based on CGL coding as well as for one or all bank codes. Additionally there are also options to include checks from different sub systems, different status, summarized by vendor, or to only print those payees that have a total exceeding a designated dollar amount. This listing is excellent for 1099 information (run the report for a calendar year for all payees).

This report can be limited to only show outstanding and/or cleared checks. This report is particularly useful when running the Escheat process. The report will show what payments were unclaimed and the Escheat payments by listing "Unclaimed" or "Escheat" in the Payee Name column.

NOTE: Be aware that if a user does not have access to a particular bank code, that user will not be able to view the check history for that bank code, view the restricted bank code through the Check Register report or the Check by Payee report.

Question:

I need to run a report that shows our contract labor that would receive a 1099 and how much each vendor has been paid for a specific time period. How do I run this report?

Answer:

The necessary information can be found on one of two reports:

1.Bank Reconciliation > Reports > Checks by Payee-make sure that the "Include only Payees with 1099 code" option is set to "Y." Also make sure that the "Check Date Range From/Thru" range is set to the date range you desire.

2.Accounts Payable/Reports/Invoice Tab/I-1 Invoices by Vendor.