QuickBooks Link Account Options

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Revision as of 13:47, 29 August 2013 by Robert (talk | contribs)
Jump to navigation Jump to search
User Manuals > QuickBooks Link > QuickBooks Link Account Options

Your company has ongoing interactions with customers, vendors, business partners, friends, leads, and so on. In CommitCRM, each of these types of contacts is called an Account. You can manage your Account contact data and all other related data in the Accounts window.

In Accounts, related data is any information related to the Account that is presently being managed in CommitCRM, such as scheduled Appointments, open Tasks, Phone Call monitoring, Ticket/incident history, Assets (customer equipment and software licenses), Charges, linked Documents (MS-Word, emails, Excel etc.), Sales Opportunities and so on.

Account information is organized in separate information tabs that display different types of data.

To view all information related to an Account, open the Accounts window, locate the required Account, and browse through its data by clicking on the information tabs.

Accounts can be easily imported from QuickBooks, and changes can be synchronized between both systems.


Actions in CommitCRM-QuickBooks Link

Aside from importing your Customers into CommitCRM, the CommitCRM-QuickBooks Link includes many other useful functions.

You can view all of the synchronization options that are available between Account records in CommitCRM and Customers/Vendors in QuickBooks in the Accounts window under the QuickBooks drop down toolbar menu.

There you will see one of the following two menus:

The first menu is displayed when a selected Account is not linked to the parallel Customer/Vendor in QuickBooks.

File:Commit quickbooks options in accounts window1.gif

The second menu is displayed when a selected Account is already linked to the parallel Customer/Vendor record in QuickBooks.

File:Commit quickbooks options in accounts window2.gif

All the options are accessible from the Accounts window, so it is not necessary to open the QuickBooks Company while those actions are being performed (although if QuickBooks is open you may notice performance improvements).


Create Invoice

This option enables you to create a QuickBooks invoice from CommitCRM for the selected Account, based on billable charges entered in CommitCRM that haven't been billed yet. You can also include not-billable charge in the invoice, without it affecting the invoice total amount.

Click Here for a detailed step–by-step guide on how to manage invoices.


Link Account To QuickBooks Customer/Job/Vendor Record

This option enables you to link between an existing record in CommitCRM and an existing record in QuickBooks.

This option is very useful when the same customer already exist in CommitCRM and also exist in QuickBooks. It tells the system that both these records are actually the same contact and there should be a link between them when synchronizing data. Also, when generating QuickBooks invoices from CommitCRM the link tells CommitCRM to which customer to link the invoice to.

To link between an existing Account record in CommitCRM and an existing Customer/Job/Vendor in QuickBooks, go to the Accounts window and select Link Account To QuickBooks Customer/Job/Vendor Record on the QuickBooks drop down toolbar menu.

File:Commit link account to quickbooks record.gif

The QuickBooks Customer/Job Selection dialog box will appear:

File:Commit quickbooks customer selection window1.gif

Type the name of the QuickBooks Customer/Job/Vendor in the Name field in QuickBooks, and click Find. The relevant records in QuickBooks will be displayed. Select the record that matches the record in CommitCRM and click OK.


Create New Record in QuickBooks Based on CommitCRM Account

This option allows you to create a new Customer/Vendor in QuickBooks based on the existing Account in CommitCRM, instead of retyping all the information again in QuickBooks. It also creates a link between the record in CommitCRM and the newly created corresponding record in QuickBooks.

This option is useful when a new Account record was created in CommitCRM and you want to add it to QuickBooks, without having to type the Account details again in QuickBooks.

To create a new Customer/Vendor in QuickBooks based on an existing CommitCRM Account, select the relevant record in the Accounts window in CommitCRM and then select Create New Record in QuickBooks Based on CommitCRM Account in the QuickBooks menu.

File:Commit new record in quickbooks based on account.gif

The Account record will now be transferred to QuickBooks as a Customer/Vendor. You can open QuickBooks and view the newly created record.

File:Commit new customer in quickbooks.gif


Update Linked QuickBooks Record with CommitCRM Account Data

You can update a linked QuickBooks Customer/Job/Vendor with CommitCRM Account data. This option is useful when you've updated an Account in CommitCRM and want to automatically transfer these updates to the corresponding linked Customer/Job/Vendor in QuickBooks.

To update a linked Customer/Job/Vendor in QuickBooks with CommitCRM Account data, select the relevant Account in the Accounts window in CommitCRM and then select Update Linked QuickBooks Record with CommitCRM Account Data on the QuickBooks drop down toolbar menu.

