Direct Deposit Data for Asia Pacific Employees

Activate User's Guide
Version
2025.1
Direct Deposit Data for Asia Pacific Employees

Use the Direct Deposit Data for Asia Pacific Employees wizard to upload employee direct deposit data for the Asian region to Dayforce. This wizard saves time and effort by reducing manual data entry.

Note: If this wizard doesn’t show under Load Your Data, check in Dayforce to make sure that you have a pay group and the corresponding (generated) pay calendar for the country you are attempting to load data for.

Note: Activate uses HR Version 2.0 (NextGen) when loading data during configuration.

Note: You can run this data load more than one time.

Supported countries

To see a list of the countries supported by this wizard, click here.

  • China (CHN)

  • Hong Kong (HKG)

  • India (IND)

  • Indonesia (IDN)

  • Malaysia (MYS)

  • Philippines (PHL)

  • Taiwan (TWN)

  • Thailand (THA)

Important: This wizard doesn’t do any country-specific validations. The data should be correct in the template before you use this wizard to import the data.

Before you begin

Employees included in the Direct Deposit Data APJ template must exist in Dayforce.

Using this wizard

The previously loaded employee direct deposit information shows in an editable grid with the compensation-related fields that need to be populated. You can enter information directly in the grid or you can download the Direct Deposit Data APJ template, populate it, and then upload the data. When you edit the data in the grid, Activate shows any applicable validation warnings or errors. If warnings or errors show, you must review and update the data in the grid or upload a corrected template to correct it.

Best Practice: Enter required changes in the template to ensure that future uploads are accurate. If you make edits directly in the grid, click Save and download the updated file for record keeping purposes.

Tasks

To complete and upload the APJ Direct Deposit Data template:

  1. In Activate Central, click Load Your Data. The Load Your Data wizards show.

  2. Click Direct Deposit Data for Asia Pacific Employees.

  3. On the APJ Direct Deposit Data page, click Download.

  4. Select the location where you want to save the template document.

  5. Open the DirectDepositDataTemplateAPJ.xlsx template on your computer.

    Note: You can also download an empty Direct Deposit Data for APJ Employees template from the Download Template Files page.

  6. On the DirectDepositData APJ tab, complete all columns with the data for all employees in the organization.

    Note: The Activate release version shows in cell B3 on the Instructions tab of the template. This information helps you later determine the version of Activate you were using when you downloaded the template.

    Note: Instructions for populating the fields are in the Direct Deposit APJ Template Fields section (below) and on the Instructions tab of the template.

  7. Click Save and close the template.

    You can use any file name for the template you upload. The file must be an Excel or CSV (Comma-Separated Value) document and contain the data in the required format.

    Important: Don’t change the name of the tab. Activate uses it to validate that the correct template is being uploaded.

  8. On the APJ Direct Deposit Data page, click Upload.

  9. Go to your completed APJ Direct Deposit Data template in the location where you saved it.

    Note: If the uploaded file has errors, a Validation Failed message shows in red at the bottom of the page. You must correct the errors in the file on your computer and upload the file again.

  10. Click Next.

To review and confirm the data:
  1. Review the information shown in the grid.
  2. To make updates to data on the page:

    • To insert a new row in the grid, click the row where you want to insert it and click New.

    • To delete a row, click the row and click Delete.

    • To download the error message list and save it to your computer, click Download Errors File.
    • To correct errors in the grid, click in the field containing the error. Click Tab to move to the right and Shift+Tab to move to the left in the row. Use the scrollbars on the right side and bottom of the grid to go to other areas of the grid.

    • To save information in the grid to your computer, click Download File and save it to the location you want.

    • To upload the file from your computer, locate the file and click Upload File. The data in the file shows in the grid.

    • To remove changes that you don’t want to save, click Refresh.

  3. When the data is complete, click Done & Install. When you leave the page, the selected values stay in the grid.
To install APJ Direct Deposit information:

