Skip to main content
Import client data

To help you get started with Karbon quickly, we offer several options for importing your existing client data and contact records.

Ian Vacin avatar
Written by Ian Vacin
Updated over a week ago

Karbon becomes more efficient with your client data in it. In this guide, we'll explain how you can safely migrate your contacts into Karbon—from exporting your current data to maintaining and managing it within Karbon.

Index

Video Overview of Importing Contacts

Options for Importing

We offer four different options to import your contacts into Karbon. Choose the method that best fits your needs:

  1. Karbon Self-Service Import (Free): This is the fastest and easiest method to import your contacts. Simply export your client list from your current provider in an Excel or CSV file, format it correctly, and upload it to Karbon from your Contacts page.

  2. Self-Service (Free):  Download the import file, fill it out with your client data, and upload it to our secure Dropbox link. The Karbon team will handle the import and notify you of any errors so you can correct them directly.

  3. Assisted ($299 USD, or free on the Karbon Business Plan): This option includes a more in-depth import, covering full client details and providing support for any errors during the process. After filling out the Assisted Import File, upload it to the secure Dropbox link. Our onboarding team will handle the rest.

  4. Enterprise Onboarding ($3,999 USD):  For a more comprehensive experience, this package includes live training, data import, process consultations, and work imports. Visit our add-on services page for more details.

Filling out the Import File

If you choose the Self-Service via Dropbox or Assisted Import options, you’ll need to complete an import file. This file has two key sections: Basic File Fields and Assisted File Fields.

Basic file fields

Organization Name: Clients in Karbon can be either Organizations (businesses) or People (individuals). In addition, People can exist in Organizations. "Organization Name" is the place to list all organizations that you do or may do business with. While only the Organization Name is required, the other fields in the sheet are important to have a complete client record.


Note: we recommend setting up marriages, couples, spouses as organizations with individuals on the People tab relating to these organizations.

Description: This field is a text field and can hold any description of the client that you'd like or any information that doesn't fit in any of the other fields.

Website URL: For the Organization Name listed, enter the org's website URL in this column. Use either the https://www.karbonhq.com convention or just www.karbonhq.com.

Client Identifier: Client ID, Client code or client number. Keep in mind that this has to be a unique value for each entity.

Fiscal Year End Day: The Fiscal Year End Day is the day of the month for the end of the fiscal year. Select the appropriate day from 1 to 31.

Fiscal Year End Month: The Fiscal Year End Month is the month for the end of the fiscal year. Select the appropriate month from 1 to 12.

First, Middle and Last Name: Enter the full name of the desired client using the three columns provided: First Name, Middle Name, and Last Name.


Preferred Name: The Person's Preferred Name is the name used in Karbon's Client Tasks in email communications with a client. This is typically the person's first name only or the name they preferred to be called.

Date of Birth: The Person's Date of Birth.

Person's Email: The Email you'd like to be associated with the person. If a person has multiple emails associated with them (maybe because they are associated with multiple organizations), simply add additional lines and specify a different email address. This will results in multiple contact cards for this contact in your account. Karbon will handle all the proper associations so your timelines and communications work as expected.

Belongs To: "Belongs To" is the column used to associate a person to an Organization. If a person is associated to multiple organizations (such as a marriage, trust, business, non-profit, etc.), you will need to do so on separate rows within the sheet. To associate the contact card to the organization, the name must match the name from the Organization tab exactly.

Role: The role the person has in the selected Organization.

Phone numbers: These fields can contain different phone numbers for the client, such as Office, Fax, Mobile, Home and Other numbers. If you have additional phone numbers, you can put those in the description field.

Social Media Profiles: These fields can contain all of the social media profiles, such as Facebook, LinkedIn, Google+, Twitter and Skype.

Addresses: For the address, include the full address for the client, whether it is the physical, mailing, legal or home address. For instance, in the US, this would include the address line, city, and state. Use commas to separate each distinct part of the address. Enter the full country name in the country field.

Client Group Name: Clients (Organizations and Persons) in Karbon can be grouped into Client Groups to represent trusts, joint tax returns, multiple entities, etc. As a primary data element throughout Karbon, the column "Client Group Name" is the place to list all client groups that you do or may do business with. While only the Client Group Name is required, the other fields in the sheet are important to have a complete client group record.

Assisted file fields

In addition to the fields mentioned above in the basic file, you can add the following fields in the assisted file.

  • Legal Name

  • Legal Firm

  • Incorporated / Registration Date

  • Industry / Line of Business

  • Annual Revenue

  • Valuation

  • Sells

  • Revenue Model

  • Services

  • Basic Notes

  • Employee Locations

  • Office Locations

  • Tax Notes

  • Sales Tax Basis

  • Sales Tax Period

  • Entity Type

  • Income Tax Instalments

  • Business Numbers

  • Company Number

  • Tax File Number

