Articles in this section

Integrating MC Trade with QuickBooks (Desktop Version)

Avatar
John Mackenzie
Updated
Follow

Integrating MC Trade with your QuickBooks system allows you to easily keep the two applications in sync with each other. Once connected, MC Trade will be your system of record for revenue transaction detail, and QuickBooks will remain your overall accounting package.

Connecting the two systems is a multi-part process:

  1. Download MC Trade Financials Desktop Integration if you have not done so yet. You will need to contact Support for your license key.
  2. Pointing MC Trade to where the QuickBooks file is located
  3. Authorizing MC Trade as a system that is allowed to push information to QuickBooks
  4. Configuring MC Trade with your Account Codes from QuickBooks

Once these steps are completed, you will have the ability to post Summary Journal Entries into QuickBooks, so that both systems share the information.

For the integration to connect properly, you must install DesktopConnect Financials application on the same machine where the QuickBooks Desktop application is installed. However, the Company File location can be on a shared network, but the user needs to have access to the file location for posting to occur. If you need administrator rights in order to download software to your desktop, you will need to contact your IT provider for assistance.

The steps below walk you through the process of integrating MC Trade to the locally installed version of QuickBooks.  If you are a QuickBooks Online user, please click here for separate instructions.

Part 1: Follow these steps to integrate QuickBooks with MC Trade:

  1. From the MC Trade Financials desktop application, click the Accounting Package Integration tab.
  2. Click the Edit/View Accounting Packages link.
  3. Click New to add a new Accounting Package. A new Row will appear in the data grid.
  4. In the Package Type drop down menu, select QuickBooks.
  5. Enter a name for the Package so you can identify it in MC Trade (this should be the name of your organization because it displays in the "bill to" address on the invoice template).
  6. Fill in the QuickBooks Application Directory. This is the name of the folder in which your QuickBooks opens from, which can be found by right-clicking on your QuickBooks shortcut (desktop), choose Properties, and copying/pasting the Start In value with the quotes (beginning and end) removed.
  7. Enter the QuickBooks Company File Path. This can be found by opening QuickBooks, logging into the Company File, and pressing the F2 Key.  The path is listed next to the title Location.  Close the window before proceeding.
  8. Click Save.
  9. Click the Test QuickBooks Connection link (you may need to scroll to the right to see this).

If for any reason you do not get a successful test message, double-check that you have entered everything correctly and that you do not have any windows open in QuickBooks. If you still cannot get the test to complete successfully, contact our Support Department for assistance.

 Part 2: Authorizing MC Trade as a system that is allowed to push information to QuickBooks

Once you've pointed MC Trade to QuickBooks and clicked the link to Test QuickBooks Connection, QuickBooks will be alerted to the fact that MC Trade is trying to communicate with it.

The following steps are to be completed in QuickBooks:

  1. Log in to QuickBooks with an Administrator-level account
  2. Go to Edit > Preferences and select Integrated Applications from the list.
  3. Click on the Company Preferences tab. MC Trade ("WebLink Connect") should be listed as an application that has previously requested access to the company file. The top check box should NOT be checked.
  4. Select WebLinkCONNECT.
  5. Click in the Allow Access box next to WebLinkCONNECT and/or you may need to click "ReAuthorize"
  6. You are required to have Account Numbers for your General Ledger Account Codes. Click box to select Use Account Numbers. You will also click in the box to select Require Accounts.
    • Please note: if you recognize revenue on an accrual basis, you must create a NEW receivables account with an account type of "Other Current Asset" to integrate with MC Trade. 
  7. Click the Properties button.
  8. Click Allow this application to access this company file. Include any other settings as they appear on the tab to allow WebLinkCONNECT™ access.
  9. Go back to the application.

I'm Connected!..... Now what?

Congratulations!  Now use the articles below to complete the integration:

  1. Import your Account Codes from QuickBooks to MC Trade.
  2. Assign those Account Codes to your Revenue Items, Payment Types, and Adjustment Types.

 Troubleshooting (uh-oh!)

Sometimes an issue causes the integration to not complete correctly. If that happens, please look below for a common solution, or contact our Support department for assistance.

 

 

Powered by Zendesk