> ## Documentation Index
> Fetch the complete documentation index at: https://help.kwentra.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Monthly Profit and Loss Report

> Run the Monthly Profit and Loss report to review each GL account's balance month by month across the year, grouped by account family, with the option to hide zero-balance rows.

The Monthly Profit and Loss report shows each GL account's balance per month across the year, grouped by account family.

### **Business Value**

* Review profit and loss for every month of the year in one view.
* Compare account balances across months to spot trends.
* Group accounts by family for a structured P\&L breakdown.
* Print report parameters with the output for full traceability.

### **Use Cases**

* Finance manager reviews monthly expense trends across the year before budgeting.
* Accountant compares each month's account balances during period-end close.
* Controller exports the report to attach to the monthly financial package.

### **How It Works**

| **Where:** Reports → Back Office → Monthly Profit and Loss |
| ---------------------------------------------------------- |

#### **Running the Report**

**Date:** Select the reporting date. The report shows one column per month from January through the month of the selected date.

**File Type:** Choose the export format — XLS, XLSX, ODS, or PDF.

Available actions: Download  |  Preview  |  Print

#### **Report Layout**

* Accounts are organized into sections (e.g., *Expenses*) and grouped under an **account-family header** (e.g., *1030 Rooms Payroll Expense*).
* Each group lists its individual GL accounts (code and description), with a subtotal row for the group.
* One amount column appears per month of the year up to the selected date, followed by a **Total** column.

#### **Report Columns**

| **Column**                                 | **Description**                                                         | **Example**               |
| ------------------------------------------ | ----------------------------------------------------------------------- | ------------------------- |
| Account                                    | GL account code and description, listed under its account-family group. | 10300001 Salaries & Wages |
| Monthly columns (01-2026 … selected month) | Net amount posted to the account in each month.                         | -267,559.29               |
| Total                                      | Sum of all displayed months for the account or group.                   | -3,277,674.07             |

| Note: Report parameters are included in the printed output. |
| ----------------------------------------------------------- |

## ***Update: June 14, 2026***

### **Zero Balance Filter**

The report now lets you hide rows where every amount column is zero, keeping the output focused on active accounts.

### **What's New?**

A new **Zero Balance** parameter is added. Set it to **Don't Show** (default) to exclude any account whose amounts are all zero, or **Show** to include every GL account regardless of activity.

### **How It Works**

* **Don't Show** (default) — hides any row where all month columns and the Total are zero.
* **Show** — displays all GL accounts, including those with no activity in the period.

<img src="https://mintcdn.com/kwentra/LsHmck1MENv3XUbr/images/back-office/bo-reports/monthly-profit-and-loss-report/zero-balance-filter.png?fit=max&auto=format&n=LsHmck1MENv3XUbr&q=85&s=d267989a78f784be24024851796ac84b" alt="Monthly Profit and Loss report parameters showing the new Zero Balance filter" width="1498" height="333" data-path="images/back-office/bo-reports/monthly-profit-and-loss-report/zero-balance-filter.png" />