PEX Connector for Sage Intacct (Prepaid)

Don’t have a PEX account yet? Sign up. Auto-sync purchases, transfers, fees, rebates, and receipt images from PEX into Sage Intacct, keeping your data accurate, organized, and up-to-date. Map Sage Intacct fields such as Expense Account, Class, Customer, Project, and more to PEX tags. You can also pull your existing vendor list from Sage Intacct into PEX to auto-create vendor cards. See the Sage Intacct vendor card creation article for details. To configure this integration, you don’t need to wait for your account manager. You can get started with your Sage Intacct and PEX credentials.

​

Pre-configuration

Prior to using this guide, please ensure you have completed all set-up components:

1. Enable Sage Intacct settings for PEX sync: document numbering, sender ID, web services user, and general ledger
2. Create PEX tags

​

Link PEX and Sage Intacct

Log in to your PEX account to finalize the setup.

​

Choose What to Sync

You can:

• Automatically import PEX purchases
  • Enable this option to import PEX purchases as expenses in Intacct.
  • You can choose to sync all PEX transactions (regardless of approval status) or just approved (recommended).
    • PEX purchases must have an Expense Account tag in order to sync. For details on transaction review, please see our article How to Review Transactions.
• Automatically import PEX attachments
  • Enable this option to import PEX receipts as expense attachments in Intacct.
    • This option is available only if the “Automatically import PEX purchases” toggle is enabled.
• Automatically import PEX transfers
  • Enable this option to import PEX transfers.
    • An example of a transfer would be an ACH/wire transfer from your business checking account to your PEX business account.
    • From the drop down list, please select the bank account in Intacct corresponding to your business checking account.
    • This account will be credited when syncing transfers to Intacct.
• Automatically import PEX account fees
  • Enable this option to import PEX account fees.
    • Examples of a PEX Fee include an ISA fee for international use or priority shipping fees.
    • From the drop down list, please select the expense account to debit when syncing fees to Intacct.
• Automatically import PEX rebates
  • Enable this option to import PEX account rebates.
    • From the drop down list, please select the income or expense account to credit when syncing rebates to Intacct.
    • This option is available only if the “Automatically import PEX purchases” toggle is enabled.
• Automatically import cardholder reimbursements
  • Enable this option to import PEX cardholder reimbursements.
• Specify a start date for the sync
  • Transactions on and after this date will sync.
    • Reimbursements with a payment processing date on and after this date will sync.
    • The start date must be less than 1 year in the past.

Click Next.

​

Configure vendor sync options

Select one of the following:

• Choose a vendor for your purchases.
  • With this option, all PEX purchases will be booked against a single vendor selected from the drop down list.
    • Tip: Consider creating a new vendor in Intacct called “PEX” if you would like to book all of your PEX purchases against a single vendor.
    
• Create a vendor for each unique merchant.
  • With this option, PEX will book purchases against corresponding vendors that already exist in your Intacct account. If there is no corresponding vendor then PEX will auto create a new vendor in Intacct.
    • Note that the connector will not create duplicate vendors, but “Walmart23455”, “Walmart-brooklyn223” are two unique vendors from the connector’s point of view. If you don’t want to have “Walmart23455” and “Walmart-brooklyn223” then read below.
    

​

Standardized merchant names

With the “Create a vendor for each unique merchant” option, you can also sync your purchases with standardized merchant names if you check “Use standardized merchant names” checkbox. This means that a purchase “Walmart23455” and a purchase “Walmart-brooklyn223” will be recorded in Intacct with “Walmart” as a vendor instead of “Walmart23455” or “Walmart-brooklyn223”. Click Next.

​

Configure sync options

Configure your asset account, journal and a default location.

• Please choose an asset account to reflect your PEX business balance.
  • The account you select will represent your PEX balance.
    • We recommend creating a new asset account named “PEX” to clearly identify all purchases made using PEX. To do this, go to General Ledger > General Ledger accounts (under the All tab) > Add.
      
    • Purchases will credit this account.
    • Transfers will debit this account.
    • Fees in PEX will credit this account.
    • Rebates in PEX will debit this account.
• Please choose a journal to use for your PEX transactions.
  • We recommend creating a new journal named “PEX” to clearly identify all transactions made using PEX. To do this, go to General Ledger > Journals (under the Setup tab) > Add.
    
  • Purchases will credit this account.
  • Transfers will debit this account.
  • Fees in PEX will credit this account.
  • Rebates in PEX will debit this account.
