Using Accounting Link to Exchange Data With QuickBooksPro/Premier 2004 - Accounting Software Secrets
book-template-default,single,single-book,postid-17983,bridge-core-2.6.3,qode-page-transition-enabled,ajax_fade,page_not_loaded,,qode-theme-ver-24.8,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.5.0,vc_responsive

Using Accounting Link to Exchange Data With QuickBooksPro/Premier 2004

Text Box:

Using Accounting Link to Exchange Data With QuickBooksPro/Premier 2004

Using Accounting Link to Exchange Data With QuickBooksPro/Premier 2004

For 2005 set up


Legrand CRM Accounting Link Provides a simple, yet effective way to link your CRM data to your QuickBooks PRO and Premier 2004 accounting data. Legrand’s Accounting Link further increases the effectiveness of your office systems by creating a seamless link between Legrand CRM and your QuickBooks PRO or Premier 2004 accounting system – no more double entries, no more wasted time.

With a few simple clicks, your sales people and account managers will be able to access a customer’s outstanding balances, contact information, credit limit and accounting notes, all within Legrand CRM’s consolidated information center – allowing your team to operate more efficiently and more effectively.


  • 1.       Import QuickBooks contacts into Legrand CRM
  • 2.       Create new Customers in QuickBooks from Legrand CRM
  • 3.       Ensure Customer addresses and Contact details are consistent between the CRM and accounting databases.
  • 4.       Import a Customer’s Credit Status, Account Balances and Notes into Legrand CRM.  Once imported into the Legrand CRM database, these accounting summaries are available to all Legrand CRM users, including remote users who will get the latest update when they synchronize their database.
  • 5.       Provides your front office staff (using Legrand CRM) with financial summaries about your Customers without Providing direct access to the QuickBooks accounting system.

QuickBooks Requirements

  • ·         QuickBooks PRO 2004 or Premier 2004, or higher.
  • ·         QuickBooks must be installed on the computer that will run Accounting Link.
  • ·         Although not strictly speaking a requirement, please note that Accounting Link will operate faster if QuickBooks is running on your computer when you execute Accounting Link.

Legrand CRM Requirements

  • ·         Accounting Link works with Legrand CRM V4 PRO and CORP editions.
  • ·         Accounting link is licensed per Legrand CRM serial number and requires an activation key to operate.


Installing and activating Accounting Link



Text Box: Installing Accounting Link is easy.  All you need is to copy the file into your Legrand application directory.  You can download the file from www.Legrand CRM .com.


To enable the use of Accounting Link you will need to record the activation key, which is a 10-character code linked to your Legrand CRM serial number.

To record the activation key, first log into Legrand CRM and then select Help > About from the menu at the top of the screen; then click on the “Record License” button on the About screen.

When presented with the License Registration screen, simply enter the 10-character activation code for the Accounting Link option.


Configuring Accounting Link

After you have recorded the activation code the next step is to specify in Legrand CRM to which accounting database the current CRM database is going to be linked to.

You will need to have System Administration user access rights to perform this function. In the menu at the top of the screen select Administration > System Administration then click on the command button Configuration Options, then click on the button Accounting System.

You will then be presented with a screen where you will specify the accounting system that this Legrand CRM database will link to.

Note:  every Legrand CRM database can have its own Accounting Link.  If you operate multiple Legrand CRM databases and multiple accounting systems you can actually link one Legrand CRM database with a QuickBooks Premier database, and link a second Legrand CRM database to another QuickBooks Premier database or even to another accounting system from one of the other supported suppliers.

In the Accounting Link Setting screen simply click on the accounting system (i.e. in this case, QuickBooks) and then click on the browse button to navigate to the QuickBooks data file (i.e. a file with a .qbw extension if using QuickBooks PRO, or a .bpw extension if using QuickBooks Premier).


First Time Import from QuickBooks

To run the Accounting Link interface go to the menu at the top left of the screen and select File > Import > Accounting Data > Import from QuickBooks..

In most cases the first time import is when you want to transfer all your Customer accounts from QuickBooks to your Legrand CRM database.  All you need to do is tick the “Scan QuickBooks for any accounts that do not exist in Legrand CRM” box.


The next step in the Accounting Link wizard will then scan your QuickBooks data and will present you with the list of Customer accounts that exist in QuickBooks but not in Legrand CRM.

You then have the option to specify exactly which accounts are to be transferred across from QuickBooks and created in Legrand CRM.

In this example we will only Process two accounts.  First click on “Unselect All” to clear all selections and then click on the check box for Mike Balak and Renee Barley to select those two accounts.

Click on the next step in the Accounting Link wizard and the system will Process all the Customer accounts you have selected, creating each one in Legrand CRM.  Upon completion of the wizard click on “All Companies” in Legrand CRM to show all companies, including all those just created by the Accounting Link wizard.


Click on the “Accounting” tab to bring forward the accounting data section.  You will notice that even though the Customer record has been created in Legrand CRM the financial summaries have not yet been brought across, but you will notice that Accounting Link has recorded in the unique QuickBooks Customer ID for each account it has created in Legrand CRM.

To bring across the financial summaries it is simply a matter of running the Accounting Link wizard a second time, but this time we select to “Get the latest financial data“. 


When the Accounting Link has completed you can view the Aged Balances of this customer in Legrand CRM, as well as any Customer notes in QuickBooks and the Customer’s credit limit. The Sales information is not currently imported.

For users with a valid accounting interface license the information displayed on the accounting tab will be refreshed in ‘real time’, for users without, the information displayed will be the balances from when the last financial import was run.

The Updated on field displays when the information was last updated.


Users with a valid accounting interface license will be able to get ‘live‘ access to the list of invoices in QuickBooks for the current Customer record in Legrand CRM.

While viewing the invoice listing there is also a drill down function. Simply by double clicking on an invoice in Legrand CRM, the corresponding Invoice is opened in QuickBooks.

Creating a new Customer in QuickBooks

To create a new account in QuickBooks from Legrand CRM is a simple two-step Process.

The first step is to identify, or mark, in Legrand CRM the Customer record that needs to be created in QuickBooks.   Simply navigate to the appropriate company record in Legrand CRM and click on the Accounting tab to show the accounting data section.

Right-mouse click on the blue underlined “Accounting” label to pop up a menu of commands, then select the “Create Next Time” command.



That’s it!  Next time you run the Accounting Link you can elect to create this record in QuickBooks.

Please note that the system will only create the record in QuickBooks if you select the option in Accounting Link to “scan Legrand CRM for accounts to be created in QuickBooks“. 

After you have run Accounting Link wizard you will notice that the app ropriate record has been created in QuickBooks, and the QuickBooks unique customer id has been recorded in the Legrand CRM database.




Simple, yet effective.  The Accounting Link wizard enables you to transfer your Customer records from QuickBooks to Legrand CRM, enables you to create new customer accounts in QuickBooks from Legrand CRM, and enables you to store accounting summaries in Legrand CRM on every customer that has been linked to QuickBooks.




More information on this topic

Contact Management Add-Ons