# Bill Wise Tax Rate Wise Sale

<p class="doc-lead">Sale documents broken down by tax rate — one row per bill and tax rate, with sale amount before tax, tax amount, and invoice total for filing and reconciliation.</p>

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

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

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

Go to <b>Sales → Reports → Bill Wise Tax Wise Sale</b>.

Report title in ERP: <b>Bill Wise Tax Rate Wise Sale</b>

<p><b>What it shows.</b> Each approved or closed sale document split by tax rate. A bill that has 5% and 18% lines appears as two rows. Columns include transaction type, branch, tax rate, sale amount before tax, tax amount, row total, and invoice total. Credit notes and advance credit notes show in red.</p>

<p><b>When to use it.</b> Use for GST or VAT filing support, tax-rate reconciliation, and checking taxable vs tax collected by rate — not for a simple bill list. Use <a href="#/sales/reports/sale-report">Sale Report</a> for one row per invoice.</p>

<p><b>How amounts are calculated.</b> Approved and closed documents in the date range are included. Each row is one tax rate on one document. <b>Taxable Amount</b> and <b>Tax Amount</b> are the amounts at that rate. <b>Total</b> is taxable plus tax for the row. <b>Invoice Total</b> is the full document total (it can repeat when a bill has more than one rate). Credit notes reverse the sign. <b>Tax Rate Type</b> can limit rows to <b>Standard</b>, <b>Zero</b>, or <b>Exempted</b>.</p>

<img src="sales/images/bill-wise-tax-wise-sale.webp" alt="Bill Wise Tax Rate Wise Sale report with invoice, tax rate, taxable amount, and tax" loading="lazy">

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

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

<ul>
<li><b>Tax filing pack</b> — Export rows by tax rate for a month or quarter.</li>
<li><b>Zero / exempt review</b> — Set <b>Tax Rate Type</b> to <b>Zero</b> or <b>Exempted</b> to list those supplies.</li>
<li><b>Document mix</b> — Use <b>Transaction Type</b> to separate sale invoices from debit notes, credit notes, and advances.</li>
<li><b>Supply type check</b> — In Advanced Filter, include or exclude Regular, Export, Deemed Export, SEZ, or GCC Export.</li>
</ul>

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

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

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

<ul>
<li><b>Date</b> — date range for documents. Defaults to today.</li>
<li><b>Tax Rate Type</b> — <b>Tax Rate Type - All</b>, <b>Standard</b>, <b>Zero</b>, or <b>Exempted</b>.</li>
<li><b>Transaction Type</b> — <b>Transaction Type - All</b>, <b>Sale Invoice</b>, <b>Sale Debit Note</b>, <b>Credit Note</b>, <b>Advance Sale Invoice</b>, or <b>Advance Credit Note</b>.</li>
<li><b>Employee</b> — documents for the selected employee. Respects your employee access in the Sale module.</li>
</ul>

<p><b>Advanced Filter</b> (filter icon) — additional fields:</p>

<ul>
<li><b>Customer</b></li>
<li><b>Customer Group</b></li>
<li><b>Form Type</b> — sale type on the invoice</li>
<li><b>Branch</b> *(when multiple branch is enabled)*</li>
<li><b>Zone</b> *(when zone access is enabled)*</li>
<li><b>State / Province</b></li>
<li><b>Supply Type</b> — All, Regular, Export, Deemed Export, SEZ with Tax, SEZ without Tax, GCC Export</li>
<li><b>Exclude Supply Type</b> — same options; drops those supply types from the result</li>
</ul>

<p>Tap <b>Clear</b> after applying Advanced Filter to reset advanced filters.</p>

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

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

| **Column** | **Description** |
|------------|-----------------|
| # | Row number on the current page. |
| Date | Document date. |
| Inv No. | Document number. Click to open the source document. |
| Transaction Type | Sale Invoice, Sale Debit Note, Credit Note, Advance Sale Invoice, or Advance Credit Note. |
| PayMode | Payment mode on the document. |
| InCharge | Employee on the document. |
| Branch | Branch on the document. |
| Customer | Customer name. Click to open the customer statement. |
| Tax registration | GSTIN, TIN, TRN, or VAT as configured for the company. |
| Tax Rate (%) | Combined tax rate for the row. |
| Taxable Amount | Sale amount before tax at this rate. |
| Taxable(Adj) | Adjustment sale amount before tax, when the report returns a prior-period adjustment column. |
| Tax Amount | Tax at this rate. |
| Total | Taxable plus tax for the row. |
| Invoice Total | Full document total. Repeats on every rate row for the same bill. |
| Footer Total | Sum of taxable, tax, row total, and invoice total for the page result. |

<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>Advanced Filter</b> — open additional filter fields</li>
<li><b>Clear</b> — reset active advanced filters</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (company header and date range are included)</li>
<li><b>Inv No.</b> link — open the source document</li>
</ul>

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

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

<p><b>Why does one bill appear more than once?</b><br>Each tax rate on the bill is a separate row. <b>Invoice Total</b> is the full bill and can repeat.</p>

<p><b>How is this different from Bill Item Wise Sale?</b><br><a href="#/sales/reports/bill-item-wise-sale-report">Bill Item Wise Sale</a> is one row per item with a CGST / SGST / IGST split. This report is one row per tax rate on the document.</p>

<p><b>Are cancelled invoices included?</b><br>No. Only approved and closed documents are included.</p>

<p><b>Why are some rows red?</b><br>Credit notes and advance credit notes are shown in red. Their amounts reduce the taxable and tax totals.</p>

<p><b>What does Tax Rate Type do?</b><br><b>Standard</b> is normal rated tax. <b>Zero</b> is 0% rated. <b>Exempted</b> is exempt supplies. Leave <b>Tax Rate Type - All</b> to see every rate.</p>

<p><b>Can I hide export invoices from a domestic return?</b><br>Yes. Open Advanced Filter and set <b>Exclude Supply Type</b> to Export or the SEZ / GCC option you need to drop.</p>

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

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

<ul>
<li><a href="#/sales/reports/sale-report">Sale Report</a></li>
<li><a href="#/sales/reports/bill-item-wise-sale-report">Bill Item Wise Sale</a></li>
<li><a href="#/sales/reports/sale-return-report">Sale Returns Report</a></li>
</ul>
