This article covers:
Do you use Microsoft Dynamics (outside of our Stoneridge Software link for Dynamics 365, AX, & NAV), Sage, MYOB, Oracle, or SAP? We've got you covered!
Along with the direct integrations Expensify supports, there's also an option to integrate with other accounting solutions via a flat-file import.
When you select one of these accounting packages on the Accounting Inbox task, Expensify will automatically create and add a relevant Export Template for you. The template will allow you to quickly and easily transfer report data to your accounting package.
Inbox Task Setup:
1. After selecting the "Collect" Task you'll be taken through a few Policy Setup tasks in the Inbox
2. When you reach the Accounting Software Inbox Task, you can now select Sage, Microsoft Dynamics, MYOB, Oracle, or SAP - along with the direct accounting integrations Expensify offers: (shown below)
3. Select your accounting package from the list
4. You'll receive a confirmation message (shown below) and the respective Export Template will be added to the account
From then on, it will show in the "Export to" option on the Reports Page:
Expenses can be exported to these import templates directly by selecting the checkboxes against either specific reports on the Reports page (shown above) or directly from within the Report itself (shown below):
Third Party Built Connectors
In addition to the direct integrations developed by Expensify, the export templates offered here and via CSV upload, there are currently two connectors built by third parties and vetted by Expensify for quality. These allow seamless connection to Microsoft Dynamics 365, AX, & NAV and Sage Financials and Sage Accounting respectively.
- Check out the guide for Stoneridge Software's Dynamics 365 Connector here*
- Check out the guide for Soljit's Sage Financials and Sage Accounting Connectors here
*Update for April, 2019: With the recent Dynamics 365 Business Central release, Stoneridge Software has removed the app from the Microsoft AppSource directory for a short period whilst they upgrade and make sure it functions smoothly with all current versions. It'll be back soon though!
I can't find my export template. Templates have been automatically placed in accounts starting early March 2017. If you've chosen an indirect accounting integration before that date, simply head to Settings > Policies > [Policy Name] > Connections page and select "Connect to" for the template to be placed in the account.
How can I tell which reports have already been exported? The Reports page has a column titled Exported where an icon will show if the report in-line has already been exported:
You can also see the full history of the report from the Report History and Comments section, including whether it has been exported or not, and the name of the accounting integration or template it was exported to: