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
 
Line 1: Line 1:
{{usermanualsquickbookslink}}
{{usermanualsquickbookslink}}


This is the appendix section for the [[QuickBooks Link|RangerMSP-QuickBooks Link]] user manual.
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.


===Changing Path/Company File===
Account information is organized in separate information tabs that display different types of data.
If you have made changes to your QuickBooks company file and it is set to synchronize with RangerMSP, or if you have modified the path to where your current QuickBooks company file is stored (i.e. by moving the QuickBooks installation from the local drive to the network), you need to change the path/company file in RangerMSP.


Please follow the instruction below to 'Change Path/Company':
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.


<u>Important Note:</u> We strongly recommend you '''backup''' RangerMSP's data prior to changing the company file (note that all users should not be using RangerMSP while you perform the backup).<br>RangerMSP data is stored in <server>\RangerMSP\DB folder.
Accounts can be easily imported from [[QuickBooks Link|QuickBooks]], and changes can be synchronized between both systems.


In RangerMSP, go to Tools > Options > QuickBooks menu, and click on Change Path/Company.


[[File:Options_quickbooks_tab3.png|center]]
__TOC__


The following wizard will open.
==Actions in RangerMSP-QuickBooks Link==
Aside from importing your Customers into RangerMSP, the [[QuickBooks Link|RangerMSP-QuickBooks Link]] includes many other useful functions.


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


Click on Click to Select New File to select the new QuickBooks company file. The file browser will display.
There you will see one of the following two menus:


[[File:Select_qb_company_file2.png|center]]
The first menu is displayed when a selected Account is not linked to the parallel Customer/Vendor in QuickBooks.


Select the new QuickBooks company file or the new path for the existing QuickBooks company file, and click Open.
[[File:quickbooks_options_in_accounts_window1.png|center]]


You can now see the path and name of the current QuickBooks company file and the path and name of the newly selected QuickBooks company file.
The second menu is displayed when a selected Account is already linked to the parallel Customer/Vendor record in QuickBooks.


[[File:New_company_file_selected.png|center]]
[[File:quickbooks_options_in_accounts_window2.png|center]]


Click Next.
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).


In the next stage you'll be asked to select whether the file you have selected is:


#'a new path for the SAME company file'<br>or
==Create Invoice==
#'a DIFFERENT QuickBooks company file'
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.


Please see the following sections for a detailed description of each option.
[[QuickBooks Link Invoice Creation Options|Click Here for a detailed step–by-step guide on how to manage invoices.]]


====Option 1. "a new path for the SAME company file"====
Select this option when:


#You moved your original QuickBooks company file from one location to another, i.e. from your local drive to a shared drive on your server.
==Link Account To QuickBooks Customer/Job/Vendor Record==
#You restored the QuickBooks company file from a backup, and it is almost identical to the original file.
This option enables you to link between an existing record in RangerMSP and an existing record in QuickBooks.
#It is an exact copy of the original QuickBooks company file, and the Customers, Items and invoices are the same or almost the same as the original company file.


<u>Note:</u> if you have imported data from one QuickBooks company file to another QuickBooks company file, RangerMSP sees the second file as a different QuickBooks company file, since the Customers, Items etc receive new record ID numbers in the second file.
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.


After you selected the new company file, the following window will open. Read the instructions carefully.
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:new_path_for_same_company_file.png|center]]
[[File:link_account_to_quickbooks_record.png|center]]


Select 'a new path for the SAME company file' and click Next.
The QuickBooks Customer/Job Selection dialog box will appear:


A window will open warning you that the replacement may take time. Click Yes to confirm that you would like to proceed.
[[File:quickbooks_customer_selection_window1.png|center]]


[[File:Replacement_warning.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 RangerMSP and click OK.


If the new company file is not identical to the original one, you will receive the following message:
==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.


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


If you are sure that the selected file is the same as the current QuickBooks company file, click Yes.<br>If you've selected a different company file than the current one, click No.
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:Replacement_of_quickbooks_company_file_finish.png|center]]
[[File:new_record_in_quickbooks_based_on_account.png|center]]


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


Done! You have successfully replaced the QuickBooks company file RangerMSP syncs with. RangerMSP now has the new path to the QuickBooks company file.
[[File:new_customer_in_quickbooks.gif|center]]


Once you have completed selecting the new company file, you will be returned to the Options window. Click OK to close it.


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


====Option 2. "a DIFFERENT QuickBooks company file"====
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.
You should select this option when you no longer want to synchronize with the currently selected QuickBooks company file, and you want to begin synchronizing with a different QuickBooks company file.


