QuickBooks Tip: Setting Up Your Customer List Effectively

| 1 min read

QuickBooks Tip: Setting Up Your Customer List Effectively

Hopefully customers are lining up for your product or service, but now you need to figure out a way to manage them effectively.  The QuickBooks customer list may not seem like a big deal, but if set up improperly you may regret it later.  Entering a new customer into QuickBooks is a simple step that almost any new QuickBooks user can easily figure out.  However, by thinking about your customer list a little bit before entering them into QuickBooks you can save yourself a lot of time down the road.  You can access your customer list by clicking on the Customer Center button on the main QuickBooks icon bar.  Here is my advice on effectively setting up the customer database:

The Name

The customer name seems pretty straightforward right?  Let me offer this piece of advice: if you primarily sell to individuals enter the Customer Name field in this format: Last Name, First Name.  As your customer list grows you will be happy it is by last name and not first name.  If you primarily sell to businesses then enter your customers by business name. 

Enter all customer information from the very beginning

If you enter as much of the customer information as possible from the beginning you will have many advantages down the road.  You will be building a customer database that is functional.  Rather than looking through other programs for contact information, phone numbers, email addresses etc you will have everything in one database.  It makes sense to use QuickBooks as your customer information database if you will be using it as your billing software.  Also, by entering all the contact information from the beginning you will be able to take advantage of some other features that QuickBooks offers.

Email invoices and statements to reduce Accounts Receivable

By entering an email address for each customer you can quickly email invoices and statements directly from QuickBooks to your customers.  This is not only a healthy choice for the environment by reducing paper use, but this may also prove to be a healthy choice for your business.  I have found that by emailing invoices and statements the amount of money due from you customers decreases much faster than using other billing methods.  Your customers will be more likely to pay in a timely manner if you email them the bills.  Using the email function from QuickBooks also makes it easy to send follow up reminders on overdue invoices and balances.  You can get a more detailed explanation on emailing invoices and statements from QuickBooks here.

If you have any questions on setting up an effective customer list or any other QuickBooks questions feel free to email me

Click me



An Affordable Bookkeeping Alternative to a CFO

Outsourcing your bookkeeping is more affordable than you would think. We save you money the moment you hire us by cutting out the expensive cost of hiring an in-house CFO.

Working with a remote bookkeeping service will still provide you with all the value you could get from an in-office bookkeeper but at a fraction of the cost.

Learn more

Learn How We Can Impact Your Business Growth

You’ve got your company’s best interest in mind. Guess what? So do we! You can rest assured that we will work closely with you to create actionable business plans and accurate financial reporting. We offer our toolkit of financial intelligence that will be your greatest asset for business growth.

Contact an Advisor