# Month Wise Collection

<p class="doc-lead">Monthly summary of customer collections split into cash sales, receipt vouchers, cheques, cash discounts, and other income — for collection trend analysis and management reporting.</p>

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

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

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

Go to <b>Sales → Reports → Month Wise Collection</b>.

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

<p><b>What it shows.</b> One row per month with the collection breakdown — cash sales, receipt voucher collections, cheque collections, cash discounts (shown as a deduction), other income, and the monthly <b>Total</b> collection.</p>

<p><b>When to use it.</b> Use to compare month-over-month collection performance across a year, review collection mix by payment source, and support management and cash-flow reporting.</p>

<p><i>Screenshot pending — Month Wise Collection report view.</i></p>

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

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

<ul>
<li><b>Finance manager</b> — How did total collections vary month over month this year? Run at quarter-end for MIS and cash-flow review.</li>
<li><b>Accounts team</b> — What share of monthly collection came from cash sales vs receipt vouchers vs cheques? Run for collection-mix analysis.</li>
<li><b>Sales manager</b> — How much did a specific salesperson collect each month? Run with the <b>Employee</b> filter for performance review.</li>
<li><b>Management</b> — Which months had high cash discounts or other income? Run at month-end before planning.</li>
</ul>

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

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

<b>Year</b> (or <b>custom</b> date range), <b>PayMode</b>, <b>Employee</b>. <b>Advanced Filter</b>: Customer Group, FormType, Branch, Route.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Month | Calendar month of the collection. |
| Cash Sale | Amount collected as direct cash/bank/wallet sales. |
| Receipt Voucher | Amount received through receipt vouchers applied to sale invoices. |
| Cheque | Cleared cheque collection amount. |
| Cash Discount(-) | Discounts and adjustments applied on collections (deducted from the total). |
| Other Income | Customer receipts recorded as custom receipt vouchers, not tied to a specific sale invoice. |
| Total | Total collection for the month, including other income. |

<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>How is the monthly Total calculated?</b><br>It is <b>Cash Sale + Receipt Voucher + Cheque − Cash Discount + Other Income</b> for the month. This equals the <b>Grand Total</b> of the <a href="#/sales/reports/collection-report">Collection Report</a> for the same period.</p>

<p><b>What is "Other Income"?</b><br>Customer receipts entered as custom receipt vouchers (not allocated to a specific sale invoice) — for example, on-account or advance payments. In the <a href="#/sales/reports/collection-report">Collection Report</a> these appear under <b>Other Receipt Vouchers</b>.</p>

<p><b>Why doesn't Cash Sale match the Collection Report?</b><br>Check the filters. This report auto-selects the logged-in user's <b>Employee</b> by default, so it may show only that employee's collections. Clear the Employee filter (or apply the same employee on both reports) to reconcile.</p>

<p><b>Which date drives the month bucket?</b><br>Each collection is placed in the month of its transaction date — sale invoice date for cash sales, receipt voucher date for receipts, and cleared date for cheques.</p>

<p><b>How is this different from Collection Report?</b><br><a href="#/sales/reports/collection-report">Collection Report</a> lists every collection transaction for a date range. Month Wise Collection summarises those same collections into one row per month.</p>