<u>Note:</u> this function is irreversible. Once you have selected to sync with another QuickBooks company file, the link between RangerMSP and the old (currently selected) QuickBooks company file is lost forever. If you choose to reselect the currently selected company file for synching with RangerMSP at a future time, all the current sync settings will not be recognized. For example, if you import/sync Customer records from QuickBooks into RangerMSP, duplicate records in RangerMSP will be created.
[[File:update_quickbooks_record_with_accounts_data.png|center]]


<u>Important Note:</u> We strongly recommend you backup RangerMSP's data prior to changing the company file (note that all users should not be using RangerMSP while you perform the backup).<br>RangerMSP data is stored in <server>\RangerMSP\DB folder.
The relevant Customer/Job/Vendor will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.


After you selected the new company file, the following window will open. Read the instructions carefully.
[[File:updated_customer_in_quickbooks.gif|center]]


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


Select 'a DIFFERENT QuickBooks company file' only if you fully understand the meaning of this option, and you want RangerMSP to sync with a different QuickBooks company file. Click Next.
<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.


Now you will be asked to open the selected QuickBooks company file as a QuickBooks Administrator and in Single User mode. Follow these instructions carefully.


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


Follow the instructions in the above screenshot to log in to QuickBooks as an Administrator and in Single User mode. Then, click Next.
In the following example, the E-mail field was updated in QuickBooks:


RangerMSP will now try to access the selected QuickBooks company file. QuickBooks will display a window requesting permission to allow access to the file. Grant RangerMSP all the relevant permissions.
[[File:updated_customer_in_quickbooks2.gif|center]]


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


Make sure you select the correct settings as illustrated above:
[[File:update_account_with_quickbooks_data.png|center]]
#Yes, always allow access to RangerMSP even if QuickBooks is not running
#Login as user with Admin privileges.


<u>Note:</u> The dialog box you see may slightly differ from the one above depending on your version/edition of QuickBooks.
The selected record in RangerMSP will be updated with the changes made in QuickBooks.


Click Continue. QuickBooks will then ask you to confirm that you grant the permissions to RangerMSP. Click Yes.
[[File:updated_account.png|center]]


The QuickBooks company file will now be replaced.
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.


A window will open warning you that the replacement may take time. Click Yes to confirm that you would like to proceed.
<u>Note:</u> If the linked Account in RangerMSP was also updated since the last synchronization took place, you will receive a system warning.


[[File:Replacement_warning.png|center]]


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


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


Click 'Yes, only if you have recently backup RangerMSP data.'
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:Last_replacement_warning.png|center]]
[[File:remove_link_between_accounts.png|center]]


Click 'Yes' to proceed.


Done!
==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.


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


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


Done! You have successfully replaced the QuickBooks company file RangerMSP syncs with. RangerMSP now has the new path to the QuickBooks company file.
[[File:new_account_based_on_quickbooks_record.png|center]]


Once you have completed selecting the new company file, you will be returned to the Options window. Click OK to close it.
The QuickBooks Selection dialog box will appear.


[[File:options_quickbooks_tab4.png|center]]
[[File:quickbooks_customer_selection_window2.png|center]]


===Starting a New Financial Year in QuickBooks===
Search for the Customer/Job/Vendor in QuickBooks that you want to use to create the new Account in RangerMSP.
Once a year, many businesses start a new financial year for their accounting purposes. This can be done in two ways in QuickBooks:


#Create a new QuickBooks company file for each new financial year ('''Less recommended''' when working with RangerMSP).<br>OR
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.
#Close your books at year-end, but this information stays in the same QuickBooks company file ('''recommended!''')


If you use the RangerMSP-QuickBooks Link, it is preferable to use the '''second option''' (i.e. continue using the same company file) in order to keep the sync settings and avoid repeating the long process of linking all your QuickBooks Customers, Vendors and Items with their corresponding records in RangerMSP (this is required when you start to use a completely new company file as described in option 1 above).
[[File:new_account.png|center]]


For your convenience, please find below some text copied from the QuickBooks Help file about closing your books at year-end. You should also read the 'QuickBooks Year-End Guide' for more information.
Done! The new Account will now be created in RangerMSP.


<u>Important Note:</u> When performing any year-end procedures, follow the instructions found in your QuickBooks documentation rather than the instructions below, since they may not suit your version/edition of QuickBooks.
You should also consult with your accountant.


Taken from QuickBooks Help:
==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.


