For today’s Pro-Tips Monday, we’ll walk you through how to integrate Expensify with NetSuite, a leading cloud-based accounting package. NetSuite integration is available on the Corporate plan, and you can also reference this post if you’d like to integrate Expensify with other cloud-based accounting software, such as Intacct.
The pre-requisite steps for NetSuite integration are: 1) Sign-up for an account at http://www.expensify.com; 2) Create a company expense policy (directions); and 3) Map your company’s accounting setup (examples).
Creating Your Export Format
Once the pre-requisites are out of the way, you’ll need to decide how your company will export from Expensify into NetSuite. PAY ATTENTION HERE. THIS PART IS IMPORTANT. NetSuite can accept financial information as “vendor bills”. Which format your company will use depends on your NetSuite implementation. If you’re unsure which is right for your company, please email us at firstname.lastname@example.org.
NetSuite requires the following information on import:
- Reference Number (unique expense report number)
- GL Account
- Location (exact name as found in NetSuite)
- Amount (decimal number; no comma or symbols)
Optional fields include: Department, Customer/Project and Class (all exact names as they appear in NetSuite), as well as Billable (yes/no).
Configuring Your Export File
After you’ve chosen the appropriate format for your company, you will create an export format that any admin can use when exporting from Expensify to NetSuite. To do so, visit Settings > Policies > [Policy Name] > Export Formats. Below is how you’d configure an export file when exporting as vendor bills.
And you’re done! At the end of your next accounting period, you can choose which reports you’d like to export, and the information will be formatted for direct upload into NetSuite. Let us know if you have any questions!