This report lists of all the vendors grouped by category. For example: All Office Supply Vendors, Hardware Vendors, Lawn Maintenance Vendors, etc. Vendors can be assigned a category in the Maintain Vendor Screen, Category Tab. The report has the option to select all vendors, or just one vendor, choosing by vendor # or vendor name. The report can also be sorted by vendor number and/or name. The user may opt to include all vendors, only active vendors or only inactive vendors on the report.
This report lists all vendors who have a hold placed on them. There is a field in the Maintain Vendor screen on the left side in the “misc” panel, where a letter can be placed (most use an “H”) in the field and if done, the vendor will show up on this report. There are no selection criteria for this report, but it displays the vendor and the corresponding vendor number, vendor name and hold code in vendor number order.
This report lists of all vendors that do not have a W9 (Certification of SSN/EIN) on file. There is a field on the vendor record in the Maintain Vendor screen where you can place a check mark to indicate that you do have a W9 on file for a vendor. If there is no check mark in this field, the vendor will appear on this report. The selection criteria allow you to select all vendors, or vendors for a particular category. You may also select just one vendor by number or name and choose to sort the report either by vendor number or name.
This report lists those vendors that have been marked to receive a 1099 MISC IRS form for a particular year. The selection criterion allows the selection of all vendors or just vendors in a certain category. Just one vendor can be selected by number or by name, and the report can be sorted by number or name. The year may be selected and the report set to either display or not display the vendor on the report if the YTD amount is less than $600. The report will display the vendor name, number, taxpayer ID, and the amount paid to them this year compared to what was paid to them last year. This report is used to monitor those vendors that were paid more than $600 in one year to determine if they must be sent a 1099 MISC form.
This report displays the total amount by the month that was paid to either a particular vendor or all vendors for the year. The report has the option to select all vendors, vendors for just a certain category, or one vendor by vendor number or name. There is also the option to select which the calendar year’s data to display as well as the month or months. The report will display the vendor name, number, year, month and the total number (count) of checks written to that vendor as well as the total paid to the vendor. This report would be used to compare to the 1099 listing and also could be run if a vendor wants a print out of what you have paid to them for a particular month or year.
This report lists vendors that were paid and are considered an MBE (Minority Business Enterprise). This information is needed for reporting to HUD. The MBE/Non-MBE box on the vendor screen, (located in the “flags” panel) must be checked for a vendor to show on the report, when it is run for a month in which that vendor was paid. Simply placing a check mark in the “minority” box, will not display payments to this vendor on the report. The selection criterion allows the selection to run this report for one or all vendors, vendors in a specific category (if you are using categories), and for any and all months of a specific year. The report can be sorted either by vendor name or vendor number.
This report lists all invoices that have been entered into the Accounts Payable system, but have not yet been paid. This report can be run for just one or all vendors or a category of vendors. The user may choose different date fields for the date filter as well as enter a date range. The user may sort the report in several different ways: vendor name, vendor number, invoice number or date and check number. The user may also select a specific bank account from which the payment will be paid, and whether or not to display the report in summary or detail format. This report is used for a variety of reasons. One of the most common is to provide a printout to management of all invoices that need to be paid for a specific time period so that they can review it and perhaps “Sign off” on the report, so the AP clerk knows it is okay to print the checks.
This report lists invoices that have been paid. The selection criterion allows the report to be run for just one particular vendor or all vendors and a specific category of vendors (if using). The user may also select from a variety of “date types” and enter a specific date range. The user may also filter by check number and choose to sort the report in a variety of ways. The user may also run the report for a specific bank account that was used to pay the invoices, choose detail or summary for the report and whether or not to include checks that have been voided. This report is used for creating a list of payments to a specific vendor. There are times when a vendor may ask for this. It may also be used by management to monitor what payments have been made to vendors for a specified period of time.
This report lists those invoices that have a “hold code” placed on them. There is a field on the invoice screen where the user can put a “code” of their choice in a box and also a date for how long they wish to hold the invoice. If there is anything in the hold code field, the invoice will show on this report. The selection criterion allows users to report on any hold code as well as a specific hold date range. Users may choose to include paid invoices and sort by either vendor name or vendor number. This report is used for monitoring which invoices have been placed on hold.
This report lists invoices that have been entered into the system but not yet paid. It will display when invoices are due for certain time periods (buckets), such as past due, due in 7 days, 14 days, etc. The selection criterion allows the user to select a specific category of vendors, one individual vendor or all vendors. It also allows for filtering by different dates and a date range. Users may choose to sort the report by vendor name, number, invoice number, date or check number. This report is used by management to monitor unpaid invoices and the amount of cash that is going to be required to have on hand to pay the invoices on their specific due dates.
This report is basically a “check register” of all checks that have been paid using the Accounts Payable program. The selection criteria allow users to select a category of vendors, one or all vendors and a range of check numbers. Users may specify the bank account and choose from a variety of report sorting methods. Users may choose to include just voided checks, non-voided checks or all checks, as well as display either a summary or detail report. A check date range is also available to filter the data. This report is used for a variety of reasons, but the most common is to compare to bank account statements during the reconciliation process. At times vendors may ask for a listing of all the checks/payments that have been made to them and this report would be used for that as well.
This report lists invoices that have been entered into the Accounts Payable System, and have been “accrued”, but not yet paid. The selection criterion allows the report to be printed for a specific vendor category, one or all vendors, a date filter and date range and a variety of sort orders. Users may also choose to report on the invoices for a particular bank account and select to report in detail or summary. This report is used by those Housing Authorities that use an “Accrual Method” of account as opposed to a “Cash” method. (Contact a Tenmast Representative for further information on these two methods.) This report is used to monitor the invoices that have been entered and accrued so that management can see what is “owed” and compare that to the amount that shows in the General Ledger Account Payable Vendors account.
This report is a listing of all invoices that have an Invoice Date on or prior to the selected report date but have either not been paid or have been paid after the selected report date. This report is used at the end of the fiscal year to list all invoices that should be accrued for year end accounting functions.
This report lists the invoices that were posted to all General Ledger accounts by General Ledger account number. The selection criterion allows users to select all invoices, checks only or expenses only. Users may choose a vendor category, one or all vendors, accrual or invoice date with a date range and a specific bank account. This report is used by management to monitor Accounts Payable to the General Ledger accounts that have been affected by payments made from invoices.
Copyright © Tenmast Software 2010