Once your Chart of Accounts is prepared, the next phase is to establish the technical link between Aplos and PEX. This process involves authenticating your credentials and configuring the mapping logic that governs how data is shared between the two platforms. By accurately mapping your Aplos funds and accounts to PEX tags, you ensure that all card activity is categorized correctly upon import, maintaining the integrity of your financial records. Follow the steps below to complete this connection.

Step 1: Authenticate Your PEX Account In Aplos

To connect your PEX account to Aplos, log in to your Aplos account. From the navigation bar, select Fund Accounting > More > “Prepaid Cards.” Then sign in to your PEX account. Click “Login to PEX” and enter your PEX credentials.

Step 2: Creating PEX Tags In The PEX Admin Portal

PEX tags are a way to categorize transactions inside PEX, and they will allow you to map and sync transactions to Aplos. You will create PEX tags that associate with Aplos accounts, Aplos funds, and Aplos tags (optional). Creating these tags in PEX first will allow for simple configuration when mapping PEX tags to Aplos accounts, funds, and tags in the Aplos Connector. 

To begin creating the necessary tags in PEX, select “Business Settings” in the navigation menu, and click Tag Manager. From here, you can create and manage your PEX tags. For more information about PEX tags, see the PEX resource for creating and setting up tags.

Create A PEX Tag For Aplos Funds

Creating an Aplos fund tag is a requirement to sync successfully. Below are the steps to create your PEX tag that will sync with your Aplos funds. When synced successfully, you will see your full list of Aplos funds in this field in PEX.

1. Click “Add Tag” and enter a name, such as “Aplos Funds” to help organize and differentiate your PEX tags.
2. Enable the required field option. This will require all transactions to have an Aplos fund tag applied so they sync successfully.
3. Select the Tag Type “Dropdown.”
4. Click “Add a New Option,” and provide a name and description under the “Display as” and “Option Value” column.
5. Click “Create a Tag.”

Note: You will need to provide at least one option in the new dropdown field to save the tag. When configuring the PEX Connector later in your setup, the connector will sync your funds, accounts, and tags, and create them as options in the dropdown for the selected PEX tag. Once you have set up the connector sync, you can disable the option you created to set up each PEX tag.

Create A PEX Tag For Aplos Accounts

Creating an Aplos account tag in PEX is required to sync successfully. You will repeat the same steps used to create your tag for funds. When synced successfully, you will see your complete chart of accounts in this field in PEX. 

1. Click “Add Tag,” and enter a name, such as “Aplos Accounts.”
2. Enable the required field option. All transactions must have an Aplos account tag assigned to sync successfully.
3. Select “Dropdown” as the Tag Type.
4. Click “Add a New Option,” and provide a name and description under the “Display as” and “Option Value” column.
5. Click “Create a Tag.”

Create A PEX Tag For An Aplos Tag Layer

If you wish to use any Aplos tags when tracking transactions in PEX, you have the option to create an additional PEX tag. This tag will further categorize transactions beyond fund and account. 

1. Click “Add Tag” and enter a name. We recommend using a name such as “Aplos Department Tags.”
2. Select the Tag Type “Dropdown.”
3. Click “Add a New Option,” and provide a name and description under the “Display as” and “Option Value” column.
4. Click “Create a Tag.”

Note: If you have multiple Aplos tag layers created, you will want to create a PEX tag for each layer.

Step 3: Launch The Aplos Connector In PEX

Once you have logged in to your PEX account and created your PEX tags, locate and click “Apps” on the left side of your PEX menu. Next, locate the installed app PEX Connector for Aplos and click “Launch.”

Step 4: Choose What To Sync In The PEX Connector

Sync Aplos Funds/Accounts to PEX Tags. 

• Enable this option to successfully retrieve your Fund and Account list from Aplos.

Automatically import PEX Purchases into Aplos. 

• Enable this option to allow PEX to import PEX purchases as expenses in Aplos.
• You can choose to sync all PEX transactions (regardless of approval status) or just approved (recommended).

PEX purchases must have an Account and Fund PEX Tag in order to sync. For details on transaction review, see our resource on reviewing transactions.

Automatically import PEX transfers into Aplos. 

• Enable this option to have PEX import transfers to Aplos. An example of a transfer would be an ACH/wire transfer from your business checking account to your PEX business account.
• If you are funding your PEX account from more than one Operating Account, choose the primary funding account since the Connector only supports one Bank Account.

