# Trial Balance Advanced

<p class="doc-lead">Expanded trial balance with account code, separate opening and closing debit/credit columns, period movement, and group drill-down.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/accounts/reports/trial-balance-advanced?id=overview">Overview</a>
<a href="#/accounts/reports/trial-balance-advanced?id=filters">Filters</a>
<a href="#/accounts/reports/trial-balance-advanced?id=columns">Columns</a>
<a href="#/accounts/reports/trial-balance-advanced?id=actions">Actions</a>
<a href="#/accounts/reports/trial-balance-advanced?id=faq">FAQ</a>
</div>
</div>

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

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

Go to <b>Accounts → Reports → Trial Balance</b> and click <b>Advanced View</b>.

Report title in ERP: <b>Trial Balance</b>

<p><b>What it shows.</b> One row per account (and group) for the selected date range, with opening balance, period debit and credit movement, and closing balance — each split into separate debit and credit columns. A <b>Total</b> row at the bottom confirms the books balance.</p>

<p><b>When to use it.</b> Use when you need opening and closing positions and period movement side by side — for period-close review, audit support, or reconciling movement over a date range. The standard <a href="#/accounts/reports/trial-balance">Trial Balance</a> shows a single date with Debit and Credit only.</p>

<p><b>How amounts are calculated.</b> Each account's natural balance side (debit or credit) determines whether its opening and closing values appear in the Dr or Cr column. Debit and Credit columns show the total movement within the selected range. If a difference is detected, a warning line appears above the table.</p>

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

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

<b>Date range</b> — select the period to report on. Click <b>Generate</b> to run.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Account Id | System account identifier. |
| Account Code | Account code from the chart of accounts. |
| Account Name | Account or group name. Click a group to open <a href="#/accounts/reports/group-summary">Group Summary</a>; click a leaf account to open <a href="#/accounts/reports/account-transactions">Account Transactions</a> for the range. |
| Opening (Dr) | Opening balance on the debit side. |
| Opening (Cr) | Opening balance on the credit side. |
| Debit | Total debit movement within the range. |
| Credit | Total credit movement within the range. |
| Closing (Dr) | Closing balance on the debit side. |
| Closing (Cr) | Closing balance on the credit side. |

A <b>Total</b> row at the bottom sums each column; total debits should equal total credits.

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

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

<ul>
<li><b>Generate</b> — run the report for the selected date range</li>
<li><b>Basic View</b> — switch to the standard <a href="#/accounts/reports/trial-balance">Trial Balance</a> (single date, Debit/Credit only)</li>
<li><b>Hide Zero Balance</b> / <b>Show Zero Balance</b> — toggle rows that have no opening, movement, or closing balance</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>How is this different from the standard Trial Balance?</b><br>Advanced View adds Account Code, separate Opening (Dr/Cr) and Closing (Dr/Cr) columns, and period Debit/Credit movement across a date range. The standard <a href="#/accounts/reports/trial-balance">Trial Balance</a> reports a single date with Debit and Credit columns only.</p>

<p><b>How do I go back to the simple layout?</b><br>Click <b>Basic View</b> in the toolbar.</p>

<p><b>How do I hide accounts with no balance?</b><br>Click <b>Hide Zero Balance</b> to remove rows with no opening, movement, or closing balance; click <b>Show Zero Balance</b> to bring them back.</p>

<p><b>Why does the report show a difference?</b><br>A red warning line appears when debits and credits do not match — usually unposted drafts, a wrong date range, or incomplete opening balances. Re-run after the period is closed.</p>

<p><b>Can I drill into an account?</b><br>Yes. Click a group name to open <a href="#/accounts/reports/group-summary">Group Summary</a>, or a leaf account to open <a href="#/accounts/reports/account-transactions">Account Transactions</a> for the selected range.</p>

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

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

<ul>
<li><a href="#/accounts/reports/trial-balance">Trial Balance</a></li>
<li><a href="#/accounts/reports/group-summary">Group Summary</a></li>
<li><a href="#/accounts/reports/account-transactions">Account Transactions</a></li>
<li><a href="#/accounts/reports/">Accounts Reports</a></li>
</ul>
