> ## Documentation Index
> Fetch the complete documentation index at: https://support.pexcard.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Exporter for Foundation Software

> With PEX it's easier than ever to reconcile your company expenses with your accounting platform of choice. Set-up typically takes 10-15 minutes and you can schedule automatic exports on a daily, weekly or monthly basis.

[Watch a demo](https://pex.navattic.com/h1c40bh7) to see how you can set-up the integration. Or, keep reading to this article and we'll walk you through the set-up process:

1. [Upload your Chart of Accounts](#1-upload-your-chart-of-accounts)
   * [Configure format and dates](#configure-format-timezone-and-dates)
2. [Configure purchases](#2-configure-purchases)
   * [Add a new field](#add-a-new-field)
3. [Configure transfers/bill payments](#3-configure-transfers/bill-payments)
   * [Add a new field](#add-a-new-field-2)
4. [Configure fees](#4-configure-fees)
   * [Add a new field](#add-a-new-field-3)
5. [Export transactions](#5-export-transactions)
   * [View history](#view-history)
   * [Download export file](#download-export-file)
6. [Import to Foundation Software](#6-import-to-foundation-software)
   * [Export receipts](#export-receipts)
7. [FAQ](#faq)

## 1. Upload Your Chart of Accounts

Begin by uploading your Foundation Software Chart of Accounts into the Tag Manager in PEX. More details [here](https://support.pexcard.com/administrator-guide/create-tags-for-exporter-app.md).

Once your Chart of Accounts is in PEX, let's access the app:

* Log in to [http://dashboard.pexcard.com/](http://dashboard.pexcard.com/?utm_source=support)
* Navigate to [Apps > Available](https://dashboard.pexcard.com/apps/available?utm_source=support)
* Locate **Exporter for Foundation Software**.
* Click **More info** > **Install** > **Launch**.

> [!NOTE]
>
> **Note:**
>
> To install the exporter, you need to enable the following permissions: *Edit business settings & apps*, *Manage cardholder*, *View card transactions*. You can enable them in [My Profile -> Permissions](https://dashboard.pexcard.com/account/permissions?utm_source=support).

## Configure format, timezone and dates

After the app launches:

**Step 1**

Select your report format: CSV or XLSX.

**Step 2**

Select your preferred timezone.

**Step 3**

Select the earliest transaction date you want to export to Foundation Software using the date picker (up to 1 year ago).

* You can leave it empty to default 1 year ago.

**Step 4**

Enter an end date or leave it blank.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-469.jpeg?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=fab941e657eef551c7919d2dd401809c)

## 2. Configure Purchases

You can export purchases to Foundation Software.

* Enable "Export purchases?" to successfully export PEX purchases, which will update the toggle from grey to green.
* You can choose to sync all PEX purchases (regardless of approval status) or just approved (recommended).

Now map purchase data to Foundation Software fields.

* There is a set of standard fields: Account, Amount, Date, Notes, Merchant.
  * The PEX source and PEX value are prepopulated for you but you can update them if needed.
  * We recommend mapping the Account field to the PEX source Tag. This enables the expense account to be dynamic for each purchase. In the PEX value column, select a tag that you previously created by following the instructions in the [Create Tags for Exporter app](https://support.pexcard.com/administrator-guide/create-tags-for-exporter-app.md) article.
* Rename fields to make them have the same names as in Foundation Software.
  * As soon as you rename a field in one section, it is auto renamed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Add a new field(s).
  * As soon as you add a new field (e.g., Class), it (Class) appears in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-470.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=8d23ecf8b04955b7221e0fd756448177)

## Add a new field

To add a field that you have in Foundation Software:

* Click **Add a new field**.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-471.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=8255d57b846b412d9dc74b6ba7b4f93e)

* Add a field name.
* Add a **PEX source**.
  * It can be Text, Tag, or Transaction.
* Add a **PEX value** for a new field.
  * The **PEX value** will change based on the **PEX source** selected.

Also, you can:

* Remove any field that you don't need.
  * As soon as you remove a field in one section, it is auto removed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Reorder fields.
  * As soon as you reorder fields in one section, they are reordered in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

## 3. Configure Transfers/Bill Payments

You can export transfers (if your business is prepaid) or bill payments (if your business is credit) to Foundation Software.

* Enable "Export transfers?/Export bill payments?" to successfully export PEX transfers/bill payments, which will update the toggle from grey to green.

Now map transfer/bill payment data to Foundation Software fields.

* There is a set of standard fields: Account, Amount, Date, Notes, Merchant.
  * The PEX source and PEX value are prepopulated for you but you can update them if needed.
* Rename fields to make them have the same names as in Foundation Software.
  * As soon as you rename a field in one section, it is auto renamed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Add a new field(s).
  * As soon as you add a new field (e.g., Class), it (Class) appears in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-472.png?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=6eeb857b83127760d5da1f5069c1be82)

## Add a new field

To add a field that you have in Foundation Software:

* Click **Add a new field.**

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-473.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=b4fb84e99c19e1725423ba320baa8946)

* Add a field name.
* Add a **PEX source**.
  * It can be Text, Tag, or Transaction.
* Add a **PEX value** for a new field.
  * The **PEX value** will change based on the **PEX source** selected.

Also, you can:

* Remove any field that you don't need.
  * As soon as you remove a field in one section, it is auto removed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Reorder fields.
  * As soon as you reorder fields in one section, they are reordered in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

## 4. Configure Fees

You can export fees to Foundation Software.

* Enable "Export fees?" to successfully export PEX fees, which will update the toggle from grey to green.

Now map fee data to Foundation Software fields.

* There is a set of standard fields: Account, Amount, Date, Notes, Merchant.
  * The PEX source and PEX value are prepopulated for you but you can update them if needed.
* Rename fields to make them have the same names as in Foundation Software.
  * As soon as you rename a field in one section, it is auto renamed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Add a new field(s).
  * As soon as you add a new field (e.g., Class), it (Class) appears in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-474.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=7716d7cf06fa2c9c159140a406b81177)

## Add a new field

To add a field that you have in Foundation Software:

* Click **Add a new field**.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-475.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=a951ead2bb1547fc1b5da1119d290eed)

* Add a field name.
* Add a **PEX source**.
  * It can be Text, Tag, or Transaction.
* Add a **PEX value** for a new field.
  * The **PEX value** will change based on the **PEX source** selected.

Also, you can:

* Remove any field that you don't need.
  * As soon as you remove a field in one section, it is auto removed in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).
* Reorder fields.
  * As soon as you reorder fields in one section, they are reordered in **all** sections (Export purchases?, Export transfers?, Export bill payments?, Export fees?).

## Save configuration

When you configured everything, click **Save** to save your configuration.

## 5. Export transactions

To export transactions, click on the **Schedule** tab. There are three options:

* *Run Now:* To run the export now, click **Run now**.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-476.png?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=89274288582fae21f7ab056e99d60f0e)

* *One time scheduled export:* To schedule a one time export, select a date and time and click **Save**.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-477.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=0239d3fe6db29c9eed6fcda35ffb92b4)

* *Recurring export:* To run this export on a recurring basis:
  * Select a date and time.
  * Enable the Repeat toggle.
  * Select the frequency.
  * Select end date for the schedule.
  * Click **Save**.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-478.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=aca72e557dc7b114d30c0364651e08d8)

## View History

The History tab shows you a list of prior exports including the date range selected, status, # transactions found, # transactions eligible, and # transactions exported.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-479.png?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=48609ab9dffd7df1d9589a3df585d567)

If you configured the app to export only approved transactions, # transactions eligible can differ from # transactions found. For example, you have 60 transactions found, but only 45 of them are approved and therefore only 45 are eligible for export.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-480.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=4ccc24c6e52ab9664a583ec302bc65f7)

## Download Export File

You will see a **Download** button in the Action column on the History tab once the export file can be downloaded. Click **Download** to download the file.

* If you selected a small date range with a low number of transactions, the export file should be ready for download in less than a minute. If the date range contains a large number of transactions, it may take a few minutes. Simply **refresh** the screen to get the latest update.

![](https://mintcdn.com/pextest/AsOtgC68beYkZbrU/images/administrator-guide/image-481.avif?fit=max\&auto=format\&n=AsOtgC68beYkZbrU\&q=85\&s=6da1feb1bf7148e9497bc090c47d1668)

## 6. Import to Foundation Software

Log in to your Foundation Software account and follow the steps to import the downloaded export file into your system.

## Export Receipts

The Exporter for Foundation Software cannot export receipts to Foundation Software. But you can export receipts from PEX using the following apps:

* [Google Drive](https://dashboard.pexcard.com/apps/available?utm_source=support). More details [here](https://support.pexcard.com/administrator-guide/connector-for-google-drive.md).
* [Microsoft OneDrive](https://dashboard.pexcard.com/apps/available?utm_source=support). More details [here](https://support.pexcard.com/administrator-guide/pex-connector-for-onedrive.md).
* [Envelope PDF](https://dashboard.pexcard.com/apps/available?utm_source=support). More details [here](https://support.pexcard.com/administrator-guide/expense-envelopes-for-admin.md).

## FAQ

> [accordion] Are split tags supported for the export?
>
> Yes. The export writes one row per split, each with that split's amount and its own tag values. If you turn on **Journal entry mode** in the field mapping, the export writes a debit row and an offsetting credit row for each split.

> [accordion] Can I re-export a purchase?
>
> Every exported purchase has a "Synced to PEX Connector for Foundation Software" note. If you remove this note, the purchase will be re-exported.

For any questions, please email [appsupport+foundationsoftware@pexcard.com](mailto:appsupport+foundationsoftware@pexcard.com)


## Related topics

- [Apps & Other Integrations](https://support.pexcard.com/administrator-guide/apps-and-other-integrations.md)
- [PEX Exporter for Serenic Navigator](https://support.pexcard.com/administrator-guide/pex-exporter-for-serenic-navigator.md)
- [PEX Exporter for Shelby (Prepaid)](https://support.pexcard.com/administrator-guide/pex-exporter-for-shelby-prepaid.md)
- [PEX Exporter for Shelby (Credit)](https://support.pexcard.com/administrator-guide/pex-exporter-for-shelby-charge.md)
- [Switching accounting platforms: what to update in PEX](https://support.pexcard.com/administrator-guide/switching-accounting-platforms.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.