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 2 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 at the top level, and credit card at the entity level. If accounts are created at the top level, add credit card at the top level.

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


Open Sage Integration

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

  2. In the Available Integrations section, find the Sage Intacct integration.

  3. Select the Connect button.

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

  2. Keep the walkthrough open in a separate tab.

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

    Company Link

  4. Select the Security tab.

  5. Select the Edit button.

    Edit Button

  6. In the Web Services authorizations section, select the Add button.

    Add Button

  7. In the Sender ID field, enter “bill.com” in all lower case letters. Then

  8. Select 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. Select the Applications drop-down menu, select the Company option and select 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

  1. Select the Roles information tab.

  2. Add the Administrator role to the role names the Web Services user can use.

Select Admin Role

4. Select the Applications drop-down menu, select the Company option, and select the ⨁ icon next to Roles.

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

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

Note: Not all Modules include a Reports section.

7. Select the Save button.

8. Select the Applications drop-down menu, select the Company option, and select the Web Services Users link.

9. Select the Edit link next to the sync user you just created.

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

11. Select 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.

  2. Select the Entities option.

    Entities Link

  3. 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 in the 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. Select the Applications drop-down menu. Then select the General Ledger option.

    Open General Ledger

  3. Select the General Ledger Accounts link.

    Open General Ledger Accounts

  4. Select 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. Select the Save button.

    Save Button


Create Credit Card Object

  1. Select the Applications drop-down menu.

  2. Select the Cash Management option.

    Open Cash Management

  3. In the Accounts menu, select the Credit card link.

    Open Credit Card Link

  4. Select the Add button.

    Add Button

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

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

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

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

  9. Select the Save button.

    Save Button

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


© 2024 JPMorgan Chase & Co.

Did this answer your question?