Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to Import from QuickBooks

This feature is not available on the Free version.  Here is how you can Purchase a Subscription OR you may opt to Try Unlimited Version for 7 14 days.

QuickBooks integration must already be enabled and connected on your Company Configuration setup.

Note
titleAccount Ownership

If the person running the import is not the sole Owner of the accounts being uploaded,

then setup

the

following before import.
  • For CSV, there must be a column for Account Owner which must be filled-up with the username of valid iCRM users.
  • For other data source, the

    field "External User Id (for data import)" on the User Profile must be filled-up for all valid iCRM users, before any import.


    For this guide, we will use the Accounts module.

    1.  Click button Import Records This button appears by default if there are no records for that module.  Otherwise, use the Tools>Import.

    2.  Click QuickBooks button from the drop down

    3.  Map the fields from the left (data source) to the corresponding iCRM fields on the right. The function matches the field labels for the mapping.
    4.  If there is a field from source that you want to import but the field does not exist on form, click Add New Field button.

       Dialog box to Add New Field opens,  here is a link to How to Add Form Fields for step-by-step guide.

       New field now appears on the list and can now be mapped.
    5.  Fill-up Import Settings.   Click this link for details on Import Settings.

    6.  Click Start Import.

       There may be some required fields on the module configuration like Account Name.  An error message will show the mandatory fields for that module. These fields have to be mapped.

    7.  Click Yes to proceed.

    8.  Click Ok on the import success prompt.

    9.  Note that an Activity log is created for this process where you can see the number of records added, not added or duplicates.

    10.  Click on the Module link or any of the views to see the records imported.


    Note

    We recommend that Products must also be imported so that Product ID automatically matches.  If product is manually added, please update the QuickBooks product ID field on you CRM product record.





    Related Pages

    Filter by label (Content by label)
    showLabelsfalse
    max10
    spacesICRM
    showSpacefalse
    sorttitle
    typepage
    cqllabel = in ( "iCRM" , "import" , "quickbooks" ) and type = "page" and space in ( currentSpace ( ) , "EmpowerCRM" )
    labelsdocumentation-space-sample

    Search this Product

    Live Search
    spaceKeyEmpowerCRM
    additionalnone
    placeholderType word to search
    typepage