# Journal Report

<p class="doc-lead">Complete journal register — every debit and credit line in a period.</p>

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

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

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

Go to <b>Accounts → Reports → Journal Report</b>.

Report title in ERP: <b>Journal Report</b>

<p><b>What it shows.</b> Flat list of journal lines with date, account, transaction source, reference and bill numbers, note, debit, and credit. Footer shows total debits and credits for the result set.</p>

<p><b>When to use it.</b> Use for audit trails and to find specific postings. Filter by category to see only automatic transaction journals, only manual journals, or everything.</p>

<p><b>How amounts are calculated.</b> Transaction category Direct Transactions limits to source documents (invoices, vouchers, expenses, etc.) and journals with no linked document. Journal Only Transactions shows manual journals only. Advanced filters can narrow by transaction type, reference number, or bill number. Paginated at 1000 lines per page.</p>

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

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

Date range, Transaction category (All Transactions, Direct Transactions, Journal Only Transactions). Advanced Filter: Transaction Type (payment/receipt vouchers, expenses, transfers, invoices, notes, opening entries, inventory, pay run, and more), Ref no, Bill No.

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

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

Date, Account, Transaction, RefNo, BillNo, Note, Debit, Credit

<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>Advanced Filter</b> — open additional filter fields (where available)</li>
<li><b>clear</b> — reset active advanced filters</li>
</ul>


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

<h2 id="faq">FAQ</h2>
<p><b>Manual vs system journals?</b><br>Filter by transaction type — system journals link to SI, PI, RV, PV, etc.</p>
<p><b>Can I find RV journal?</b><br>Filter transaction type Receipt Voucher or search by reference.</p>
<p><b>Why journal not editable?</b><br>System-linked journals must be changed at source voucher.</p>
<p><b>Does cancel show on report?</b><br>Cancelled journals may filter out — check status filter.</p>
<p><b>Export for audit?</b><br>Yes — Excel export with date and type filters.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/accounts/reports/">Accounts Reports</a></li>
</ul>