Back

Household Linking

Contents

Introduction

Link Individual Households

Link Multiple Households

Step One: Export Tamarac CRM Data

Step Two: Export Tamarac Reporting Data

Step Three: Match the CRM and Tamarac Reporting Data in Excel

Step Four: Upload the Excel File in Tamarac Reporting

Create in Tamarac

Finding Linked Households

 

Introduction

Using Household integration allows you to streamline client onboarding and simplify data management between Tamarac CRM and Tamarac Reporting. Household integration bi-directionally integrates the Household name and address between Tamarac CRM and Tamarac Reporting to reduce redundancies in data management. Household integration additionally updates the fields in the Net Worth and Revenue calculators for all linked Households.

From Tamarac CRM, you can create a new Household and new Clients in Tamarac Reporting with the click of a button – making it fast and easy to manage your households. The Household and Clients will be automatically linked, and your updates to the Household will then sync across the products.

Note

When you link a Tamarac CRM Account/Household with a Tamarac Reporting Household, the Tamarac CRM name will overwrite the Tamarac Reporting Household Name.

Link Individual Households

In order to take advantage of the Household level integration such as name and address synchronization and the daily updates to the Net Worth and Revenue calculators, Tamarac Reporting Households need to be linked with Tamarac CRM Accounts. You can link Households in Tamarac Reporting to Accounts in Tamarac CRM either manually one at a time or in bulk using an upload.

To link a Household individually, follow these steps in Tamarac Reporting:

  1. On the Accounts menu in Tamarac Reporting, click Households.

  2. Click an existing Household. You can also perform this step when you create a new Household.

  1. On the Settings page, click the Add CRM Household button.

  1. In the Search CRM Household Names box, the name of the Household in Tamarac Reporting will be automatically searched.

Link Multiple Households

In order to take advantage of the Household level integration such as name and address synchronization and the daily updates to the Net Worth and Revenue calculators, Tamarac Reporting Households need to be linked with Tamarac CRM Accounts. You can link Households in Tamarac Reporting to Accounts in Tamarac CRM either manually one at a time or in bulk using an upload.

Follow this procedure for each separate CRM Type. If you want to link client accounts with Households, do one export for that, then do a separate export to link CPAs, attorneys, and other third parties.

To link multiple Households, you will use this general procedure:

  1. Export account information from Tamarac CRM.

  2. Export a bulk report from Tamarac Reporting.

  3. Match the Tamarac CRM and Tamarac Reporting data in Excel.

  4. Upload the Excel file in Tamarac Reporting.

Step One: Export Tamarac CRM Data

  1. On the side menu, select Accounts under Clients.

  2. On the Accounts page, select the Tamarac Reporting Household Upload view.

  3. Click to open the advanced filtering panel.

  4. If you only want to link clients, do the following:

    Choose Status, then choose Equals and Household. Then click Apply.

    If you want to link all account types, click Cancel.

  5. Click Export to Excel. This generates an Excel file you can download.

  6. In the Excel file, click Enable Editing.

    Columns A through C are hidden. You need only the Account Name and Account GUID columns. Delete any extra columns.

Step Two: Export Tamarac Reporting Data

  1. In Tamarac Reporting, create a Household Information bulk report. Include the following columns:

  1. Run the Household Information bulk report.

  2. Save and open the bulk report Excel file.

Step Three: Match the CRM and Tamarac Reporting Data in Excel

  1. Copy and paste the GUID from the CRM export into the matching row in the Tamarac Reporting bulk report.

Important

It is critical that each CRM GUID is correctly matched with the corresponding Tamarac Reporting Household. This is what Tamarac Reporting uses to link the records, so incorrect matching will result in mixed up data.

  1. Spot-check to confirm GUIDs were correctly copied into the Tamarac Reporting file.

Step Four: Upload the Excel File in Tamarac Reporting

  1. In Tamarac Reporting, under Setup, click Upload.

  2. Create a Household Information upload.

  3. Add the Excel file containing the matched Account/Household data to the upload.

  4. Click Upload. When the upload is complete, check in Tamarac Reporting to confirm that Households are linked with the correct CRM account.

Create in Tamarac

Using the Create in Tamarac button allows you to create and link Households in Tamarac Reporting with just a few clicks. Use this button when you are ready to create new clients in Tamarac Reporting after they have been qualified as a lead. The Create in Tamarac button can be used to create and link records in Tamarac Reporting one at a time. To link multiple records, see Link Multiple Households information.

A Contact must have an email address to be created in Tamarac Reporting. A contact that does not have an email address, is not able to be selected in the Create in Tamarac Reporting window.

To create Households and Clients in Tamarac Reporting, follow these steps:

  1. On the side menu, select Accounts under Clients.

  2. Open the record for the Account you want to create in Tamarac Reporting.

  3. Click Create in Tamarac.

  4. On the Create in Tamarac Reporting window, click the check box next to any Contacts you want to create as contacts in Tamarac Reporting.

    This window contains options to choose which Contacts to create in Tamarac Reporting at the same time as the Household is created. This window shows contacts that are the Primary and Secondary contact assigned to the Household, as well as any Contact assigned to the account.

  5. Click Create Household.

    You will receive a confirmation message that the Household has been created successfully in Tamarac Reporting.

  6. Click Open in Tamarac to finish the onboarding process in Tamarac Reporting.

Finding Linked Households

On the Account/Household record, you can identify a linked Household using the Linked to Tamarac field. This field will show as Not Linked for any Household that has not been linked to Tamarac Reporting and the Create in Tamarac button will be visible.

The Linked to Tamarac field will show as Linked for any Household that has been linked to Tamarac Reporting and the Create in Tamarac button will not be visible.

You can create a view to identify all linked or unlinked Account/Households in Tamarac CRM. To create a view, follow these steps:

  1. On the side menu, select Accounts under Clients.

  2. Click to open the advanced filtering panel.

  3. Select Linked to Tamarac and choose Equals and Linked.