# Transaction Detail

The Transaction Report is a detailed document that provides insights into all transactions within a specified period. It includes data such as transaction dates, points earned or redeemed, and the type of transaction.

#### Filter for the Transaction Detail Report

Before running the report, you can apply the following filters to customize the data:

* **Transaction Date Range**: Specify the start and end dates for the transactions you want to include. These dates represent when the transaction happened in the source system.
* **Last Modified Date Range**: Set the date range for when transactions were last modified.
* **Locations**: Select the specific locations for which you want to view transactions. You can run the report for all locations or narrow it down to specific locations.
* **Location Groups**: Choose a location group (e.g. you can create groups for franchises, regions, etc) to view the transactions for locations within a given group.
* **Earn Perks**: Filter transactions based on earning perks, including standard perks, bonus perks, and inactive perks.
* **Redeem Perks**: Filter transactions based on redemption perks, including standard redemptions, instant rewards,  referral offers, and inactive perks.
* **Classification**: Filter only be earn or redeem transactions.
* **Status**: Include transactions based on their status, such as active or voided.

#### Columns in the Transaction Detail Report

* **Customer Name**
* **Customer Email**
* **Membership Status**:  Options include Active, Inactive, or None. Only applicable to businesses using memberships.
* **Membership ID**: The external ID of the member. Only applicable to businesses using memberships.
* **Membership Type**: The member's membership type. Only applicable to businesses using memberships.
* **Type**: The type of perk for this transaction (e.g. Standard, Point adjustment, Progress activity, etc)
* **Title**: The title of the perk.
* **Transaction Date**: The date of the transaction from the source system. 
* **Created Date**: The date the transaction was created in Perkville.
* **Last Modified Date**: The date the transaction was last modified in Perkville. Primarily applicable to transactions with a status of Void.
* **Location Name**: The name of the location at which this transaction took place.
* **Quantity**: The quantity applied to this transaction.
* **Total Points**: The total points for this transaction, which is the quantity multiplied by the perk's points.
* **Status**: Options include Active and Void.

{% embed url="<https://docs.perkville.com/faqs/miscellaneous/how-are-voided-transactions-accounted-for>" %}

* **Unique ID**: The unique identifier given to this transaction. This not only prevents unintended duplicates, but also often includes identifiers from the source system (like checkin ID)

### Generating the Report

To generate the **Transaction Detail Report**:

1. Navigate to the **Reports** section in your Perkville dashboard.
2. Select **Transaction Detail** from the list of available reports.
3. Apply the desired filters and choose your date range. \
   Note, this report is limited to a period of 90 days.
4. Click **Run Report** to export the data as a CSV file for further analysis.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.perkville.com/features/reports/transaction-detail.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.