Connect to Sage Intacct
Connect your Workspace to Sage Intacct to automate expense syncing and reduce manual data entry. This guide walks through the setup for user-based and role-based permissions and covers options for exporting expenses as reports or vendor bills.
Note: The Sage Intacct integration is only available on the Control plan.
Overview of Sage Intacct Integration
With this integration, you can:
- Import standard dimensions like Department, Class, Location, Customer, and Project/Job
- Import user-defined dimensions
- Export expenses as Expense Reports or Vendor Bills
- Sync using role-based or user-based permissions
Your available features may vary depending on your Sage Intacct subscription. If a feature isn’t supported, you’ll see an error in Expensify during setup or export.
Integration Setup Checklist
Complete these steps to set up the integration:
- Create a web services user and configure permissions
- Enable the Time & Expenses (T&E) module (if exporting expense reports)
- Set up Employees in Sage Intacct (if exporting expense reports)
- Set up Expense Types in Sage Intacct (if exporting expense reports)
- Enable Customization Services
- Download the Expensify Package
- Upload the package to Sage Intacct
- Add web services authorization
- Enter credentials in Expensify and connect to Sage Intacct
- Configure integration sync options
Step 1a: Set up a web services user (User-based permissions)
If your Sage Intacct instance doesn’t match these steps, skip to Step 1B.
- Go to Company > Web Services Users > New
- Fill out the form:
- User ID:
xmlgateway_expensify
- Name: Expensify
- Email: Use your shared accounting email
- User type: Business
- Admin privileges: Full
- Status: Active
- User ID:
- Assign the following permissions:
- Administration (All)
- Company (Read-only)
- Cash Management (All)
- General Ledger (All)
- Time & Expense (All) – if exporting as Expense Reports
- Projects (Read-only) – if using Projects or Customers
- Accounts Payable (All) – if exporting as Vendor Bills
Step 1b: Set up a web services user (Role-based permissions)
If your Sage Intacct instance uses role-based permissions, follow these steps:
Create the role:
- Go to Company > Roles > + New Role
- Name it
Expensify
and click Save - Go to Roles > Subscriptions and configure the same permissions listed in Step 1a
Create the user:
- Go to Company > Web Services Users > New
- Complete the user form as in Step 1a
- Assign the
Expensify
role to the user and save
Step 2: Enable and configure the Time & Expenses module
Required if exporting out-of-pocket expenses as Expense Reports
- Go to Company > Subscriptions > Time & Expenses
- Toggle on the subscription
- Under Auto-numbering sequences:
- Expense Report:
EXP
- Employee:
EMP
- Duplicate Numbers: Do not allow creation
- Set up sequence ID
EXP
with:- Print Title:
EXPENSE REPORT
- Starting Number: 1
- Next Number: 2
- Print Title:
- Expense Report:
- Under Advanced Settings:
- Fixed Number Length: 4
- Fixed Prefix:
EXP
- Uncheck Enable expense report approval
- Click Save
Step 3: Set up Employees in Sage Intacct
Required if exporting as Expense Reports
- Go to Time & Expenses > + Employees
- If this menu is missing, check role permissions under Company > Roles > Time & Expenses
- Provide:
- Employee ID
- Primary contact name
- Email address (create a contact if needed)
Step 4: Set up Expense Types in Sage Intacct
Required if exporting as Expense Reports
- Confirm your Chart of Accounts is set up via Company Setup Checklist > Import
- Go to Time & Expense > Setup > + Expense Types
- For each type, provide:
- Expense Type name
- Description
- Linked Account Number
Step 5: Enable Customization Services
Note: If you already have Platform Services enabled, you can skip this step.
In Sage Intacct, go to Company > Subscriptions > Customization Services to activate Customization Services.
Step 6: Download the Expensify Package
- In Expensify, from the left-hand menu, go to Workspaces > [Workspace Name] > Accounting
- Select Sage Intacct > Connect to Sage Intacct
- Click Download Package
Step 7: Upload the package in Sage Intacct
Depending on your setup:
-
Customization Services: Go to Customization Services > Custom Packages > New Package
-
Platform Services: Go to Platform Services > Custom Packages > New Package
Then:
- Click Choose File and select the downloaded package
- Click Import
Step 8: Add web services authorization
- Go to Company > Company Info > Security > Edit
- Under Web Services Authorizations, add
expensify
(lowercase) as the Sender ID
Step 9: Enter credentials and connect to Sage Intacct
- In Expensify, go to Workspaces > [Workspace Name] > Accounting
- Click Set up next to Sage Intacct
- Enter your web services user credentials
- Click Confirm
FAQ
Why wasn’t my report automatically exported to Sage Intacct?
If auto-export fails, the specific error will appear in the report’s comment section. Once resolved, you can manually export the report from the report header.
Can I export negative expenses to Sage Intacct?
Yes, but reports exported as Expense Reports must not have a total below $0.