# Repeating Customer Sale Report

<p class="doc-lead">Identifies customers with repeat purchase activity — frequency, total spend, and last purchase date for loyalty and retention analysis.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/sales/reports/repeating-customer-sale?id=overview">Overview</a>
<a href="#/sales/reports/repeating-customer-sale?id=use-cases">Use Cases</a>
<a href="#/sales/reports/repeating-customer-sale?id=filters">Filters</a>
<a href="#/sales/reports/repeating-customer-sale?id=columns">Columns</a>
<a href="#/sales/reports/repeating-customer-sale?id=actions">Actions</a>
<a href="#/sales/reports/repeating-customer-sale?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Sales → Customer Reports → Repeating Customer Sale Report</b>.

Report title in ERP: <b>Repeating Customer Sale Report</b>

<p><b>What it shows.</b> Customers who purchased more than once in the selected period, with purchase count, total spend, average order value, and last purchase date.</p>

<p><b>When to use it.</b> Use to identify loyal repeat buyers, measure customer retention, and target marketing to frequent purchasers.</p>

<p><b>How amounts are calculated.</b> Counts distinct sale invoices per customer within the selected date range. Only customers with more than one invoice appear.</p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Loyalty programs</b> — Identify frequent buyers eligible for loyalty rewards or discounts.</li>
<li><b>Retention analysis</b> — Measure repeat purchase rates across customer segments.</li>
<li><b>Churn prevention</b> — Compare repeat customers against <a href="#/sales/reports/customer-inactive">Inactive Customer</a> report.</li>
<li><b>Marketing campaigns</b> — Export repeat customer lists for targeted promotions.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<b>Date</b>, <b>Minimum Purchase Count</b>, <b>Customer Group</b>, <b>Employee</b>. <b>Advanced Filter</b>: Route, Branch, Item Group, Payment Mode.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| Customer | Customer name. |
| Customer Code | Unique identifier assigned in the master record. |
| Purchase Count | Number of sale invoices in the period. |
| Total Spend | Sum of invoice totals. |
| Avg Order Value | Total Spend divided by Purchase Count. |
| First Purchase | Date of first invoice in the period. |
| Last Purchase | Date of most recent invoice. |
| Days Between Avg | Average days between consecutive purchases. |

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected filters</li>
<li><b>Export</b> / <b>Export All</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>clear</b> — reset active filters</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>What defines a repeating customer?</b><br>A customer with more than one approved sale invoice in the selected period (configurable via minimum purchase count).</p>
<p><b>Can I include one-time buyers?</b><br>Set minimum purchase count to 1, or use Customer Wise Sale Report for all customers.</p>
<p><b>How is days between average calculated?</b><br>Average interval between consecutive invoice dates for the customer in the period.</p>
<p><b>Does this include returns?</b><br>Total spend reflects invoice totals. Net values may adjust when returns are configured in the report.</p>
<p><b>What defines a repeating customer?</b><br>Customer with more than one approved invoice in the selected period or repeat purchase pattern per report logic.</p>

<p><b>How is this different from Inactive Customers?</b><br><a href="#/sales/reports/customer-inactive">Inactive Customers</a> finds no recent sales. Repeating finds loyal repeat buyers.</p>
<hr class="doc-section-divider">

<h2 id="related">Related</h2>

<ul>
<li><a href="#/sales/reports/new-customer-report">New Customer Report</a></li>
<li><a href="#/sales/reports/customer-inactive">Inactive Customer</a></li>
</ul>