# Trade Payables

<p class="doc-lead">Supplier payables summary with invoice age, due age, invoice balance, closing balance, and PDC. Click a supplier to open their statement for payment follow-up. Optionally show supplier bank account details for payment processing.</p>

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

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

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

Go to <b>Purchase → Reports → Trade Payables</b>.

Report title in ERP: <b>Trade Payables</b>

<p><b>What it shows.</b> One row per supplier with payable details — invoice age, due age, invoice balance, closing balance, and post-dated cheque (PDC) amounts. Optionally expand to show individual open documents (purchase invoices, expenses, purchase expenses, and prepaid expenses). Click a supplier name to open the supplier statement.</p>

<p><b>When to use it.</b> Use for daily payment planning, accounts payable control, and verifying total outstanding before releasing supplier payments.</p>

<p>The report also appears on the <b>Purchase Dashboard</b> and <b>Accounts Dashboard</b> as the Trade Payables widget.</p>

<img src="purchase/images/trade-payables.webp" alt="Trade Payables report with supplier, invoice age, due age, invoice balance, and closing balance" loading="lazy">

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

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

<ul>
<li><b>Accounts payable</b> — Which suppliers have the highest closing balance and oldest due invoices? Run daily or weekly before payment runs.</li>
<li><b>Finance</b> — How much is outstanding per supplier including PDC cheques? Run before approving bulk payments or month-end close.</li>
<li><b>Procurement</b> — What payables are linked to each employee's suppliers? Run with the <b>Employee</b> filter for purchase follow-up.</li>
<li><b>Finance manager</b> — What is the total trade payables position as of a prior date? Run with <b>On Previous Date</b> for month-end reporting.</li>
<li><b>Payment processing</b> — Export with <b>Show Bank Details</b> to prepare NEFT/RTGS payment files using supplier account numbers and IFSC.</li>
<li><b>Reconciliation</b> — Does invoice-level balance match the supplier ledger? An asterisk (*) on <b>Invoice Balance</b> means closing balance differs from summed open documents.</li>
</ul>

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

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

| **Filter** | **Description** |
|------------|-----------------|
| Employee | Optional employee filter. Respects purchase-module employee access filters. |
| On Previous Date / Today | Toggle between today's balances and a historical as-on date. |
| Sort | Highest Closing Balance, Lowest Closing Balance, Supplier Name, Supplier Code. |
| Advanced Filter | Supplier Group, Form Type (purchase type), Branch, Center, Supplier. |
| Show Invoices | Expand document-level detail under each supplier. |

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

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

| **Column** | **Description** |
|------------|-----------------|
| CODE | Supplier code or system ID. |
| SUPPLIER | Supplier name and address. Click to open supplier statement. |
| Bank Account / IFSC | From supplier bank account master (when <b>Show Bank Details</b> is on). Uses the primary bank account if set; otherwise the first account. |
| PHONE | Supplier contact number. |
| Group | Supplier group. |
| Type | Document type when <b>Show Invoices</b> is on (purchase invoice, expense, purchase expense, prepaid expense). |
| Inv Date | Document date when expanded. |
| Bill # | Document number when expanded. |
| Total | Document total when expanded. |
| Balance | Open balance on the document when expanded. |
| InvAge | Days since the oldest open document date (summary) or per document when expanded. |
| DueAge | Days since the oldest due date (summary) or per document when expanded. |
| Invoice Balance | Sum of open document balances for the supplier. Asterisk (*) when different from closing balance. |
| Closing Balance | Total payable balance on the supplier account. |
| PDC | Post-dated issued cheque amount held against the supplier. |

<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 document-level detail under each supplier</li>
<li><b>Sort</b> — order by closing balance, supplier name, or supplier code</li>
<li><b>Advanced Filter</b> — open additional filter fields; <b>clear</b> resets active filters</li>
<li><b>More</b> (caret menu) — <b>On Previous Date</b> / <b>Today</b>; <b>Show Bank Details</b> / <b>Hide Bank Details</b></li>
</ul>

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

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

<p><b>How do I open a supplier statement?</b><br>Click the supplier name on any row to open the full supplier statement.</p>

<p><b>Can I see individual unpaid invoices?</b><br>Yes. Use <b>Show Invoices</b> on the report to expand document detail under each supplier (purchase invoices, expenses, purchase expenses, and prepaid expenses).</p>

<p><b>What documents are included in Invoice Balance?</b><br>Open credit purchase invoices plus supplier-linked expenses, purchase expenses, and prepaid expenses (when no purchase-type or center filter is applied). This aligns with how supplier payables are tracked across modules.</p>

<p><b>Where do bank details come from?</b><br>From the supplier's bank accounts on the <a href="#/purchase/suppliers">Supplier</a> master. The report uses the account marked <b>Primary</b>; if none is primary, it uses the first bank account.</p>

<p><b>Why are bank columns empty for some suppliers?</b><br>Bank account and IFSC are not maintained on the supplier record. Add bank details on the supplier master and regenerate the report.</p>

<p><b>Why does Invoice Balance differ from Closing Balance?</b><br>The asterisk (*) marks suppliers where ledger closing balance does not match the summed open documents — for example unallocated payments, journal entries, opening balance, or documents outside the report filters. Use <a href="#/purchase/reports/supplier-statement">Supplier Statement</a> to investigate.</p>

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

<p><b>How is this different from Supplier Outstanding Invoices?</b><br><a href="#/purchase/reports/supplier-outstanding">Supplier Outstanding Invoices</a> lists open purchase invoices, open debit notes, and open expenses for one supplier. Debit notes are in their own section and are not included in the invoice total. Trade Payables summarises payables across suppliers and shows PDC.</p>

<p><b>Are PDC amounts included?</b><br>Yes. The <b>PDC</b> column shows issued cheques in post-dated status linked to payment vouchers for the supplier. Invoice balance also includes purchase invoices in PDC status with pending PDC balance.</p>

<p><b>Can I run the report as of a past date?</b><br>Yes. Open the caret menu and choose <b>On Previous Date</b>, pick the date, then <b>Generate</b>.</p>

<p><b>Can I run this from the dashboard?</b><br>Yes. The <b>Trade Payables</b> widget on the Purchase Dashboard and Accounts Dashboard links directly to this report.</p>

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