QuickBooks Link Account Options: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
No edit summary
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
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 [[Accounts|Account]]. You can manage your Account contact data and all other related data in the Accounts window.
{{usermanualsquickbookslink}}


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|Sales Opportunities]] and so on.
Your company has ongoing interactions with customers, vendors, business partners, friends, leads, and so on. In RangerMSP, each of these types of contacts is called an [[Accounts|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 RangerMSP, 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|Sales Opportunities]] and so on.


Account information is organized in separate information tabs that display different types of data.
Account information is organized in separate information tabs that display different types of data.
Line 7: Line 9:
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.
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 [[Commit-QuickBooks Link|QuickBooks]], and changes can be synchronized between both systems.
Accounts can be easily imported from [[QuickBooks Link|QuickBooks]], and changes can be synchronized between both systems.




__TOC__
__TOC__


==Actions in Commit-QuickBooks Link==
==Actions in RangerMSP-QuickBooks Link==
Aside from importing your Customers into CommitCRM, the [[Commit-QuickBooks Link]] includes many other useful functions.
Aside from importing your Customers into RangerMSP, the [[QuickBooks Link|RangerMSP-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.
You can view all of the synchronization options that are available between Account records in RangerMSP 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:
There you will see one of the following two menus:
Line 21: Line 23:
The first menu is displayed when a selected Account is not linked to the parallel Customer/Vendor in QuickBooks.
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|center]]
[[File:quickbooks_options_in_accounts_window1.png|center]]


The second menu is displayed when a selected Account is already linked to the parallel Customer/Vendor record in QuickBooks.
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|center]]
[[File:quickbooks_options_in_accounts_window2.png|center]]


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).
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).
Line 31: Line 33:


==Create Invoice==
==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.
This option enables you to create a QuickBooks invoice from RangerMSP for the selected Account, based on billable charges entered in RangerMSP that haven't been billed yet. You can also include not-billable charge in the invoice, without it affecting the invoice total amount.


[[QuickBooks Link Invoice Creation Options|Click Here for a detailed step–by-step guide on how to manage invoices.]]
[[QuickBooks Link Invoice Creation Options|Click Here for a detailed step–by-step guide on how to manage invoices.]]
Line 37: Line 39:


==Link Account To QuickBooks Customer/Job/Vendor Record==
==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 enables you to link between an existing record in RangerMSP 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.
This option is very useful when the same customer already exists in RangerMSP and also exisst 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 RangerMSP the link tells RangerMSP 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.
To link between an existing Account record in RangerMSP 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|center]]
[[File:link_account_to_quickbooks_record.png|center]]


The QuickBooks Customer/Job Selection dialog box will appear:
The QuickBooks Customer/Job Selection dialog box will appear:


[[File:commit_quickbooks_customer_selection_window1.gif|center]]
[[File:quickbooks_customer_selection_window1.png|center]]
 
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.


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 RangerMSP and click OK.


==Create New Record in QuickBooks Based on CommitCRM Account==
==Create New Record in QuickBooks Based on RangerMSP 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 allows you to create a new Customer/Vendor in QuickBooks based on the existing Account in RangerMSP, instead of retyping all the information again in QuickBooks. It also creates a link between the record in RangerMSP 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.
This option is useful when a new Account record was created in RangerMSP 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.
To create a new Customer/Vendor in QuickBooks based on an existing RangerMSP Account, select the relevant record in the Accounts window in RangerMSP and then select Create New Record in QuickBooks Based on RangerMSP Account in the QuickBooks menu.


[[File:commit_new_record_in_quickbooks_based_on_account.gif|center]]
[[File:new_record_in_quickbooks_based_on_account.png|center]]


The Account record will now be transferred to QuickBooks as a Customer/Vendor. You can open QuickBooks and view the newly created record.
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|center]]
[[File:new_customer_in_quickbooks.gif|center]]




==Update Linked QuickBooks Record with CommitCRM Account Data==
==Update Linked QuickBooks Record with RangerMSP 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.
You can update a linked QuickBooks Customer/Job/Vendor with RangerMSP Account data. This option is useful when you've updated an Account in RangerMSP 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.
To update a linked Customer/Job/Vendor in QuickBooks with RangerMSP Account data, select the relevant Account in the Accounts window in RangerMSP and then select Update Linked QuickBooks Record with RangerMSP Account Data on the QuickBooks drop down toolbar menu.


[[File:commit_update_quickbooks_record_with_accounts_data.gif|center]]
[[File:update_quickbooks_record_with_accounts_data.png|center]]


The relevant Customer/Job/Vendor will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.
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|center]]
[[File:updated_customer_in_quickbooks.gif|center]]


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.
The two images above, show that a 'Fax' number that was added in to the record in RangerMSP and how it has been updated in the parallel record in QuickBooks after activating this option.


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


==Update Account Data from the Linked QuickBooks Record==
==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.
You can update a linked RangerMSP 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 RangerMSP.


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


[[File:commit_updated_customer_in_quickbooks2.gif|center]]
[[File:updated_customer_in_quickbooks2.gif|center]]


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.
To update the linked RangerMSP Account with the changed data from the parallel record in QuickBooks, select the relevant Account in RangerMSP 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|center]]
[[File:update_account_with_quickbooks_data.png|center]]


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