When the direct deposit information is complete in Activate, you must install it in Dayforce.

  1. After making any necessary corrections, on the APJ Direct Deposit Review page, click Load.

    The Load page opens with a list of the steps to complete and an estimate of how long the installation usually takes. During the installation, the current step in the process is bolded so you can monitor the progress.

    Important: If No shows in the Is Remainder column for any direct deposit records, Dayforce generates a physical check for any excess funds for those records.

  2. Click one of the following:

    • Add Email and enter your email address to receive an email when the installation process ends, instead of waiting for it to finish.
    • Next w hen the installation is complete.

    Activate Central opens with the name of the Wizard now shown in green text and a green checkmark to the left of the wizard’s name. The current day, date, and time of completion are included, along with your name as the user who completed the Wizard. The environment in which the installation was applied (Stage, Config, or Train) is also shown.

    Note: If you want to add more information, click I want to add more. See Executing a Rollback When Using the “Add More“ Feature in the Payroll Wizards.

Results

Fields populated in Dayforce

The data uploaded from the APJ Direct Deposit Data template populates the fields on the Direct Deposit page (People icon > Payroll > Direct Deposit) in Dayforce.

Note: You must select an employee if you haven’t already done so.

Dayforce fields populated by the APJ Direct Deposit Data template
Field in Template Field in Dayforce
Employee Identifier Employee Reference / Number
First Name First Name
Last Name Last Name
Bank Code Bank Code
Branch Code Branch Code
Account Number Account Number
Account Holder Account Holder
Deposit Order Deposit Order
Is Remainder Is Remainder
Percentage Value Percentage Value
Amount Value Amount Value
File generated by the Direct Deposit Data for APJ Employees wizard

After completing the Direct Deposit Data for APJ Employees wizard, a single import file is automatically generated and placed on the customer's FTP site.

HR Import

  • FTP Subdirectory: Import/HRImport
  • Filename: <Namespace> HRImport <DateTime>.xml
