Skip to content
Tutorials Center
My learning

Topics

Lesson 15 of 36 ยท Vendors, Bills and Expenses

QuickBooks Vendors: Records, Terms and 1099 Tracking

Manage the QuickBooks vendor list: add vendors, payment terms, default expense accounts, import and merge, track 1099 contractors, collect W-9 data and review vendor balances.

A vendor is anyone you pay: suppliers, landlords, utilities, contractors, the tax agency. Vendor records feed bills and expenses, drive accounts payable and, for US businesses, support year-end 1099 reporting. This lesson opens the money-out chapter with vendor setup and contractor tracking.

The vendor list

Go to Expenses > Vendors (or gear > All lists > Vendors). The top bar summarizes purchase orders, unbilled expenses, overdue and open bills. Click a vendor to see its bills, expenses, checks, purchase orders and credits, with a New transaction menu.

Add a vendor

  1. New vendor.
  2. Enter Name (a unique display name), Company, contact fields, e-mail and address.
  3. Enter Account no. if the vendor assigns you a customer number (useful when matching statements).
  4. Choose Terms such as Net 30; they set the due date on bills.
  5. Set Default expense category to the account most of this vendor's bills use, such as Utilities for the electricity company. It fills in on new transactions.
  6. Enter Business ID no. (tax ID) and tick Track payments for 1099 if the vendor is a contractor.
  7. Save.

Add the vendor's Account no. and billing rate (cost per hour) where useful, and attach contracts. A tidy vendor page turns month-end questions into a quick look.

Import and merge

Use gear > Import data > Vendors with the sample spreadsheet for bulk loads. As with customers, merge duplicates by renaming one record to exactly match the other. Make unused vendors inactive instead of deleting them if they have transactions.

1099 tracking (US)

In the United States, a business generally reports payments of 600 or more (the threshold changes; confirm the current figure with the IRS) in a year to unincorporated contractors on Form 1099-NEC, and some other payments on 1099-MISC. QuickBooks helps by tracking the totals:

  1. In Account and settings or the vendor record, tick Track payments for 1099.
  2. Record the vendor's tax ID (SSN or EIN) and mailing address, ideally from a Form W-9 the contractor gave you. Never ask for the form by e-mail unencrypted.
  3. Pay with a method QuickBooks recognizes. Payments made by credit card or through third-party networks (such as PayPal) are reported by the processor on Form 1099-K, so do not include them on your 1099-NEC. QuickBooks reports bill payments, checks and expenses paid by cash or bank transfer.
  4. Make sure each payment is categorized to an account mapped to a 1099 box (the 1099 settings let you map accounts to boxes, and you can exclude accounts such as reimbursements).

At year end open Expenses > Vendors > Prepare 1099s (the exact path can differ by version): confirm company details, verify vendors, map accounts to boxes, review the 1099 Transaction Detail Report and then e-file or print.

Other countries have different contractor and withholding rules. The QuickBooks mechanics (vendor tax IDs, payment tracking, annual summaries) are similar, but ask your accountant what you must file locally.

Vendor reports

  • Reports > Who you owe > A/P Aging Summary or Detail: bills by age.
  • Vendor Balance Summary and Vendor Balance Detail.
  • Expenses by Vendor Summary: how much you spend with each supplier.
  • Open Purchase Order List (see purchase orders).

Stand-in: vendor payments and the 1099 threshold

The stand-ins simulate the year-end check: which vendors reached the reporting threshold using reportable payment methods only.

Python Stand-in: which vendors need a 1099?

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Python Stand-in: payment terms and due dates

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What does the vendor's Terms setting control?

    Terms such as Net 30 set the due date on that vendor's bills.
  2. 2. A contractor is paid by credit card. How is that payment usually reported?

    Card and third-party network payments are reported by the processor, not on your 1099-NEC.
  3. 3. Which form collects a contractor's tax ID and name?

    A W-9 is the request for taxpayer identification you keep on file.
  4. 4. What is the Default expense category on a vendor for?

    It saves time and keeps categorization consistent.

Summary

  • Vendor records hold terms, tax ID, account number and default category.
  • Import, merge and inactivate vendors like customers.
  • Track 1099 vendors with a W-9, map accounts to boxes and know that card payments go on 1099-K.
  • Use A/P aging and vendor balance reports to see what you owe.

Next: Bills and bill payments