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

# How to Export Transactions via a File Download to QuickBooks Desktop or QuickBooks Online

> If you prefer not to use the connector for auto syncing PEX transactions to your QuickBooks account every 24 hours, you can manually export transactions using a file.

## Export to QuickBooks Desktop

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

  <Step>
    Navigate to [Reports](https://dashboard.pexcard.com/reports/generate?utm_source=support).
  </Step>

  <Step>
    Click on the dropdown to select "QuickBooks export" or type "QuickBooks export" to search.

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

  <Step>
    Select **Start** and **End** dates for the export.

    <Warning>
      **Important:**

      To avoid creating duplicate records in QuickBooks, select dates not previously exported.
    </Warning>
  </Step>

  <Step>
    Click **Export** at the bottom of the page.

    * This downloads a file ending in `.qbo` to the folder you select.
  </Step>

  <Step>
    When the download completes, double-click your downloaded `.qbo` file to open it in QuickBooks.
  </Step>

  <Step>
    Select the "Import new transactions now" option and click **OK**.
  </Step>

  <Step>
    On the right, select the bank account you want to import the transactions into.
  </Step>

  <Step>
    Click **Continue**.

    * The QuickBooks dialog box will indicate that data was successfully imported.
  </Step>

  <Step>
    Click **Transaction List**.

    * Imported transactions will appear so you can add the payee and account and either accept or delete the transaction. Under the **ACTION** column, you can select **Quick Add** or **Add More Details** to include more information. The Memo field will include the cardholder name by default.
  </Step>
</Steps>

## Export to QuickBooks Online

<Steps>
  <Step>
    Follow steps 1–4 under [Export to QuickBooks Desktop](#export-to-quickbooks-desktop) to generate and download a `.qbo` file.
  </Step>

  <Step>
    In QuickBooks Online, go to **Transactions** → **Bank transactions** → select **Upload from file** → drag and drop or select the `.qbo` file you just saved.
  </Step>

  <Step>
    Click **Open**.
  </Step>

  <Step>
    Click **Continue**.
  </Step>

  <Step>
    Select the bank account you want to import the transactions into.
  </Step>

  <Step>
    Click **Continue** and confirm the import.
  </Step>

  <Step>
    Return to the **Banking** tab to view your transactions.
  </Step>
</Steps>

## FAQ

<AccordionGroup>
  <Accordion title="My PEX account balance and my QuickBooks balance do not match">
    * PEX statements and the .qbo file export only include settled transactions.
    * Pending transactions, which appear in the card transaction history, are not final (because the transaction month and amount may change).
    * Pending transactions should not be entered into QuickBooks.
    * Be sure that the time period of the statement matches the .qbo file export start and end dates. The default statement period is a calendar month.
  </Accordion>

  <Accordion title="I cannot find my PEX account number">
    * The unique number for your PEX Account (a 13 digit number) is listed on the Transfers / ACH Instructions page of the Administrator website.
    * You must log in to retrieve your account number.

    <Note>
      **Note:**

      If you have multiple PEX Accounts, each PEX Account will have its own unique account number.
    </Note>
  </Accordion>

  <Accordion title="My file is missing older transactions">
    * A maximum of 3 months of transactions can be exported at one time.
    * PEX makes the last 12 months of spend available on the Administrator site.
    * Older months can be sourced by emailing the request, with the desired time period and file type (.qbo or .csv), to [adminsupport@pexcard.com](mailto:adminsupport@pexcard.com).
    * PEX will email the information to you.
  </Accordion>

  <Accordion title="Limiting the file to a single cardholder account">
    * The export contains all transactions that affect the PEX Account balance, including:

      * ACH transfers
      * Wire transfers
      * Fees
      * Merchant purchases and returns

    * All cards are included — there is no .qbo file export per single PEX Card Account.
  </Accordion>

  <Accordion title="Missing transaction tags and/or notes">
    * Transaction tags and notes cannot be included in the .qbo export file.
  </Accordion>

  <Accordion title="Unable to import the file">
    <Note>
      **Note:**

      Only .qbo, .ofx, and .csv files are available.
    </Note>

    * PEX does not support .qfx.
    * Please contact Intuit for file conversion options.
  </Accordion>

  <Accordion title="Expected transactions do not appear in the exported file">
    * Only settled transactions appear in the export and statement files.
    * If a merchant has not completed the transaction process within 14 days, then:

      * The pending transaction will no longer appear on the card account.
      * There is no record of that transaction in the export.
      * If you have a receipt, but there is no settlement, then please call the merchant.
  </Accordion>
</AccordionGroup>

## Support & inquiries

For any questions related to exports, please email [appsupport+quickbooksexport@pexcard.com](mailto:appsupport+quickbooksexport@pexcard.com).