How-to: Use Paylocity to reimburse employees outside of Expensify

Mark Louis
Mark Louis Expensify Team Posts: 167 Expensify Team
edited June 2021 in How-to Docs

Expensify integrates with Paylocity using our custom export formats. To set this up, you will need to be an admin of a Control policy.

First, you’ll need to add payroll codes in Expensify. Since this is a bit complex, we’ll break this down in detail.

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
  1. In Expensify, head to Settings > Policies > Group > [Policy Name] > Categories.
  2. Enter the Earning/Deduction Code (from Paylocity) as a Payroll Code.
  3. Next, head to the People section of your policy editor.
  4. Click the settings cog to the right of the employee name.
  5. Enter the Employee # into one of the Custom Field columns. (It doesn't matter if you use Custom Field 1 or 2, as long as the CSV export format you create in the steps outlined below lines up with the correct one.

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. Here’s how you create this setup in Expensify:

  1. Go to Settings > Policies > Group > [Policy Name] > Export Formats.
  2. Click on “New Export Format”.
  3. Name your new export, and then change the columns accordingly. Ensure that you enter the columns in this order so they import easily to Paylocity:

Pat yourself on the back! You did it! Now, you can export your reports using your Paylocity export format:

  1. On the Reports page, select the reports you’d like to export.
  2. At the top, click on “Export To” and select your Paylocity export file format.

Related articles: