> For the complete documentation index, see [llms.txt](https://docs.balkan.id/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/adp-workforce-now-how-do-i-send-hris-data-via-sftp.md).

# ADP Workforce Now - How do I send HRIS data via SFTP?

Send a scheduled ADP Workforce Now employee report to BalkanID's SFTP server: create the report in ADP, schedule its delivery, and add the SFTP integration.

{% hint style="info" %}
BalkanID is retiring its Merge HRIS connector. From 1 December 2026, send ADP reports with the [SFTP integration](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup.md) instead, as described on this page.
{% endhint %}

## Overview

In this guide you create a custom report in ADP, have ADP's Automatic Export Service (AES) deliver it to BalkanID's SFTP server on a schedule, and add the [SFTP integration](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup.md) in BalkanID with the SSH key that ADP provides.

This guide is tailored to ADP Workforce Now. If you have another product, like RUN, DECIDUM or Vantage, the steps may still apply but may look a little different.

## Step 1: Create a custom report in ADP

1. Log in to ADP and click **Reports & Analytics**.
2. Click **Set Up New** under Custom Reports.

   ![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2F3c21b6e4-2ea2-4620-9273-9d3faff79b01-CleanShot_2024-11-27_at_09_34_19.png?Expires=253370764800\&Signature=X3wrSXU4vyVJdnFE4P0IPShueWIN~J5d7Yp~e~oOGA3w~2ov9JhU4KvGGdwAbK2Sg1NIq6l8UgUWMaHwVygO6PdotOp--jLp1dI2OcVTQlLf4eqt7iVBFIpMNMDDB49reMQvu9eGXHUYvqATd493MfSnNlL1p1apnsIYPrAsouSwvqhGYgkEWNHKZRh2ZVLEKbI5tvoLd9PEYq0FLizZcp~-acuZiL6K4ufw9IOeM1EcNbwHUGixxAJkDlLeZRRoG1K0CjOpVhYrgGv3KKW8jSrLmh0RzVs-kvzJtGsVOxaMeY4KwlaFeMFQmwlkq3pW9W492KScnZoiW05ypz0rnQ__\&Key-Pair-Id=K3NV4LZ47N8M46)
3. On the **Set Up New Report** page, give the report a title, for example **Employee-Census.csv**.

   ![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2Fefb50a36-dea8-4cfd-9223-19b7bc483f21-CleanShot_2024-11-27_at_09_36_06.png?Expires=253370764800\&Signature=Q15CcAiK1Tiep71lvvm4zljhpZhu3C11yCOd9qQThnQVhjYjVl2rn0vqH6Ov8Nt0sQrkC6HRxeOlZEUORX8kA~Vkm1V3bXJpPb7axoJTRb8BzxJ9jDh66MJfiK-HdMNYQlVEtb3E~doqB7PlLgSh1yN-qwyVUmU-n9nKXDQL4smwMdrmBCdb8VYuNeqSc-D6zoBDcMdvK7FgOrqalUwnAsgu8t4m9jN3U-RkopTqrDilxS5EwhdKBAUi49Why0j0e-MjjT5pyD9gDawoqOjMmvlHG5z8BzFn1Dx9oW3c9pjrRYfgd0zClE57fsDfsC5GpTulGcDO-x8DpPPoxWdZ~Q__\&Key-Pair-Id=K3NV4LZ47N8M46)
4. Click **Select Fields** to continue.

### Add fields to your custom report

To add a field, search for it under **ADD FIELDS** and click the **+** button to add it to the report on the right.

Add at least:

* The employee's work email. Required.
* **First Name** and **Last Name**. A name is required.
* **Associate ID**. Recommended: it keeps each employee's record stable if their email changes.
* **Reports To Associate ID**, to bring in each employee's manager.
* The hire date, termination date, job title and position status. Recommended: the termination date is how BalkanID knows an employee has left; see [Employees who leave](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup/sftp-sync-behavior.md#employees-who-leave).

The report keeps ADP's column names; you match them to BalkanID's in Step 3. BalkanID keeps only work details from any other column and drops the rest; see [SFTP File Columns](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup/sftp-file-columns.md).

**Note:** We recommend that you **do not** ask ADP to create this report for you, as we've observed this incurs additional fees.

5. When you are done, click **Save + Run**.
6. On the View Report screen, export the report as CSV and click **Run**. Keep this file: you use it as a sample in Step 3.

![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2F1529dcc7-f578-4fe8-98b9-2b38113a8062-image.png?Expires=253370764800\&Signature=BB1OCpalRVszLjMpbXN24LTrKIRcDA78N9rPrY5iDe~DT0taVXb5ZAYn5hFl~0l3RGvrpYaG10wgH~tpL1Ot4NTXiz2UOPd4o7o2n2bnGYGh8bGDTogR317zi~xAehrRVe2VkfU85YhNHpha7VV65UxrJpGMOLZhad1Z06myXMua2QAm8M52121PnMaWR6t7SANKVv-9IIJ7obsrHs0Vk0MLpHI4v6dNB4qwByeYPIkVK9AAeZl-xmoE~dC8luW7hawjSi5Du1B7idmftbmYeXEvxx8kef9x8Xp82cWKDXL8oJr23IsHuajrWSKC9viRlekHtwixZNsXc9kBGwfvJg__\&Key-Pair-Id=K3NV4LZ47N8M46)

If ADP appends a Report Totals row to the report, remove it.

![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2Fcaecae28-6949-4674-8a77-9dc2edacebe8-image.png?Expires=253370764800\&Signature=aAFVzLvUIptJx2l8FgArGsPLghdGwHcbSHzTlSP~1hDEWOyV3TM7~7~51-g9D3mGc9KbC8fUBYk8Lmgmn-kKGZjZ-uyDtZxVZIlH6e36aPhW7twpUaU4-TDRj-ImmO0mDIozZlSw8vCrCpCBmOOiVkLY0rOwkaGckbKuKB5w-ATksWtM2FIvG3h8s6L2c7RXbqT65P~mZQOx-rfKFRhNFgT5~uf-sDNR-mXcxnipDA4xNJeJKcZBRFD2im8EbU27clt0IpzjEOMKtGjStwh5QEm1NSeq2znD6gG2fd8uD-Aup2ED6O7RLjyBI2If8N4V1rcdJh3lspllswzt0L-iVQ__\&Key-Pair-Id=K3NV4LZ47N8M46)

## Step 2: Set up recurring delivery with ADP

To send the report automatically, contact your ADP representative to set up the Automatic Export Service (AES). ADP charges a recurring fee for this, which can cover one or several reports; for pricing, ask your ADP representative. *Charges may vary, but anecdotally we have heard prices range from $30-$50/month.*

To set it up, you complete a Statement of Work (SOW) with ADP. Once it is finalized, ADP applies the automation to the custom report you created. The process typically takes 3-4 weeks.

### How to fill out the SOW

1. In **Client Supplied Information**, fill in:
   1. **WFN Client ID:** the characters to the right of the @ symbol in your ADP login name.
   2. **WFN Security Master:** the person you chose as the Security Master in your ADP instance, likely your ADP admin.
   3. **Authentication Level:** SSH Key (ADP Provided).
   4. **Date Stamp Required:** No.
   5. **Require PGP Encryption:** No. SFTP already encrypts the transfer, and BalkanID does not read PGP-encrypted files.
2. Fill in the connection details with BalkanID's SFTP server. In BalkanID, go to **Configure > Integrations**, click **Add integration**, select **SFTP**, and keep **BalkanID's SFTP server** selected. The values are listed under **Enter these values in the SFTP delivery settings of the system that sends the files**:
   1. **Host Name:** the **SFTP Address**, without `sftp://`.
   2. **Port:** the **Port**, 22.
   3. **Directory:** the **Directory**, `/`.
   4. **FTP Username:** the **User Id**. It is `balkanid-` followed by your BalkanID subdomain: if you sign in at `xyz.balkanid.app`, your User Id is `balkanid-xyz`.

Once the SOW is completed, ADP typically responds in 3-4 weeks with when the report is scheduled, and with the SSH key that authenticates the connection. You need that key in Step 3.

### Scheduling the report

ADP may schedule the report for you. To schedule it yourself:

1. Go to **Reports & Analytics** > **All Custom Reports**.

   ![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2Fc1a75df1-4fd0-4828-92b3-644cc97d31e6-image.png?Expires=253370764800\&Signature=FV5V~Jeq~YFSp8oh-N7e2TEw3kKSFwn~C9L4f5JkqmLKwHpwHvnQz0qQaC~LF0FLXrEhkGFUTbWI993PhM6KNBZ0Ecl~qJjcNh2pgqeSUUhH8F5bUIP8ehbV3VnlDKA2qOpXBonvnRvltSNz52WGD4Nro0jPTTU6zp5UIJO4QcbRCAXybmYtbvznso9SNF6XHs-LheV0FWhsFGA9drqMtQl~KUE7AX4fqxk1pkiw259oVQy8T8EtRY9gFxOim-BObXd~j~WWH2hVMB5BW8RbsJQgcWLid5iRlRqmNDPuTWuC3tRA81Kbvea3sBvDgBJOxJJDWP-R36p0-~jMEmTbGA__\&Key-Pair-Id=K3NV4LZ47N8M46)
2. On the **Reports** main page, find your custom report, open its menu and select **Schedule To Run**.

   ![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2F125dcaf0-735c-475c-90bc-d0b83c291678-image.png?Expires=253370764800\&Signature=OoTMUZb52Irp5fxafORDge6LLJC8yGvr1fCzTaMs3~p8menU9zrh6~LstfsU3LaTn189a7dwHBsTK2mGku5TVa4A7rgvmQ1rPzfyIcBcbUBla8N9jSNkkzaApmrkRFW3R0vEmtBKpe5X3xeoy~HSxcbv9pF9Ux0FIMi7x28bWi4f0rJirRtlLQ4EwSrThJltwnDSu0A9PweyGc8S1J0KOfAoS-z5sb-RWg2gVhR8fg0Y7WuvPb~nPemDnn68-NVtN~-x5ELrdv5k6EGHk74ws5tkdknCGCDPo-PfBnYTFlDp-W1VViQf~w10P~t0Rtm0KlM8mzDXzx43BjkqsVWZ7A__\&Key-Pair-Id=K3NV4LZ47N8M46)
3. On the **Schedule and Distribution** page, set up a recurring schedule and click **Apply**. A daily schedule that finishes before 03:00 UTC is recommended; see [When new files are read](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup/sftp-sync-behavior.md#when-new-files-are-read).

   ![](https://assets.usepylon.com/f49877ed-d3d7-46e1-834d-1ddef64edf14%2F90903168-7c98-4063-ba4e-2a5097081daf-image.png?Expires=253370764800\&Signature=RSpxK~ryRbPfCxlwwg~rUoTf4Beabm9TAvedhvFktINBn5bVOJAlD1StdT17txONxoOKUUEAzPZHJ9-izU~mM9YSMPAC8lLMSqUNkBiougI0mztJB1PcrKO7m7sRA-q3HculKtOe7lNUfQjw3sdc~z9PhW0LwxK2pffvZsfrMCGFvSDB7mCxUz8OiTQX9Y7hqw8bvEWYR-h4v3MsM1eAas5SSGQwJGE5Qe7jniHgN0zmvE8gm~DMvpd6fbmRRvw-q82jhtj8Z7Ivxrfmx0StY1sYTA74cfEYtLcmq8sRktS0F-WZHipT4OtbL5LIr79heHIwEA-fxgy4fUlq6Kooqg__\&Key-Pair-Id=K3NV4LZ47N8M46)

## Step 3: Add the SFTP integration in BalkanID

Once ADP has sent you the SSH key, add the integration as described in [SFTP Integration Setup](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup.md), with **BalkanID's SFTP server** selected. For ADP:

* Paste the SSH key from ADP into **SSH Authentication Key Pair**.
* On the **Employees** card under **Column mappings**, enter the report's file name in **File name pattern**, for example `Employee-Census.csv`.
* Click **Map columns from a sample file**, choose the CSV you exported in Step 1, and match ADP's columns to BalkanID's:

| ADP column                          | BalkanID column               |
| ----------------------------------- | ----------------------------- |
| The work email                      | **Work Email**                |
| **First Name**, **Last Name**       | **First Name**, **Last Name** |
| **Associate ID**                    | **Source User ID**            |
| **Reports To Associate ID**         | **Manager ID**                |
| The hire date, the termination date | **Start Date**, **End Date**  |

## Step 4: Go live

1. Once ADP has delivered the first report, in BalkanID go to **Configure > Integrations**, open the menu on the SFTP integration, and select **Quick Sync**. Otherwise, the report is read at the next scheduled sync; see [When new files are read](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup/sftp-sync-behavior.md#when-new-files-are-read).
2. When the sync finishes, review your employees under **Configure > Users**.
3. Monitor the first few scheduled syncs to catch issues such as missing columns or missing rows.

For a one-time load instead of a scheduled delivery, upload the exported report as described in [Manual user data upload](https://docs.balkan.id/getting-started/setting-up-your-tenant/integrate-employee-data/manual-user-data-upload.md).

## Troubleshooting

* The report must be `.csv` or `.csv.gz`, and its file name must match **File name pattern** in BalkanID.
* If a sync reports a missing column, the report lacks a work email or a name, or the column is not mapped. Add the field to the report, or map it with **Map columns from a sample file**.
* If a sync stops, its history says why; see [When a sync stops](https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/sftp-integration-setup/sftp-sync-behavior.md#when-a-sync-stops).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.balkan.id/getting-started/setting-up-your-tenant/application-integrations/direct-application-integrations/adp-workforce-now-how-do-i-send-hris-data-via-sftp.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
