Skip to main content
All CollectionsIntegrationsSage Intacct
How do I set up the Sage Intacct integration for my account?
How do I set up the Sage Intacct integration for my account?

Learn how to set up the Sage Intacct Integration, powered by Bill.

S
Written by Spend Center
Updated over 5 months ago

The Sage Intacct integration allows you to sync transaction information from Spend Center to your Sage Intacct account. This integration is set up by generating a Web Services user in Sage Intacct and connecting that user to Spend Center.

Notes:

  • The images in this article display setting up the Sage Intacct integration for a top-level company. If you need to connect Spend Center to a specific entity in Sage Intacct, please create your Web Services user, permissions, and credit card at the entity level.

  • For help troubleshooting sync errors, view the Accounting Integration Sync Errors Troubleshooting Guide.


Open Sage Integration

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

  2. In the Available Integrations section, find the Sage Intacct integration. Then click the Connect button.

  3. A walkthrough displays on the page. Keep this walkthrough open as you follow all the steps in the integration.


Add BILL to Web Services Authorization

To add BILL as a trusted Sender ID for Web Services, follow these steps:

  1. Open Sage Intacct in a new tab. Keep the walkthrough open in a separate tab.

  2. In the Applications drop-down menu, select the Company option.

    Company Link

  3. Select the Security tab. Then select the Edit button.

    Edit Button

  4. In the Web Services authorizations section, click the Add button.

    Add Button

  5. In the Sender ID field, enter “bill.com” in all lower case letters. Then click the Save button.

    Save Information


Create Web Services User

In order to set up your Sage Intacct integration, you will need to create a Web Services user and assign permissions to that user.

  1. Click the Applications drop-down menu, select the Company option and click the ⨁ icon next to Web Services Users.

    Web Services Users

  2. In the User ID field, enter “Spendcenter”. This username indicates a non-billable user and is used strictly for the integration.

  3. In the Last name, First name, and Email address fields, enter the information of the person managing the account or the sync.

    Web Services User Information

  4. In the User type options, select the Business option.

  5. In the Admin privileges section, select the Full option.

    Admin Privileges

  6. Save the details of the new user. Once the user is created, you will receive an email from Sage Intacct with a temporary password.


Assign Role

Click the Roles information tab. Then add the Administrator role to the role names the Web Services user can use.

Select Admin Role

Subscription-Based Permissions

If you are using role-based permissions, follow the steps below:

  1. Click the Applications drop-down menu, select the Company option, and click the Web Services Users link.

  2. Select the XML Bill.com user.

  3. Open Subscriptions.

  4. Click the Permissions link for each module and enable permissions for all modules.

    Open Permissions

  5. For each module, select the All option for the Activities/List and Reports sections.

    Note: Not all Modules include a Reports section.

    Select All Option

  6. Click the Save button.


Role-Based Permissions

If you are using role-based permissions, follow the steps below to create a new role for the XML_Bill.com user, with access to all modules in Sage Intacct.

  1. Click the Applications drop-down menu, select the Company option, and click the ⨁ icon next to Roles.

  2. In the Name field, enter "Billcom Role".

  3. For each module, select the All option for the Activities/List and Reports sections.

    Note: Not all Modules include a Reports section.

  4. Click the Save button.

  5. Click the Applications drop-down menu, select the Company option, and click the Web Services Users link.

  6. Click the Edit link next to the sync user you just created.

  7. Click the Roles information tab [1] and select the role that you just created [2].

  8. Click the Save button.


Find Entity ID

If you want to target a specific entity, follow the steps below to find your entity ID.

  1. In the Applications drop-down menu, open the Company menu. Then select the Entities option.

    Entities Link

  2. Copy to entity ID from the Entity ID column. Paste the ID in the walkthrough in Spend Center.

    Copy Entity ID


Obtain Credentials

After saving the Web Services user, check the email inbox from the email used in step 4 for the Web Services user ID and password. Enter the credentials into set up fields in Spend Center.

Obtain Credentials


Create Sage General Ledger Account

  1. Open Sage Intacct in a new tab and sign in. If you’re signed into Sage Intacct already and have it open, continue to the next step.

  2. Click the Applications drop-down menu. Then select the General Ledger option.

    Open General Ledger

  3. Click the General Ledger Accounts link.

    Open General Ledger Accounts

  4. Click the Add button.

    Add Button

  5. In the Account Number field, enter your desired value.

  6. In the Title field, enter “Spend Center GL Account”.

  7. In the QuickStart Category field, select the category you want to sync to Spend Center.

    Enter Account Details

  8. In the Account type drop-down menu, select the Balance Sheet Account option.

  9. In the Normal balance drop-down menu, select the Credit option.

    Account Type and Normal Balance

  10. In the Period and closing type drop-down menu, select the Non-Closing Account option.

  11. In the GL account alternative drop-down menu, select the None option.

  12. In the Status drop-down menu, select the Active option. The Disallow Direct Posting checkbox should be unchecked.

    Period and Closing Type

  13. Ensure that all dimensions are unchecked. Required dimensions may cause sync failure.

    Uncheck Dimensions

  14. Click the Save button.

    Save Button


Create Credit Card Object

  1. Click the Applications drop-down menu. Then click the Cash Management option.

    Open Cash Management

  2. In the Accounts menu, click the Credit card link.

    Open Credit Card Link

  3. Click the Add button.

    Add Button

  4. In the ID field, enter “Spend Center CC Object”.

  5. Enter information in the other required fields. Ensure that your expiration date is far into the future.

  6. In the Credit card offset account drop-down menu, select the “Spend Center GL Account” that you created in the previous steps.

  7. In the Default location drop-down menu, select a location related to the Spend Center account you are connecting. This location will be applied to all card transactions from this Spend Center account.

    Default Location

  8. Click the Save button.

    Save Button

  9. Your Spend Center account is now connected to the Sage Intacct integration.


© 2024 JPMorgan Chase & Co.

Did this answer your question?