Call 301-977-9389

Get Payroll QuickBooks® Payments Client Portal Get QuickBooks®

QuickBooks Bookkeeping

Your Experts in Everything QuickBooks®

  • Home
  • Bookkeeping
  • Payroll
    • Payroll Solutions
    • Payroll Demo
    • Form Downloads
    • Payroll Setup
  • Services
    • Troubleshooting for QuickBooks
    • Training on QuickBooks
    • Analysis of QuickBooks Data
  • Products
    • Accept Credit Cards
    • Enterprise Solutions by QuickBooks
    • Online, Pro & Premier by QuickBooks
    • Bill.com
    • Jill Recommends
  • Testimonials
  • Blog
  • About
    • Our Team
    • Getting Started with Us
  • Contact

By Jill Frillman

Using QuickBooks Online’s Customer Records

Your customers are your company’s lifeblood. Are you managing those relationships carefully? Here’s how QuickBooks Online can help.

If you’ve been in business long enough to remember tracking your customers manually, you probably remember what a nightmare it was. Maybe you had a card file and paper folders – and lots of sticky notes and calendar notations.

Unless you had an unusually effective organization system, it was probably difficult to find historical transactions when customers called with questions, for example, and you may have experienced cash flow problems because it was hard to keep up with invoices and statements and payments.

If you’re already using QuickBooks Online, you know those days are over. But have you explored all the customer relationship management tools available to you on the site?

Thorough Records

The core of any good customer-tracking system is a comprehensive set of individual profiles. QuickBooks Online offers thorough, flexible record templates for just that purpose. Click 

Sales in the main toolbar, then the Customers tab at the top of the screen. To create a new customer record, click New Customer off to the right to open the Customer Information window.

Note: If you have your customer database in an existing Excel or .CSV file, you should be able to import it. QuickBooks Online provides instructions for this.

You’ll need to enter a lot of the information yourself here, mostly contact details. A down arrow next to a field indicates that there’s a drop-down list of options available.

The lower left quadrant of the screen contains a series of tabbed information windows. Click on each to enter what you can about each customer’s:

  • Address – both billing and shipping
  • Notes – any that you’d like to enter
  • Tax info – exemption details and default tax code (if taxable)
  • Payment and billing – preferred payment and delivery method, payment terms, and opening balance
  • Attachments – any files pertaining to this customer that you want to include

When you’re done, click Save. Your new record will appear in your list of customers. You’ll be able to toggle back and forth between the details you just entered and a list of their transactions.

Working with Customers

You can always add new customers as you go along, but it’s a good idea to enter records for all of them before you start creating transactions. It will save time down the road, and their accessibility will help with other accounting tasks.

When you click on Sales | Customers now, you’ll see something like this:

The Customers page consists of many elements. The main section displays a table of your customers. Click on one to open the page containing the Transaction List and Customer Details.

On this screen, though, you’ll only see columns for Customer/Company, Phone, Open Balance, and Action by default; click the gear icon in the upper right if you want to include more columns here. When you click on the down arrow next to a field in the Action column, a drop-down list will display the options available for that customer, like Receive payment, Send reminder, and Create Statement.

A series of colored bars runs across the top of the screen. Each represents the current status of a specific transaction type: Estimates, Unbilled Activity, Overdue, Open Invoices, and Paid Last 30 Days. Click on any of these to open a list of pertinent transactions.

You can do all of these activities elsewhere in QuickBooks Online, but it’s convenient to be able to work directly from the Customers screen, too. The fewer clicks, the better.

Call on Us

Did you make a resolution to start using QuickBooks Online this year? The site was built for use by business managers, not accountants, but it can still be a little daunting at first. We’re always available to take your questions and help you with setup and/or daily implementation. 

Connect with us if you need assistance.

SHARE THIS ARTICLE

Filed Under: Bookkeeping Tips, QuickBooks

Form Downloads

Form W-4 (2020)
Form W-9
Virginia Form VA-4 (2018)
I-9
I-9 Instructions
MW507
Employee Authorization for Direct Deposit
Employee Information Sheet

Top 100 ProAdvisor 2018 - Insightful Accountant Logo
Certified Profit First Professional

Bill.com Expert QuickBooks Desktop Certified ProAdvisor QuickBooks Advanced Certified ProAdvisor QuickBooks Enterprise Certified ProAdvisor QuickBooks Online Certified ProAdvisor Intuit Premier Reseller
TSheets Pro Certified Logo

Client Portal

Is Your Business Leaking Money?

Want to Know the Top 10 Money Leaks in Your Accounting System?

 

You'll also receive our free newsletter full of QuickBooks® and Business tips.

Privacy: We never rent, sell, or share your information to anyone.

Save Money on Checks and Forms

Checks for Less

Stay In Touch

Search Blog Archives

Top 100 ProAdvisor 2018 - Insightful Accountant Logo
Certified Profit First Professional

Stay In Touch

Client Portal

Save Money on Checks and Forms

Checks for Less

© Copyright 2025 Bookkeeping Etc., Inc., 23 Firstfield Rd. #3091, Gaithersburg, MD 20878 · All Rights Reserved


Serving QuickBooks® Clients Throughout the U.S.


Jill Frillman | Bookkeeping Etc., Inc. | BookkeepingEtcInc.com | 301.977.9389


Accounting, Bookkeeping and Payroll solutions for service based businesses in but not limited to Maryland, DC, Virginia, Texas, Michigan, Arizona, Florida, West Virginia, Georgia and Ohio.

Terms and Services