1. Help Center
  2. Accounting
  3. Assistant Accountant/Department Head

How to: Use PEX

Options for Uploading PEX

1. Use an automated daily import of transactions to create Envelopes in our application

2. Copy/Paste with Entry Window Template

3) Manually upload your transactions

1) If GreenSlate is importing your PEX transactions for you. NOTE: this is the default configuration for GreenSlate clients using PEX :

Step 1: Click IMPORT STORAGE on the left navigation.

Step 2: Click EDIT.

2021-05-09 20_04_24-Import Storage

Step 3: Make any necessary coding changes. NOTE: You may use the select column to mass-update coding. 

2021-05-09 20_05_31-Import Storage

Step 4: Click SUBMIT.

2021-05-09 20_07_20-Template (12).csv - Excel

When you create your envelope, the list of unused transactions will appear to be brought into a new PCard Envelope. You may follow the instructions from this article to complete the process: How to: Submit a Prepaid Card Envelope


NOTE: When using PEX, and auto-imported transactions, funding transactions will auto-import into GreenSlate, and appear from General Ledger screen, as unposted transactions. Once posted, the CP Custodian is credited, and the CP Account is debited. 

2) If you are using the Entry Window Template for Copy/Paste:

You must request of GreenSlate Support that the Auto-imported transactions, and auto-reconciliation features be disabled, as they may be enabled, by default. 

Step 1: Copy and paste data from envelopes exported from PEX CSV file to our GreenSlate Entry Window Template.

Step 2: Select All from the excel file, and COPY.

Step 3: Click the + to the right of PCard Envelopes on the left navigation.

2021-05-09 19_54_21-Bill 864

Step 3: Select the PEX vendor from the Cards drop down menu and click SUBMIT.

2021-05-09 19_55_13-Select Card

Step 4: Within the envelope, in the Details area, click PASTE. Your copied transactions should appear as detail lines. 

2021-05-09 20_13_55-Envelope #

Step 5: Enter an envelope # or check the box to auto generate and enter a description.

2021-05-09 19_57_27-Template (12).csv - Excel

Step 6: (Optional) If you wish to indicate, replenishment of the prepaid card account balance, any replenishment amount, OR the total of the detail lines may be added in the Reimburse Amount field. This will create a credit and a debit line automatically to move funds back to the PEX vendor's account. With PEX, funding transactions happen manually when auto-imported transactions are disabled, so replenishment of cards is a manual process, and this method is one way to accomplish this. 

2021-05-09 19_59_44-Template (12).csv - Excel

Step 7: Add notes and upload files as needed.

PRO TIP: In the Envelope FILES area, upload a PDF version of your PEX Envelope, so it may be virtually paperclipped to this transaction's PDF in GreenSlate!

2021-05-09 20_01_11-Envelope #

Step 8: Click SUBMIT.

2021-05-09 20_01_56-

Info on the entry window template can be found here: Copy/Paste with Entry Window Template

3) If you are uploading your PEX transactions manually:

Step 1: Complete and upload the template of transactions to Import Storage. 

Step 2: Click the + to the right of PCard Envelopes on the left navigation.

2021-05-09 19_54_21-Bill 864

Step 3: Select the PEX vendor from the Cards drop down menu and click SUBMIT.

2021-05-09 19_55_13-Select Card

Step 4: Select the transactions in the Add Imports window then click ADD.

2021-05-09 19_56_50-Envelope #

Step 5: Enter an envelope # or check the box to auto generate and enter a description.

2021-05-09 19_57_27-Template (12).csv - Excel

Step 6: Enter the total of the detail lines in the Reimburse Amount field. This will create a credit and a debit line automatically to move funds back to the PEX vendor's account.

2021-05-09 19_59_44-Template (12).csv - Excel

Step 7: Add notes and upload files as needed.

2021-05-09 20_01_11-Envelope #

Step 8: Click SUBMIT.

2021-05-09 20_01_56-