# Brand Wise Aging

<p class="doc-lead">Outstanding receivables aged by brand — shows how much is owed per brand across aging buckets for brand-level credit exposure analysis.</p>

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

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

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

Go to <b>Sales → Reports → Brand Wise Aging</b>.

Report title in ERP: <b>Brand Wise Aging</b>

<p><b>What it shows.</b> Each brand with outstanding invoice balances split across aging periods (Current, 0–30, 31–60, 61–90, 91–120, >120 days).</p>

<p><b>When to use it.</b> Use to monitor credit exposure by product brand and prioritize collection efforts on high-aging brand portfolios.</p>

<p><b>How amounts are calculated.</b> Outstanding balances from unpaid sale invoices are allocated to brands based on invoice line brand values, then aged by invoice or due date.</p>

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

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

<ul>
<li><b>Brand portfolio review</b> — Identify brands with the oldest outstanding receivables.</li>
<li><b>Collection prioritization</b> — Focus follow-up on customers with high aging in premium brands.</li>
<li><b>Credit policy</b> — Assess whether certain brands need stricter credit terms.</li>
<li><b>Management reporting</b> — Present brand-wise aging in monthly sales review meetings.</li>
</ul>

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

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

<b>Date</b>, <b>Brand</b>, <b>Employee</b>, <b>Age On</b> (Invoice Date / Due Date). <b>Advanced Filter</b>: Customer, Customer Group, Branch.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Brand | Brand name. |
| Current | Amount not yet due. |
| 0-30 | Amount 0–30 days past due. |
| 31-60 | Amount 31–60 days past due. |
| 61-90 | Amount 61–90 days past due. |
| 91-120 | Amount 91–120 days past due. |
| >120 | Amount more than 120 days past due. |
| Total Outstanding | Total unpaid balance for the brand. |

<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>
<li><b>Show Invoices / Hide Invoices</b> — expand or collapse invoice detail per brand</li>
</ul>

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

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

<p><b>How is aging calculated?</b><br>Based on invoice date or due date per the <b>Age On</b> filter, same as Customer Aging.</p>
<p><b>Can I see customer detail?</b><br>Use <b>Show Invoices</b> to expand invoice-level detail, or run <a href="#/sales/reports/customer-aging">Customer Aging</a>.</p>
<p><b>Does this include PDC?</b><br>Post-dated cheques may appear in outstanding depending on configuration. Check Customer Outstanding for PDC detail.</p>
<p><b>Why does a brand show zero outstanding?</b><br>All invoices for that brand in the period may be fully paid.</p>
<p><b>Can I filter by brand and customer together?</b><br>Yes. Combine brand and customer filters to review ageing for a specific product line with one buyer.</p>

<p><b>How is this different from Customer Aging?</b><br><a href="#/sales/reports/customer-aging">Customer Aging</a> ages total customer balance. Brand Wise Aging splits receivables by brand on the invoice.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/sales/reports/customer-aging">Customer Aging</a></li>
<li><a href="#/sales/reports/brand-wise-outstanding">Brand Wise Outstanding</a></li>
</ul>