Expensify.org is accepting proposals for new campaigns. Submit yours here by May 15th to receive up to $100,000 in funding for campaigns dismantling injustice related to: Climate Justice, Food Security, Housing Equity, Reentry Services, and Youth Advocacy.

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

Mark Louis
Mark Louis Expensify Team Posts: 140 Expensify Team
edited August 2020 in How-to Docs

Expensify integrates with Paylocity using our custom export formats for users that would rather reimburse reports outside of Expensify. 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:

Sign In or Register to comment.