[[File:commit_updated_account.gif|center]]
[[File:updated_account.png|center]]


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.
In the example above, you can see that the E-mail field in RangerMSP has been updated with the new information from the linked QuickBooks record.


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




==Remove Link Between the Account and QuickBooks Record==
==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.
You can remove the link between a RangerMSP 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.
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.
To remove the link between the records, select the relevant Account in RangerMSP 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|center]]
[[File:remove_link_between_accounts.png|center]]




==New Account in CommitCRM Based on a QuickBooks Record==
==New Account in RangerMSP 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 allows you to create a new Account record in RangerMSP 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 RangerMSP.


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.
This option is useful when a new Customer/Job/Vendor record was created in QuickBooks and you want to add it to RangerMSP, without typing the details again in RangerMSP.


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.
To create a new Account in RangerMSP based on a Customer/Job/Vendor in QuickBooks, select New Account in RangerMSP Based on QuickBooks from the Accounts window in RangerMSP.


[[File:commit_new_account_based_on_quickbooks_record.gif|center]]
[[File:new_account_based_on_quickbooks_record.png|center]]


The QuickBooks Selection dialog box will appear.
The QuickBooks Selection dialog box will appear.


[[File:commit_quickbooks_customer_selection_window2.gif|center]]
[[File:quickbooks_customer_selection_window2.png|center]]


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


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.
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|center]]
[[File:new_account.png|center]]


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




==Import New Records / Update Linked Records from QuickBooks==
==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.
If you have added or updated any Customers/Vendors/Jobs in QuickBooks, you can import these changes into RangerMSP using the same function as the one you used initially to import all the records from QuickBooks into RangerMSP.


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.
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 RangerMSP.


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


From the second import and on:
From the second import and on:
#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.
#All the new records in QuickBooks that were created during the period between the last import and the current import, will be imported to RangerMSP as new records.
#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.
#All the records in QuickBooks that were updated during the period between the last import and the current import, will be updated in RangerMSP 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.
Please note, that Jobs are not imported in the batch import from QuickBooks to RangerMSP. You can import the jobs on one by one basis using the 'New Account in RangerMSP Based on QuickBooks' option. However, updates to Jobs that have been are already linked to RangerMSP Accounts will be synchronized and will update the corresponding record in RangerMSP.


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...'
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|center]]
[[File:importing_accounts_from_qb.gif|center]]




==See Also==
==See Also==
*[[Commit-QuickBooks Link]]
*[[QuickBooks Link|RangerMSP-QuickBooks Link]]
*[[Accounts]]
*[[Accounts]]


[[Category:User Manuals]]
[[Category:User Manuals]]
[[Category:QuickBooks]]
[[Category:QuickBooks]]

Latest revision as of 12:03, 9 July 2020

User Manuals > QuickBooks Link > QuickBooks Link Account Options

Your company has ongoing interactions with customers, vendors, business partners, friends, leads, and so on. In RangerMSP, 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 RangerMSP, 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 RangerMSP-QuickBooks Link

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

You can view all of the synchronization options that are available between Account records in RangerMSP 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.

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

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 RangerMSP for the selected Account, based on billable charges entered in RangerMSP 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 RangerMSP and an existing record in QuickBooks.

This option is very useful when the same customer already exists in RangerMSP and also exisst 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 RangerMSP the link tells RangerMSP to which customer to link the invoice to.

To link between an existing Account record in RangerMSP 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.

The QuickBooks Customer/Job Selection dialog box will appear:

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 RangerMSP and click OK.

Create New Record in QuickBooks Based on RangerMSP Account

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

This option is useful when a new Account record was created in RangerMSP 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 RangerMSP Account, select the relevant record in the Accounts window in RangerMSP and then select Create New Record in QuickBooks Based on RangerMSP Account in the QuickBooks menu.

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


Update Linked QuickBooks Record with RangerMSP Account Data

You can update a linked QuickBooks Customer/Job/Vendor with RangerMSP Account data. This option is useful when you've updated an Account in RangerMSP 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 RangerMSP Account data, select the relevant Account in the Accounts window in RangerMSP and then select Update Linked QuickBooks Record with RangerMSP Account Data on the QuickBooks drop down toolbar menu.

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

The two images above, show that a 'Fax' number that was added in to the record in RangerMSP 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 RangerMSP 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 RangerMSP.

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

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

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

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

Note: If the linked Account in RangerMSP 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 RangerMSP 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 RangerMSP and then select Remove Link Between the Account and QuickBooks Record on the QuickBooks drop down toolbar menu.


New Account in RangerMSP Based on a QuickBooks Record

This option allows you to create a new Account record in RangerMSP 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 RangerMSP.

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

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

The QuickBooks Selection dialog box will appear.

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

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:New account.png

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


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 RangerMSP using the same function as the one you used initially to import all the records from QuickBooks into RangerMSP.

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 RangerMSP.

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

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 RangerMSP 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 RangerMSP as well.

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

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...'


See Also