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 | PrintReport 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.
