# Month Wise Expense

<p class="doc-lead">Expense bill totals by expense account, with one column per month.</p>

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

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

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

Go to <b>Accounts → Reports → Month Wise Expense</b>.

Report title in ERP: <b>Month Wise Expense</b>

<p><b>What it shows.</b> Approved and closed expense bills, with expense accounts down the rows and one column per month in the selected range. Each row has the account group and a total. A grand total sums every month.</p>

<p><b>When to use it.</b> Use to see how each expense account moved month by month, then open the bills behind a figure.</p>

<p><b>How amounts are calculated.</b> Only expense bills with status Approved or Closed are included. The date range cannot be longer than 12 months.</p>

<ul>
<li><b>Amount</b> is the bill total, the same Amount column as <a href="#/accounts/reports/expense-report">Expense Report</a>.</li>
<li><b>Taxable</b> is the bill amount minus tax on every bill. A bill with no tax counts at its full amount.</li>
<li><b>Both</b> shows Taxable and Amount under each month.</li>
</ul>

<p>Click an account name or its row total to open <a href="#/accounts/reports/bill-wise-expense">Bill Wise Expense</a> for that account across the full range. Click a month amount to open the bills for that month only. Branch, supplier, employee, and payment mode filters stay applied.</p>

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

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

Date range. <b>Amount</b>, <b>Taxable</b>, or <b>Both</b>. Advanced Filter: Expense Account (leaf accounts), Branch, Supplier, Employee, Payment mode (Credit, Cash, Bank, Prepaid, Digital Wallet).

A branch data filter on the user still limits the report to that branch.

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

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

Expense Account, Group, one column per month (or Taxable and Amount under each month when <b>Both</b> is selected), Total.

<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 the current view 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 advanced filters</li>
</ul>

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

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

<ul>
<li><a href="#/accounts/reports/expense-report">Expense Report</a></li>
<li><a href="#/accounts/reports/bill-wise-expense">Bill Wise Expense</a></li>
<li><a href="#/accounts/reports/">Accounts Reports</a></li>
</ul>
