How Do You Manage Vendors in Quickbooks?
If you buy and resell products or need to purchase materials to create your own items, good management of your company’s vendor records is critical. Maintaining a physical card file is way too inflexible. You can’t find or edit individual records quickly or easily. They get lost or are illegible because you’ve updated the cards too many times.
When you create a transaction like a purchase order or write a check, you have to look back and forth between your card and the form, and it’s easy to make transposition errors. And you can’t generate reports – not even an alphabetized list.
QuickBooks solves all of these problems. It includes blank vendor records that you can fill in and save. You can find the ones you’re looking for in a couple of seconds, and modifying them is a simple process. If you need to use vendor data elsewhere in the software, you must select the correct entry from a list. And vendor reports are plentiful.
Here’s how it works:
The Vendor Information Screen
QuickBooks displays all of your vendor records and related tools on one page. To get to it, click Vendors in your toolbar to open the Vendor Information screen. There’s a list of vendors and transactions to the left and a small horizontal toolbar at the top containing action icons. But most of the page is taken up by your vendor records, displayed one at a time. To create a new one, click New Vendor in the upper left corner. A window like this appears:
Figure 1: Partial view of a QuickBooks vendor record.
Fill in the blanks to complete your vendor’s contact information. Below that section, you’ll enter a physical address. Click Payment Settings in the series of tabs in the upper left. Here, you can enter an account number (if applicable) and select payment terms (like Net 30). You can also specify a credit limit and indicate how the vendor’s name should appear on checks. Click Tax Settings to enter a Vendor Tax ID and mark them as eligible for an IRS Form 1099 (using information from the vendor-provided W-9).
Clicking the Account Settings tab opens a window that may be confusing to you. If you’re entering a phone bill, for example, you’ll need to assign the correct expense account to it, which in this case would be Utilities: Telephone. That account will be automatically selected when you create a transaction for that vendor. There’s space for two alternate accounts here, too, if you think you’d ever have occasion to use a different one.
Warning: You must be accurate when assigning default accounts anywhere in QuickBooks, or you may run into problems with reports and taxes. If you have questions, please call, and someone can go over this concept with you.
Click the final tab, labeled Additional Info, and you’ll have two options. You can specify a Vendor Type, like Utilities or Subcontractors (or create your own) and you can define Custom Fields that will appear on your customer, vendor, and employee records. You can assign up to 18 total, no more than seven to vendors.
Figure 2: You can define up to seven custom fields for your vendor records.
When you’ve completed your vendor record, click OK, and it will appear in your Vendors list and be available to use in transactions.
More Vendor Options
When you highlight a name in your Vendors list, the screen changes to display their contact information in the upper horizontal pane. Click the paper clip icon in the upper right corner to attach a file and the pencil icon to edit the record.
The lower half of this screen is divided into five sections, accessible by clicking tabs. It opens to Transactions, which is a list of all of your activity with the vendor. Click Contacts to see that vendor’s contacts, and To-Do’s to see any related tasks that have been created (you can right-click in the table and select Create New to generate your own). Notes are similar; right-click and select Add New. The final tab, Sent Email, displays just that. Links at the bottom of the screen let you Manage To-Do’s and Run Reports.
Figure 3: You can add To-Do’s for your individual vendors.
Manage Your Vendor Relationships
Your business relationships with vendors are critical right now, considering it may be hard to get all the supplies you need. QuickBooks can ensure that you have the information you need about them – information that is comprehensive and easy to access. It can also save you time and improve the accuracy and thoroughness of your transactions and reports. Please call if you need help with any element of vendor management or if you need assistance with your use of QuickBooks in other areas.
Any accounting, business or tax advice contained in this communication, including attachments and enclosures, is not intended as a thorough, in-depth analysis of specific issues, nor a substitute for a formal opinion, nor is it sufficient to avoid tax-related penalties. If desired, we would be pleased to perform the requisite research and provide you with a detailed written analysis. Such an engagement may be the subject of a separate engagement letter that would define the scope and limits of the desired consultation services.