FitSmallBusiness
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes
  • BE A PARTNER
  • WORK AT FSB
  • About
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes

Accounting | How To

How To Set Up Vendors in QuickBooks Online

Tim Yoder, Ph.D., CPA

REVIEWED BY: Tim Yoder, Ph.D., CPA

Tim is a Certified QuickBooks Time (formerly TSheets) Pro, QuickBooks ProAdvisor, and CPA with 25 years of experience. He brings his expertise to Fit Small Business’s accounting content.

 

WRITTEN BY: Mark Calatrava

Published May 15, 2023

Mark has researched and reviewed accounting software at Fit Small Business since 2019 and has developed an extensive knowledge of accounting software features and how unique business needs determine the best accounting software.

Published May 15, 2023

This article is part of a larger series on Accounting Software.

Learn More With Our QuickBooks Online Course
Explore the chapters in the guide.
  1. How to Set Up QuickBooks Online
  2. Part 1: Setting Up QuickBooks
    1. How to Set Up Company Information
    2. How to Customize Invoices, Sales Receipts & Estimates
    3. How to Set Up Invoices, Sales Receipts & Estimates
    4. How to Set Up Products and Services
    5. How to Set Up Messages
    6. How to Set Up Statements
    7. How to Set Up Expenses
    8. How to Set Up Advanced Settings
  3. Part 1: Setting Up QuickBooks (Cont.)
    1. How to Import Bank Transactions
    2. How to Import Credit Card Transactions
    3. How to Set Up Multiple Users
    4. How to Set Up the Chart of Accounts
    5. How to Set Up the Products and Services List
    6. How to Set Up Customers
    7. How to Set Up Vendors
  4. Part 2: Managing Sales and Income
    1. How to Create Estimates (Quotes or Bids)
    2. How to Create and Send Invoices
    3. How to Receive Payments
    4. How to Create & Send Sales Receipts
  5. Part 3: Managing Bills and Expenses
    1. How to Write & Print Checks
    2. How to Enter Bills
    3. How to Pay Bills
  6. Part 4: Managing Banking Transactions
    1. How to Enter Banking Transactions Manually
    2. How to Manage Downloaded Banking Transactions
    3. How to Record Bank Deposits
    4. How to Transfer Funds Between Bank Accounts
    5. How to Handle Bounced Checks From Customers
    6. How to Process Bank Reconciliation
  7. Part 5: Managing Business Credit Card Transactions
    1. How to Enter Business Credit Card Transactions Manually
    2. How to Manage Downloaded Business Credit Card Transactions
    3. How to Enter a Credit Card Refund
    4. How to Reconcile Business Credit Card Accounts
  8. Part 6: Managing Credit Card Sales
    1. How to Manage Credit Card Sales With QuickBooks Payments
    2. How to Manage Credit Card Sales With a Third-party Credit Card Processor
  9. Part 7: Set Up and Manage Payroll
    1. How Set Up and Run Payroll
    2. How to Manage Payroll Tax
    3. How to Add Historical Payroll Data
    4. How to Set Up Automatic Deposits
    5. How to Print Payroll Checks
    6. How to Run Payroll Reports
    7. How to Reconcile Payroll Liabilities
  10. Part 8: Reporting in QuickBooks Online
    1. How to Run a Profit and Loss Statement
    2. How to Run a Balance Sheet Report
    3. How to Run a Statement of Cash Flows
    4. How to Run an A/R Aging Report
    5. How to Run an A/P Aging Report

In this tutorial, we’re going to teach you how to set up vendors in QuickBooks Online. We’ll show you how to add vendors manually and import vendor information from an Excel, comma-separated values (CSV), or Google Sheets file. You will also learn how to inactivate a vendor if you’re no longer doing business with them.

We hope our free QuickBooks Online courses, including this one, help you understand how to use the platform better. If you want to try it before committing to any plan, you can sign up for a 30-day free trial. If you purchase right away, you’ll get 50% off for three months.

Visit QuickBooks Online

When setting up vendors in QuickBooks Online, you only need to enter their names to save their records. However, it’s best to gather as much information as possible about your new vendors, including the following:

  • Company name
  • Contact name
  • Address
  • Email address
  • Phone numbers
  • The rate you pay to service vendors
  • The rate you charge your clients for service vendors’ work
  • The amount you owe the vendor prior to the start of using QuickBooks
  • Employer identification number (EIN)

