Importing clients
Bring your client list from a spreadsheet or another program. Check every client before anything is saved, then add their contacts.
- Choose a file
- Check the list
- Untick any
- Import
- On Clients, open Import and choose From a spreadsheet (CSV).
- Drop in your file: exports from Zoho, QuickBooks, Xero and Excel all work. Or choose Paste rows instead.
- Under From your file, check what each column fills and which rows were skipped.
- Untick anyone to leave out, then click Import.
What Vylan reads
Column names match in English or French. A French Excel file, with semicolons, works too.
| In your file | Becomes |
|---|---|
| Name, first and last name, or company | The client's name. A row with none is skipped. |
| Email, phone, primary contact | The client's Primary contact. |
| Type | Individual or Business. Without it, Inc, Ltd or a numbered company is a business. |
| Language | English or French. |
| Fiscal year end, industry, business activity, provincial business number | The same fields on the client. |
| Owner, or one of your role names | Matched to your team. |
| Status | Inactive comes in archived. |
| Corporate access number, in an Alberta firm | A custom field of that name. |
- The name sets a business's structure: Inc or Ltd is a corporation, a trust is a trust.
- Turn off Owners and roles from the file to make every client yours.
Vylan does not check for clients you already have. Take them out of the file first, or they come in twice.
From your firm's Xero
With your firm's own Xero connected, Import also offers From Xero: your Xero contacts that are not clients yet.
- Import makes a contact a client.
- Link joins it to an existing client.
- Import all takes the rest. Likely matches wait for you to link.
See your books in Xero.
Importing contacts
Import clients first. Then Import, on the Contacts list, takes a spreadsheet of people.
- Each person goes on the client their account column names, labelled with their title, or Secondary.
- Someone already in Vylan with the same name and email is linked, never made twice.
- Each person's outcome shows before anything is saved.
vylan