How to Create and Use Vendor Records in QuickBooks® Online

Keeping your supplies coming in may be difficult right now. Be sure you know your vendors and track their records carefully.

Your company counts on its supply chains to keep operations running smoothly. When it falters, you can have trouble creating and shipping products. Problems may even crop up that have a negative effect on your internal business needs.

We don’t have to tell you that COVID-19 has interrupted supply chains. The pandemic has been catastrophic for many small businesses because of this, and because income has been suddenly and sharply reduced. Some financial help is available, and we hope you’re able to take advantage of it during these extraordinarily difficult times.

It’s perhaps more important than ever to carefully track your income and expenses, and we hope you’re using QuickBooks to do so. Among the software’s financial management tools is the ability to maintain thorough records of those vendors that make up your supply chain. Let’s take a look at how this works.

Creating Vendor Records

We’ll go through the steps for creating vendor records, though you may have at least started on these already. Hover your mouse over Expenses in the toolbar and select Vendors. If you’ve already added some, you’ll see them in a list. To create a new one, click New Vendor in the upper right. Most of the form is easy to complete; it’s primarily contact information.

There are a few fields, though, that need special attention. These are:

  • Cost rate/hr and Billing rate/hr. These help you track time costs for your projects. Don’t enter anything here if you pay vendors via bills or expenses.
  • Terms. Due on receipt? 15 days? 30 days? 
  • Account no. and Business ID No. You should have these on file.
  • Track payments for 1099. Put a check in this box for any 1099 contractors.

When you’re done, click Save. This vendor will now appear in your list.

Taking Action

A screenshot of a cell phone

Description automatically generated

You can take a number of actions from QuickBooks’ Vendors screen.

You can do a lot of your work directly from QuickBooks’ Vendors page. This screen displays a list of all of your vendors, along with columns for their Phone, Email, and Open Balance. At the end of each row is an Action column. The link there reads either Create bill or Make payment, depending on whether there is an outstanding balance. 

Click on the down arrow in that column to open a list of additional options. If there is a zero balance, you can Create expense, Write check, Create purchase order, or Make inactive. If money is due, your options are to Create bill or Create expense. Icons in the upper right allow you to print the list, export it to Excel, or change the column settings.

Collecting Your Billables

Before we look at vendor records in QuickBooks, we’d like you to check a couple of settings to make sure you’re billing your customers for every expense they incur with you. Click the gear icon in the upper right corner and select Your Company | Account and Settings, then click on Expense. Among others, you’ll see these options:

A close up of a map

Description automatically generated

If you incur expenses on behalf of customers, be sure you will be reimbursed for them by adding a Billable column on expense and purchase forms.

To add a Customer column to expense and purchase forms, click in the first box pictured in the image above. To Make expenses and items billable, click in the second box and add a default markup rate if you want. Do you want to Track billable expenses and items as income? If you’re not sure, ask us. And if you’ve set up sales tax in QuickBooks and want to add that to billable items, check that box, too. When you’ve finished with these and the other questions under Bills and expenses, click Save.

Now is the time to focus on the importance of cash flow and vendor relationships by maintaining good vendor payable records. You want to keep your relationships with your suppliers in good status. If you’re having trouble tracking cash flow or dealing with any other element of your accounting (or QuickBooks itself), please do contact us. We want to support you through this difficult period as much as we can.

Setting Up Sales Taxes in QuickBooks, Part 1

If your business is required to collect and pay sales taxes, you can use QuickBooks’ tools to help you meet those obligations.

Next to payroll, state sales taxes represent probably the most complex element of your accounting tasks. QuickBooks can help with the mechanics, but there’s a lot you need to learn before you can start charging and paying them. For example:

  • Is your company located in a destination-based or origin-based state where taxes are concerned (do you charge sales tax based on where your customers are or where you are)?
  • Certain types of items and services are exempt from sales tax. Are yours?
  • What local taxes (city, county, etc.) must you collect, if any?
  • How often must you submit what you owe, and to what agency?

If you don’t know your state’s rules, search for your Department of Revenue (sometimes called the Department of Taxation) on Google. Or talk to us about this whole complicated process. You can’t begin to work with sales taxes in QuickBooks until you know the answers to many questions.

First Steps

Once you know what your state’s rules are, you can start setting up the sales taxes you’re required to collect and pay. Open the Edit menu and select Preferences. Click on Sales Tax, then Company Preferences. Make sure the Yes button is highlighted next to Do you charge sales tax?, then click on Add sales tax item. You’ll see this window:

In states where it’s required, you may have to at least set up a state sales tax item in QuickBooks. You may also be responsible for local (city, county, etc.) taxes.

TYPE should already be set to Sales Tax Item. Enter a name for your tax in the Sales Tax Name field; the Description should automatically appear as Sales Tax. Type in the Tax Rate (%) and the name of the Tax Agency that will collect it (select <Add New> if it’s not there already). Click OK to return to Company Preferences and continue to define additional tax rates. If there is a sales tax item you use frequently, you can select it from the Your most common sales tax item field.

Tip: Each sales tax rate is considered an Item in QuickBooks. When you have to edit or delete one, open the Lists menu and select Item List. Type sales tax in the Look for box, then Search. Right-click on your target and select your desired action from the local menu that appears.

Sales Tax Groups

When you want to combine multiple sales taxes as one item (state, county, etc.), click Add sales tax item again in Company Preferences and choose Sales Tax Group. Enter a Group Name/Number and Description. In the table below, click the down arrow in the field in the TAX ITEM column. Keep selecting individual tax rates until you’re finished, then click OK. When you use one of these groups in a transaction, the customer will only see the total tax, but reports will break them down into their individual parts.

Completing Your Preferences

The bottom half of the Company Preferences screen needs more information.

It’s important that all the entries at the bottom of the Company Preferences screen are correct before you start working with sales taxes in QuickBooks.

The first two items here are simply field labels that will appear in transactions to indicate whether or not a line item should be taxed. You should leave them as is; they’re automatically created by QuickBooks. If you want to Identify taxable amounts as “T” for Taxable when printing, click in that box to make a checkmark.

Is your QuickBooks company file set up on a cash or accrual basis? Click on the button in front of the correct choice. WHEN DO YOU PAY SALES TAX is a question that will be answered as you’re learning about your state’s sales tax requirements. When you’ve completed this section, click OK.

Assigning Tax Codes

As you create item and service records in QuickBooks, you’ll be asked to indicate whether or not they’re taxable. The Tax Code field appears at the bottom of the window, like in the image below.

You’ll need to designate every item or service you sell as taxable or non-taxable.

There’s much more you need to know about collecting and submitting sales taxes, like how to work with transactions and reports. We’ll cover those topics next month. In the meantime, let us know if we can help you set up your QuickBooks company file for this complex task.