> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-and-branch-wise-new-repeat-lapsed-sale-analysis.md).

# Retail Customer & Branch Wise New/Repeat/Lapsed Sale Analysis

**YouTube:** [How to Configure Retail Customer & Branch-Wise New/Repeat/Lapsed Sales Analysis?](https://youtu.be/OK5dksEz3Ks)

## How to Configure Retail Customer & Branch - Wise New / Repeat / Lapsed Sales Analysis?

In this tutorial, we will learn how to configure and generate the **Retail Customer and Branch-Wise New, Repeat, or Lapsed Sale Analysis** report in Logic ERP.

This report helps businesses analyze branch-wise retail sales performance and understand customer purchasing patterns. It identifies new, repeat, and lapsed customers for the selected period, helping businesses evaluate customer retention and sales trends.

***

### Access to the Report

* Navigate to the **Setup Accounts** module from the main menu.
* Expand **Setup Customer Database**.
* Open **Retail Customer & Branch Wise New/Repeat/Lapsed Sale Analysis**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FB0LOMn9Wny5cghPNILDq%2FDF.png?alt=media&#x26;token=15f37ffe-6556-4ad3-b015-8e7f9765101e" alt=""><figcaption></figcaption></figure>

* Before generating the report, let's configure the required settings.

***

### Configure the Report Options

Under **Report Options**, locate the **Period Type** dropdown.

* Select the required period type.
* For this example, we have selected **Monthly**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FqgAVv29QWClLWmqBqID6%2Fcnf.png?alt=media&#x26;token=0fa0df51-7684-4629-8c55-66269d92573b" alt=""><figcaption></figcaption></figure>

This setting determines how the report groups sales and customer activity for analysis. The choices are Date Wise, Week Wise, Journey Cycle Wise, Monthly, Quarterly, Half Yearly and Yearly. The report is split by period only when **Period** is ticked under **Dimensions**.

**Configure the Look Back Period**

* Next, in the **Customer Movement** section, define the **Look Back Period**.
* The Look Back Period is a number of **months**: 3, 6, 12 (default) or 24. It sets how far back before the report's start date the system looks for earlier bills of each customer. This decides who is counted as New and who is counted as Lapsed.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F2Zn2c058sHqusFzRdkNt%2Fcnf2.png?alt=media&#x26;token=60ef96cb-aee7-4d60-8aa3-41b62ed1ca64" alt=""><figcaption></figcaption></figure>

* This helps the report evaluate customer purchasing behavior in relation to the selected reporting period.

**Configure the Repeat Customer Basis**

* Under **Repeat Customer Basis**, select the required option to define how the system identifies repeat customers.
* For this example, we have selected **Two Or More Bills Within The Range** (the default). The other choice is **Also Bought In The Look Back Period**, which counts a customer who bought in the report range and also bought during the look-back months.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FwGv2z2IJ6kTDrHBemTkK%2Fcnf3.png?alt=media&#x26;token=c7bdef29-eb4f-47c5-8477-bbca764f3351" alt=""><figcaption></figcaption></figure>

* With this setting, the report identifies repeat customers based on having two or more bills within the report's date range.
* Choose the option that best matches your business's customer analysis requirements.

***

### Generate the Report

Once all the required settings have been configured:

* Review the selected **Period Type**.
* Verify the **Look Back Period**.
* Confirm the **Repeat Customer Basis**.
* Click **Create** (or press **F2**) to generate the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FBcYI4yGBrQACKj8kfgxK%2FReport.png?alt=media&#x26;token=37593330-117e-40d0-af16-230b9c03dd6a" alt=""><figcaption></figcaption></figure>

The report displays branch-wise sales performance and customer activity for the selected period.

***

### Understand the Report Details

The report helps you analyze sales performance across different stores or branches (tick **Branch**, and **Period** for a month-wise view, under **Dimensions**).

The report counts only bills of registered retail customers. Bills without a customer (walk-in bills) are left out of every figure.

It includes key sales and customer metrics, such as:

* **Total Bills:** The number of retail-customer bills during the selected period.
* **Total Qty-1 / Total Qty-2:** The total quantity sold, each in its own unit setting.
* **Net Sale Value:** The net sales value achieved during the period (Gross Sale Value is also available).
* **Total Customers:** The number of different registered retail customers billed.
* **New Customers:** Customers with no bill in the look-back months before the report start date, whose first bill falls within the report range.
* **Repeat Customers:** Customers who purchased again, based on the selected Repeat Customer Basis.
* **Lapsed Customers:** Customers who bought during the look-back months before the start date but did **not** buy at all within the report range. This column is blank on rows split by period.

***

### Analyze Customer Purchasing Patterns

Using this report, you can understand how customer activity changes across branches and over time.

* **New Customers** help you evaluate customer acquisition.
* **Repeat Customers** help you assess customer retention and recurring purchases.
* **Lapsed Customers** help you identify customers who may need follow-up or targeted offers.

Comparing these figures across branches can help you identify stores with stronger customer retention and those where customer engagement may need improvement.

***

### Key Benefits

* **Branch-Wise Analysis:** Compare sales and customer activity across stores.
* **Customer Classification:** Understand new, repeat, and lapsed customer trends.
* **Sales Performance Tracking:** Review bills, quantities, and net sales.
* **Customer Retention Insights:** Identify patterns in repeat purchasing behavior.
* **Better Business Decisions:** Use customer trends to plan marketing and retention activities.

### Final Outcome

The **Retail Customer and Branch-Wise New, Repeat, or Lapsed Sale Analysis** report provides a consolidated view of branch-wise sales performance and customer purchasing patterns. By configuring the period type, look back period, and repeat customer basis, you can analyze customer activity and better understand how effectively each store attracts and retains retail customers.

***

For every setting of this report, see [Retail Customer & Branch Wise New/Repeat/Lapsed Sale Analysis - Configuration](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-and-branch-wise-new-repeat-lapsed-sale-analysis/retail-customer-and-branch-wise-new-repeat-lapsed-sale-analysis-configuration.md).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-and-branch-wise-new-repeat-lapsed-sale-analysis.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
