The Vendor Analysis Report provides month-to-date (MTD), year-to-date (YTD), and to-date (TD) totals for paid posted invoices and discounts taken for each vendor.
To run the Vendor Analysis Report
In Accounts Payable, there is the Cash Requirements Report. This report will display all of your outstanding invoices sorted by Due Date. The GLS bank account balance can optionally be included on this report to show a running bank account balance, allowing you to see how the balance will be affected by the payables on the report.
To specify a running bank account balance be included on the Cash Requirements Report
To run a Cash Requirements Report
In Version 19, we introduced the ability to mark vendors as inactive. Invoices, manual checks, and EFTs cannot be entered for inactive vendors.
To mark a vendor as inactive
Inactive vendors can be included or excluded from the Vendor Lookup window, Vendor List, and Vendor Analysis Report.
Note: Vendors with one or more recurring entries cannot be marked as inactive. Recurring entries must be deleted before the vendor can be marked inactive.
Yes, there is! A miscellaneous vendor can be set up for just this purpose. The Miscellaneous Vendor feature was designed to be used for “one-time” vendors so that you don’t have a multitude of vendors set up in your vendor file that you will never use again. You can enter a different name and address for each invoice or manual check that is entered for a miscellaneous vendor.
A miscellaneous vendor can be designated via the Vendor file (File | Open | Vendor) by selecting the desired vendor or creating a new vendor, and then selecting the Miscellaneous Vendor check box. Once the vendor has been set up, simply enter the desired address during Invoice/Manual Check Entry.
To enter an invoice for a miscellaneous vendor
You can change what information is included in the journal entry, as well as what order the information is in, via APS Customization.
To include vendor information in GLS journal entries for posted checks
Discount information can be set up in the Vendor file. Once set up, the discount will automatically be taken for any future invoices that meet the criteria.
To set up a discount for a vendor
The Check for Duplicate Invoices setting can help prevent this from happening. When this setting is enabled, a warning will be shown if an invoice or manual check for the same vendor has the same invoice number, invoice date, and invoice amount. This preventative measure is performed when an invoice/manual check is added, or when an invoice is changed and saved.
To enable Check for Duplicate Invoices
You can transfer all of the invoices and checks from one vendor to another using the Transfer Invoices function. Everything will then be on one vendor number and you can delete the vendor that you transferred everything from.
To transfer all invoices and checks from one vendor to another
Now that the transfer is completed, you can delete the unwanted vendor, effectively combining the two vendor numbers into one.
The Tabs3 Accounts Payable Software (APS) makes paying bills easier. You can print checks, track vendors, generate 1099-MISC forms, run reports and check registers, and more!
APS lets you write checks to saved vendors as well as vendors that are not individually tracked in the software. For monthly payments, set up recurring entries to create multiple invoices in one step. Writing a check by hand? Enter a manual check that will show up in your check register.
Tracking vendors is a snap. In addition to name and address, you can save information for frequently used vendors such as the Federal ID number, 1099-MISC information, vendor discount information, and more! Month-to-date, year-to-date, and to date paid figures for each vendor are also tracked for easy reference.
APS integrates with Tabs3 Billing and Tabs3 General Ledger Software (GLS) to bring things together. Costs can integrate with Tabs3 when adding, changing, or deleting an invoice or manual check. When integrating with GLS, journal entries are automatically created when checks are posted, and voided checks will create reversing journal entries.
APS also offers many reports that can be run to determine activity in the software, including a Check Register, Pre-Check Register, Cash Requirements Report, Aged Unpaid Invoice Report, Vendor Analysis, and lists for vendors, bank accounts, recurring entries, and voided checks.
If you are not currently using APS, try it out! You can install APS Trial Software using the Tabs3 CD, or download a free trial. Contact your Tabs3 reseller or consultant, or our Sales Department at (402) 419-2200 for pricing and information.
Note: Tabs3 works exclusively with Nelco to provide you with checks guaranteed to work with Tabs3 software.