# Customer Opening Balance Report

<p class="doc-lead">Lists customer opening balance entries — initial receivable or payable balances recorded when onboarding customers.</p>

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

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

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

Go to <b>Sales → Customer Reports → Customer Opening Balance Report</b>.

Report title in ERP: <b>Customer Opening Balance Report</b>

<p><b>What it shows.</b> Each customer opening balance entry with date, amount, balance type (Debit/Credit), reference, and remaining unsettled amount.</p>

<p><b>When to use it.</b> Use to audit opening balances imported during migration, verify unsettled opening entries, and reconcile customer ledgers.</p>

<p><b>How amounts are calculated.</b> Lists opening balance records from Sales → Sale Settings → Opening Balance within the selected filters.</p>

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

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

<ul>
<li><b>Migration audit</b> — Verify opening balances imported when moving from another system.</li>
<li><b>Ledger reconciliation</b> — Identify opening entries not yet cleared by payments or invoices.</li>
<li><b>Year-end review</b> — Confirm all opening balances are properly reflected in customer statements.</li>
<li><b>New customer onboarding</b> — Track opening balances set for customers joining mid-period.</li>
</ul>

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

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

<b>Date</b>, <b>Customer</b>, <b>Status</b> (Settled / Unsettled), <b>Employee</b>. <b>Advanced Filter</b>: Customer Group, Branch, Balance Type.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Date | Opening balance entry date. |
| Customer | Customer name. |
| Customer Code | Unique identifier assigned in the master record. |
| Reference No. | Opening balance reference number. |
| Balance Type | Debit (customer owes) or Credit (company owes customer). |
| Amount | Opening balance amount. |
| Settled Amount | Portion cleared by subsequent transactions. |
| Unsettled Amount | Remaining opening balance not yet cleared. |
| Remarks | Notes on the opening entry. |

<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>Reference No.</b> link — open the opening balance entry</li>
</ul>

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

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

<p><b>Where are opening balances created?</b><br>Under <b>Sales → Sale Settings → Opening Balance</b>.</p>
<p><b>How is unsettled amount calculated?</b><br>Opening amount minus payments, invoices, or adjustments applied against the entry.</p>
<p><b>Do opening balances appear on customer statements?</b><br>Yes. They appear as the first entries on the customer ledger and statement.</p>
<p><b>Can I edit an opening balance from this report?</b><br>Navigate to the opening balance entry via the reference link to edit if permitted.</p>
<p><b>Does this include opening balance sale invoices?</b><br>It lists opening balance entries from <a href="#/sales/sale-opening-balance">Customer Opening Balance</a> setup, not regular sales.</p>

<p><b>How does this affect ageing?</b><br>Reference bill dates on opening entries feed <a href="#/sales/reports/customer-aging">Customer Aging</a> for migrated debt.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/sales/sale-opening-balance">Opening Balance</a></li>
<li><a href="#/sales/reports/customer-statement">Customer Statement</a></li>
</ul>