For an example illustrating how translates the template data to XML, click here.
Copy
Copy 
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<EmployeeImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Employee>
        <XRefCode>980005</XRefCode>
        <EmployeeNumber>980005</EmployeeNumber>
        <FirstName>Sam</FirstName>
        <LastName>Carter</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>789</RoutingTransitNumber>
            <AccountNumber>257607668</AccountNumber>
            <DepositNumber>1</DepositNumber>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>true</IsRemainder>
            <AccountHolder>SAM CARTER</AccountHolder>
            <BankName>024</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980010</XRefCode>
        <EmployeeNumber>980010</EmployeeNumber>
        <FirstName>Sisel</FirstName>
        <LastName>Suresh</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>ICICI</RoutingTransitNumber>
            <AccountNumber>025301613515</AccountNumber>
            <DepositNumber>1</DepositNumber>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>true</IsRemainder>
            <AccountHolder>SISEL SURESH</AccountHolder>
            <BankName>ICIC0000253</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980008</XRefCode>
        <EmployeeNumber>980008</EmployeeNumber>
        <FirstName>Nadia</FirstName>
        <LastName>Even</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>001</RoutingTransitNumber>
            <AccountNumber>7013009728</AccountNumber>
            <DepositNumber>1</DepositNumber>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>true</IsRemainder>
            <AccountHolder>NADIA EVEN</AccountHolder>
            <BankName>7375</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980014</XRefCode>
        <EmployeeNumber>980014</EmployeeNumber>
        <FirstName>Arcelia</FirstName>
        <LastName>Yuna</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>081</RoutingTransitNumber>
            <AccountNumber>1011720604</AccountNumber>
            <DepositNumber>1</DepositNumber>
            <DepositValue>20</DepositValue>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Arcelia Yuna</AccountHolder>
            <BankName>7171</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980014</XRefCode>
        <EmployeeNumber>980014</EmployeeNumber>
        <FirstName>Arcelia</FirstName>
        <LastName>Yuna</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>146</RoutingTransitNumber>
            <AccountNumber>0150166134</AccountNumber>
            <DepositNumber>2</DepositNumber>
            <DepositValue>35</DepositValue>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Arcelia Yuna</AccountHolder>
            <BankName>7232</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980014</XRefCode>
        <EmployeeNumber>980014</EmployeeNumber>
        <FirstName>Arcelia</FirstName>
        <LastName>Yuna</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>519</RoutingTransitNumber>
            <AccountNumber>519354930001</AccountNumber>
            <DepositNumber>3</DepositNumber>
            <DepositValue>25</DepositValue>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Arcelia Yuna</AccountHolder>
            <BankName>7339</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980014</XRefCode>
        <EmployeeNumber>980014</EmployeeNumber>
        <FirstName>Arcelia</FirstName>
        <LastName>Yuna</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>001</RoutingTransitNumber>
            <AccountNumber>0528014049</AccountNumber>
            <DepositNumber>4</DepositNumber>
            <IsPercentage>true</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>true</IsRemainder>
            <AccountHolder>Arcelia Yuna</AccountHolder>
            <BankName>7375</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980012</XRefCode>
        <EmployeeNumber>980012</EmployeeNumber>
        <FirstName>Silvanus</FirstName>
        <LastName>Vinny</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>081</RoutingTransitNumber>
            <AccountNumber>084166669</AccountNumber>
            <DepositNumber>1</DepositNumber>
            <DepositValue>5000</DepositValue>
            <IsPercentage>false</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Silvanus Vinny</AccountHolder>
            <BankName>7171</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980012</XRefCode>
        <EmployeeNumber>980012</EmployeeNumber>
        <FirstName>Silvanus</FirstName>
        <LastName>Vinny</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>146</RoutingTransitNumber>
            <AccountNumber>3503768605</AccountNumber>
            <DepositNumber>2</DepositNumber>
            <DepositValue>2000</DepositValue>
            <IsPercentage>false</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Silvanus Vinny</AccountHolder>
            <BankName>7232</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980012</XRefCode>
        <EmployeeNumber>980012</EmployeeNumber>
        <FirstName>Silvanus</FirstName>
        <LastName>Vinny</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>519</RoutingTransitNumber>
            <AccountNumber>3953719868</AccountNumber>
            <DepositNumber>3</DepositNumber>
            <DepositValue>2000</DepositValue>
            <IsPercentage>false</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>false</IsRemainder>
            <AccountHolder>Silvanus Vinny</AccountHolder>
            <BankName>7339</BankName>
        </DirectDepositInformation>
    </Employee>
    <Employee>
        <XRefCode>980012</XRefCode>
        <EmployeeNumber>980012</EmployeeNumber>
        <FirstName>Silvanus</FirstName>
        <LastName>Vinny</LastName>
        <DirectDepositInformation>
            <RoutingTransitNumber>001</RoutingTransitNumber>
            <AccountNumber>107384553</AccountNumber>
            <DepositNumber>4</DepositNumber>
            <IsPercentage>false</IsPercentage>
            <IsDeleted>false</IsDeleted>
            <DFPayMethodXrefCode>SAVINGS</DFPayMethodXrefCode>
            <IsRemainder>true</IsRemainder>
            <AccountHolder>Silvanus Vinny</AccountHolder>
            <BankName>7375</BankName>
        </DirectDepositInformation>
    </Employee>
</EmployeeImport>

Next steps

Complete the next wizard, as appropriate.

Direct Deposit APJ template fields

All templates have the same basic structure:

  • Instructions tab: Helps you understand the purpose of the data and complete the fields in the template.
  • Data tab: Contains headers for the data to be included in the template. The headers remain the same, but you can change the column order. If you add more columns, Activate ignores them.

All number ranges in the templates include the numbers at both ends of the range.

