# Cash Account Wise Sale

<p class="doc-lead">Groups sale collections by cash or bank account — shows invoice totals received through each payment account for cash flow tracking.</p>

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

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

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

Go to <b>Sales → Reports → Cash Account Wise Sale</b>.

Report title in ERP: <b>Cash Account Wise Sale</b>

<p><b>What it shows.</b> Sale invoice totals grouped by the cash or bank account used for payment, with invoice count, collection amount, and account reference.</p>

<p><b>When to use it.</b> Use to reconcile daily collections, verify bank deposits, and track sales routed through specific cash or bank accounts.</p>

<p><b>How amounts are calculated.</b> Includes approved sale invoices with cash or bank payment modes linked to an account within the selected date range. Invoices with payment mode <b>Split</b> add each Cash Split amount to that line's cash or bank account (not a single header account).</p>

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

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

<ul>
<li><b>Daily cash reconciliation</b> — Match physical cash and bank deposits against account-wise collections.</li>
<li><b>Multi-account review</b> — Compare collection volumes across branch cash drawers or bank accounts.</li>
<li><b>Audit trail</b> — Export account-wise sales for accounting verification.</li>
<li><b>Payment mode analysis</b> — Cross-check cash vs bank collections alongside the Collection Report.</li>
</ul>

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

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

<b>Date</b>, <b>Cash Account</b>, <b>Employee</b>, <b>Center / Branch</b>. <b>Advanced Filter</b>: Payment Mode, Customer, Form Type.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Cash Account | Cash or bank account name. |
| Account Code | Chart of accounts code for the cash or bank account. |
| Center | Branch or center linked to the account. |
| Invoice Count | Number of invoices collected through this account. |
| Collection Amount | Total amount collected via this account. |
| Cash Amount | Portion collected in cash. |
| Bank Amount | Portion collected via bank transfer or card. |
| Credit Amount | Credit sales not yet collected. |

<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>Does this include receipt vouchers?</b><br>It focuses on sale invoice collections. Use <a href="#/sales/reports/collection-report">Collection Report</a> for receipt voucher collections.</p>
<p><b>Can I filter one account?</b><br>Yes. Select the account in the <b>Cash Account</b> filter.</p>
<p><b>Why is credit amount shown?</b><br>Credit sales appear for reference but are not collected through cash accounts until paid.</p>
<p><b>How does this relate to Collection Report?</b><br>Collection Report covers all collection types. This report groups sales specifically by cash/bank account.</p>
<p><b>Why is a credit sale missing?</b><br>This report groups cash and bank receipts on invoices. Filter <a href="#/sales/reports/sale-report">Sale Report</a> by PayMode Credit for open credit sales.</p>

<p><b>Are PDC cheques in cash account columns?</b><br>Depends on how receipts were posted. Verify receipt voucher pay mode if columns look unexpected.</p>

<p><b>How are Split invoices counted?</b><br>Each Cash Split amount is added to that account's Collection Amount. Filter by Cash or Bank to see the matching portions — there is no Split option in Payment Mode. See <a href="#/sales/sale-invoice?id=split-payment">Sale Invoice — Split payment mode</a>.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/sales/reports/collection-report">Collection Report</a></li>
<li><a href="#/sales/reports/sale-report">Sale Report</a></li>
</ul>