# Customer Outstanding By Month

<p class="doc-lead">Customer × month grid of open invoice balances — one column per calendar month in the selected year or custom range, plus a Total column.</p>

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

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

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

Go to <b>Sales → Customer Reports → Customer Outstanding By Month</b>.

Report title in ERP: <b>Customer Outstanding By Month</b>

<p><b>What it shows.</b> One row per customer with a dynamic column for each month in the selected year (or custom date range) and a <b>Total</b> column. Month headers use the month name.</p>

<p><b>When to use it.</b> See which months still have unpaid invoices, compare customers whose open balances sit in older months, and export a year grid for finance review.</p>

<p><b>How amounts are calculated.</b> Each month column is the <b>sum of invoice balance</b> for approved (still-open) invoices whose <b>invoice date</b> falls in that calendar month. Closed invoices are not included. This is not a month-end as-of snapshot — it is open balance grouped by the invoice’s calendar month. Custom range is limited to about 12 months.</p>

<img src="sales/images/customer-outstanding-by-month.webp" alt="Customer Outstanding By Month with monthly outstanding totals" loading="lazy">

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

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

<ul>
<li><b>Age by invoice month</b> — See how much open balance still sits in January vs later months.</li>
<li><b>Rep portfolio</b> — Filter by <b>Employee</b> to review open balances for one salesperson.</li>
<li><b>Collection drive</b> — Export All for a year and focus on customers with large older-month columns.</li>
<li><b>Drill to bills</b> — Tap a month cell to open that customer’s outstanding for that month.</li>
</ul>

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

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

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

<ul>
<li><b>Year</b> — calendar year, or <b>custom</b> to show a date range picker. Defaults to the current year.</li>
<li><b>Employee</b> — limits results to invoices 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>Center</b></li>
<li><b>Form Type</b> — sale type on the invoice</li>
<li><b>State / Province</b></li>
<li><b>Zone</b> *(when zone access is enabled)*</li>
<li><b>Branch</b> *(when multiple branch is enabled)*</li>
<li><b>Invoice Route</b></li>
<li><b>Customer Route</b></li>
<li><b>Brand</b> *(when brand-wise profit and loss is enabled)*</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** |
|------------|-----------------|
| SlNo | Row number (continues across pages). |
| Code | Customer party code. |
| Customer Name | Customer name. |
| Month columns | One column per month in the year or custom range — sum of open invoice balances dated in that month. |
| Total | Row total across the month columns. |
| Footer Total | Column totals for each month and grand total. |

<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 All</b> — export the full result to Excel</li>
<li><b>Print</b> — print the report</li>
</ul>

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

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

<p><b>Is this outstanding as of each month-end?</b><br>No. Each column is the current open balance of invoices dated in that month. Payments that closed an invoice remove it from the grid entirely.</p>

<p><b>Why is a paid January invoice missing?</b><br>Only approved invoices that are still open are included. Closed invoices do not appear.</p>

<p><b>How is this different from Customer Outstanding Bills?</b><br><a href="#/sales/reports/customer-outstanding">Customer Outstanding Bills</a> lists every open document for one customer. This report is a multi-customer month grid of open invoice balances.</p>

<p><b>How is this different from Month Wise Outstanding?</b><br><a href="#/sales/reports/monthwise-outstanding">Month Wise Outstanding</a> is a company-wide trend. This report is per customer.</p>

<p><b>Why am I asked to select dates within 12 months?</b><br>A custom range cannot exceed about 370 days.</p>

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

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

<ul>
<li><a href="#/sales/reports/customer-outstanding">Customer Outstanding Bills</a></li>
<li><a href="#/sales/reports/monthwise-outstanding">Month Wise Outstanding</a></li>
</ul>
