- Create records for customers to save time when creating transactions.
- Save details about the people or businesses that you regularly do business with.
- Keep track of who owes you money and to whom you owe money.
Import your customer details
Import from CSV file
Consider importing customer records if you already have the details somewhere else. Just export them to a CSV file (type of Excel spreadsheet) and import all the details in one go.
You can import additional new contacts at any time.
Import from mobile phone
If your customer details are in your mobile phone contacts, consider importing them using our mobile app.
Download the mobile app:
Open the mobile app and from the menu choose Contacts. Select the plus button, then choose Import from phone.
From the list of contacts in your phone, choose the ones to import.
Once you've imported your contacts, edit them in the mbile or web app to enter additional details.
Create new customers
For one off customers, or if you don't want to import them, create new customer records from Contacts.
From Contacts, choose Customers, then New Customer.
Enter the details. You can save a customer record with just a name and then enter more details later.
See the following sections for more about the details stored on customer record and how it is used.
If you don't know all the details yet, just enter the business name and save. All other details can be entered later. You'll always need an address before you save can an invoice for a customer.
- From Contacts, choose Customers, then select New Customer.
Enter the person's name or the business name in the Business Name field.
For a business, enter the business name here and then the name of the primary contact person as the Contact Name.
- Enter the rest of the contact's details. If your contact has an account number, enter it in the Reference field.
- Email address - this the email address that your invoices and statements are sent to by default.
- Enter the businesses main address on Account details tab. This is the address that will appear on any invoices or statement you send.
- For customers outside the UK or Ireland, chose the appropriate region from the UK & Ireland drop-down, then specify the Country at the end of the address.
If you don't have an address for a customer, just use No address on the first line.
If the business has a different delivery address, add this on the Delivery Address tab. Clear the Same as invoice address checkbox first.
You can add more delivery addresses once you save the customer record. When you create an invoice, just choose which delivery address to use.
If your customer is VAT registered, you'll need to enter their VAT registration number to make sure the correct VAT rate is used when entering invoices.
From the Account Details tab
Enter the VAT number for the customer. We check the VAT number against the Country entered in the address. You cannot save the VAT number unless it has the correct format.
Ledger accounts are used to categorise or group your transactions to make sure they are reported correctly on financial reports, such as the Profit and Loss or Balance sheet.
Selecting the right ledger account is key to making sure you know where your money coming from and what you are selling.
On sales invoices, you must select a ledger account on each line to indicate what you have sold. You can use our default Ledger accounts or set up your own.
To make sure the right ledger account is selected automatically, you can set a default on you customer records. This is really useful if usually sell the same type of goods to a single customer. For example, if you usually sell
From the Account Details tab
Choose the ledger account to use by default for this customer from the Account Default drop-down.
If you usually use the same ledger account for all your sales, set this in the Record and Transaction settings. See Record and Transactions settings
If you've agreed credit terms with your customer, you can record them here.
The credit terms sets the number of days an invoice is outstanding before it need to be paid. Once set up, the due date on the invoice is worked out based on the credit terms set here.
We've set the credit terms to 30 days as this is usual for most businesses.
If your credit terms are different, set them in the Record and Transaction Settings so they re applied to all new customer records, or if this customer has unusual credit terms, then just enter them here.
From the Payment Details tab
Set a credit limit. Once the balance on your customer's account is more than this, then youll see a warning message.
Set credit Terms. This is the number of days an invoice is outstanding before it's due to be paid.
If you have bank details for any of you customers you can store them on the Payment Details tab. They are not used anywhere and are just for your information.
If you use product and services, and use different prices, such as a retail and a wholesale price, set the price used by this customer.
For example, if the customer is a wholesaler, you're likely to always want to charge them the wholesale price. When you add a product or service to the invoice, the wholesale price will be entered automatically.
From the Defaults tab
Select the price type for this customer.
Read more about product and service prices
For customers based overseas, you'll need to
From the Account Details tab, select the Region and then the Country when entering their address.
From the Account Details tab, enter a VAT number if they are registered for tax . This will make sure that the correct VAT rate is used on invoices.
From the Defaults tab, choose the currency .
Read more about foreign currency sales
You can use analysis groups to group you customers together for reporting purposes. For example, you may want to divide your customers by the region in which they are based so you can compare sales across regions, or you may want to see total based by sales manager to calculate commission.
Once you've set them up, just choose the group that this customer belongs to from the Analysis tab.
This is just a space for you to add any other relevant notes about your customer. They notes are not printed on any documents such as sales invoices.
If you indicated that your business is VAT registered on sign up, there will already be two contacts on the list. You'll use the