• Please choose a journal to use for your PEX transactions.
  • We recommend creating a new journal named “PEX” to clearly identify all transactions made using PEX. To do this, go to General Ledger > Journals (under the Setup tab) > Add.
  
• Please choose a default location for your PEX purchases, transfers, fees, rebates.

Click Next.

​

Purchase field mappings

Transaction tags are available with selected plans.

• You can map an Intacct field “Expense Account” to a PEX tag. That tag must be created beforehand, following the logic described in the Create PEX tags for Sage Intacct article.
  
• Make sure to enable the Sync toggle. This will pull your expense accounts from Intacct into PEX as tag option values.
  
  The mapping and auto sync allows you and your cardholders to select a tag value for each purchase and reimbursement. For that go to the “Transactions” menu -> locate a transaction -> click on it -> select a tag value (“Advertising” in our example below) of the “Expense Account” tag -> click “Save & Submit”. Note that you and your cardholders can select one of the tag values for each purchase once you finish the Intacct connector setup and sync tag options from Intacct to PEX.
  
  The purchase will debit the expense account that it is tagged with (“Advertising” in our example above). If you are using split tag functionality on the PEX platform, the connector will support that while exporting the purchases and create the same split structure for purchases in Intacct.
• When mapping to a tag, you can also specify a default “Expense Account” value: for example, Uncategorized, as highlighted below.
  
  Note that a purchase will not be tagged with this default value (“Uncategorized” in our example) on the purchase details. It means that if you or your cardholders forget to tag a purchase before it is synced to Intacct, the default value (“Uncategorized” in our example) will be applied to this purchase during the sync. If you or your cardholders do tag a purchase with the tag option from the tag chosen in the highlighted field below,
  
  that specific purchase will be recorded against the expense account (“Accounting” in our example below) you tagged the purchase with. Tags take precedence over default values.
  

PEX tags can also be mapped to other Intacct fields for coding of purchases and reimbursements.

• If you use Class, Customer, Project, Location, Department, Employee, Item, Warehouse, Billable fields or User Defined Dimensions in Intacct, map them to PEX tags. Those PEX tags must be created beforehand, following the logic described in the Create PEX tags for Sage Intacct article. Note:
  • All of the above fields should be mapped to PEX tags with the type set to “Dropdown”.
    • Only Billable should be mapped to a PEX tag with the type set to “Yes / No”.
    
• Make sure to enable the “Sync” toggle. This will pull your classes, customers, etc. from Intacct into PEX as tag option values.
  
• You can select a default value for every tag.
  • Note that a purchase will not be tagged with this default value. It means that if you or your cardholders forget to tag a purchase before it is synced to Intacct, the default value will be applied to this purchase during the sync.
    

Click Next.

​

Transfer field mappings

You can also set default fields for transfers so the connector knows which values to use when syncing transfers to Intacct. These values will be applied to transfer transactions during the sync to Intacct. Click Next.

​

Fee field mappings

You can also set default fields for fees so the connector knows which values to use when syncing fees to Intacct. These values will be applied to fee transactions during the sync to Intacct. Click Next.

​

Rebate field mappings

You can also set default fields for rebates so the connector knows which values to use when syncing rebates to Intacct. These values will be applied to rebate transactions during the sync to Intacct. Click Next.

​

Other options

On this step, you can map a vendor within your Sage Intacct account. This is available for purchase transactions and reimbursements (both GL journal entries and paid bills).

• Switch on the toggle “Copy a vendor to the Sage Intacct memo field” if you want to sync the vendor name to your Sage Intacct memo field.
  • Overall, vendors will be copied to the memo field and also synced to the vendor field of journal entry/paid bill details in your Sage Intacct account.

Note that the connector will automatically copy a cardholder and PEX transaction notes to the Sage Intacct description field. You can also decide if to sync ISA fees as business fees.

• Switch on the toggle to sync ISA fees as business fees. This means that ISA fees will debit the expense account selected on the first step.
  
• Switch off the toggle to sync ISA fees as purchases.

Click Finish.

​

Configure reimbursement sync options

PEX can sync reimbursements to Intacct as GL journal entries or as paid bills. GL journal entries in Intacct: Paid bills in Intacct: To sync reimbursements to Intacct, you have to:

