# Employee Outstanding Bills

<p class="doc-lead">Open invoices, credit notes, and linked invoice expenses for one selected employee. Use it for collection follow-up on that salesperson's open bills — not a team ranking.</p>

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

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

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

Go to <b>Sales → Employee Reports → Employee Outstanding Bills</b>.

Report title in ERP: <b>Employee Outstanding Bills</b>

<p><b>What it shows.</b> After you choose an <b>Employee</b>, the report lists that employee's open sale invoices in the date range, then (when present) invoices with a post-dated cheque (PDC) balance, open credit notes, and open invoice expenses. The list opens <b>grouped by customer</b>. Click an invoice or credit note number to preview the voucher.</p>

<p><b>When to use it.</b> Collection calls for one salesperson, credit control on their overdue bills, or a printout of their open bills.</p>

<p><b>How amounts are calculated.</b> Sale invoices must be approved and still open, dated in the selected range, and tagged to the selected employee. <b>Include pre-approved</b> also adds pre-approved credit bills (saved but not yet approved). Balance is the unpaid invoice balance. <b>C Balance</b> is a running total of those balances down the list. PDC, credit notes, and expenses are listed in their own tables and are not subtracted from the outstanding invoice total.</p>

<img src="sales/images/employee-outstanding.webp" alt="Employee Outstanding Bills with employee, customer, due age, and balance" loading="lazy">

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

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

<ul>
<li><b>Daily collection list</b> — Select the employee and this month (the default range) and work the Outstanding Invoices table by due date or invoice age.</li>
<li><b>PDC follow-up</b> — Use <b>Show Invoices with PDC Balance</b> when post-dated cheques still sit against bills.</li>
<li><b>Credit note offset</b> — Review Open Credit Notes before applying them to the same customers.</li>
<li><b>Print for the field</b> — Print the statement-style page (company header, employee name, and date range).</li>
</ul>

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

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

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

<ul>
<li><b>Date</b> — invoice / credit note / expense date range. Defaults to the current month. This is not every old unpaid bill as of today — only documents dated in the range.</li>
<li><b>Employee</b> — required. The report does not run until an employee is selected.</li>
<li><b>Include pre-approved</b> / <b>Pre-approved on</b> — when on, pre-approved credit sale invoices are included in outstanding bills.</li>
<li><b>Grouped by customer</b> / <b>Group by customer</b> — on when the report opens. Groups each section by customer. Click <b>Group by customer</b> for one flat list.</li>
<li><b>Hide bills</b> / <b>Bills hidden</b> — shown only while grouped. <b>Hide bills</b> leaves the customer summary. <b>Bills hidden</b> shows each bill again under its customer.</li>
</ul>

<p><b>Advanced Filter</b> (filter icon) — additional fields:</p>

<ul>
<li><b>Form Type</b> — sale type on the invoice</li>
<li><b>Customer</b></li>
<li><b>Center</b></li>
<li><b>Brand</b> *(when brand-wise tracking is enabled)*</li>
<li><b>Invoice Route</b></li>
<li><b>Customer Route</b></li>
</ul>

<p>Tap <b>Clear</b> after applying Advanced Filter to reset advanced filters. Employee stays selected.</p>

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

<h2 id="group-by-customer">Group by customer</h2>

The report opens with <b>Grouped by customer</b> on. Outstanding invoices, invoices with a PDC balance, open credit notes, and open invoice expenses are each grouped the same way.

<ul>
<li>Each customer is a header with the customer name, code, and bill count, plus the customer's bill amount and balance.</li>
<li>Bills for that customer are listed under the header. Click a bill number to preview it.</li>
<li><b>Hide bills</b> removes the individual bills and keeps one row per customer: bill count, oldest invoice age, latest due date, bill amount, and balance.</li>
<li>Click <b>Bills hidden</b> to show the bills again. Click <b>Group by customer</b> to turn grouping off and return to the flat list.</li>
</ul>

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