File:Commit update quickbooks record with accounts data.gif

The relevant Customer/Job/Vendor will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.

File:Commit updated customer in quickbooks.gif

The two images above, show that a 'Fax' number that was added in to the record in CommitCRM and how it has been updated in the parallel record in QuickBooks after activating this option.

Note: If the linked Customer/Job/Vendor in QuickBooks was also updated since the last synchronization took place, you will receive a system warning.


Update Account Data from the Linked QuickBooks Record

You can update a linked CommitCRM Account with QuickBooks Customer/Job/Vendor data. This option is useful when you've updated a Customer/Job/Vendor in QuickBooks and want to automatically transfer the changes to CommitCRM.

In the following example, the E-mail field was updated in QuickBooks:

File:Commit updated customer in quickbooks2.gif

To update the linked CommitCRM Account with the changed data from the parallel record in QuickBooks, select the relevant Account in CommitCRM and then select Update Account Data from the Linked QuickBooks Record on the QuickBooks drop down toolbar menu.

File:Commit update account with quickbooks data.gif

The selected record in CommitCRM will be updated with the changes made in QuickBooks.

File:Commit updated account.gif

In the example above, you can see that the E-mail field in CommitCRM has been updated with the new information from the linked QuickBooks record.

Note: If the linked Account in CommitCRM was also updated since the last synchronization took place, you will receive a system warning.


Remove Link Between the Account and QuickBooks Record

You can remove the link between a CommitCRM Account and QuickBooks Customer/Job/Vendor. This feature is useful for removing links that were created by mistake, removing links to QuickBooks records that were deleted, or when you don't want to continue synchronizing data between records.

When you remove a link between records, you will no longer be able to synchronize changes between them. You can always link the records again in the future with the Link Account To QuickBooks Customer/Job/Vendor Record option on the QuickBooks drop down toolbar menu as described above.

To remove the link between the records, select the relevant Account in CommitCRM and then select Remove Link Between the Account and QuickBooks Record on the QuickBooks drop down toolbar menu.

File:Commit remove link between accounts.gif


New Account in CommitCRM Based on a QuickBooks Record

This option allows you to create a new Account record in CommitCRM based on an existing Customer/Job/Vendor in QuickBooks. It also creates a link between the record in QuickBooks and the newly created corresponding record in CommitCRM.

This option is useful when a new Customer/Job/Vendor record was created in QuickBooks and you want to add it to CommitCRM, without typing the details again in CommitCRM.

To create a new Account in CommitCRM based on a Customer/Job/Vendor in QuickBooks, select New Account in CommitCRM Based on QuickBooks from the Accounts window in CommitCRM.

File:Commit new account based on quickbooks record.gif

The QuickBooks Selection dialog box will appear.

File:Commit quickbooks customer selection window2.gif

Search for the Customer/Job/Vendor in QuickBooks that you want to use to create the new Account in CommitCRM.

Enter the name of the Customer/Job/Vendor in the Name field in QuickBooks, and click Find. Any related QuickBooks Customers/Jobs/Vendor will be displayed. Select the relevant record and click OK.

File:Commit new account.gif

Done! The new Account will now be created in CommitCRM.


Import New Records / Update Linked Records from QuickBooks

If you have added or updated any Customers/Vendors/Jobs in QuickBooks, you can import these changes into CommitCRM using the same function as the one you used initially to import all the records from QuickBooks into CommitCRM.

Using this option after the initial import enables you to import all the QuickBooks records that have been added to QuickBooks after the initial import. It also syncs all updates performed to records in QuickBooks and applies them to the corresponding linked records in CommitCRM.

During the first import, all the relevant Account records from QuickBooks will be imported into CommitCRM.

From the second import and on:

  1. All the new records in QuickBooks that were created during the period between the last import and the current import, will be imported to CommitCRM as new records.
  2. All the records in QuickBooks that were updated during the period between the last import and the current import, will be updated in CommitCRM as well.

Please note, that Jobs are not imported in the batch import from QuickBooks to CommitCRM. You can import the jobs on one by one basis using the 'New Account in CommitCRM Based on QuickBooks' option. However, updates to Jobs that have been are already linked to CommitCRM Accounts will be synchronized and will update the corresponding record in CommitCRM.

To sync/import all the records, go to Accounts window > QuickBooks drop down toolbar menu and select the option 'Import New Records / Update Linked Records from QuickBooks...'

File:Commit importing accounts from qb.gif


See Also