What to set up in Sage Intacct before your first upload to Validis
Before you can upload your data, Sage Intacct needs to be set up to allow Validis to read it. There are four things to do: authorise Validis as a sender, enable web services, create a web service user, and give that user the right permissions. This is a one-time setup, done in Sage Intacct rather than in Validis.
Please note
You need Top-level administrator access in Sage Intacct to complete these tasks. Without it, the company configuration pages are not visible to you.
Before you start
- Make sure you have Top-level administrator access within the Sage Intacct portal.
- Multi base currencies are enabled, if you use them. To check, go to Company, then Subscriptions, then Multi Entity Console, select Configure, and view Enable multiple base currencies.
On this page:
- Sender ID for Sage Intacct API access
- Enable Web Services
- Creating the Web Service User
- Web Service User Permissions
- Full Web Service User Permissions List
Sender ID for Sage Intacct API access
Step 1
Sign in to your company
Sign in to your company in Sage Intacct.
Step 2
Open the company configuration
Go to Company, then Setup, then Company. You need Top-level administrator access to see the company configuration.
Step 3
Add Validis to the authorization list
Select the Security tab and scroll down to Web Services authorizations. Add a new record to the authorization list, using Validis Holdings as the Sender ID, then save.
Enable Web Services
Step 4
Open your subscriptions
Select Company, then Admin, then Subscriptions.
Step 5
Enable Web Services
Enable Web Services.
Creating the Web Service User
Step 6
Open Web Service Users
Go to Company, then Admin, then Web Service Users.
Step 7
Add the user
Select Add to start creating the user.
Step 8
Fill in the DataShare user details
Every field on the form must be completed: User ID, Last name and First name, Email address, Contact name, User name, User type, Admin privileges, and Status. Use exactly these values to set up the DataShare user.
| Field | Value |
|---|---|
| User ID | DataShare |
| Username | DataShare Validis |
| Account email address | Your email address. Once the user has been created, Sage Intacct sends the credentials you need for the upload to this address, so use one you can access. |
| Status | Active |
| User type | Business |
| Admin privileges | Limited |
Step 9
Add the contact name
The user needs a contact record. In the Contact name field, select the dropdown and select Add.
Enter these details, then select Save.
| Field | Value |
|---|---|
| Last name | Validis |
| First name | Datashare |
| Primary email address | Your email address. |
Step 10
Add a role
Go to the Role section, select the dropdown, and select Add.
You can name the role whatever you like. Enter the name, then select Save.
Step 11
Save the user
With all the fields filled in, select Save. The DataShare web service user is now created, and you should receive an email from Sage Intacct with the upload credentials.
Web Service User Permissions
The new user now needs permissions. How you grant them depends on whether your company is configured for role-based or user-based permissions.
Go to Company, then Admin, then Web Service Users, and open the Permissions and Roles report. From there, go to Roles, then Admin.
- Role based permissions. Assign the user a role with the correct permissions. You can use the default Admin role, or create a new one.
- User based permissions. Amend the user's permissions directly.
Either way, make sure the web service user has access to the following modules. All the required permissions sit within these six.
- Administration
- Cash Management
- Company
- General Ledger
- Accounts Payable
- Accounts Receivable
Note
Sage Intacct requires Edit access on some of these permissions before an extract can complete. Validis reads your data only, and never edits data in your accounting package.
If you want to set the permissions exactly, rather than granting the whole modules, the full permission list sets out what to enable and what to switch off.
To see the permissions a user already has, go to Company, then Admin, then Web Service Users, and select View Permissions and Roles.
Full Web Service User Permissions List
For each module below, select All permissions, then disable the permissions listed. Anything not listed stays enabled.
Administration
| Permission | Disable these actions |
|---|---|
| Application Subscriptions | Subscribe, Configure, Remove, Assign Users |
| Grant Admin Rights | Grant |
| Messages | Add, Edit, Delete |
| Users | Add, Edit, Delete, Permissions, Impersonate |
| External Authorizations | Add, Edit, Delete |
| Clients | Add, Edit |
| Templates | Add, Edit, Delete |
| Cancel Service | Run |
| Access Log | Run |
| Audit Log | Run |
Company
| Permission | Disable these actions |
|---|---|
| Affiliate entity groups | List, View, Add, Edit, Delete |
Cash Management
| Permission | Disable these actions |
|---|---|
| Rule Set Performance Log | List, View |
| Bank/Check Register | Run |
| Deposits Register | Run |
| Receipts Register | Run |
| Credit Card Register | Run |
| Cash Balances | Run |
| Cash Analysis | Run |
| CM Revaluation Report | Run |
| Adjusted Available Cash | Run |
General Ledger
| Permission | Disable these actions |
|---|---|
| Journal Entries | Reclass |
| Statistical Journal Entries | Reclass |
| Adjusting Journal Entries | Reclass |
| Statistical Adjusting Journal Entries | Reclass |
| User-Defined Journal Entries | Reclass |
| GAAP Adjusting Entries | Reclass |
| Tax Adjusting Entries | Reclass |
| Restriction Release | List, View, Generate, Delete |
| Financials | List, View, Add, Edit, Delete |
| Trial Balance | Run |
| Graphs and Performance Cards | List, View, Add, Edit, Delete |
| General Ledger | Run |
| Department Activity Report | Run |
| Location Activity Report | Run |
| Deferred Revenue Forecast | Run |
| Deferred Revenue Forecast Graph | Run |
| Deferred Revenue Details | Run |
| Deferred Revenue Revaluation Report | Run |
| General Ledger Revaluation Report | Run |
Accounts Payable
| Permission | Disable these actions |
|---|---|
| AP Advances | Edit, Delete |
| Vendors | Unmask Bank Details |
| AP Ledger | Run |
| Recurring Transaction Status | Run |
| Vendor Aging Reports/Graphs | Run |
| Check Register | Run |
| Form 1099 | Run |
| 1099 Reports | Run |
| Reclassification Report | Run |
| AP Open Items Revaluation Report | Run |
Accounts Receivable
| Permission | Disable these actions |
|---|---|
| Print/Email Dunning notice | Run, List, View, Resend |
| Dunning Levels | List, View, Add, Edit, Delete |
| AR Ledger | Run |
| Recurring Transaction Status | Run |
| Recurring Transaction Forecast | Run |