Tips and Tricks for a Smooth Import

  • Be sure to check for invalid email addresses

  • Don't forget to look for unwanted duplicates

  • Add another row for the organization or person to add multiple email addresses.

  • People can be associated with more than one Organization. Use multiple lines if they belong to more than one Organization and/or if they have additional details (i.e. email addresses, street addresses, etc.)

  • On the people tab, Preferred names are necessary when using Karbon's client tasks. We use the preferred name in the salutation (i.e. Dear John).

Exporting your data from another provider

Whether from email, workflow, CRM and accounting solutions providers, learn how to export your data for migration into Karbon.

Exporting contacts from Outlook

  1. Log in to your Outlook.com account.

  2. Go to your contacts.

  3. From People, select Manage > Export.

Note: If any of these steps are different from what you see on your screen, search Microsoft Outlook.com help for the latest address book export instructions.

Exporting contacts from Gmail

  1. Log in to your Gmail account.

  2. From the list on the left side of the page, click Contacts.

  3. Select More actions > Export.

  4. Choose to export using Outlook CSV format (for importing into Outlook or another application).

Note: If any of these steps are different from what you see on your screen, search Gmail help for the latest address book export instructions.


Exporting contacts from Canopy

  1. Click the Options icon in the top, right corner of your Contacts screen.

  2. Click Export All Contacts.

  3. A CSV file will automatically start to download to your computer

  4. Check your computer’s Downloads folder to locate the file.

Exporting contacts from Xero Practice Manager

  1. Open Xero Practice Manager.

  2. In the Business menu, select Settings.

  3. Under Connections, click Export.

  4. Under Options, for File Type, select Generic - Clients.

  5. Do not change any other settings. Scroll down and click Export.

  6. Scroll down to Export Result and press Click to download export file.

  7. Xero Practice Manager will download all your company's clients in a CSV file to your computer.

  8. Repeat Steps 2 - 6 for Generic - Contacts.

Note: If any of these steps are different from what you see on your screen, search Xero Practice Manager help for the latest client export instructions.

Exporting contacts from QuickBooks Online

  1. Sign in to QuickBooks Online.

  2. Click Reports and search Customer Contact List.

  3. Click on Customize, in the top left corner.

  4. Click Change Columns. This will allow you to choose the columns you need for your spreadsheet, including Website.

  5. Make any additional customizations needed to capture all your data.

  6. Click Run Report.

  7. Click Export and choose excel or .CSV.

Exporting contacts from CCH Axcess

  1. Open Return Manager.

  2. In the Quick Search criteria, set filters to All.

  3. Click Go.

  4. Press Control + A to select all client IDs.

  5. Click the Home tab.

  6. Click Export Grid.

Exporting contacts from CCH Workflow

  1. Click File > CT Import/Export > Export.

  2. In the Select client(s) to export window, search for the client by:

  3. Name: Enter the company name in the Name box or click the Name column header to sort the list alphabetically.

  4. Client Code: Enter the client code in Code or click the Client Code column header to order by number or alphabetically.

  5. Use the vertical scroll bar to scroll up and down the list.

  6. Group: Enter the name of the Group(s) to filter the list of clients to groups only.

  7. Choose the Client(s) by selecting the check box to the left of each individual Client Code, and then click Next at the right of the bottom menu bar.

  8. To choose All Clients, select the check box to the left of the Client Code column header on the top menu bar.

  9. In the Select export file window, select where you want to save the file to by clicking on either (Click here to select an export file) or (Browse). A new Save As window opens.

Exporting contacts from OfficeTools

  1. Go to Contacts > Import/Export Contacts > Excel Importer > Export.

  2. Check the boxes of the fields you want included in the file.

  3. You can filter the contacts info to be exported by Contact Type and Entity Type.

Exporting contacts from Thomson Reuters - Practice CS

  1. Go to File > Export.

  2. Mark the Other checkbox, located at the top of the Export Clients window, for the option "Export Clients To:"

  3. Click the More button to the right of the blank Other field, and browse to the location which you want to save the file.

  4. Name the file, and verify the Save as type field shows, ".csv or .xlsx".

  5. Select the clients that you would like to export.

Exporting your client list from another provider

Refer to your current solution provider for export instructions.

Maintain your contact records

Once your contacts are setup, you can import additional individual contacts as needed.

An integration with Zapier can also help you keep contacts up to date going forward. If you wish to make bulk changes to your contact data to update, add or delete entities, you can do so as well. Depending on your plan, there may be an additional fee for bulk updates. Visit our add-on services page for more details.

Suggested articles:

Did this answer your question?