> ## 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 Sage 50

> 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.

## 1. Upload Your Chart of Accounts

Begin by uploading your Sage 50 Chart of Accounts into the Tag Manager in PEX. More details [here](/administrator-guide/create-tags-for-exporter-app).

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 Sage 50**.
* 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).
</Note>

### Configure format, timezone and dates

After the app launches:

<Steps>
  <Step>
    Select your report format: CSV or XLSX.
  </Step>

  <Step>
    Select your preferred timezone.
  </Step>

  <Step>
    Select the earliest transaction date you want to export to Sage 50 using the date picker (up to 1 year ago).

    * You can leave it empty to default 1 year ago.
  </Step>

  <Step>
    Enter an end date or leave it blank.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-27.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=9d6c9ba69ef27887871a9b042b55e0cc" alt="" width="931" height="233" data-path="images/api-&-integration/image-27.png" />
</Frame>

## 2. Configure Purchases

You can export purchases to Sage 50.

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

Now map purchase data to Sage 50 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](/administrator-guide/create-tags-for-exporter-app) article.
* Rename fields to make them have the same names as in Sage 50.
  * 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?).

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-28.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=e0d8340890f1fa1c6496a2ddc9c25e35" alt="" width="1494" height="563" data-path="images/api-&-integration/image-28.png" />
</Frame>

### Add a new field

To add a field that you have in Sage 50:

* Click **Add a new field**.

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-29.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=a33978d024f5565d2a21ce2cad709b5e" alt="" width="1479" height="180" data-path="images/api-&-integration/image-29.png" />
</Frame>

* 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 Sage 50.

* 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 Sage 50 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 Sage 50.
  * 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?).

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-30.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=280ad9f5611e0340a1e07e5e36257795" alt="" width="1482" height="505" data-path="images/api-&-integration/image-30.png" />
</Frame>

### Add a new field

To add a field that you have in Sage 50:

* Click **Add a new field.**

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-31.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=78371e82ee917ab00670b6f854401872" alt="" width="1481" height="172" data-path="images/api-&-integration/image-31.png" />
</Frame>

* 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 Sage 50.

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

Now map fee data to Sage 50 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 Sage 50.
  * 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?).

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-32.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=4994cda7960fae92be16d08537a991b8" alt="" width="1485" height="496" data-path="images/api-&-integration/image-32.png" />
</Frame>

### Add a new field

To add a field that you have in Sage 50:

* Click **Add a new field**.

  <Frame>
    <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-33.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=01d69e94913c10dc39e61ac60f4cb2a5" alt="" width="1473" height="107" data-path="images/api-&-integration/image-33.png" />
  </Frame>
* 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**.

  <Frame>
    <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-34.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=e4d4346e18bd22a3dd9b46bd1ae51e8d" alt="" width="522" height="313" data-path="images/api-&-integration/image-34.png" />
  </Frame>

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

  <Frame>
    <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-35.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=ba9219068623611de550782cbd254089" alt="" width="525" height="343" data-path="images/api-&-integration/image-35.png" />
  </Frame>

* *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**.

  <Frame>
    <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-36.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=e24880c9fa5bc1390b658f0b40045480" alt="" width="592" height="346" data-path="images/api-&-integration/image-36.png" />
  </Frame>

### 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.

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-37.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=3db98237b6fc333206087dba56b78d92" alt="" width="1514" height="271" data-path="images/api-&-integration/image-37.png" />
</Frame>

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.

<Frame>
  <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-38.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=29739ad4b5c4d3b660e63c39b57141b8" alt="" width="1500" height="106" data-path="images/api-&-integration/image-38.png" />
</Frame>

### 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.

  <Frame>
    <img src="https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-39.png?fit=max&auto=format&n=uCSQ9yXeTyRSlT2V&q=85&s=3e054e122f9db47b2c4e7eca919a65a0" alt="" width="1502" height="219" data-path="images/api-&-integration/image-39.png" />
  </Frame>

## 6. Import to Sage 50

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

### Export Receipts

The Exporter for Sage 50 cannot export receipts to Sage 50. 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](/administrator-guide/connector-for-google-drive).
* [Microsoft OneDrive](https://dashboard.pexcard.com/apps/available?utm_source=support). More details [here](/administrator-guide/pex-connector-for-onedrive).
* [Envelope PDF](https://dashboard.pexcard.com/apps/available?utm_source=support). More details [here](/administrator-guide/expense-envelopes-for-admin).

## FAQ

<AccordionGroup>
  <Accordion title="Are split tags supported for the export?">
    At this time, split tags are not supported.
  </Accordion>

  <Accordion title="Can I re-export a purchase?">
    Every exported purchase has a "Synced to PEX Connector for Sage 50" note. If you remove this note, the purchase will be re-exported.
  </Accordion>
</AccordionGroup>

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