> For the complete documentation index, see [llms.txt](https://docs.shopwaive.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.shopwaive.com/shopify/accounts/export-accounts.md).

# Export accounts

Exporting data for your third-party reporting and analytics teams is as easy as one click

## Export customer balances

Export all your customer account balances. Follow the steps below to get a real-time snapshot of your customer account balances.

Open Shopwaive and click **Customers**. Click **More actions**, then <mark style="color:blue;">**Export all balances**</mark>.

Your browser downloads `Customer balances.csv`, sorted by email. It lists every account, including accounts with a balance of 0.

| Store            | Columns                                                         |
| ---------------- | --------------------------------------------------------------- |
| Money balances   | `Email`, `Balance`, `Expiry`, `Note`, `Customer ID`             |
| Points or tokens | `Email`, `Balance`, `Currency`, `Expiry`, `Note`, `Customer ID` |

A money store shows the currency symbol and two decimals in Balance, for example `$25.00`. A points or tokens store shows whole points, with the unit in Currency. Expiry is filled only for accounts with an expiration date switched on.

## Export customer transactions

If you'd like to receive a full ledger of all your customer transactions, including issuance and redemption of credit, follow the steps below.

Open Shopwaive and click **Customers**. Click **More actions**, then <mark style="color:blue;">**Export all transactions**</mark>. To export one customer only, click <mark style="color:blue;">**Export transactions**</mark> on that customer's row.

Your browser downloads `Customer transactions.csv` with these columns, in this order:

`Email`, `Previous Balance`, `Transaction Amount`, `Transaction Type`, `Transaction ID`, `Transaction Note`, `Order Number`, `Date`, `Available Balance`, `Balance Due`, `Currency`, `Figures`

* A store with B2B Checkout switched on also gets `Placed By` and `Funded By` after `Email`.
* A column that does not apply to a row is left blank.
* `Figures` says where the row's balances come from: `recorded` (stored with the transaction), `reconstructed` (rebuilt from the account's history), `derived` (worked out from the rows around it) or `not recorded` (an Opening balance row).
* An account that holds a balance but has no history gets one row of type `Opening balance`.
* A points or tokens store shows whole points, with the unit in `Currency`.

While the export runs, the page title shows **Preparing N accounts**. Keep the page open until the file downloads: a store with many accounts can take several minutes or more.

## If an export does not finish

* **Nothing to export**: there is nothing to put in the file, for example a customer with no transaction history.
* **Export problem**: the export stopped before the file was complete, so no file is written. Run it again.