# Transaction Wise Commission Report

<p class="doc-lead">Sale invoice commission and bonus breakdown by transaction. Shows invoice amount, commission discount, net commission base, and per-employee commission and bonus amounts — with a 100-day maximum date range.</p>

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

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

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

Go to <b>Payroll → Payroll Reports → Transaction Wise Commission Report</b>.

<p><b>What it shows.</b> One row per sale invoice with taxable amount, <b>discountOnCommissionAmount</b>, amount after discount, aggregated commission and bonus, and optional per-employee detail lines.</p>

<p><b>When to use it.</b> Verify commission calculations against sale invoices, audit salesperson and bonus allocations, and reconcile before posting additional payments on transactions.</p>

<p><img src="payroll/images/transaction-wise-commisn-rep.webp" alt="Transaction Wise Commission Report" loading="lazy"></p>

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

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

<ul>
<li><b>Sales manager</b> — Which invoices earned commission for which employees this week?</li>
<li><b>Payroll</b> — Confirm commission base after discounts before pay-run additional payments.</li>
<li><b>Audit</b> — Export detailed view with per-employee commission % and bonus % against invoice net amount.</li>
</ul>

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

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

| **Filter** | **Description** |
|------------|-----------------|
| Date range | Sale invoice dates. <b>Maximum 100 days</b> — selecting a longer range returns an error ("Select dates within 3 months"). |
| Customer | Optional customer filter. |
| Branch | Optional branch filter (when branch access enabled). Respects user default branch filter if configured. |

<p>Additional filters are available via URL parameters: employee, sale type, center, customer group, pay mode, zone, state, route, brand, payment term, dummy party name.</p>

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

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

<h3>Summary view (default)</h3>

| **Column** | **Description** |
|------------|-----------------|
| Date | Sale invoice date. |
| Bill Number[ID] | Invoice bill number and ID — click for quick view. |
| Customer | Customer name. |
| Invoice Amount | Taxable amount total on the invoice. |
| Discount | <b>discountOnCommissionAmount</b> — discount applied before commission calculation (sum of discount on linked additional-payment-on-transaction records). |
| Total | Amount after discount (<code>invoiceAmount − discountOnCommissionAmount</code>) — commission base. |
| Commission Amount | Total commission across all employees on the invoice. |
| Bonus Amount | Total bonus across all employees on the invoice. |
| Total | Commission + Bonus. |
| Total % | Total as percentage of amount after discount. |

<h3>Detailed view (Show Detailed)</h3>

<p>Additional sub-rows per employee with Commission Amount, Commission %, Bonus Amount, and Bonus % — each calculated against the amount after discount.</p>

<p><img src="payroll/images/transaction-wise-commisn-rep-hide.webp" alt="Transaction Wise Commission Report detailed view" loading="lazy"></p>

<p>A footer <b>Total</b> row aggregates invoice amount, discount, amount after discount, commission, bonus, and grand total across the result set. Results are paginated (default 250 per page).</p>

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

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

<ul>
<li><b>Generate</b> — run the report</li>
<li><b>Show Detailed / Hide Detailed</b> — toggle per-employee commission and bonus lines</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
</ul>

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

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

<p><b>Why do I get "Select dates within 3 months"?</b><br>The date range exceeds 100 days. Narrow the from/to dates.</p>

<p><b>What is discountOnCommissionAmount?</b><br>The sum of discount fields on <b>Employee Additional Payment on Transaction</b> records linked to the sale invoice. Commission and bonus percentages are applied to <code>invoiceAmount − discountOnCommissionAmount</code>.</p>

<p><b>Where are commission rules configured?</b><br>See <b>Sale Invoice Commission</b> in <a href="#/payroll/payroll-settings-config">Payroll Settings (Configuration)</a> and branch-level commission percentages on Payroll Settings.</p>

<p><b>Why is an invoice row highlighted?</b><br>Rows with zero total commission/bonus may appear with danger styling when no commission lines exist.</p>

<p><b>Which sale invoices appear?</b><br>Invoices with approved Commission On Transaction or linked additional payment commission lines in the date range — per report filter rules.</p>

<p><b>Can I audit branch commission limits?</b><br>Compare commission % columns to branch maximums on Payroll Settings — over-limit approvals should fail at commission approve.</p>

<p><b>Does the report show pay-run settlement?</b><br>It shows calculated commission amounts from invoices — settlement status is on Additional Payment and pay run documents.</p>

<p><b>Why is employee commission split across rows?</b><br>Multiple employees on one invoice each get a row segment — totals aggregate at invoice level on the report.</p>

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