In order to establish a connection between Intacct and MarginEdge, there is setup required in both systems. To access everything needed for the setup, you must be logged into Intacct as a user with Full Admin permissions.
Below are the steps walking you through both parts. Please don't hesitate to reach out if you need support.
Note: If you are a Canadian customer utilizing the Canadian tax module in Intacct, this integration will not support that feature. In order to export any items from [me] to Intacct, you will need to first disable this module in Intacct.
FIRST: Intacct
-
Turn on Web Services: Enable the Web Services subscription by going to Company > Subscriptions (or in the Action UI: Company > Admin > Subscriptions).
Scroll down and turn on the toggle as seen below:
-
Authorize the MarginEdge Sender ID: MarginEdgeMPP
-
Go to Company > Setup > Company.
-
Switch to the Security tab, click Edit.
-
Scroll down to Web Services authorization, and click Add.
-
Enter MarginEdgeMPP for the Sender ID and Web Sender ID for the Description.
-
Click Save.
-
-
Create a Role called "ME User" with proper access to communicate with ME
-
Go to Company > Admin > Roles and click on the + (plus sign) to create a new role
- Create a role called ME User and click "Save" in the top corner.
-
This will take you to a page that will let you choose your role descriptions. You need:
Company, General Ledger, Accounts Payable, Accounts Receivable, and Cash Management. -
For each section, you will need to set the Permissions for each role subscription using the following information:
Company
Departments: List, View
Locations: List, View
Attachment Folders: List, View, Add
Attachments: List, View, Edit
General Ledger
Journal Entries: List, View, Add, EditAccounts: List, View
Accounts Payable
Pay Bills: Run
Vendors: List, ViewAP Terms: List, View
Bills: List, View, Add, Edit
Adjustments: List, View, Add, Edit
Payment Requests: Delete
Accounts Receivable
Customers: List, View
Cash Management
Checking Accounts: List, View
- Click "Save" in the upper right corner to save the permissions for this role.
-
-
Create a Web Services User
NOTE: You only need to create one Web Services user account in Intacct for MarginEdge, even if you are connecting multiple restaurants in MarginEdge.-
Go to Company > Admin > Web Services Users and click on the + (plus sign) to create a new Web Services User
- Fill out the form with the proper information. This should be someone in your organization who will be managing the credentials (coming via email) that will be needed to complete the setup in MarginEdge.
-
Be sure the User Type is Business and the Admin Privileges are off
- Then click the Roles information tab and select the ME user role that was created in step #3 and save the user. You may be prompted for the password to complete this setup. It is the same password that was used in the initial login.
NOTE: If you are setting this up for an accounting firm that uses one login to access multiple companies, you will not be able to set a role. You will have to give them full Admin Privileges on the previous screenshot. - Once this is completed, the web services user you created will get an email sent to them providing the Password, Sage Intacct Company ID, and the User ID. All of these will be needed back in MarginEdge.
-
SECOND: MarginEdge
- Log in to MarginEdge and using the navigation bar on the left, go to the Setup > Integrations page. If you have access to multiple units, be sure you have actively chosen the correct unit.
-
Select Intacct from the dropdown and click the button to "Connect to Intacct". Scroll down (we'll get to the other settings in step #3) and you will see the following required fields that need to be filled out using the information sent to the Intacct Web Services User you created. Details about each one are below.
-
Intacct Company ID
-
This is the same company ID used to log into Intacct and can be found in the email that was sent to the web services user
-
-
Intacct Sender ID
-
This should be prefilled and if not, the ID is MarginEdgeMPP
-
-
Intacct User ID
-
This is the user ID that was created with the web services user and can also be found in the email that was sent out.
-
-
Intacct User Password
-
This was also sent out in the email to the web services user that was created.
-
-
Intacct Journal Symbols for Sales Entries
-
This needs a two letter symbol and can be found in Intacct by going to General Ledger > Journal Entries
- Once you are on the screen below look in the symbol column for this value. The vast majority of clients use GJ which stands for General Journal
- Put in the TWO letter symbol Sales Entries
-
-
Intacct Journal Title for Sales Entries
- An optional field, but adding General Journal or General Ledger can be helpful in reporting
- An optional field, but adding General Journal or General Ledger can be helpful in reporting
-
-
Let's look at the additional options found at the top of the Intacct integrations page. More general information about these settings can be found here: How to Export to Accounting with QuickBooks Online, Intacct or Xero
Read below for a few things to know about Intacct specifically.
- Multi-entity shared company: This line is very important and most people need to leave this blank. This should only be edited if the intacct account is run by an accounting firm that oversees multiple companies and has one single login to all units. In this situation they can choose the appropriate location.
-
If using "Locations": When a company has multiple units and you want to choose a specific unit, you would use the If using “Locations” lines to select the appropriate unit.
- Multi-entity shared company: This line is very important and most people need to leave this blank. This should only be edited if the intacct account is run by an accounting firm that oversees multiple companies and has one single login to all units. In this situation they can choose the appropriate location.
-
Once you have made the proper choices, Save the integration settings and let your Implementation Manager know it has been completed. Well done!