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

# Connector for CMiC

> Auto-sync purchases and receipt images from PEX into CMiC. Map Job/Dept/Eqp., Cost Code/Account/Category, Cost Type/Tran Code, and other CMiC fields to PEX tags.

To configure this integration, you don't even need to wait for your account manager. You can get started right away with just your CMiC and PEX credentials.

## Prerequisites

To sync PEX transactions to CMiC, you need the Job Costing Module and Document Management Module enabled in CMiC. With the Enterprise plan, you need a license for CMiC ECN Application and setup config.

## Connect PEX and CMiC

To connect your PEX and your CMiC accounts from the PEX Marketplace follow these steps:

<Steps>
  <Step>
    Log in to [http://dashboard.pexcard.com/](http://dashboard.pexcard.com/?utm_source=support)
  </Step>

  <Step>
    Navigate to [Apps > Available](https://dashboard.pexcard.com/apps/available?utm_source=support)
  </Step>

  <Step>
    Locate **Connector for CMiC**.
  </Step>

  <Step>
    Click **More info > Install > Launch**.

    * You'll be re-directed you to a **Connect** tab.
  </Step>

  <Step>
    Click **Manage credentials**.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-1.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=5dd38c38d56e683ee0f80b3f27cf0f1a" alt="" width="750" height="418" data-path="images/administrator-guide/connector-for-cmic/image-1.png" />
    </Frame>
  </Step>

  <Step>
    Enter your CMiC username and CMiC password in the popup window.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-2.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=7b2ce7a8af7b6e19bfec3d333ba56d02" alt="" width="1095" height="409" data-path="images/administrator-guide/connector-for-cmic/image-2.png" />
    </Frame>
  </Step>

  <Step>
    Click **Save credentials**.
  </Step>

  <Step>
    You will see the success message.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-3.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=fa00a69fecbecb9da1dddc966152f3c6" alt="" width="668" height="223" data-path="images/administrator-guide/connector-for-cmic/image-3.png" />
    </Frame>
  </Step>
</Steps>

## Configure Transaction Settings

On the Transaction Settings card, you can configure the **Start Date** and **End Date**.

Start date:

* Must be less than 1 year ago (if today is Nov 30, 2024 then you can not go further back than Nov 30, 2023).
* Leave empty to default 2 months back.
* Auto-sync will always process 2 months back.

End Date:

* Leave empty to default to the time of sync.
* Temporarily pick a small date range for testing and reconciliation purposes.

For PEX to know which company to sync transactions to, select a **CMiC company** if it is not already prepopulated. Also, select an **AP Invoice Location** if it is not already prepopulated.

Now decide if you want to:

* Sync all purchases or only approved purchases
  * "Only approved" means that purchases must be approved in PEX before syncing to CMiC.
* Only sync purchases with attachments
  * Purchases must have an attachment before syncing to CMiC. If this box is unchecked, a default attachment will be used if a purchase does not have an attachment.

Choose a **vendor** for purchases. Every purchase will sync with the same vendor you select in this field. Consider creating a new vendor named "PEX" in CMiC if you would like to book all of your PEX purchases against a single vendor.

**Purchase Field Mappings**

In this table, you need to map CMiC fields so the connector knows which values to use when syncing purchases to CMiC:

* The "Group Code", "Valid Flag", and "Type Code" fields can be mapped only to static values.
* The "Job/Dept/Eqp.", "Cost Code/Account/Category", and "Cost Type/Tran Code" fields can be mapped to static values or PEX Tags.

If you choose to use PEX tags, you must create them in advance, following the logic described in the ["Create PEX tags for CMiC"](/administrator-guide/create-pex-tags-for-cmic) article.

For example, the "Job/Dept/Eqp." is one of the fields on your Purchase:

* Mapping the "Job/Dept/Eqp." to a static value means that you can select one Job/Department/Equipment out of the many presented in CMiC, and that value ("NYC Office Renovation" in our example below) will be applied to all PEX purchases.

  <Frame>
    <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-4.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=42cdb64a17e7528c833466bdd39e9266" alt="" width="1436" height="235" data-path="images/administrator-guide/connector-for-cmic/image-4.png" />
  </Frame>

  <Note>
    **Note:**

    Note that a purchase will not be tagged with this static value. You will not see this static value on the purchase details. The static value will be used only when syncing a purchase to CMiC.
  </Note>

* Mapping the "Job/Dept/Eqp." to a PEX tag ("Job" in our example below) means that you and your cardholders can select one of the tag values for each purchase.

  <Frame>
    <img src="https://mintcdn.com/pextest/4XKZ8SDv0u7DUjZE/images/administrator-guide/connector-for-cmic/image-5.png?fit=max&auto=format&n=4XKZ8SDv0u7DUjZE&q=85&s=9cc31221d87b8d10bf7f7ebf18842c62" alt="" width="782" height="245" data-path="images/administrator-guide/connector-for-cmic/image-5.png" />
  </Frame>

  For that go to the "Transactions" menu -> locate a purchase -> click on it -> select a tag value ("NYC Office Renovation" in our example below) of the "Job" tag -> click "Save". Note that you and your cardholders can select one of the tag values for each purchase once you finish the CMiC connector setup and sync tag options from CMiC to PEX.

  <Frame>
    <img src="https://mintcdn.com/pextest/4XKZ8SDv0u7DUjZE/images/administrator-guide/connector-for-cmic/image-6.png?fit=max&auto=format&n=4XKZ8SDv0u7DUjZE&q=85&s=64212a37da87ff2e8b7287cb6c5b1ab9" alt="" width="984" height="485" data-path="images/administrator-guide/connector-for-cmic/image-6.png" />
  </Frame>

  When mapping to a tag, you can also specify a default "Job/Dept/Eqp." value: for example, Downtown Hospital Expansion Phase 2, as highlighted below.

  <Frame>
    <img src="https://mintcdn.com/pextest/4XKZ8SDv0u7DUjZE/images/administrator-guide/connector-for-cmic/image-7.png?fit=max&auto=format&n=4XKZ8SDv0u7DUjZE&q=85&s=6bfa05bc314db6a8612bff3cac0c69e9" alt="" width="1202" height="236" data-path="images/administrator-guide/connector-for-cmic/image-7.png" />
  </Frame>

  <Note>
    **Note:**

    Note that a purchase will not be tagged with this default value ("Downtown Hospital Expansion Phase 2" 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 CMiC, the default value ("Downtown Hospital Expansion Phase 2" in our example) will be applied to this purchase during the sync.
  </Note>

  If you or your cardholders do tag a purchase with the tag option from the tag chosen in the highlighted field below,

  <Frame>
    <img src="https://mintcdn.com/pextest/4XKZ8SDv0u7DUjZE/images/administrator-guide/connector-for-cmic/image-8.png?fit=max&auto=format&n=4XKZ8SDv0u7DUjZE&q=85&s=4abeefbfd8d92346143d8b393179c16d" alt="" width="1141" height="235" data-path="images/administrator-guide/connector-for-cmic/image-8.png" />
  </Frame>

  that specific purchase will be recorded against the tag option ("NYC Office Renovation" in our example below) you tagged the purchase with. Tags take precedence over default values.

  <Frame>
    <img src="https://mintcdn.com/pextest/4XKZ8SDv0u7DUjZE/images/administrator-guide/connector-for-cmic/image-9.png?fit=max&auto=format&n=4XKZ8SDv0u7DUjZE&q=85&s=4a69e28f0f262350e7f8ab3e7db47f60" alt="" width="1141" height="235" data-path="images/administrator-guide/connector-for-cmic/image-9.png" />
  </Frame>

* Enable the sync toggle to sync field values from CMiC into PEX as tag options.

  <Frame>
    <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-10.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=3b5f39cdc4a19d63f93599dfcf29a17d" alt="" width="1783" height="236" data-path="images/administrator-guide/connector-for-cmic/image-10.png" />
  </Frame>

  For example, the values for the PEX tag "Job" (in [Tag Manager](https://dashboard.pexcard.com/business-settings/tag-manager?utm_source=support)) will be populated with the names of your CMiC jobs.

  <Frame>
    <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-11.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=f9ec6a92df6f10d7a6a404d157340d6a" alt="" width="1450" height="857" data-path="images/administrator-guide/connector-for-cmic/image-11.png" />
  </Frame>

Click **Save**. PEX will redirect you to the **Sync tab**.

## Sync to CMiC

In the Sync tab, you can:

<Steps>
  <Step>
    View the last synchronization time.
  </Step>

  <Step>
    Manually sync by clicking "**Execute**".

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-12.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=0a84a514e7310d713eff9449eb5dccf4" alt="" width="541" height="305" data-path="images/administrator-guide/connector-for-cmic/image-12.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-13.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=1145c09a79fc5207ee491c6f17739e4e" alt="" width="731" height="718" data-path="images/administrator-guide/connector-for-cmic/image-13.png" />
    </Frame>
  </Step>

  <Step>
    View **Connection** info.
  </Step>

  <Step>
    Enable/disable auto-sync.

    * Enabled: Transactions sync automatically every 24 hours.
      * Disabled: Transactions will not sync automatically.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-14.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=61108909c5c896afbe82e9ad70132b42" alt="" width="408" height="210" data-path="images/administrator-guide/connector-for-cmic/image-14.png" />
    </Frame>
  </Step>

  <Step>
    Disconnect.
  </Step>

  <Step>
    View the **History** of transactions synced to CMiC.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-15.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=69d23caaae727a810db098f958bf7b0c" alt="" width="1239" height="413" data-path="images/administrator-guide/connector-for-cmic/image-15.png" />
    </Frame>
  </Step>

  <Step>
    ​View Settings information
  </Step>

  <Step>
    Edit settings if necessary.
  </Step>
</Steps>

**Auto-sync**
Auto-sync will always process transactions based on the start date specified on the **Connect tab**, with a maximum limit of 2 months back from today. If there is no start date specified on the **Connect tab** then auto-sync will sync transactions up to 2 months back from today.

**Manual sync**
Manual sync will process transactions based on the start date specified on the **Connect tab**, with a limit of 1 year back from today. If there is no start date specified on the **Connect tab** then manual sync will process transactions only up to 2 months back from today.

## Auto Tagger

The Auto Tagger app is a great complement to CMiC. It allows you to create rules that auto-tag purchases. [Learn more.](/administrator-guide/pex-auto-tagger)

## View Transactions and Receipts in CMiC

Log into CMiC account and navigate to *Enterprise ->* *Enterprise Content Management -> Image Manager ->*

<Frame>
  <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-16.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=052eefdd655189f9d40f0b98723503b1" alt="" width="730" height="776" data-path="images/administrator-guide/connector-for-cmic/image-16.png" />
</Frame>

*-> select your folder ->*

<Frame>
  <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-17.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=b463d10d734bcf5a51acd0876e324286" alt="" width="508" height="263" data-path="images/administrator-guide/connector-for-cmic/image-17.png" />
</Frame>

*-> click on a transaction* to view it.

<Frame>
  <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-18.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=2346f1d31fe00d5511c971eb05583c8d" alt="" width="1898" height="837" data-path="images/administrator-guide/connector-for-cmic/image-18.png" />
</Frame>

You can find and view the receipt on the left.

<Frame>
  <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-19.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=4db63f973a26cf9da8284082bb008546" alt="" width="1899" height="841" data-path="images/administrator-guide/connector-for-cmic/image-19.png" />
</Frame>

If a transaction does not have a receipt, you will see **No Attachment** title.

<Frame>
  <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-20.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=83567f6cb675982e2b495c4499b01c89" alt="" width="1897" height="844" data-path="images/administrator-guide/connector-for-cmic/image-20.png" />
</Frame>

## FAQ

<AccordionGroup>
  <Accordion title="Can I enable auto-sync?">
    Auto-sync is not available during the connector BETA period.
  </Accordion>

  <Accordion title="What transactions are synced?">
    Only purchases in a settled status are synced.
  </Accordion>

  <Accordion title="Do pending transactions get synced?">
    No. Only transactions in settled status get synced to your account. If you see a "Pending" label next to the merchant name as shown on the screen below, then the transaction is still in the pending status.

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-21.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=6c6bd778588401bffb7059d8be74efdf" alt="" width="706" height="348" data-path="images/administrator-guide/connector-for-cmic/image-21.png" />
    </Frame>
  </Accordion>

  <Accordion title="Can transactions be automatically tagged?">
    Yes. If you prefer not to manually tag each transaction, PEX Auto Tagger offers a solution. This app allows you to create dynamic rules that automatically tag transactions. [Learn more](/administrator-guide/pex-auto-tagger).
  </Accordion>

  <Accordion title="Can I combine manual and automatic tag sync from CMiC to PEX?">
    We strongly recommend using automatic sync of tag options from CMiC to PEX. This will keep your PEX tags and CMiC fields in sync. For more information, check out the support article ["Create PEX tags for CMiC"](/administrator-guide/create-pex-tags-for-cmic) to add tags and test tag options.

    Once added, enable "Sync Tag" for fields with the Type set to Tag (as shown in the example below).

    <Frame>
      <img src="https://mintcdn.com/pextest/ijadawBf-Qyc3wnw/images/administrator-guide/connector-for-cmic/image-22.png?fit=max&auto=format&n=ijadawBf-Qyc3wnw&q=85&s=ffd2f824211eeb6bb503bb63577bdf04" alt="" width="1783" height="236" data-path="images/administrator-guide/connector-for-cmic/image-22.png" />
    </Frame>

    We strongly recommend using automatic sync of tag options from CMiC to PEX. This will keep your PEX tags and CMiC fields in sync. For more information, check out the support article [.](/administrator-guide/create-pex-tags-for-cmic)
  </Accordion>

  <Accordion title="Will a previously synced transaction re-sync to my CMiC account if I change its status (Rejected -> Approved), re-tag or add another receipt?">
    Every synced transaction has a "Synced with CMiC" note. As long as you don't remove the "Synced with CMiC" note on a transaction, it will not re-sync to your CMiC account.
  </Accordion>

  <Accordion title="Didn't find the answer you were looking for?">
    Didn't find the answer you were looking for? Check out our [Accounting Software Connector Troubleshooting](/administrator-guide/accounting-software-connector-troubleshooting) article.
  </Accordion>
</AccordionGroup>

## Support & Inquiries

For any questions or for more information, please email [appsupport+cmic@pexcard.com](mailto:appsupport+cmic@pexcard.com)