Skip to content
English
  • There are no suggestions because the search field is empty.

Month & Year To Date Profit & Loss Report 

This guide explains how to generate a Month & Year‑to‑Date Profit & Loss Report

This report helps agencies track revenue, expenses, and profitability trends over time and supports multi-currency reporting and custom financial statement formats.

Step by Step Guide: 

1. Go to ACCOUNTING > General Ledger > General Ledger Statements and Reports.

2. Expand Profit and Loss Statements

Click on the Month & Year-To-Date Profit & Loss Report hyperlink.

3. Apply Report Filters

Customize the report using the available filter options:

  • Accounting Year – Select the accounting year to retrieve financial data for a specific period.
  • Accounting Month – Choose the month for the profit and loss report.
  • Show Sub GL Account Detail? (Checked by default) – Displays detailed sub-GL account data. Uncheck this to roll up the report at the header account level.
  • Suppress Current Month Column – (Optional) Check this to exclude the current month's data from the report.
  • Apply Ownership? – Applies ownership percentages as specified in each office record.
  • Report Format – If the agency has custom financial statement formats, apply one of those formats. (See Financial Statement Formats for more details.)
  • Use Office Home Currencies – Generates the report in the default currency of each office.
  • Convert to Selected Currency – Consolidates financial data across multiple offices with different currencies. (The Report FX Rate column will show the exchange rate applied to each office.)

4. Generate and Export the Report

Click PREVIEW to generate and review the Month & Year-To-Date Profit & Loss Report.

Select one of the following export options:

  • PDF – Generate a printable version of the report.
  • Excel – Download the report in a structured data format for further analysis.

5. The Month & Year-To-Date Profit & Loss Report provides a detailed financial summary, allowing agencies to track performance over time, compare results across multiple currencies, and apply custom financial statement formats. By leveraging export options, users can further analyze and report on financial trends efficiently.