Ensure that your vendor list is either in an Excel, CSV, or Google Sheets file. If you’re currently using a different program to manage your vendors, you can save a lot of time by exporting your vendor information from that program, which we will discuss in the later part of this tutorial.

Tip:

It’s often better to import a vendor list into QuickBooks Online when you have a large number of vendors to add as it can save you time and reduce the risk of errors compared to adding them manually one by one.


Navigate to the Vendor Center by clicking on Expenses and then Vendors from the left menu bar, as shown below.

Steps showing how yo navigate to the vendor center in QuickBooks.

Navigate to the Vendor Center in QuickBooks Online

Seeing a different left-side navigation menu?

  • 1. Check User View
  • 2. Switch to Accountant view

QuickBooks has two user views: Business View and Accountant View. Your left-side navigation menu may look different depending on the user view you are in.

If your sidebar menu is not what is shown in our tutorial, it means that you are on Business View. We prefer and recommend using the Accountant View because it shows a full range of business accounting features and tools that you can use in QuickBooks.

To verify whether you’re using the Business View, click on the cog wheel at the top right-hand corner of your QuickBooks dashboard, and check whether the button on the lower right-hand says Switch to Accountant view, as shown below. If so, then it means you are on Business View.

Screen showing where to verify whether you are using the Business View or Accountant View in QuickBooks Online

Verify whether you are using Business View or Accountant View in QuickBooks

Once you verify that you are on Business View, click on Switch to Accountant view to update the appearance of your sidebar menu. In a few seconds, you should see the same left-side menu bar illustrated in this tutorial.

Steps showing how to switch from Business View to Accountant View in QuickBooks Online

Switching from Business View to Accountant View in QuickBooks


Click the green New vendor button in the upper right-hand corner of the Vendor Center to enter vendor information manually.

Vendor center in QuickBooks highlighting the New vendor button.

Create a new vendor in QuickBooks Online


On the new vendor screen, enter as much information as possible for your vendor. To help you understand how to complete the new vendor form better, let’s use a sample scenario.

Paul’s HVAC works with a new vendor, Spiral HVAC Pipes & Supplies, a company that supplies pipes and duct products. The company gathered all the vendor information ahead of time and wants to add the new vendor in QuickBooks.

The GIF below shows how the vendor form is completed based on our example.

New vendor set up form showing how it's completed based on a sample vendor.

Vendor profile information in QuickBooks Online

Below are some of the important fields in the new vendor setup form:

Name and Contact

  • Name: Provide the company name and the name of your contact person. In our example, the new vendor is recorded as Spiral HVAC Pipes & Supplies.
  • Vendor display name: This field will populate automatically based on the information entered in the company name field but can be changed if you wish. This is how your vendor will show up on your vendor list in QuickBooks.
  • Contact information: You can enter all the vendor’s contact information for easy future reference. You may add their email address, phone and mobile numbers, and even their website address.
  • Name to print on checks: When you write checks to pay vendor bills, the payee information will come from here. Type the payee name here if it’s different from the vendor name.

Address

This should be the address where you need to mail your vendor payments. You’ll be asked to enter the street name, city, state, ZIP code, and country.

Notes and Attachments

  • Notes: You can add notes to enter additional information in your vendor reports.
  • Attachments: Vendor documents, such as contracts, Form W-9, or proof of insurance, can be dragged and dropped to this screen to attach them to the vendor information screen for easy reference.

