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
In the Navigation Menu, click the Integrations link.
In the Available Integrations section, find the Sage Intacct integration. Then click the Connect button.
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:
Open Sage Intacct in a new tab. Keep the walkthrough open in a separate tab.
In the Applications drop-down menu, select the Company option.
Select the Security tab. Then select the Edit button.
In the Web Services authorizations section, click the Add button.
In the Sender ID field, enter “bill.com” in all lower case letters. Then click the Save button.
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.
Click the Applications drop-down menu, select the Company option and click the ⨁ icon next to Web Services Users.
In the User ID field, enter “Spendcenter”. This username indicates a non-billable user and is used strictly for the integration.
In the Last name, First name, and Email address fields, enter the information of the person managing the account or the sync.
In the User type options, select the Business option.
In the Admin privileges section, select the Full option.
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.
Subscription-Based Permissions
If you are using role-based permissions, follow the steps below:
Click the Applications drop-down menu, select the Company option, and click the Web Services Users link.
Select the XML Bill.com user.
Open Subscriptions.
Click the Permissions link for each module and enable permissions for all modules.
For each module, select the All option for the Activities/List and Reports sections.
Note: Not all Modules include a Reports section.
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.
Click the Applications drop-down menu, select the Company option, and click the ⨁ icon next to Roles.
In the Name field, enter "Billcom Role".
For each module, select the All option for the Activities/List and Reports sections.
Note: Not all Modules include a Reports section.
Click the Save button.
Click the Applications drop-down menu, select the Company option, and click the Web Services Users link.
Click the Edit link next to the sync user you just created.
Click the Roles information tab [1] and select the role that you just created [2].
Click the Save button.
Find Entity ID
If you want to target a specific entity, follow the steps below to find your entity ID.
In the Applications drop-down menu, open the Company menu. Then select the Entities option.
Copy to entity ID from the Entity ID column. Paste the ID in the walkthrough in Spend Center.
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.
Create Sage General Ledger Account
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.
Click the Applications drop-down menu. Then select the General Ledger option.
Click the General Ledger Accounts link.
Click the Add button.
In the Account Number field, enter your desired value.
In the Title field, enter “Spend Center GL Account”.
In the QuickStart Category field, select the category you want to sync to Spend Center.
In the Account type drop-down menu, select the Balance Sheet Account option.
In the Normal balance drop-down menu, select the Credit option.
In the Period and closing type drop-down menu, select the Non-Closing Account option.
In the GL account alternative drop-down menu, select the None option.
In the Status drop-down menu, select the Active option. The Disallow Direct Posting checkbox should be unchecked.
Ensure that all dimensions are unchecked. Required dimensions may cause sync failure.
Click the Save button.
Create Credit Card Object
Click the Applications drop-down menu. Then click the Cash Management option.
In the Accounts menu, click the Credit card link.
Click the Add button.
In the ID field, enter “Spend Center CC Object”.
Enter information in the other required fields. Ensure that your expiration date is far into the future.
In the Credit card offset account drop-down menu, select the “Spend Center GL Account” that you created in the previous steps.
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.
Click the Save button.
Your Spend Center account is now connected to the Sage Intacct integration.
© 2024 JPMorgan Chase & Co.