Pro-Tips Monday: Expensify Integrates with NetSuite

Jason Mills —  June 4, 2012 — Leave a comment

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.

Initial Setup

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 help@expensify.com.

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.

Configuration for exporting as a vendor bill

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!

No Comments

Be the first to start the conversation!

Have something to say? Share your thoughts with us!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s