vylan

Importing clients

Bring your client list from a spreadsheet or another program. Check every client before anything is saved, then add their contacts.

  1. Choose a file
  2. Check the list
  3. Untick any
  4. Import
  1. On Clients, open Import and choose From a spreadsheet (CSV).
  2. Drop in your file: exports from Zoho, QuickBooks, Xero and Excel all work. Or choose Paste rows instead.
  3. Under From your file, check what each column fills and which rows were skipped.
  4. 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 fileBecomes
Name, first and last name, or companyThe client's name. A row with none is skipped.
Email, phone, primary contactThe client's Primary contact.
TypeIndividual or Business. Without it, Inc, Ltd or a numbered company is a business.
LanguageEnglish or French.
Fiscal year end, industry, business activity, provincial business numberThe same fields on the client.
Owner, or one of your role namesMatched to your team.
StatusInactive comes in archived.
Corporate access number, in an Alberta firmA 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.
Still stuck?

If you can't find it here, write to us. A real person reads it.