Advice and answers from the zExpensify Team

Expensify integrates with Paylocity using our custom export formats for users that would rather reimburse reports outside of Expensify.

How to Connect with Paylocity

Step 1: Create a company account, upgrade to the Corporate policy, and create a company policy.

Step 2: Add payroll codes in Expensify

This step is a little more involved, in the sense that you’ll have to know your organization’s setup in Paylocity. As a generalized example, a basic setup for Paylocity import file includes five columns. In order (from left to right), these columns are: 

  • Employee # - Company defined
  • Earning/Deduction Type - Use Deduction for Expense Reimbursement (Ex: D)
  • Earning/Deduction Code - See the Deductions link under Payroll Setup in Paylocity (Ex: EXPNS)
  • Blank Column
  • Amount 

In Expensify, you can enter the Earning/Deduction Code as a Payroll Code at Admin > Policies > [Policy Name] > Categories.

The Employee # is entered in the Payroll ID column in the People section (this is below the Categories section in the Policy Editor). 

Step 3: Create Paylocity Export Format

When you’re ready to close your payroll period and export your expense report information from Expensify to Paylocity, you’ll need to have the correct export format setup. Step 3 lists the column order for Paylocity. This step will show you how to create this setup in Expensify.  

The first step is to visit Admin > Policies > [Policy Name] > Export Formats.

Step 4: Export Reports using Your Paylocity Format

Good news! This is the easy part. Just go to your Reports page, choose all the relevant reports you’d like to export, click on the “export to…” button and select the name of your Paylocity export file format.

And you’re done!

Did this answer your question?