Automatically import Fees into Aplos. 

• Enable this option to have PEX import PEX business and cardholder fees to Aplos. Examples of a PEX Fee include an ISA fee for international use or priority shipping fees. 

Automatically import Rebates into Aplos. 

• Enable this option to have PEX import rebates to Aplos. This option is available only if "Automatically import PEX Purchases into Aplos" is on.

Sync 990 Tag.

• You can enable this option to successfully retrieve 990 tags from Aplos. 

If you enable 990 Tag, make sure you have 990 tag enabled in Aplos. Otherwise, your transactions will not sync. 
 

Select an asset account that represents your PEX balance.

• PEX Purchases will credit this account.
• PEX transfers will debit this account.
• Fees in PEX will credit this account.
• Rebates in PEX will debit this account. 
  Note that the asset account you select should be of the "Register" type in Aplos.
  

Select the Start date to begin the sync.

• Transactions after this date will sync to Aplos.
• The start date must be <1 year in the past.

Select the Post date for syncing transactions to Aplos

• either Settlement Time or Transaction Time.

Create a contact for each unique merchant(optional).

• Choose wether you wish to select a single contact for all purchases or create a unique contact for each merchant.

Specify a start date for the sync.

• Transactions after this date will be synced automatically.

Step 5: Configure Contact Sync Options

Select one of the following:

Choose a contact for your purchases.

• With this option, all PEX purchases will be booked against a single contact selected from the drop down list. 
• Tip: Consider creating a new contact in Aplos called "PEX" if you would like to book all of your PEX purchases against a single contact.
   

Create a contact for each unique merchant. 

• With this option, PEX will book purchases against corresponding contacts that already exist in your Aplos account. If there is no corresponding contact then PEX will auto create a new contact in Aplos.
• Note that the connector will not create duplicate contacts, but "Walmart23455", "Walmart-brooklyn223" are two unique contacts from the connector's point of view. 
  • If you don't want to have "Walmart23455" and "Walmart-brooklyn223" then check the "Use standardized merchant names" checkbox. This means that a purchase "Walmart23455" and a purchase "Walmart-brooklyn223" will be recorded in your Aplos account with "Walmart" as a contact instead of "Walmart23455" or "Walmart-brooklyn223".

Step 6: Configure PEX Tag Mapping

With the PEX Connector, your Aplos chart of accounts and Aplos tags sync so you can see your Aplos account, Aplos fund, and Aplos tag in PEX. These will appear as fields when you are tracking your purchases in PEX. To begin, map the Aplos account, fund, and tag field name to the corresponding PEX tag you created in Step 2.

Note: Your Aplos account and Aplos fund are required fields to import transactions from PEX and must be assigned a PEX tag.

1. Fund (required)
   The Aplos field “Fund” should be mapped to the PEX tag called “Aplos Funds.” This is a required field to map in order to successfully sync transactions.
2. Account (required)
   The Aplos field “Account” should be mapped to the PEX tag created for “Aplos Accounts.” This is a required field to map in order to successfully sync transactions.
3. Tag (optional)
   If desired, PEX tags can also be mapped to your Aplos tags if they are enabled in Aplos. If you have a tag layer that is required in Aplos, it will be required to map this field in PEX to successfully sync transactions. If you have multiple Aplos tag layers, select the blue plus sign (+) on the right side of your screen to map a PEX tag for each tag layer.

Syncing Tag Options From Aplos 

Syncing tag options is recommended because it gives you the option to import data from your Aplos account when configuring your PEX tags. For example, the values for the PEX tag will be populated with the names of all your accounts. This helps reduce manual efforts to populate PEX tags with the data from your Aplos account.

Step 7: Choose Default Fund And Contact PEX Transfers And Fees 

1. Transfers
   When you fund a PEX account via either an ACH transfer or wire transfer, the transfer will credit the selected bank account you use to fund your account and debit the asset account you chose for your PEX funds (in Step 4 of this connector).
2. Fees
   If you incur any PEX account fees, the transactions for those fees will be imported to Aplos and assigned to the account, fund, and contact you select.
3. Rebates
   If you have any PEX rebates, the transactions for those rebates will be imported to Aplos and assigned to the account, fund, and contact you select.