Additional Information

  • Taxes: Enter the vendor’s business ID number or Social Security number and check the box for Track payments for 1099 to indicate you must provide this vendor with a Form 1099. If needed, you can check out our guide on how to prepare and file Form 1099.
  • Expense rates: This is the amount that the vendor charges you for their services on an hourly basis. Not all vendors will have an hourly billing rate. If a vendor charges a flat fee for their services, or if you have negotiated a different billing arrangement with them, you can leave this field blank.
  • Payment terms: This is where you can specify the payment terms that you have agreed to with the vendor. For example, if you agreed to pay the vendor within 30 days of receiving their invoice, you should select Net 30. In our guide on how to set up expenses in QuickBooks Online, we cover setting up default payment terms for all vendors. Here, you can change the default payment term for any vendor.
  • Account number: Input your account number with the vendor to print it on all checks automatically.
  • Default expense category: This is where you can specify the default expense category that should be used when entering transactions for this vendor. For instance, in our example, since it’s a pipe supplier, you can assign a default expense category like “Materials & Supply.”
  • Opening balance: A vendor’s opening balance is the amount you owe the vendor for periods prior to your QuickBooks Online start date for which you won’t be entering invoices. This is common if you’re transferring from different bookkeeping software. You’ll be able to apply future payments to the vendor against this opening balance.

Click the green Save button to record the new vendor.


The new vendor will now appear in the Vendors Center. Click on the vendor’s name to go to the vendor information screen. In the screenshot below, we can see the new vendor that we just set up is now in the Vendors Center. Click on the vendor’s name to open the transactions list and vendor details.

Vendor center in QuickBooks highlighting a sample vendor that is recently added to QuickBooks.

View vendor in QuickBooks Online

Within the vendor information screen, click the Edit button in the upper right corner if you wish to make any changes to the vendor information.

Vendor details screen highlighting the Edit button in QuickBooks.

View and edit vendor details in QuickBooks Online

The new vendor setup form you previously used will show up, and you can make any changes you wish to make. Click the Save button once done.


How To Import Vendor Information Into QuickBooks Online

Step 1: Prepare Your Spreadsheet

First, make sure your file is in the correct format. You can use an Excel, CSV, or Google Sheets file, but it must meet certain requirements. Your file should have a header row that lists the column names, such as vendor name, address, and phone. Each column represents a field that you wish to import into QuickBooks Online, and each subsequent row should contain the vendor information for one vendor.

The following fields are available for import, but you may choose to import only a few of them:

  • Company name
  • Contact name
  • Email address
  • Phone number
  • Mobile number
  • Fax number
  • Website
  • Street
  • City
  • State
  • ZIP code
  • Country
  • Opening balance
  • Opening balance date
  • Tax identification number (TIN)

The first row in your spreadsheet should be a label for each column, but the labels don’t have to correspond to the exact field names in QuickBooks Online. You’ll have the opportunity to map each of your columns to one of the fields listed above during the import process. It’s OK if you’re missing columns for fields that you don’t want to import.

Use only the first tab.

Only the first tab or worksheet within an Excel or Google Sheets file will be imported, so make sure your vendor information is on the first tab.

Here is a worksheet with some of the basic fields included:

Sample vendor list created in an Excel format.

Vendor worksheet for import into QuickBooks Online

Step 2: Navigate to the Import Screen

Navigate to the Vendor Center by clicking on Expenses and then Vendors in the left menu bar. Select the drop-down menu next to New vendor and select Import vendors.

Steps showing how to navigate to the Import vendors feature in QuickBooks Online.

Select Import vendors in QuickBooks Online

Step 3: Select the File to Upload

If your vendor list is in an Excel or CSV format, click on the Browse button under the Select a CSV or Excel file to upload section. If you’re uploading a Google Sheets file, click on the Connect button under Select Google Sheet.

Import Vendors screen where you can locate a file to upload into QuickBooks Online.

Select Excel or Google Sheets file to import into QuickBooks Online

Step 4: Map Your Data

In this screen, you must assign each column in your spreadsheet to the correct QuickBooks Online field.

Screen where you can map QuickBooks Online fields to those in your spreadsheet.

Map your spreadsheet columns to QuickBooks Online fields

The left column is the QuickBooks Online fields available for import. The right column provides a drop-down box to select the column from your spreadsheet to assign to the corresponding QuickBooks Online field. QuickBooks Online will make a selection automatically if one of your column headers matches the QuickBooks Online field. However, these are only suggestions, and you can change them as needed.

It’s OK if your spreadsheet has extra columns. The only columns that will import into QuickBooks are the columns you match to a QuickBooks field. You also don’t have to have a column for each QuickBooks field. You can indicate No Match for the fields that you don’t have a matching column.

Step 5: Review and Import Your Data

