# Supplier Aging

<p class="doc-lead">Supplier payables broken into aging buckets from the due date. Shows total outstanding and how much is current, 0–30, 31–60, 61–90, 91–120, and 120+ days overdue.</p>

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

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

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

Go to <b>Purchase → Reports → Supplier Aging</b>.

Report title in ERP: <b>Supplier Aging</b>

<p><b>What it shows.</b> One row per supplier with total outstanding and amounts in aging columns based on how long each payable has been overdue from its due date. Expand or drill down to view underlying invoices where supported.</p>

<p><b>When to use it.</b> Use to prioritize supplier payments, manage cash flow, and identify long-overdue liabilities.</p>

<b>Report view</b>
<img src="purchase/images/purchase-supplieraging-report.webp" alt="Supplier Aging" loading="lazy">

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

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

<ul>
<li><b>Accounts payable clerk</b> — Which suppliers have the oldest unpaid bills? Run weekly before scheduling payment vouchers.</li>
<li><b>Finance manager</b> — How much payables fall in each aging bucket as of today? Run at month-end for management reporting.</li>
<li><b>Procurement lead</b> — Are we at risk of supply disruption with key suppliers due to overdue payments? Run before supplier review meetings.</li>
<li><b>Auditor</b> — Does the aging total match supplier ledger balances? Run during accounts payable reconciliation.</li>
</ul>

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

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

<b>Date</b>, <b>Employee</b>, <b>Purchase on Invoice Date</b> or <b>on Due Date</b>. <b>Advanced Filter</b>: Supplier, Supplier Group, Branch, Center.

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

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

| **Column** | **Description** |
|------------|-----------------|
| CODE [ID] | Supplier code or system ID. |
| SUPPLIER | Supplier name. |
| PHONE | Supplier contact number. |
| TOTAL | Total outstanding payable to the supplier. |
| CURRENT | Amount not yet overdue (within current terms). |
| 0–30 | Overdue up to 30 days past due date. |
| 31–60 | Overdue 31 to 60 days. |
| 61–90 | Overdue 61 to 90 days. |
| 91–120 | Overdue 91 to 120 days. |
| 120+ | Overdue more than 120 days. |

<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>Show Invoices</b> / <b>Hide Invoices</b> — expand or collapse invoice detail under each supplier</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>What is the difference between CURRENT and 0–30?</b><br><b>CURRENT</b> is amounts not yet past the due date. <b>0–30</b> is amounts overdue by up to 30 days after the due date.</p>

<p><b>Should I age on invoice date or due date?</b><br>Use <b>on Due Date</b> for payment scheduling (recommended). Use <b>on Invoice Date</b> when analyzing liability from bill date.</p>

<p><b>How is this different from Month Wise Outstanding?</b><br>Supplier Aging buckets by days overdue. <a href="#/purchase/reports/month-wise-outstanding-report">Month Wise Outstanding</a> shows balances by calendar month.</p>

<p><b>Can I see individual unpaid invoices?</b><br>Yes. Use <b>Show Invoices</b> on the report, or open <a href="#/purchase/reports/supplier-outstanding">Supplier Outstanding Invoices</a> for a supplier-specific list.</p>

<p><b>How is this different from Trade Payables?</b><br><a href="#/purchase/reports/trade-payables">Trade Payables</a> is a payables summary with statement drill-down and optional bank details. Supplier Aging breaks balances into overdue day buckets.</p>

<p><b>Which pay modes are aged?</b><br>Credit purchase invoices and credit purchase expenses with open balances. Cash, bank, and wallet bills settled on approve are excluded.</p>

<p><b>Why is my report empty?</b><br>No open credit payables match the as-of date and supplier filters.</p>

<p><b>How are aging buckets calculated?</b><br>Days overdue are measured from the selected basis date — invoice date or due date — to the report as-of date.</p>