Sage Intacct <-> Modeloptic Connection Instructions

The instructions below will walk you through how to authorize Modeloptic to retrive data from your Sage Intacct account. If you'd like help on any part of this process or run into any issues, please don't hesitate to contact us and we'll be happy to assist!

Enable Web Services
  1. Company -> Admin tab -> Subscriptions
  2. Find "Web Services" and click on it to Subscribe
  3. Ignore the warning about additional charges (you won't be charged)
Add Modeloptic under Web Services Authorizations
  1. Company -> Setup tab -> Configuration header -> Company
  2. Click Edit
  3. Click on the "Security" tab
  4. Go to the section labeled "Web Services authorizations" and click "Add"
  5. Under "Sender ID", enter: modelopticMPP
  6. Under "Description", enter: Modeloptic
  7. Be sure the status is set to Active
  8. Hit Save twice (once in the authorizations menu, and once in the company settings menu).
User Authorization

Instructions vary slightly depending on if you use "User-Based" or "Role-Based" security.

[OPTIONAL: IF YOU ARE USING "Role-Based" Security]: Create a Role
  1. Go to Company -> Admin -> Roles (click the plus sign next to it)
  2. In the Name and Description fields, enter: Modeloptic
  3. Click SAVE
  4. Check the boxes for the following lines, and for each, click on the "Permissions" link, click the "Read only" option within each section, then click "Save":
    • Company
    • General Ledger
      • After clicking the "Read only" options, find the "User-defined books" line and also select the "List" and "View" permissions
    • Accounts Receivable
    • Accounts Payable
    • Consolidation (if applicable)
      • After clicking the "Read only" options, find the "Manage books" line and also select the "View" permission
  5. Click Save
Create a Web Services User
  1. Go to Company -> Admin -> Web Service Users (click the plus sign next to it)
  2. For User ID, enter: modeloptic-user
  3. Fill out contact information for whoever is managing your Modeloptic Account
    • After you complete the rest of the steps in this section, Sage will send an email to the email address you enter containing credentials that will need to be entered into Modeloptic to enable access your Sage account
  4. Set User type to: Business
  5. Set Admin privileges to: Limited
  6. Set Status to: Active
  7. [OPTIONAL: IF YOU ARE USING "Role-Based" Security]: Click on the "Roles information" tab and select the Role created in the prior step
  8. Click SAVE
  9. Ignore any warning that there will be a charge for creating the User (you won't be charged)
Enter User Credentials into Modeloptic

Log in to Modeloptic, navigate to the Historical Data page for your company, and click into your Sage Intacct Data Connection. You should see a section that looks as follows:

Click on "Edit Sage Intacct Credentials", which will open up the following screen:

After finishing the "Create a Web Services User" step above, you should have received an email that shows your Sage Intacct Company ID and Password for the Web Services User that you created. Enter those here, and click "Save & Close".

Your integration should now be live!

Back to the Documentation