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

**Step 1**

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

**Step 2**

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

**Step 3**

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

![](https://mintcdn.com/pextest/uCSQ9yXeTyRSlT2V/images/api-&-integration/image-278.png?fit=max\&auto=format\&n=uCSQ9yXeTyRSlT2V\&q=85\&s=d0738f174805776a11ae9164343b71e6)

**Step 4**

Select **Start** and **End** dates for the export.

> [!WARNING]
>
> **Important:**
>
> To avoid creating duplicate records in QuickBooks, select dates not previously exported.

**Step 5**

Click **Export** at the bottom of the page.

* This downloads a file ending in `.qbo` to the folder you select.

**Step 6**

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

**Step 7**

Select the "Import new transactions now" option and click **OK**.

**Step 8**

On the right, select the bank account you want to import the transactions into.

**Step 9**

Click **Continue**.

* The QuickBooks dialog box will indicate that data was successfully imported.

**Step 10**

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.

## Export to QuickBooks Online

**Step 1**

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

**Step 2**

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

**Step 3**

Click **Open**.

**Step 4**

Click **Continue**.

**Step 5**

Select the bank account you want to import the transactions into.

**Step 6**

Click **Continue** and confirm the import.

**Step 7**

Return to the **Banking** tab to view your transactions.

## FAQ

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

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

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

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

> **Missing transaction tags and/or notes**
>
> * Transaction tags and notes cannot be included in the .qbo export file.

> **Unable to import the file**
>
> > [!NOTE]
> >
> > **Note:**
> >
> > Only .qbo, .ofx, and .csv files are available.
>
> * PEX does not support .qfx.
> * Please contact Intuit for file conversion options.

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

## Support & inquiries

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


## Related topics

- [PEX Connector for QuickBooks Desktop](https://support.pexcard.com/administrator-guide/pex-connector-for-quickbooks-desktop.md)
- [PEX Connector for QuickBooks Desktop (Prepaid)](https://support.pexcard.com/administrator-guide/pex-connector-for-quickbooks-desktop-prepaid.md)
- [How to add PEX to your QuickBooks™️ Online account](https://support.pexcard.com/administrator-guide/how-to-add-pex-to-your-quickbooks-online-account.md)
- [Adding PEX to your QuickBooks™️ Desktop account](https://support.pexcard.com/administrator-guide/adding-pex-to-your-quickbooks-desktop-account.md)
- [Apps & Other Integrations](https://support.pexcard.com/administrator-guide/apps-and-other-integrations.md)


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