<h2 id="sections">Sections &amp; columns</h2>

<h3 id="outstanding-invoices">Outstanding Invoices</h3>

| **Column** | **Description** |
|------------|-----------------|
| Date | Invoice date. |
| Invoice# | Sale invoice number. |
| Customer | Customer name. |
| Order# | Linked sale order, when present. |
| Invoice Age | Days from invoice date to today. |
| Due Date | Due date on the bill, or invoice date plus payment-term days. |
| Due Age | Days past due. Shown when any row has a due date. |
| Payment Term | Payment term name. |
| Bill Amount | Invoice total. |
| Balance | Unpaid balance. |
| C Balance | Running total of Balance from the first row down. |

<p>The footer <b>Total</b> sums Bill Amount and Balance.</p>

<h3 id="pdc">Invoices with PDC Balance</h3>

<p>Shown when any of this employee's invoices in the range have a PDC balance. Use <b>Show Invoices with PDC Balance</b> / <b>Hide</b>. Columns match outstanding invoices, plus <b>PDC Balance</b> instead of C Balance. Approved and closed invoices with PDC can appear here.</p>

<h3 id="credit-notes">Open Credit Notes</h3>

<p>Approved credit notes for the same employee and date range that still have a balance. Columns: Date, Credit Note#, Customer, Invoice Age, Due Date, Due Age (when due dates exist), Payment Term, Bill Amount, Balance.</p>

<h3 id="expenses">Open Invoice Expenses</h3>

<p>Approved credit expenses linked to a sale invoice for this employee. Columns: Date, Expense#, Customer, Invoice#, Amount.</p>

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

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report (employee is required)</li>
<li><b>Include pre-approved</b> — toggle pre-approved credit invoices</li>
<li><b>Grouped by customer</b> / <b>Group by customer</b> — group or flatten the lists</li>
<li><b>Hide bills</b> / <b>Bills hidden</b> — hide or show individual bills while grouped</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>Clear</b> — reset active advanced filters</li>
<li><b>Show Invoices with PDC Balance</b> / <b>Hide</b> — show or hide the PDC table</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the employee statement</li>
</ul>

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

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

<p><b>Why does it say Choose employee to continue?</b><br>This report is for one employee at a time. Select <b>Employee</b> in the header, then Generate.</p>

<p><b>How is this different from Employee Wise Sale Report?</b><br>Sale Report (and Employee Wise Sale) is invoiced revenue. This report is open balances on that employee's documents — use it for follow-up, not revenue.</p>

<p><b>How is this different from Trade Receivables or Customer Outstanding?</b><br>Those are customer-level. This list is scoped to the employee on the invoice or credit note.</p>

<p><b>Does the date range mean as-of outstanding?</b><br>No. Only invoices, credit notes, and expenses <b>dated</b> in the range are listed. Older open bills outside the range do not appear. Widen the dates if you need a longer book.</p>

<p><b>What is Include pre-approved?</b><br>When on, pre-approved credit sale invoices for the employee are included. They are highlighted in the invoice list.</p>

<p><b>How do I see one row per customer?</b><br>Leave <b>Grouped by customer</b> on and click <b>Hide bills</b>. Each customer shows bill count, oldest invoice age, latest due date, bill amount, and balance.</p>

<p><b>Does PDC reduce the outstanding total?</b><br>No. PDC is a separate table. Outstanding Invoice Balance is still the unpaid invoice balance.</p>

<p><b>Why don't I see some employees in the picker?</b><br>Your employee access in the Sale module may restrict which employees you can select.</p>

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

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

<ul>
<li><a href="#/sales/reports/trade-receivables">Trade Receivables</a></li>
<li><a href="#/sales/reports/customer-outstanding">Customer Outstanding Bills</a></li>
<li><a href="#/sales/reports/employee-sale-report">Employee Wise Sale Report</a></li>
<li><a href="#/sales/reports/collection-commision">Collection Commission</a></li>
</ul>
