Aplos partners with PEX to provide Aplos customers based in the United States with Visa prepaid cards that empower staff and volunteers to make authorized purchases, while maintaining tight spending controls. Once you have enabled prepaid cards in Aplos and successfully created your PEX account, you can connect your PEX account with Aplos to automatically sync approved transactions with your accounting once a day. 

If you haven’t created a PEX account yet, check out our resource on Prepaid Cards With PEX. If you already have a PEX account outside of Aplos, contact our Support Team to request to migrate to the discounted Aplos plan.

 

Note: Please follow the instructions below in order as you will need to complete a series of steps before opening the PEX Connector to successfully set up your integration.

 

Tracking PEX Prepaid Cards In Your Aplos Chart Of Accounts

Before setting up the integration, create the accounts you wish to use in your chart of accounts in Aplos. These will be visible in PEX to assign to your transactions.

Create an asset account for tracking your account balance in PEX
This will allow you to map all PEX purchases, fees, rebates and transfers against a single asset account. If you need to create an asset account, see our guide for setting up your chart of accounts in Aplos. You only need to create one asset account regardless of the number of cards you issue. Mark this asset account as a 'Register' account in order for it to appear in the PEX connector.
Note: Individual card balances will be visible from the prepaid card screen in Aplos. 

Accounts, funds, and tags for expense tracking
When you create accounts, funds, and tags to track your expenses, these will sync to PEX so you can assign them to your transactions. After connecting Aplos and PEX, when you add additional accounts, funds, or Aplos tags, the integration will sync daily and update your PEX account with new options. 

Create Aplos tags to track individual prepaid cards (optional)
Aplos tags will help further categorize your transactions for more detailed reporting by cardholders. This is an optional upgrade to your Aplos subscription. For more information, see our guide on Aplos accounting tags.

 

How To Import Transactions From PEX

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” and then “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.

 

Assign Aplos Accounts And Funds To PEX Transactions

Review Transactions In PEX To Sync With Aplos 

To sync your transactions log in to PEX and follow either of the options below based on your configuration:

• If “Automatically import all PEX purchases into Aplos” was selected in Step 4

A cardholder or administrator will need to select a PEX tag for both an account and fund of their choosing (and any Aplos tag options, if applicable) for each transaction you want to sync. Once these are selected, the transaction will automatically sync with Aplos.

• If “Automatically import approved PEX purchases” was selected in Step 4

A cardholder or administrator will need to select a PEX tag for both an account and fund of their choosing (and any applicable Aplos tag options) for each transaction you want to sync. Selecting these and/or adding a receipt image will move the transaction into the PEX Review queue for review and approval.

To review your transactions, click “Review” from the menu on the right side of your screen in PEX. Then click “Not Reviewed.” This will provide you with a list of transactions that need approval. For more information on transaction review, see the PEX resource for reviewing transactions. Transactions will sync with Aplos once they are assigned the Approved status in PEX.

 

Assign Account And Fund To Each Transaction

When reviewing a transaction, ensure that you meet the following requirements in PEX to successfully sync the transaction to your Aplos Account:

1. Each transaction has a PEX tag that is mapped to an Aplos fund.
2. Each transaction has a PEX tag that is mapped to an Aplos account.
3. If you have a required tag in Aplos, each transaction must have a PEX tag that is mapped to a required Aplos tag.

If desired, you have the option to split a transaction in PEX, which will import a split transaction to Aplos. For more information about splitting tags, see the PEX resource for splitting tags. 

After selecting the appropriate fund, account, and tag (optional), click “Save” and either “Approve” or “Reject.” An approval is required for syncing transactions if that option was selected in the initial configuration.

 

How To Sync Approved PEX Transactions

The PEX Connector will automatically sync your accounts, funds, tags, and transactions with Aplos every 24 hours. If you wish to sync immediately, you can open the PEX Connecter and go to Sync History. Then click the Sync Now button to trigger an immediate sync.

Click “Sync History” to view details and confirm that your account is syncing as expected.

 

Automatic Import Of Bank Transfers To PEX

Transfers that occur from your external bank account to your PEX account will be synced to your Aplos account automatically. These will be posted based on the account, fund, and contact selected in Step 6 of your PEX Connector configuration. To learn more about how to create a transfer and fund your PEX account, refer to PEX's guide for how to fund from an admin site. No additional action is required.

 

Viewing PEX Transactions In Aplos

Viewing Purchases In The PEX Register In Aplos

Once you have configured your PEX Connector and initiated the process to sync transactions and transfers, the PEX Connector will then import approved transactions to your accounting in Aplos. You can view PEX transactions from the Register screen for your PEX asset account under Transaction History in Aplos. You will also be able to view any transfers, rebates and fees that occur.

To see your PEX register, select “Fund Accounting” from the navigation menu. Then click “Transactions” and “Registers” to select the asset account for your PEX account.

 

Viewing PEX Bank Transfer Journal Entries

You can also view a list of your bank transfers from the Journal Entry screen by selecting “Fund Accounting” in the navigation menu, and then clicking “Transactions” and “Journal Entry.”

 

Viewing Prepaid Card Balances In Aplos

Once you have logged in to PEX from inside Aplos, open cards will be displayed on your Prepaid Cards screen in Aplos. 

From this screen, you can check the balances, expiration dates, card numbers, and names of the cards issued. On the right side of the screen, you will have options for refreshing your card list, managing your PEX account, or unlinking your PEX account.

 

Managing Your PEX Connector Configuration 

1. In the PEX Admin Portal, click “Manage Sync” from the top navigation to review or edit your configuration.
2. Enable/disable auto-sync. Enabled: Transactions sync automatically every 24 hours. Disabled: Transactions will not sync automatically.
3. Click “Edit” at the bottom of the screen to make any changes in the configuration settings.

 

Note: The Disconnect button at the bottom of the screen can be used to disconnect your Aplos account from your PEX account.