AccountingBalanceSheet

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)	`accountingBalanceSheet`	`AccountingBalanceSheetGLDtoInput`

Description

The AccountingBalanceSheet service provides a balance sheet report for accounting.

Bilan : Générez un aperçu des actifs et passifs de votre entreprise pour une période déterminée.

Balance de situación : Consulta el estado de los activos y pasivos de tu empresa en un periodo determinado.

Bilanz : Zeigen Sie Ihre Vermögenswerte und Verbindlichkeiten für einen beliebigen Zeitraum an.

Balanço : Gere um resumo dos seus ativos e passivos para um determinado período contabilístico.

This service generates a structured view of assets and liabilities, allowing a clear snapshot of the financial position over a specified period.

Functionality

Balance Sheet Generation: Returns the balance sheet structured by lines and sections.
Fiscal Period Selection: Generates the balance sheet for a specific date range.
Line Filtering: Allows excluding lines without amounts.
Carryforward Handling: Option to include or exclude temporary carryforwards.

Input Parameters

Report Dates: Mandatory, defines the reporting period using StartDate and EndDate.
Display Options: Optional parameters to control the output:
- OnlyLinesWithAmount: Whether to include only lines that contain amounts.
- ShowTemporaryCarryForward: Whether to include temporary carryforward lines.

Response

The service returns an array of AccountingBalanceSheetOutputGLDto objects, each representing a line of the balance sheet:

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 balance sheet structure in a single call.
Pagination is not required, as the result is a complete ordered array representing the balance sheet layout.

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 Balance Sheet service?

GraphQL Query

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

GraphQL Variables

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

Example Response

{
  "data": {
    "accountingBalanceSheet": [
      {
        "amountColumn1": 0,
        "amountColumn2": 0,
        "amountTotal": 0,
        "multiColumn": false,
        "code": "A0",
        "description": "ACTIF",
        "lineType": "ACCOUNT_CALCULATION",
        "order": 1
      },
      {
        "amountColumn1": 0,
        "amountColumn2": 0,
        "amountTotal": 0,
        "multiColumn": false,
        "code": "A000",
        "description": "   CAPITAL SOUSCRIT NON-APPELÉ (I)",
        "lineType": "RESULT_CALCULATION",
        "order": 2
      }
    ]
  }
}