AccountingProfitAndLoss

Quick Links

Accounts Accounting Entries Products Customers Sales quotes Sales invoices Suppliers Purchase invoices

HTTP	Operation	Type	Object	DTO Why-DTOs?
POST	Read	⚙️ ActionThe action resource represents a type of object that differs from standard queries or mutations. For a query, it returns a result already prepared by Sage Active, with no possibility to add filters, sorts, or explore the data further, or it executes an action (e.g., sending an email). For a mutation, it executes a specific business action, also carried out by Sage Active, which will impact the data (e.g., generating a credit note from an invoice). (Query)	`accountingProfitAndLoss`	`AccountingProfitAndLossGLDtoInput`

Description

The AccountingProfitAndLoss service provides a profit and loss report for accounting.

Compte de résultat : Générez une vue d’ensemble des revenus, des coûts et des dépenses encourus au cours d’un exercice ou d’une période de votre choix.

Pérdidas y ganancias : Obtén una visión global de los ingresos y gastos de tu empresa en un ejercicio o periodo seleccionado.

Gewinn- und Verlustrechnung : Erhalten Sie eine Übersicht über Einnahmen, Kosten und Ausgaben für ein Geschäftsjahr oder einen Zeitraum Ihrer Wahl.

Resultados : Crie uma síntese das receitas, custos e despesas incorridas durante um ano fiscal ou período contabilístico à sua escolha.

This service generates a structured view of revenues and expenses, allowing analysis of financial performance over a specified period.

Functionality

Profit and Loss Generation: Returns a profit and loss statement structured by lines and sections.
Fiscal Period Selection: Generates the report for a specific date range.
Line Filtering: Allows excluding lines without amounts.
Multi-column Support: Supports single or multiple amount columns depending on configuration.

Input Parameters

Report Dates: Mandatory, defines the reporting period using StartDate and EndDate.
Display Options:
- OnlyLinesWithAmount: Whether to include only lines with non-zero amounts.

Response

The service returns an array of AccountingProfitAndLossOutputGLDto objects, each representing a line of the profit and loss statement:

Structure Information:
Code, Description, LineType, Order
Amounts:
- AmountColumn1
- AmountColumn2
- AmountTotal
Layout Information:
- MultiColumn: Indicates whether the line uses multiple amount columns

Tips and Tricks

This query returns the full profit and loss structure in a single call.
Pagination is not required, as the result is a complete ordered array.

Key	Value
`Authorization`	Bearer Current access Token How to find?
~~`X-TenantId`~~ DeprThis field is now deprecated, and we recommend using an alternative solution	Current tenant id Why deprecated ?
`X-OrganizationId`	Current organization Id How to find?
`x-api-key`	Primary or secondary subscription key of your app How to find?

How to use the Profit and Loss service?

GraphQL Query

query ($input: AccountingProfitAndLossGLDtoInput!) {
  accountingProfitAndLoss(input: $input) {
    code
    description
    lineType
    order
    multiColumn
    amountColumn1
    amountColumn2
    amountTotal
  }
}

GraphQL Variables

{
  "input": {
    "startDate": "2025-01-01",
    "endDate": "2025-12-31",
    "onlyLinesWithAmount": false
  }
}

Example Response

{
  "data": {
    "accountingProfitAndLoss": [
      {
        "amountColumn1": 0,
        "amountColumn2": 0,
        "amountTotal": 0,
        "multiColumn": false,
        "code": "P0",
        "description": "PRODUITS D'EXPLOITATION",
        "lineType": "1",
        "order": 1
      },
      {
        "amountColumn1": 16640687.72,
        "amountColumn2": 0,
        "amountTotal": 16640687.72,
        "multiColumn": false,
        "code": "P001",
        "description": "MONTANT NET DU CHIFFRE D'AFFAIRES",
        "lineType": "4",
        "order": 2
      }
    ]
  }
}