# Customer Rebate Summary

<p class="doc-lead">Rebate earned from Customer Rebate schemes for a month, week, quarter, half year, or year — summary Amount and Commission, or a detailed target / value / qty / % / fixed breakdown.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/sales/reports/customer-rebate-summary?id=overview">Overview</a>
<a href="#/sales/reports/customer-rebate-summary?id=use-cases">Use Cases</a>
<a href="#/sales/reports/customer-rebate-summary?id=filters">Filters</a>
<a href="#/sales/reports/customer-rebate-summary?id=layout">Layout &amp; columns</a>
<a href="#/sales/reports/customer-rebate-summary?id=actions">Actions</a>
<a href="#/sales/reports/customer-rebate-summary?id=faq">FAQ</a>
</div>
</div>

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

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

Go to <b>Sales → Customer Reports → Customer Rebate Summary</b>.

Report title in ERP: <b>Customer Rebate Summary</b>

<p><b>What it shows.</b> One row per customer with qualifying sales in the rebate period. Summary mode shows <b>Amount</b> and <b>Commission</b>. <b>Show Detailed</b> adds target, value, quantity, %, and fixed-amount columns so you can see how each scheme line was earned.</p>

<p><b>When to use it.</b> Settle period rebates, check which customers hit value or quantity targets, and share a rebate statement in an account review.</p>

<p><b>How amounts are calculated.</b> Qualifying approved and closed sale invoice lines in the selected period are matched to <a href="#/sales/customer-rebate">Customer Rebate</a> schemes. <b>Amount</b> is taxable sale value used for the rebate. <b>Commission</b> is the rebate earned from percentage and/or fixed amount on the scheme. The calculation period on the report should match the period set on the rebate scheme. Customers with zero rebate are hidden unless <b>Show Zero Rebate</b> is on.</p>

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

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

<ul>
<li><b>Period settlement</b> — Generate for the scheme period and process Commission as credit or payment.</li>
<li><b>Target check</b> — Use <b>Show Detailed</b> to see who missed a value or quantity band.</li>
<li><b>One account</b> — Select <b>Customer</b> to review a single rebate statement.</li>
</ul>

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

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

<p><b>Header (quick filters)</b></p>

<ul>
<li><b>Period</b> — <b>Month</b>, <b>Week</b>, <b>Quarter</b>, <b>6 Month</b>, or <b>Year</b>.</li>
<li><b>Period picker</b> — Month: month control. Week: date range (maximum 7 days). Quarter: year and <b>Q1 (Jan-Mar)</b> through <b>Q4 (Oct-Dec)</b>. 6 Month: year and <b>H1 (Jan-Jun)</b> / <b>H2 (Jul-Dec)</b>. Year: calendar year.</li>
<li><b>Customer</b> — optional. Limit to one customer.</li>
<li><b>Show Detailed</b> / <b>Hide Detailed</b> — toggle the detailed target / value / qty / % / fixed columns.</li>
</ul>

<p><b>More</b></p>

<ul>
<li><b>Show Zero Rebate</b> / <b>Hide Zero Rebate</b> — include or hide customers with zero commission.</li>
</ul>

<p>There is no Advanced Filter button on this report.</p>

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

<h2 id="layout">Layout &amp; columns</h2>

<p><b>Summary</b> (Hide Detailed)</p>

| **Column** | **Description** |
|------------|-----------------|
| Customer | Customer name. |
| Customer Code[ID] | Party code and customer id. |
| Amount | Sale amount before tax used for rebate. |
| Commission | Rebate earned. |
| Footer Total | Sum of Commission. |

<p><b>Show Detailed</b> adds:</p>

| **Column** | **Description** |
|------------|-----------------|
| Customer Group | Customer group (on detail lines). |
| Item Group / Sub Group / Item | Scheme line — item group, optional sub group, and item. |
| Amount → Target | Value target band on the scheme (or - when not used). |
| Amount → Value | Sale amount before tax when commission is on value. |
| Quantity → Target | Quantity target band (or - when not used). |
| Quantity → Qty | Quantity when commission is on quantity. |
| Quantity → Value | Sale amount before tax paired with quantity commission. |
| Commission → % | Percentage on the scheme line. |
| Commission → Fixed Amount | Fixed rebate amount on the scheme line. |
| Commission → Total | Rebate on that line. |

<p>If there is no rebate for the filters, the page shows <b>No Rebate</b>.</p>

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

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

<ul>
<li><b>Generate</b> — run the report for the selected period and customer</li>
<li><b>Show Detailed</b> / <b>Hide Detailed</b> — toggle the breakdown</li>
<li><b>More</b> — <b>Show Zero Rebate</b> or <b>Hide Zero Rebate</b></li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (period label is included)</li>
</ul>

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

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

<p><b>Where is rebate configured?</b><br>Schemes are defined in <a href="#/sales/customer-rebate">Customer Rebate</a>. The period you pick here should match the scheme period.</p>

<p><b>Does this change invoice prices?</b><br>No. Rebate is calculated after the fact for settlement — it is not a discount at bill entry.</p>

<p><b>Why is Commission zero?</b><br>Sales did not meet the value or quantity target, or <b>Show Zero Rebate</b> is listing customers with no earned rebate.</p>

<p><b>Can a customer have more than one scheme line?</b><br>Yes. Show Detailed lists each item-group / item line under the customer.</p>

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

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

<ul>
<li><a href="#/sales/customer-rebate">Customer Rebate</a></li>
<li><a href="#/sales/reports/customer-wise-sale-report">Customer Wise Sale Report</a></li>
</ul>