• Select whether to sync reimbursements to Intacct as GL journal entries or as paid bills.
  • If you choose GL journal entries, select a bank account that reimbursements will credit in Intacct.
    
    • If you choose paid bills, select a bank account that reimbursements will use to pay bills in Intacct.
    
• Configure vendor sync options. Select one of the following:
  • Use a single vendor for your reimbursements.
    • With this option, all PEX reimbursements will be booked against a single vendor selected from the drop down list.
      • Tip: Consider creating a new vendor in Intacct called “PEX” if you would like to book all of your PEX reimbursements against a single vendor.
      
    • Create a vendor for each unique cardholder.
    • With this option, PEX will book reimbursements against corresponding cardholders (saved as vendors) that already exist in your Intacct account. If there is no corresponding cardholder-vendor then PEX will auto create a new cardholder-vendor in Intacct.
• Optionally set a default expense account.
  • Only reimbursements without an expense account tag will default to the account selected here. They will debit the selected default account.
    • It’s recommended to tag reimbursements before syncing to Intacct. Tagged reimbursements will debit the expense account that they are tagged with (“Office Supplies” in the example below).
    
    • Reimbursements use the same tag mappings, tags, and tag options as purchase transactions. In other words, the mappings set in the Purchase field mappings step apply to both purchase transactions and reimbursements.
    • If there is no tag and no default expense account, the reimbursement will not sync.
• Automatically import reimbursement attachments as expense attachments into Sage Intacct.
  • Enable this option to import reimbursement attachments to Intacct.

Click Next.

​

Auto Tagger

The Auto Tagger app is a great complement to Intacct. It allows you to create rules that auto-tag purchases. Learn more about PEX Auto Tagger

​

Approve transactions in PEX

If you configured the connector to sync only approved purchases, then approving purchases in PEX is necessary before they can sync to Intacct. To approve a purchase:

​

Start syncing

Navigate to the Manage Sync tab and click on the green sync button to initiate the sync between PEX and Intacct. Manual sync will process transactions based on the start date specified on the Sync Selection step, with a limit of 1 year back from today. If there is no start date specified on the Sync Selection step then manual sync will process transactions only up to 2 months back from today. Each sync also imports tag option values from Intacct to PEX if the “Sync” toggle is enabled.
Once transactions are synced to Intacct, you can view their history in the Sync History table and view the synced transactions in your Intacct account.

​

View transactions in Intacct

Log in to your Intacct account and navigate to General Ledger > Journal Entries (under the All tab). Click View transactions next to the journal you configured to sync PEX transactions to view the synced transactions.

​

View reimbursements in Intacct

If you sync reimbursements as GL journal entries, log in to your Intacct account and navigate to General Ledger > Journal Entries (under the All tab). Click View transactions next to the journal you configured (on the Configure sync options step) to sync PEX transactions and view the synced reimbursements. If you sync reimbursements as paid bills, log in to your Intacct account and navigate to Accounts Payable > Bills (under the All tab) to view the synced reimbursements.
A single payment can include multiple reimbursements. If there is more than one, PEX creates a separate GL journal entry/paid bill in Intacct for each reimbursement.

​

Manage sync

On the “Manage sync” tab you can:

• Run a manual sync between PEX and Intacct by clicking on the green sync button.
  
  • Enable/disable auto-sync.
    • With auto-sync enabled, transactions and tag option values sync automatically every 24 hours.
    • Auto-sync will always process transactions based on the start date specified on the Sync Selection step, with a maximum limit of 2 months back from today. If there is no start date specified on the Sync Selection step then auto-sync will sync transactions up to 2 months back from today.
      
• View/Edit configuration settings.
• View/Edit tag mapping.
• View Sync history.
• Change your Intacct account credentials if your Intacct password has changed.
• Disconnect from your Intacct account.

​

How does data flow between PEX and Intacct?

If everything is configured correctly and transactions are tagged, PEX will sync the following data points to Intacct:

• Cardholder name and last 6 digits
• Merchant name (Description field in)
• Transaction date and time (Description field in)
• Transaction amount
• Project name

​

FAQ

If you didn’t find the answer you need, see Accounting Software Connector Troubleshooting.

​

Support & inquiries

For any questions related to your connector, please email appsupport+sageintacct@pexcard.com.