Skip to content
Tutorials Center
My learning

Topics

Lesson 8 of 36 ยท Customers, Invoices and Sales

QuickBooks Customers: Records, Sub-customers, Import and Statements

Manage the QuickBooks customer list: add customers and contacts, payment terms, tax status, sub-customers and projects, import from a spreadsheet, merge duplicates and send statements.

Every sale in QuickBooks belongs to a customer. A good customer record saves typing on every invoice, drives the right tax and terms, and gives you balances and history at a glance. This lesson covers creating customers, organizing them with sub-customers, importing lists, merging duplicates and sending statements.

Open the customer list

Go to Sales > Customers (or gear > All lists > Customers). The list shows name, company, phone, e-mail and open balance. A summary bar above it shows totals for estimates, unbilled activity, overdue and open invoices. Click a customer's name to open the customer page with a transaction list, notes, attachments and a New transaction button.

Add a customer

  1. Click New customer.
  2. Enter the Display name (must be unique and is how the customer appears in lists), company, first/last name, e-mail and phone.
  3. In Billing address enter the invoice address; tick Same as billing for shipping, or add a different shipping address.
  4. On the Payments tab set payment method, terms (for example Net 30), delivery method (print later, send later) and preferred language.
  5. On the Taxes tab choose Taxable or tax-exempt with reason (see sales tax setup).
  6. Add a Notes entry and attachments (a signed contract, a tax exemption certificate).
  7. Save.

Decide a naming convention before you have 200 customers: for example Company name for businesses and Last name, First name for people. A consistent convention makes search and merging reliable.

Customer types that matter later

  • Terms drive due dates and aging. A customer with Net 15 gets invoices due 15 days after the invoice date.
  • Opening balance at creation is a shortcut; for proper history enter open invoices instead (see opening balances).
  • Parent/sub-customer relationship (next section).
  • Currency (multi-currency plans): set once; it cannot be changed after transactions exist.

Sub-customers and projects

A sub-customer belongs to a parent: a business with several locations, or a client with several jobs. Edit or create a customer, tick Is sub-customer and choose the parent. Choose Bill with parent to put its charges on the parent's invoice, or Bill this customer to invoice it separately. Reports and the parent's balance roll up all children.

On plans with the Projects feature, a project is a special kind of sub-customer used to track the income, costs and time of one job (see the later projects lessons).

flowchart TD
    P["Parent: Harbor Hotels"] --> A["Harbor Hotels - Downtown"]
    P --> B["Harbor Hotels - Airport"]
    P --> C["Harbor Hotels - Renovation Project"]

Balances of the three children add up on the parent.

Import customers

For many customers, use gear > Import data > Customers (also reachable from the Customers page via the Import option). Download the sample file, fill columns such as Display name, E-mail, Phone, Billing address, Terms and Opening balance, upload, map columns, and review before importing. Clean the spreadsheet first: remove duplicates, fix phone formats and make sure names are unique.

Merge duplicates

If the same customer exists twice, edit one record and give it exactly the same display name as the other. QuickBooks asks whether to merge. All transactions move to the surviving record. It cannot be undone, so check both first. A customer with sub-customers can be merged only after their relationship is handled.

Inactive customers and deletion

Customers with transactions cannot be deleted, only made inactive (row action drop-down > Make inactive). They vanish from drop-downs but their history stays in reports. Use the Include inactive filter to see and reactivate them.

Statements

A statement summarizes a customer's open charges and credits over a period, more compact than separate invoices. Use + New > Statement, choose Balance forward, Open item or Transaction type, a date range and customers, and Preview then Send or Print. Statements suit customers with many small charges or an unpaid history.

Stand-in: searching, merging and statements

This pair of stand-ins imitates duplicate detection and the statement logic without touching real data.

Python Stand-in: spotting duplicate customers

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: a balance-forward statement

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 customer's Terms setting control?

    Terms such as Net 30 set the due date and therefore the aging.
  2. 2. Why can't you delete a customer who has transactions?

    Inactive customers disappear from lists but remain in reports.
  3. 3. How do you merge two customer records?

    Matching the display name triggers a merge, which cannot be undone.
  4. 4. What is a sub-customer useful for?

    Sub-customers separate jobs or sites while balances roll up to the parent.

Summary

  • Create customers with a unique display name, terms, tax status and address.
  • Use sub-customers (or projects) for locations and jobs; balances roll up.
  • Import lists from a cleaned spreadsheet; merge duplicates by matching names.
  • Make customers inactive instead of deleting; use statements for open balances.

Next: Products and services