Integrate iCompleat with Sage Intacct for real-time AP automation

iCompleat can integrate with Sage Intacct to share your accounts payable and purchasing data in real-time.

• Supports top level or company/entity level integration
• Supports dimensions that have been renamed in Intacct
• Supports "Vendor Type" categorisation filter in Intacct
• Supports simple UDDs (does not support UDDs with formulae or one-to-many relationships)
• Integrates with Fixed Assets module
• Integrates with Prepaid Expenses module

This guide explains everything you need to know about integrating iCompleat with Sage Intacct. The setup process involves steps to get your Sage Intacct entity ready to connect with iCompleat, followed by connecting to Sage Intacct from within your iCompleat company.

Want to learn more, book a demo, or register with Compleat Software? Click here.

Integration summary

The tables below show the data that iCompleat retrieves from and posts to Sage Intacct.

 

iCompleat retrieves from Sage Intacct	iCompleat posts to Sage Intacct
Payment terms	Invoice header and line data
Currency codes	Invoices posted as "draft"
Account codes	Invoices posted as "posted"
Departments	New suppliers (configurable in iCompleat)
Projects	Invoice PDF
Delivery sites	URL link to invoice
Bank details	General Ledger posting date
Journal reference of posted invoice	Credit note header and line data (USA only)
Invoice payment status
Tax codes (depending on Sage Intacct customer territory)
Simple user-defined fields
Simple employee dimensions
Locations
Custom fields
Class
Item names and ID dimensions in inventory control

 

Fixed Assets module integration

When you connect iCompleat to Sage Intacct, it automatically detects if the Fixes Assets module is in use. The only step you need to take is to ensure the correct permissions are enabled in Sage Intacct, which we outline in the user role permissions steps further down this guide.

 

iCompleat retrieves from Sage Intacct	iCompleat posts to Sage Intacct
Asset class	Asset class
Asset name	Asset name
Asset date into service	Asset date into service

 

Prepaid Expenses module integration

iCompleat retrieves from Sage Intacct	iCompleat posts to Sage Intacct
Prepaid expense class	Prepaid expense class
Prepaid expense schedule	Prepaid expense schedule
Amortisation start date
Prepaid expense name

 

Top level and company level integration

You can choose to connect iCompleat to Sage Intacct at either company level or top level.

Connecting at company level lets you integrate a single Sage Intacct entity with iCompleat. At company level, suppliers, nominal codes and analysis codes must be created separately for each company.

If you manage multiple companies within Sage Intacct you can configure iCompleat to allow the creation of suppliers, nominal codes and analysis codes at a centralised level. This approach, known as Top Level, enables these elements to be shared across all individual companies. 

iCompleat scope's the data to cache from Sage Intacct based on your Sage Intacct setup. For example, at entity level it will automatically cache entity suppliers plus any top level suppliers.

Find Sage's guidance on how top level and entity level works here.

 

Integration steps

Follow the five key steps below to integrate iCompleat with Sage Intacct.

 

1. Add iCompleat to Web Services Authorizations in Sage Intacct

The first step is to add iCompleat to the Web Services Authorizations list in your Sage Intacct account. This lets the two systems share information with one another and is essential if you want to enjoy two-way integration between iCompleat and Sage Intacct.

To do this, log into Sage Intacct, and go to Company > Setup > Company.

Add CompleatMPP to your list of Web Services Authorizations, and make it active.

 

2. Create a Web Services user in Sage Intacct

Next you need to create a Web Services user. This is a user within Sage Intacct that you'll use to perform the integration with iCompleat.

Make sure the user you create has full admin privileges. 

Once you've created the user, you'll get an email from Sage Intacct confirming the username and password, and the company within Sage Intacct that it's associated with.

To create the user in Sage Intacct, go to Company > Admin > Web Services Users.

 

3. Create a role with the correct permissions

The final step within Sage Intacct is to give your new Web Services user a role that has the correct permissions in place so that iCompleat can access the information it needs.

With your Web Services user still on screen, go to Roles Information, and click a cross (+) icon in the grid to add a new role.

We recommend calling the role CompleatWebServicesUser.

Then, go to Company > Roles, find your new role in the list, and click Edit beside it.

Click View Subscriptions, and then configure the permissions for each of the modules in the drop-downs below.

If there are modules listed that you don't use, you don't need to configure their permissions. We've only listed the permissions that you should enable; you can leave all other permissions unticked.

 

 

4. Connect to Sage Intacct

Our connector manages and protects all the information that's passed between Sage Intacct and iCompleat. Any information shared is secure and encrypted.

To connect to Sage Intacct, follow these steps.

 

1. On the homepage, click Configuration.
2. Click Company.
3. Select Connection.
4. Next to Connect to a new finance system, click Connect.
5. Click Sage Intacct.
6. Enter the Sage Intacct login details for the web services user you created in step 2.
7. When the connection is confirmed, click Test Connection.
8. Select whether to integrate with Sage Intacct at top level, or to a specific entity, and click Connect.
9. Ensure Sage Intacct is the selected from the drop-down, and click the search button.
10. If you're connecting Sage Intacct at company level, select the entity you want to connect to iCompleat.

    If you're connecting at top-level, ensure Top Level is selected from the available companies drop-down.

    
11. In the supplier email drop-down, select whether you'd like iCompleat to cache primary or secondary supplier email addresses for sending approved orders.
12. In the Attachment folder drop-down, select AP Bills.This tells iCompleat where to collect data from Sage Intacct.
13. Select which types of Sage Intacct suppliers you'd like to cache into iCompleat.

    All supplier types are selected by default, but you can click the black X to remove this option and manually select supplier types individually.

    Any supplier types that you don't select won't be available to use in iCompleat for ordering and coding invoices.

    
14. From the Base Currency drop-down, select a currency.
15. Click Connect.
16. Select the features you use in Sage Intacct for your company from the drop-downs, and then click Save.

    Our recommended settings are already selected by default.

    
17. Job done!

    When the connection is complete, Sage Intacct is listed as your connector.

 

5. Customisation

Once iCompleat is connected to your Sage Intacct company, there are a couple of extra customization steps you can take.

 

Choose how invoices are posted to Sage Intacct

By default, fully approved invoices in iCompleat are posted to your Sage Intacct company as Submitted invoices. If you'd like to carry out work on invoices in Sage Intacct after they are posted and use an approval process outside iCompleat, you can choose to instead have invoices posted to Sage Intacct as Drafts.

To do this, go to Configuration > Company > Connection, and turn off the Posting toggle.

 

 

Edit Sage Intacct custom fields

iCompleat extracts your user-defined custom fields from Sage Intacct so that you can use them to code transactions.

You can view and edit these by going to Configuration > Company > Connection, and selecting Configure next to Custom fields.

If you use the Prepaid Expenses and Fixed Assets modules in Sage Intacct, you can configure the relevant custom fields for those modules here.

 

 

To view a custom field and edit its behaviour in iCompleat, select it from the list.

Depending on the type of custom field (Date, Predefined, Number, Simple text, etc.) your options for editing may vary.

Here's a custom date field, with the options to allow past dates, future dates, and make it a mandatory field on invoices to be posted to Sage Intacct:

 

 

 Still got questions? Comment below and let us know how we can improve this guide.