# Customer Wise Advance Received

<p class="doc-lead">Customer advance balances — invoiced and still-uninvoiced portions.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/accounts/reports/customer-wise-advance-received?id=overview">Overview</a>
<a href="#/accounts/reports/customer-wise-advance-received?id=filters">Filters</a>
<a href="#/accounts/reports/customer-wise-advance-received?id=columns">Columns</a>
<a href="#/accounts/reports/customer-wise-advance-received?id=actions">Actions</a>
</div>
</div>

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

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

Go to <b>Accounts → Reports → Customer Wise Advance Received</b>.

Report title in ERP: <b>Customer Wise Advance Received</b>

<p><b>What it shows.</b> Per customer: advance activity in the period and opening/closing uninvoiced balance from advance sale invoices.</p>

<p><b>When to use it.</b> Use to track customer prepayments before they are applied to sale invoices.</p>

<p><b>How amounts are calculated.</b> Opening uninvoiced balance comes from advances before the period; closing adds period activity. Totals row sums across customers.</p>

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

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

Date range only

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

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

Customer, Code, Opening Balance, Count, Taxable, Tax, Total, UnInvoiced, Closing Balance

<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 (where available)</li>
<li><b>clear</b> — reset active filters</li>
</ul>


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

<h2 id="faq">FAQ</h2>
<p><b>What advances appear?</b><br>Approved <a href="#/sales/advance-sale-invoice">Advance Sale Invoice</a> balances not yet deducted. Refunds via <a href="#/sales/advance-credit-note">Advance Credit Note</a> reduce the remaining advance.</p>
<p><b>Link to RV?</b><br>Advance may be received via RV against advance SI.</p>
<p><b>Deduction on invoice?</b><br>Sale invoice advance deduction reduces balance shown here.</p>
<p><b>Customer filter?</b><br>Run per customer or all customers.</p>
<p><b>GL account?</b><br>Advance liability account per transaction account map.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/accounts/reports/">Accounts Reports</a></li>
</ul>