If your organization relies on Sage Intacct for accounting and Fyle for managing expenses, you're in the right place. The Fyle-Sage Intacct integration streamlines the flow of financial data between these two essential systems, making your job easier.
In this article, we'll walk you through the process of setting up the integration step by step. Whether you're new to the integration or need a quick refresher, this guide will provide the context and instructions you need to get started.
Connect to Your Sage Intacct Account
Access the Integration:
Go to the Fyle Admin Settings page.
Navigate to Integration > Native Apps > Sage Intacct.
Connect Your Account:
Click the Connect button to link your Sage Intacct account with your Fyle account.
Enter Required Credentials:
You'll need to provide specific credentials. For detailed instructions on generating these credentials, please refer to our guide.
Choose a Location Entity:
After successfully connecting, select a Location Entity. This choice will determine where expenses from Fyle will be posted in Sage Intacct in the future.
Complete the connection setup
Click on Save and Continue.
Configure Export Settings
Configuring export settings is mandatory for the Integration and can be tailored to your needs, allowing you to export Reimbursable Expenses/Corporate Card Expenses, or both.
Reimbursable Expenses
Select how reimbursable expenses will be exported: as Expenses, Bills, or Journal Entries.
Choose the relevant account to post these transactions.
Select how your employees are represented in Sage Intacct—as either Employees or Vendors.
(Note: When exporting as Expense Reports, the representation defaults to Employee, and when exporting as Bills, it defaults to Vendor)Choose the state in Fyle from which you want your expenses to be exported to Sage Intacct: either Processing or Closed.
Decide how expenses will be grouped (e.g., as individual transactions or consolidated into a single transaction).
Set the date for transactions in Sage Intacct (e.g., Current Date, Spend Date, or Date of Approval).
Corporate Credit Card Expenses
Choose how corporate card expenses will be exported: as Bills, Charge Card Transactions, Expense reports, or Journal Entries.
Set a default credit card vendor or account to use for unmatched transactions.
Choose the state in Fyle from which you want your expenses to be exported to Sage Intacct: either Approved or Closed.
Decide how to group these expenses (e.g., by expense or by report).
Select the date for transactions in Sage Intacct
Note: Card Transaction Post Date option is only available when exporting expenses as Charge Card Transactions.
Import Settings
Import key dimensions from Sage Intacct to Fyle for streamlined expense management. These include:
Chart of Accounts as Categories in Fyle
Vendors as Merchants in Fyle
Tax Groups as Tax Group in Fyle (for non-US entities only)
You can also import and map additional dimensions such as Projects, Departments, Locations, Classes, Allocations, and Items as Projects, Cost centers, or a select-type custom field in Fyle.
Advanced Settings
Customize and automate your export workflow with advanced settings. Options include:
Scheduling Automatic Exports
Set a frequency for the integration to export expenses automatically.
The Fyle-Sage Intacct Integration allows automatic expense exports from Fyle to Sage Intacct, eliminating manual intervention. You can set a frequency and control how frequently you want expenses (after reaching the desired state of export) to be exported to Sage Intacct automatically.
To ensure seamless exports, admins can enable email notifications for failed exports due to Sage Intacct errors or mapping issues.
If an export fails, an instant email alert is sent with details like date, time, failed transactions, error messages, and a direct link to fix issues. Notifications are only sent when a new expense group fails, this will prevent duplicate notifications for the same export errors.
Auto-Creation of Vendors
Fyle can auto-create new vendors in QuickBooks Online when no match exists, ensuring accurate expense categorization instead of assigning them to Credit Card Misc. Learn more about this functionality here.
Auto-Creation of Employees
Enabling this toggle ensures that if a corresponding employee record is not found in Sage Intacct while exporting reimbursable expenses, the integration will automatically create a new employee record. All current and future expenses for that employee will then be recorded under the newly created record in Sage Intacct.
Auto-Sync Payments
Automatically sync payment status between Fyle and Sage Intacct. When an expense is marked as paid in Fyle, it updates in Sage Intacct, and if a Bill is marked as paid in Sage Intacct, the corresponding expense report in Fyle is closed.
Customizing Descriptions
You can customize the description field in Sage Intacct by selecting or unselecting which data points to export. Data points you can choose from are Employee Email, Employee Name, Merchant, Car Number, Purpose, Category, Spent On, Report Number, and Expense Link.
Export with Next Open Accounting Period Date
If an expense isn’t recorded before closing an accounting period, Fyle allows you to automatically post it in the current open period to prevent export failures in Sage Intacct. Any expense from a closed period will be exported with the first day of the current open period. For example, if the current period is June 1–June 30 and an expense from May 1 wasn’t exported, it will be recorded as a June 1 expense, ensuring accurate reporting and reconciliation.
Skip Export of Specific Conditions
Set conditions and skip export of specific expenses and reports. Learn more about this functionality here.
Default Values
Set default values for Location, Class, Department, Project, and Item. If these fields are marked as mandatory fields on Sage Intacct and if any of these values are not selected in the expense form, then the integration will apply these default values, preventing the expense from being exported to Sage Intacct.
Additionally, you can choose to use the employee's assigned Location or Department from Sage Intacct by selecting the Use Employee’s Location and Use Employee’s Department options.
Next Steps
Learn how to export expenses using the Fyle Sage Intacct integration by referring to this article.