To see a list of the fields in the template, click here.
Employee Identifier (Required)
Order Data Type Description Examples Why This Is Needed
1 Alphanumeric. Unique value between 1-9 characters. Unique identifier of employees, such as Employee Number. 3241245
000000006 abc123499 		The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. This required field validates that the data being loaded is assigned to the correct employee record. The values must match exactly to an existing employee record in Dayforce.
First Name (Required)
Order Data Type Description Examples Why This Is Needed
2 String1 between 1-64 characters. Employee's First Name as per record in Dayforce. Joe The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. This required field validates that the data being loaded is assigned to the correct employee record. The values must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Last Name (Required)
Order Data Type Description Examples Why This Is Needed
3 String1 between 1-64 characters. Employee's First Name as per record in Dayforce. Smith The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. This required field validates that the data being loaded is assigned to the correct employee record. The values must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Bank Code (Conditional)
Order Data Type Description Examples Why This Is Needed
4 Alphanumeric between 1-64 characters.

The Bank Code of the employee's bank account. As bank file formats vary across different countries, the requirements for this field might differ.

Work with your Implementation consultant to understand more details on this field.

 024 This code identifies the bank Name.
Branch Code (Conditional)
Order Data Type Description Examples Why This Is Needed
5 Alphanumeric between 1-64 characters.

The Branch Code of the employee's bank account. As bank file formats vary across different countries, the requirements for this field might differ.

Work with your Implementation consultant to understand more details on this field.

 081
789		 Unique identifying code for a given branch of a bank
Account Number (Required)
Order Data Type Description Examples Why This Is Needed
6 Numeric between 7-30 digits. Employee Bank Account Number. 021000021147013 026012881487145 This is the employee's account number.
Account Holder (Required)
Order Data Type Description Examples Why This Is Needed
7 Alphanumeric between 1-510 characters. Employee Bank Account Holder Name. Sally Smith John This field names the individual to identify the account details entered.
Deposit Order (Required)
Order Data Type Description Examples Why This Is Needed
8 Numeric. Accepted Values are between 1-4.

When there is more than one account for the employee, this number sets the order.

If you only have one account for the employee, you can leave this field blank or enter 1. Dayforce accepts up to 4 accounts for each employee.

The last account on the list must also be set as the remainder account.

1
2
3
4

Pay is added to the accounts based on the priority that you set here. If you have an employee that earns $1500 and he splits his pay between four accounts, you must add deposit order numbers 1,2,3,4 to each of his accounts.

If the employee had the following setup: *30$ for the account with deposit order 1, *$1000 for the account with deposit order 2, *$900 for the account with deposit order 3 and *0 for the account with deposit order 4. Then, the third account only gets a deposit of $470 and nothing is deposited into the fourth account.

If another employee had the same setup for splitting deposits but earned $2600, then the third account would get the full $900 and the remaining $670 would go into the fourth account. For an example of this configuration, see employee identifier 1560 on the Examples tab.
Is Remainder (Required)
Order Data Type Description Examples Why This Is Needed
10 Accepted Values:
YES
NO

When there’s more than one account for the employee, set this indicator for the last account in the sequence to YES and set to NO on all other accounts. It tags the account that will receive any money not distributed in the other deposit accounts.

Set YES if the employee has a single account.

 YES
NO		 All amounts that aren’t allocated to a specific account go into this remainder account. In the previous example, if the employee was earning $2600, the 670$ that isn’t allocated to the three first accounts go into the remainder account that MUST also be the last account in the “deposit order.” The remainder account MUST be the last account in the sequence with an amount value 0 or a blank percentage value.
Percentage Value (Conditional)
Order Data Type Description Examples Why This Is Needed
11 Numeric. Accepted Values are between 1-99. Not required if the employee has a single account This field is used to show the percentage distribution among the accounts. The sum of the percentage values among the employee's accounts needs to be less than 100 (because the remainder account must be blank for the percentage value). 50
25
25 		The percentage of the pay that goes into the account. If the remainder account uses an amount, this value is blank.
Amount Value (Conditional)
Order Data Type Description Examples Why This Is Needed
12 Numeric. Less than 1000000000. Not required if the employee has a single account. This field is used to show the dollar amount distribution among the accounts. The last account on the list must be blank and Remainder=YES. 50 150 The dollar amount that goes into each account. If the remainder account uses a percentage, this value is blank.