Skip to main content
All CollectionsIntegrationsQuickBooks Desktop
How do I set up the QuickBooks Desktop integration with Spend Center?
How do I set up the QuickBooks Desktop integration with Spend Center?

Learn how to set up an integration between your transactions and your QuickBooks Desktop software.

S
Written by Spend Center
Updated over 6 months ago

As an administrator, you can set up an integration to sync transactions in your Spend Center account to QuickBooks Desktop. To set up this integration, you need to download the Sync Dashboard to your device, create a credit card object in QuickBooks Desktop, and connect the Sync Dashboard to your QuickBooks Desktop account.

Once your integration is set up, you need to configure the integration in Spend Center. Once the integration is configured, you can select the transactions to sync and complete the sync from the Sync Dashboard.

Note: The Sync Dashboard can only be used on Microsoft Windows devices.


Open QuickBooks Desktop Integration

  1. In the Navigation Menu, click the Integrations link.

  2. In the Available Integrations section, find the Quickbooks Desktop integration. Then click the Connect button.

  3. The QuickBooks Desktop Integration Setup Tutorial displays in Spend Center. You will use this tutorial to set up the Sync Dashboard.

  4. On the first page, review the Terms of Service and Privacy Policy. Then click the Continue button.

  5. Download the Sync Dashboard to your desktop. The Sync Dashboard can only be used on Microsoft Windows devices.


Download Sync Dashboard

Note: Spend Center supports version 3.1 of the Sync Dashboard. If you have previously downloaded the Sync Dashboard, make sure you are on the most recent version.

  1. Open the EXE file downloaded in the previous step.

  2. Close QuickBooks Desktop.

  3. In the Setup window, click the Next button.

    Next Button

  4. Select the destination folder for the Sync Dashboard. Then click the Install button.

  5. The Sync Dashboard downloads to your selected destination folder. When the installation is complete, click the Next button.

  6. When the installation is complete, a Sync Dashboard icon displays on your desktop for easy access.


Create Credit Card Object

  1. Open QuickBooks Desktop.

  2. Click the Company drop-down menu [1] and select the Chart of Accounts option [2].

    Open Chart of Accounts

  3. Click the Accounts menu [1] and select the New option [2].

    New Account

  4. In the Choose Account Type window, select the Credit Card option [1]. Then click the Continue button [2].

    Select Credit Card

  5. Enter “Spend Center” in the Account Name field. The Optional fields can be left empty or completed with additional information. Then click the Save & Close button.


Connect Sync Dashboard to QuickBooks Desktop

  1. Open the Sync Dashboard.

  2. Open QuickBooks Desktop and log in to the company you want to connect as Admin in single user mode

  3. In the Profile Editor window, click the Next button.

  4. The Sync Dashboard will automatically detect the file path of the company that you have open in QuickBooks. Verify the file in the QuickBooks File field [1]. Then click the Next button [2].

    Confirm Your Company File

  5. In QuickBooks Desktop, the Application Certificate for the plugin displays automatically.

  6. Select the Yes, always; allow access even if QuickBooks is not running option [1]. In the Login as drop-down menu, select the Admin option [2]. Then click the Continue button.

    Select Admin Option

  7. In the Access Confirmation menu, click the Done button.

    Access Confirmation

  8. In Spend Center, open the Setup Tutorial (as mentioned in the Open QuickBooks Desktop Integration section of this article) and find the Sync Token field. This field contains a sync token to paste in the Sync Dashboard.

  9. To copy the token, click the Copy Sync Token button.

    Copy Sync Token

  10. In the Sync Dashboard, click the Next button.

    Next

  11. In the Sync Dashboard, enter “token” in the Email/Username field [1]. In the Password/Token field, paste the sync token you copied from the Setup Tutorial [2] Select the Next button [3].

    Enter Tokens

  12. In the Organization field, select the name of the organization you want to sync [1]. Click the Finish button [2].

    Select Organization

  13. In the Sync Profiles window, select the profile to sync [1]. Then click the Sync button [2].

  14. The sync may take a few minutes to complete. When the sync is finished, click the Continue button in the Setup Tutorial.

  15. Once you have synced your Spend Center account with QuickBooks Desktop, you need to configure your integration.


© 2024 JPMorgan Chase & Co.

Did this answer your question?