Welcome to the Fit Small Business Xero training course! In this lesson, we’re going to cover how to set up customers in Xero.
You can follow along on your own Xero account. If you don’t have one already, click here to sign up for a free 30-day trial. Fit Small Business readers also receive 50% off their first three months if they decide to subscribe.
To complete this lesson, you can either watch the video below, read through the step-by-step instructions, or do both. Let’s begin!
For some small business owners, Xero will provide enough tools to handle their books all on their own. But, for many, it makes sense to use Xero in conjunction with experienced small business accountants who are also Xero experts, like those at Bookkeeper360.
Bookkeeper360 can handle your monthly bookkeeping, payroll, new employee paperwork, taxes, and more. Basic plans start at $249/month. Get your first consultation free.
Why Is It Important to Set up Customer Contacts
If you’re converting from another accounting software to Xero, then you know how much time you can save by having access to your customer contact details like contact person, email address and telephone number all in one place.
Beyond contact details, you can setup custom payment terms (i.e. Net 30) and special sales tax rates if your default settings do not apply to a specific customer. Xero also has a couple of great sorting tools called “smart lists and “groups” which can help you save time when invoicing customers or setting up email marketing campaigns. We will chat more about both of these later on.
In this lesson, we will focus on how to set up customer contacts manually. However, if you have an existing customer list that you would like to import into Xero then check out our How to Import Customers lesson. Once you have imported your customer list, you can come back to this lesson to learn how to modify your customer information.
How to Add a Customer Contact
In Xero, anyone who pays you money is considered a “customer” contact. Anyone you pay money to is considered a “supplier.” Based on the type of transaction (i.e. invoice, bill, credit note), Xero will automatically group your contacts as customers, suppliers or both. For example, if you purchase products or services and sell products and services to the same company, they will be set up as both a supplier and a customer contact in Xero.
Although customers and suppliers are added under the same menu, there are different fields you need to focus on for each. If you want to add suppliers, we cover that here.
To add a customer contact, follow the steps below.
Step 1 – Navigate to the Contacts menu and select Customers as indicated in the screenshot below.
Step 2 – Click the “Add Contact” button as indicated in the screenshot below.
Step 3 – Complete Customer Contact Information
This screen is broken up into 2 parts: contact information and financial information. We will cover contact info first. In the screenshot below, we have highlighted the key contact info fields to complete for your customers along with a brief description of each.
- Contact Name – Enter your customer’s name in this field.
- Account Number – If you assign a unique number to each customer to identify them, enter that information in this field. This number can be alphanumeric.
- Primary person – Enter the name and email address of your primary contact in this field. If you have more than one contact, click the “Add another person” link directly below this field to add additional contacts.
- Phone/Fax/Mobile – Enter the telephone number, fax number and cellphone numbers for your customer in these fields.
- Skype Name/Number – Enter the skype id of your customer. This is ideal to have if you plan to communicate with your customer via Skype.
- Website – Enter the customer’s website info in this field, if applicable.
- Postal Address – Enter the mailing address where the customer would like to receive their invoices and other correspondence from you.
- Street Address – Enter the physical address of where the customer is located. This information is important when it comes to calculating sales tax. In the How to Set Up Sales Tax lesson,we discuss how to properly set up sales tax.
Note: While it might seem time consuming to enter this information now, it’s important to set aside the time to do this because this data will be used for email templates, reports, any apps that you add-on from the marketplace and a variety of other tasks.
Step 4 – Complete Financial Details
In Xero, the setup screen for customers and suppliers is identical. For the purposes of this lesson, we will only focus on the fields that would relate to customers only. The fields that are related to suppliers will be discussed in the next lesson, How to Set Up Suppliers.
In the screenshot below, we have highlighted the financial details fields to complete for your customers along with a brief description of each.
Note: Any information that you enter here will be default settings for your customer. However, you can override them if needed when you create invoices, quotes, or credit notes for your customers.
- Sales Settings – From the dropdown menu, you can select from one of the following tax options:
- Tax inclusive – This option will include tax for each taxable item on invoices and credit notes that you create for customers.
- Tax exclusive – This option will show tax separately on invoices and credit notes (or purchase orders) that you create.
- No Tax – Select this option if you are not required to charge your customers sales tax.
- Default account – From the dropdown menu, you can assign a default account that will be used on all sales transactions that you create for this customer (i.e. invoices, credit notes). I recommend that you leave this field blank unless the product or service that you sell to the customer is always the same.
- Default Tracking category – Xero allows you to setup tracking categories that will allow you to see how different areas of your business are performing (i.e. departments, locations or regions). From the dropdown menu, you can assign a default tracking category for customer contacts; in the screenshot above region has been set up as a tracking category.
- Tax – Generally, you would need to keep your supplier’s tax id number (and not your customer’s) on file for 1099 reporting. However, if for some reason you do need to keep your customer’s EIN or social security number on file, you can enter that information in this field. Otherwise, you can leave it blank.
- Tax on Sales – From the dropdown, select the appropriate tax rate for the customer. If you have not set up sales tax rates, head over to the How to Set Up Sales Tax lesson to learn how to track and manage sales tax. If sales tax is not applicable, select the default rate (Tax on Sales 0%).
- Sales Discount % – If a customer should receive a discount on everything that they buy, you can enter the discount in this field to ensure that it is applied to every transaction created for the customer.
- Invoices Due Date – In the How to Set Up Organization and Financial Settings lesson, we set up default due dates for all invoices. If you have special payment terms for a customer that are different from the default payment terms, then you need to set those payment terms up here to override the default payment terms.To do this, you can select from the following 4 options:
- XX days (or day) of the following month
- XX days (or day) after the bill date
- XX days (or day) after the end of the bill month
- XX days (or day) of the current month
- Xero Network Key (Known as Xero to Xero) – This is a unique and private network key that is assigned to each organization. By entering the Xero network key for a customer, you will be able to send (and receive) invoices and bills directly into your Xero account. You can find step by step instructions on how to send a Xero Network invite to another Xero user here.
How to Edit a Customer Contact
Once you have added a new customer contact, you can make changes to the contact and financial information at anytime. Follow these steps to edit an existing customer contact.
Step 1 – Navigate to All Contacts
From the contacts menu, select all contacts and the following screen will display. In this screen, you can see the contact details of the customer in the first two columns. The last two columns will show your current accounts payable balance (you owe them) and your current accounts receivable balance (they owe you).
Step 2 – Select the customer to edit
From the customer list, click on the customer that you want to make changes to as indicated in the screenshot below.
Step 3 – Update customer information
From this screen, you can easily view all of the contact and financial information all in one screen. Select the “Edit” button as indicated below, make the necessary changes and save your work.
How to Archive and Restore Customer Contacts
Once you set up a contact in Xero, you cannot delete it. However, you can archive a customer that you no longer plan to do business with. When you archive a customer, you will still be able to view the customer and any transactions that have been created; however, you will not be able to create any new transactions for that customer.
The good news is that if you decided to resume business with the customer, you can easily restore the customer contact so that it can be used again. Let’s walk through the steps to archive a customer contact and then we will also show you how to restore a customer contact that was previously archived.
Archive Customer Contact
Follow the steps below to archive a customer contact.
Step 1 – Select the customer to Archive
From the customer list, put a checkmark in the box to the left of the customer that you want to archive as indicated in the screenshot below.
Step 2 – Select Archive
Click on Options and then Archive as indicated in the screenshot below.
Step 3 – Confirm that you want to archive the customer contact.
As indicated in the screenshot below, click on the Archive button to proceed or click cancel if you have changed your mind.
Restore Customer Contact
Follow the steps below to restore a customer contact that was previously archived.
Step 1 – Navigate to Archived Group
From the contact list menu, you will see a group entitled Archived as indicated in the screenshot below. Click on that group to display the contacts that have been archived.
Step 2 – Select customer contact to restore
From the customer list, click on the customer that you want to restore as indicated in the screenshot below.
Step 3 – Select Restore
Click the Restore button in the upper right hand corner as indicated in the screenshot below.
Step 4 – Confirm Restore
The following screen will appear. You can click restore to proceed or cancel if you have decided not to restore the customer contact.
Smart Lists and Groups
After you have saved all of your customers into Xero, you can sort them using smart lists and groups. Among other benefits, this allows you to:
- Gain insight to additional products or services that you can offer your customers
- Stay on top of outstanding customer invoices and payments
- Create a list of customers who live nearby
- Segment your customers for marketing promotions
Let’s take a look at how smart lists and groups can help you get the most out of your customer contact info.
A smart list is created by selecting criteria to filter your contacts and automatically add to a list. For example, you can create a filter based on inventory items purchased, outstanding customer invoices or geographical location of your customer. Here are the searches that are already set up in Xero; or you can create your own.
- Customers who have bought an inventory item.
- Customers who have had invoices outstanding for more than 30 days.
- Customers who have had invoices overdue for more than 7 days.
- Customers who have paid you in the last year.
Example: Let’s say our fictitious company, Acme Web Pros Plus would like to know which customers they have had an initial consultation with in the last 30 days. They can run the customers who have bought an inventory item search and select initial design consultation as the inventory item. These search results can be exported to your email marketing program to send specialized promotional emails. Xero allows you to export contacts directly to Constant Contact or another email marketing program using a .csv file.
To access Smart Lists, follow the steps below.
Step 1 – Navigate to Contacts.
From the Contacts menu, select Customers as indicated in the screenshot below.
Step 2 – Locate Smart Lists
On the left-hand side of the contacts list, you will see Smart Lists as indicated in the screenshot below. You can select one of the four searches we discussed earlier or click the New link to create your own.
Step 3 – Export Search Results
In the screenshot below, we have run the “have purchased an item” search. You will find a brief description of each section below.
- Search Criteria – To continue with our previous example, in this section we have set our conditions for this search to all customers that have purchased a website. Since we have set up website as an inventory item, we are able to track our website sales in Xero. In our setting up products and services lesson, we discuss the importance of setting up inventory items and we show you how to do it.
- Search results – A total of 3 customers have purchased a website from Acme Pros Plus.
- Export options – As discussed, you can export these results to a CSV file or directly to Constant Contact. While Constant Contact is a pre-installed integration, you can also check out the Xero App Marketplace, which offers 500 additional integrations with a wide range of business software.
While SmartLists are used to create targeted customer lists that you can export out of Xero, Groups offer a way to organize both customer and supplier contacts within Xero. For example, you can create a group for customers who are on a monthly billing cycle. If these customers are also billed the same amount then you could also create an invoice for each contact in a group.
Step 1 – Navigate to Groups
On the left-hand side of the contacts list, you will see Groups as indicated in the screenshot below. You can create a new group by clicking on the New link.
Step 2 – Create a new contact group
Enter the name of the group and then click the “Save” button as indicated in the screenshot below.
Step 2 – Add customer contacts to the group
In the customer contact screen, put a checkmark in the box to the left of each customer that you want to add to the new group; click the dropdown next to options and select Add to Group as indicated in the screenshot below.
NOTE: You can also add the contacts from a smart list to a group as indicated in the screenshot below:
That wraps up the section on how to set up customers. The next lesson in our Xero Training Course will be how to set up suppliers. In this lesson, we will walk you through how to set up contact and payment information for suppliers. To access this lesson or any of the others in the series, click here. For a free 30-day trial of Xero, click the button below.