# Collection Report

<p class="doc-lead">Daily collection summary showing cash sales, receipt voucher collections, and cheque receipts. Use it to reconcile cash in hand and track collections by employee and date.</p>

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

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

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

Go to <b>Sales → Reports → Collection Report</b>.

Report title in ERP: <b>Collection Report</b>

<p><b>What it shows.</b> Total collections for a period, including cash sales, amounts received through receipt vouchers, and cheque collections. Breakdown by employee and payment source. Sale invoices with payment mode <b>Split</b> appear as one cash-sale row per Cash Split account.</p>

<p><b>When to use it.</b> Use for daily cash reconciliation, end-of-day collection review, and verifying that receipt vouchers match physical collections.</p>

<b>Report view</b>
<img src="sales/images/sale-collection-report.webp" alt="Sale Collection Report" loading="lazy">

<b>Filtration — Employee</b>
<img src="sales/images/sale-collection-report1.webp" alt="Sale Collection Report1" loading="lazy">

<b>Filtration — Date range</b>
<img src="sales/images/sale-collection-report2.webp" alt="Sale Collection Report2" loading="lazy">

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

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

<ul>
<li><b>Cashier</b> — Does today's total collection match cash sales and receipt vouchers? Run at end of day for cash drawer reconciliation.</li>
<li><b>Accounts team</b> — How much was collected from customers through receipt vouchers this week? Run after posting receipt vouchers.</li>
<li><b>Sales manager</b> — Which salesperson collected the most in a period? Run with the <b>Employee</b> filter for performance review.</li>
<li><b>Finance manager</b> — What is the total cash inflow from sales and collections for the month? Run at month-end for cash-flow reporting.</li>
<li><b>Collections team</b> — How much was collected from a specific customer or customers in a state? Run with the <b>Customer</b> or <b>State / Province</b> advanced filter.</li>
</ul>

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

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

<b>Date</b>, <b>Employee</b>, <b>PayMode</b> (All, Cash, Bank, Digital Wallet), <b>Time Offset</b>. <b>Advanced Filter</b>: Customer, Customer Group, FormType, Branch, Route, State / Province.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Date | Collection or sale date. |
| Employee | Employee who handled the sale or collection. |
| Customer | Customer from whom payment was received. |
| Bill No | Related sale invoice number. |
| Receipt Voucher | Receipt voucher number for the collection. |
| Cash Sales | Amount collected as direct cash sale. |
| Receipt Collection | Amount received through receipt vouchers. |
| Cheque | Cheque collection amount. |
| Total Collection | Total amount collected for the row or period. |

<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> — 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 advanced filters</li>
</ul>

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

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

<p><b>Does this include credit sales?</b><br>No. The Collection Report covers cash sales, receipt voucher collections, and cheques — not unpaid credit balances.</p>

<p><b>How do Split invoices appear?</b><br>Each Cash Split line becomes its own cash-sale row, attributed to that cash or bank account. Cash / Bank / Digital Wallet PayMode filters include the matching split portions. See <a href="#/sales/sale-invoice?id=split-payment">Sale Invoice — Split payment mode</a>.</p>

<p><b>How is this different from Bill Wise Sale?</b><br><a href="#/sales/reports/sale-report">Bill Wise Sale</a> lists all invoices with payment mode splits. Collection Report focuses on actual cash and receipt collections received.</p>

<p><b>Can I reconcile with receipt vouchers?</b><br>Yes. Match the <b>Receipt Voucher</b> column against posted receipt vouchers in Accounts for the same date range.</p>

<p><b>Are PDC cheques included?</b><br>Cheque collections appear when recorded. Post-dated cheques may be tracked separately in receivables reports.</p>
<p><b>What receipts are included?</b><br>Receipt vouchers and payment collections allocated to sale invoices in the selected date range.</p>

<p><b>Can I filter by customer or state?</b><br>Yes. Open <b>Advanced Filter</b> and select <b>Customer</b> and/or <b>State / Province</b>. State filters use the invoice billing address for sales and receipt voucher collections, and the customer address for other income and cheques.</p>

<p><b>How is this different from Customer Statement?</b><br>Collection Report is receipt-focused for the period. <a href="#/sales/reports/customer-statement">Customer Statement</a> shows full ledger including invoices and adjustments.</p>