'''''About closing your books at year-end'''<br>You can choose whether to close your books at the end of the year or not. QuickBooks doesn't require you to do so.''
During the first import, all the relevant Account records from QuickBooks will be imported into RangerMSP.


'''''Advantages to closing your books'' (less recommended when working with RangerMSP)'''
From the second import and on:
*''Restricted access: You can set a password to restrict access to data from the prior accounting period, including the details of every transaction. Transactions can't be changed without your knowledge. To modify or delete a transaction in a closed period, a user must know the closing date password and have the appropriate permissions.
#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 RangerMSP as well.


*''Reporting: Any changes made after the closing date to transactions dated on or before the closing date will appear in the 'closing date exception report'.''
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.


'''''Advantages to NOT closing your books'' (recommended when working with 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...'
*''Detail: You always have easy access to last year's data, including the details of every transaction.''


*''Reporting: You can create comparative reports between this year and last year.''
[[File:importing_accounts_from_qb.gif|center]]


'''''Year-end adjustments QuickBooks makes automatically'''<br>QuickBooks performs certain year-end adjustments, based on your fiscal year start month.''
*''QuickBooks adjusts your income and expense accounts at year-end to zero them out. Therefore, you start your new fiscal year with a zero net income.''
*''QuickBooks makes an adjusting entry to your net income. For example, if your profit for the year was $12,000, on the last day of your fiscal year the equity section of your Balance Sheet would show a line for net income of $12,000.''
*''On the first day of the new fiscal year, QuickBooks increases your Retained Earnings equity account by the previous year's net income ($12,000 in this example) and decreases your net income by the same amount. This way, you start each new fiscal year with a net income of zero.''
===Introduction to RangerMSP Service Tickets===
As an IT service provider, you provide support to your customers, or Accounts. The services you provide vary and may include installation of new PCs, router setup, anti-virus updates, server administration, printer repair, phone support, fixing network configuration problems, and more. Each incident, problem, or job you handle for a given Account is managed in RangerMSP using a Ticket record.
Use the Tickets window to view and manage all your Tickets.
Each Ticket record is linked to a selected Account, and has a unique Number, Description, Type, Assigned Employee and Status. A Ticket can also be linked to an Account Asset (such as hardware, or software licenses owned by the customer).
The Ticket Status field allows you to check whether a ticket has just been opened, whether it was scheduled with a technician, whether it is awaiting information from a customer, or whether it was resolved and closed.
While viewing Ticket information, you can see all data related to the ticket. This includes scheduled technician visits, open tasks that must be completed in order for the ticket to be closed, special service notes, information regarding the Account's service contract, linked documents, charges for labor, expenses and parts, etc.
The Ticket information is organized on separate tabs, with each tab displaying different information about the Ticket.
The Tickets window is often the window that is most used during day-to-day operations. It helps you keep track of all tasks and issues that need attention.
To each Ticket you can add as many Charge records as you need (for more information, see the chapter about Charges). Charge records help you log all your activity on a single ticket. You can add Labor Charges for work you've performed, Parts Charges to track parts used to solve the problem and Expense Charges to charge for travel time, special deliveries etc.
You can bill you customers for charges collected in RangerMSP by easily generating a QuickBooks invoice from RangerMSP based on all the billable charges.
Here's a screen shot of the Tickets main window:
[[File:Tickets_window_sample.png|center]]
===Introduction to Contracts===
As a computer services business, you probably use service contracts that describe the service terms you provide to your customers. Use RangerMSP's Contract records to manage your service contracts and track their status.
Note that using the Contracts tool is optional. If you don't have special contract terms with your customers and you bill according to the activity performed (such as labor, expenses, and parts), you can use the default system contract that is automatically created for each Account, and avoid creating and managing contracts yourself.
Each Contract record you open in RangerMSP is linked to a selected Account, and has a unique Code, Start and End Date, Type, and Status.
RangerMSP Contracts are categorized according to type: Standard, Block of Time, Block of Tickets and Block of Money. The contract type is set when you create a new Contract, and the system automatically tracks the status of contracts according to their type.
You can create and manage several contracts for each Account and use them concurrently; for example, one contract can be for phone support, another for a one-time network installation project, and another for managing warranties.
Every Ticket and Charge in RangerMSP is created under one of the Account Contracts. When you create a Ticket under an active Contract, the system will warn you if the contract terms are obsolete – e.g. if the block of time allocated has already been used, if the end date has passed, etc.
You can easily generate QuickBooks invoices from RangerMSP based on Charges logged in RangerMSP. You can generate an invoice at the Contract level where all unbilled billable charges related to that contract will be included in the invoice regardless of the Ticket records they are related to (you can also generate invoices at the Ticket level).
When a contract has terminated, change its status to Completed. You can also use the status to indicate that a contract has been suspended or canceled.
Here's a screen shot of the Contracts main window:
[[File:Contracts_window_sample.png|center]]
===Detailed Installation Instructions for RangerMSP-QuickBooks Link===
Follow the detailed instructions below to set up RangerMSP-QuickBooks Link. This procedure is only required once.
<u>Note:</u> during installation, you may be asked to download files from the Internet.
[[File:options_menu.png|center]]
From RangerMSP's main menu select Tools > QuickBooks > Sync Options.
[[File:quickbooks_options.png|center]]
Select the country your edition of QuickBooks belongs to, and click ''Connect'.
[[File:quickbooks_wizard_step1.png|center]]
Click Next.
[[File:quickbooks_wizard_step2.png|center]]
Click Next
You may be asked to install QBFC.
To integrate with QuickBooks, RangerMSP uses the latest direct API technologies offered by Intuit/QuickBooks, known as QBFC. QBFC should be installed on every PC on your network which will be using the RangerMSP-QuickBooks Link.
[[File:install_qbfc_question.png|center]]
QBFC must be installed in order to use RangerMSP-QuickBooks Link. Click Yes to install QBFC.
If you do not have the QBFC installation file, you may download it [http://{{SERVERNAME}}/quickbooks_downloads/ here]. Instructions for downloading the file from the RangerMSP site will appear. Follow these instructions, and then continue with the setup process.
The entire synchronization process takes place between RangerMSP and a QuickBooks company file which you select.<br>Continue following the wizard until you are asked to select the QuickBooks company file you wish RangerMSP to sync with.
If a window pops up with a security message about the QBFC7_0Installer.exe file, allow all security warnings, and run the file.
The QBFC installation will begin:
[[File:qbfc_wizard_step1.gif|center]]
[[File:qbfc_wizard_step2.gif|center]]
[[File:qbfc_wizard_finish.gif|center]]
Click Finish. The QBFC installation is complete.
You should now continue with the RangerMSP-QuickBooks Link wizard.
[[File:quickbooks_wizard_step3.png|center]]
Click Next.
[[File:quickbooks_wizard_step4a.png|center]]
Click on Select to select your QuickBooks company file.
[[File:select_qb_company file.png|center]]
Select the company file and click Open.
[[File:quickbooks_wizard_step4_after.png|center]]
Click Next.
In the following screen, you will be asked to run QuickBooks and open the selected QuickBooks company file as a QuickBooks Administrator user and in Single User mode. Follow these instructions carefully to ensure a smooth installation of the RangerMSP-QuickBooks Link.
[[File:quickbooks_wizard_step5.png|center]]
Follow the instructions in the image displayed above.<br>After logging in to QuickBooks as an Administrator and in Single User Mode, click Next.
RangerMSP will now try to access the selected QuickBooks company file. QuickBooks will display a window requesting permission to allow access to the file. Grant RangerMSP all the relevant permissions.
[[File:quickbooks_permissions.gif|center]]
This QuickBooks window may be displayed in order for you to allow RangerMSP to use QuickBooks.<br>Make sure you select the following settings as illustrated above:
#Always allow access even if QuickBooks is not running
#Login as user with Admin privileges.
<u>Note:</u> The dialog box you see may slightly differ from the one above depending on your version/edition of QuickBooks.
The following confirmation dialog box may be displayed.
[[File:quickbooks_confirm_permissions1.gif|center]]
Click Yes to grant access.
Finally, the Access Confirmation window is displayed.
This is the last confirmation needed to allow RangerMSP to access your firm's QuickBooks data file.
[[File:quickbooks_confirm_permissions2.gif|center]]
Click Done.
[[File:quickbooks_wizard_finish.png|center]]
Click Finish.
[[File:Options_quickbooks_tab2.png|center]]
You will return to the Options window. Confirm by clicking OK.
Done! The RangerMSP-QuickBooks Link setup is now complete.


==See Also==
==See Also==
*[[QuickBooks Link|RangerMSP-QuickBooks Link]]
*[[QuickBooks Link|RangerMSP-QuickBooks Link]]
*[[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

Retrieved from "https://www.rangermsp.com/w/index.php?title=QuickBooks_Link_Account_Options&oldid=8583"