# How to build a profit and loss report in Sage X3

> Source: https://netray.co/erp-help/sage-x3-profit-and-loss-report-how-to
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

A Sage X3 P&L is built from the chart of accounts: income and expense accounts grouped into report lines by a financial report definition, filtered by company, ledger and period. Verify it against the trial balance, then add analytical dimensions if you need P&L by department or project.

## Kind

how-to

## System

sage

## Erp

Sage X3

## Module

Finance / Financial Reporting

## Query

sage x3 profit and loss report

## Alternate Queries

- sage x3 income statement
- sage x3 financial statements
- sage x3 p&l by analytical dimension

## Applies To

Sage X3 V7 and later. Report tooling and menu names vary by version and legislation.

## Steps

### Building the report

**Items:**

- Confirm the chart of accounts has income and expense accounts correctly classified and mapped to the right collective or group codes.
- Define the report layout: rows (revenue, cost of sales, gross profit, expenses, net result) each referencing account ranges or groups.
- Choose the company or consolidation scope, the ledger, the fiscal year and the period range.
- Run the report and compare each total against the trial balance for the same filters.
- Add comparison columns such as prior year or budget if required.
- Add analytical dimensions to report by cost centre, business unit or project, and test the totals still tie.

## Sections

### Why it must tie to the trial balance

**Body:**

The P&L is a presentation of balances already in the ledger. If it does not agree with the trial balance for the same company, ledger and period, the usual cause is an account missing from the layout, a filter on posting status, or journals in a different ledger.

### Account structure choices

**Body:**

Ranges are easy to build but break when new accounts are created outside the range. Account groups are more robust, as long as someone owns the grouping when accounts are added.

### Analytical reporting

**Body:**

- If departmental P&L matters, make sure the dimensions are mandatory on the expense accounts that need them. Reporting is only as good as the posting discipline.

## Pitfalls

- New accounts left out of the layout.
- Mixing ledgers (for example local and group) in one report.
- Including unposted or provisional journals by accident.
- Different period filters on current and prior columns.
- Currency conversion mixed with local currency figures.

## Ai Angle

A grounded assistant can answer why revenue changed month on month by reading ledger data read-only and showing which accounts drove the movement. Netray can run this privately on-prem, so financial data does not leave your network.

## Faq

### Where do I find the P&L in Sage X3?

**Answer:** Under the accounting reporting area, using financial statements or report definitions. Exact menu names depend on version and legislation, so check your folder.

### Why does my P&L not match the trial balance?

**Answer:** Usually an account is outside the layout, a different ledger or posting status is used, or the period range differs. Align the filters first.

### Can I get P&L by department?

**Answer:** Yes, if analytical dimensions are set up and used consistently on postings. Historical postings without dimensions cannot be split later without adjustments.

### Can I export to Excel?

**Answer:** Yes, reports can generally be exported, and many sites also use external reporting tools against the data.

## Search terms

sage x3 profit and loss, sage x3 p&l report, sage x3 income statement, sage x3 financial statements, sage x3 financial reports, sage x3 trial balance, sage x3 analytical accounting

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json