This is where you can perform a final review of the data that will be imported into QuickBooks Online. Be sure to verify that the number of records agrees with the number of rows in your spreadsheet, minus one for your header row.

If the mapping isn’t right, click the Back button to go back and make any necessary changes. You can change any vendor information on this screen if you wish. Deselect any records that you don’t want to be imported.

Select Import in the lower right-hand corner once you’re ready to proceed.

Screen where you can review mapped vendor data before importing them to QuickBooks Online.

Review vendor data before importing it into QuickBooks Online.

Once the import is complete, you’ll receive a message that the import is successful. You can now view the imported vendors in the Vendor Center.

How To Delete a Vendor in QuickBooks Online

You cannot delete a vendor once you have used them in a transaction. For example, once you have created a check to pay a vendor, that vendor cannot be deleted. However, the vendor can be made inactive so that they don’t appear in the Vendor Center.

Tip:

You should consider inactivating a vendor when you no longer do business with them or when their services are no longer needed. Inactivating a vendor essentially removes them from your active vendor list but keeps their historical transactions and information for reporting purposes.

Navigate to the Vendor Center by clicking on Expenses then Vendors in the left menu bar. Locate the vendor you wish to make inactive, and then click on the vendor’s name. Next, click on the small dropdown arrow next to Edit, and then select Make inactive.

Vendor center showing how to make a vendor inactive in QuickBooks Online.

Make a vendor inactive in QuickBooks Online

Vendors with an outstanding balance:

If you try to inactivate a vendor that has an outstanding balance, QuickBooks will give you a warning message and ask if it’s OK to make an adjusting transaction. You should answer No and then record the payment of the outstanding balance prior to inactivating the vendor. If you don’t plan to pay the outstanding balance, you should void the outstanding bills before inactivating the vendor.

Why Setting Up Vendors in QuickBooks Is Important

QuickBooks Online, our leading small business accounting software, makes it easy to enter a bill when you have vendors set up within the platform. Instead of inputting all the details of a bill, you can select the vendor from a drop-down list, and many of the fields will auto-populate.

Also, setting up vendors in QuickBooks can help you better manage and track your expenses. When you enter transactions for a vendor, QuickBooks automatically categorizes them based on the vendor’s default expense account, which can help you keep track of your spending. Additionally, you can run reports showing both the total amount spent and the items purchased from each vendor, helping you manage your cash flow more effectively.

Frequently Asked Questions (FAQs)

At the very least, you only need to enter the name of the vendor. However, it’s best to complete as many fields as possible to ensure that you have accurate and complete information about the vendor. Also, it can help you generate detailed reports about your expenses and cash flow.


Yes, you can import a list of vendors into QuickBooks from an Excel, CSV, or Google Sheets file. We recommend importing your vendor list if you have a large number of vendors to add in QuickBooks.


No, but you can inactivate a vendor if you no longer do business with them. This will remove the vendor from your active vendor list, but you can still view their information and transactions in your account.


A vendor and a supplier in QuickBooks are essentially the same thing. They refer to a person who or company that provides goods or services to your business.


Wrap Up

You now know how to set up vendors in QuickBooks Online. The next tutorial in our training course is how to create estimates in QuickBooks Online, which will cover how to create quotes and bids to send to customers.

← Previous Tutorial

Free QuickBooks Online Tutorials

Next Tutorial →

About the Author

Mark Calatrava

Find Mark OnLinkedIn

Mark Calatrava

Mark Calatrava is an accounting expert for Fit Small Business. He has covered more than 50 accounting software for small businesses and niche industries and has developed an in-depth knowledge of the important features of accounting software and how the importance of these features vary by business.

Fit Small Business

Facebook Twitter LinkedIn YouTube

Company

  • About Us
  • Editorial Policy
  • Careers

Partners

  • Work With Us

Contact Us

228 Park Ave S # 20702
New York, NY 10003-1502

info@fitsmallbusiness.com

Fit Small Business BBB Business Review

Facebook Twitter LinkedIn YouTube

© Fit Small Business 2023

California Privacy Rights | Privacy | Terms | Sitemap

Need Assistance with QuickBooks Online?
QB Live matches you with a personal bookkeeper!
Visit QuickBooks Live

Was this article helpful?

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

Please select at least one newsletter.