# Expense Claim Report

<p class="doc-lead">Expense claims grouped by category for a date range. Shows pending (approved, not yet cleared) and cleared amounts per category, with optional employee filter.</p>

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

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

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

Go to <b>Payroll → Payroll Reports → Expense Claim Report</b>.

<p><b>What it shows.</b> One row per <a href="#/payroll/expense-claim-categories">Expense Claim Category</a> with amounts split into <b>Pending</b> and <b>Cleared</b>, plus category total. Defaults to the current fiscal year date range.</p>

<p><b>When to use it.</b> Track reimbursement backlog by expense type, prepare pay-run expense sections, and audit claim volumes by category.</p>

<p><img src="payroll/images/reimbursmntexpnse.webp" alt="Expense Claim Report" loading="lazy"></p>

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

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

<ul>
<li><b>Accounts</b> — How much travel vs food expense is still pending reimbursement?</li>
<li><b>Manager</b> — Filter by employee to review one person's claims by category.</li>
<li><b>Payroll</b> — Confirm cleared vs pending before closing a pay run.</li>
</ul>

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

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

| **Filter** | **Description** |
|------------|-----------------|
| Employee | Optional — limit to one employee's claims. |
| Date range | Claim dates to include (default: current fiscal year). |

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

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

| **Column** | **Description** |
|------------|-----------------|
| ID | Expense claim category ID. |
| Expense Claim Category | Category name (e.g. Tea & Food, Fuel). |
| Pending | Sum of approved claims not yet cleared through pay run. |
| Cleared | Sum of closed claims reimbursed. |
| Total | Pending + Cleared for the category. |

<p>Footer row totals Pending, Cleared, and Total across all categories.</p>

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

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

<ul>
<li><b>Generate</b> — run the report</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
</ul>

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

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

<p><b>What is the difference between Pending and Cleared?</b><br><b>Pending</b> — approved expense claims awaiting reimbursement. <b>Cleared</b> — claims closed after payment through a pay run or otherwise.</p>

<p><b>Why is a category missing?</b><br>Only categories with claims in the date range appear. Categories with zero activity are omitted.</p>

<p><b>Can I see line-level claims?</b><br>Use <b>Payroll → Expense Claim</b> list filtered by category and employee for individual vouchers.</p>

<p><b>Which date filter applies?</b><br>Claim date on the expense claim header — not pay-run process date or payment voucher date.</p>

<p><b>Are draft claims included?</b><br>No. Only approved and closed claims appear — draft and declined claims are excluded.</p>

<p><b>Can I export this report?</b><br>Use Export and Print on the report toolbar when permitted.</p>

<p><b>Why do Pending and Cleared totals not match pay run?</b><br>Pending are approved but unpaid claims. Cleared includes claims closed on pay-run approve — timing may lag until pay run is processed.</p>

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