Read the workspace trial balance

GET/v1/reports/trial-balance

Query parameters

bankAccountId string

Optional bank account id filter or query option.

Minimum length: 1 character. · Maximum length: 128 characters.

Example01JQ2T5Y5Q3R8W9N6M4K2H7P1G

start string

Calendar date in YYYY-MM-DD format for the reporting period.

Maximum length: 10 characters.

Example2026-01-15

end string

Calendar date in YYYY-MM-DD format for the reporting period.

Maximum length: 10 characters.

Example2026-01-15

range string

Optional range filter or query option.

Allowed values: "all"

Exampleall

timezone string

Optional timezone filter or query option.

Maximum length: 100 characters.

ExampleUTC

clients string[]

Optional clients filter or query option.

at most 500 items

Example1 item

projects string[]

Optional projects filter or query option.

at most 500 items

Example1 item

vendors string[]

Optional vendors filter or query option.

at most 500 items

Example1 item

tags string[]

Optional tags filter or query option.

at most 500 items

Example1 item

invoices string[]

Optional invoices filter or query option.

at most 500 items

Example1 item

expenses string[]

Optional expenses filter or query option.

at most 500 items

Example1 item

recurringExpenses string[]

Optional recurring expenses filter or query option.

at most 500 items

Example1 item

payouts string[]

Optional payouts filter or query option.

at most 500 items

Example1 item

Headers

authorization string required

Bearer workspace API key.

ExampleBearer $NQD_API_KEY

workspace-id string required

Workspace scope for the request. Required for workspace operations and must belong to the authenticated identity.

Minimum length: 1 character. · Maximum length: 128 characters.

Example01JQ2T5Y5Q3R8W9N6M4K2H7P1A

Response

200Success

Response headers

x-request-id string

Correlation identifier returned with every response for support and request tracing.

Example550e8400-e29b-41d4-a716-446655440000

data object

Returned records. Collections and batches use an array; single records use an object.

ShowHide 5 properties

data.report object

report for this report.

ShowHide 7 properties

data.report.currency object

Referenced currency with its opaque ID and ISO 4217 currency code.

ShowHide 4 properties

data.report.currency.id string

Opaque identifier for this resource or reference.

Minimum length: 1 character. · Maximum length: 128 characters.

Example01JQ2T5Y5Q3R8W9N6M4K2H7P1F

data.report.currency.code string

ISO 4217 currency code, such as SAR or USD.

Minimum length: 1 character. · Maximum length: 128 characters.

ExampleSAR

data.report.currency.conversion object

Currency conversion quote used for reporting, including source, target, and rate.

ShowHide 3 properties

data.report.currency.conversion.from string

ISO 4217 code of the source currency in this persisted quote.

Minimum length: 1 character. · Maximum length: 128 characters.

ExampleSAR

data.report.currency.conversion.to string

ISO 4217 code of the target reporting currency in this persisted quote.

Minimum length: 1 character. · Maximum length: 128 characters.

ExampleSAR

data.report.currency.conversion.rate string

Exact decimal conversion rate from the quote source currency to its target currency.

Maximum length: 128 characters.

Example1.00

data.report.currency.name string

Display name of the record.

ExampleSaudi Riyal

data.report.accounts object[]

accounts within report.

ShowHide 7 properties

data.report.accounts[].key string

key within accounts.

ExampleConsulting services

data.report.accounts[].label string

Human-readable label for the value.

ExampleOperating account

data.report.accounts[].type string

Type of the record or operation.

Allowed values: "asset", "liability", "equity", "income", "expense", "unresolved"

Exampleasset

data.report.accounts[].status string

Current status of the record or operation.

Allowed values: "resolved", "unresolved"

Exampleresolved

data.report.accounts[].debit number

debit within accounts.

Example100

data.report.accounts[].credit number

credit within accounts.

Example100

data.report.accounts[].context string nullable

context within accounts.

ExampleConsulting services

data.report.totalDebit number

total debit within report.

Example100

data.report.totalCredit number

total credit within report.

Example100

data.report.difference number

difference within report.

Example100

data.report.unresolvedCount number

unresolved count within report.

Example100

data.report.unresolvedAmount number

Exact decimal string used for financial calculations. Do not round or convert it to a display number.

Example100

data.fiscalStart string

fiscal start for this report.

Example2026-01-01

data.defaultRange object

default range for this report.

ShowHide 2 properties

data.defaultRange.end string

Calendar date in YYYY-MM-DD format for the reporting period.

Example2026-01-31

data.defaultRange.start string

Calendar date in YYYY-MM-DD format for the reporting period.

Example2026-01-01

data.asOfDate string

Calendar date in YYYY-MM-DD format for the reporting period.

ExampleConsulting services

data.generatedAt string

ISO 8601 timestamp for generated.

Example2026-01-15T12:00:00.000Z

Possible errors

400 Invalid request

Response headers

x-request-id string

Correlation identifier returned with every response for support and request tracing.

Example550e8400-e29b-41d4-a716-446655440000

error object

Error details returned for a failed request.

ShowHide 4 properties

error.code string

Stable machine-readable error or resource code.

Exampleinvalid_input

error.message string

Human-readable explanation of the result or error.

ExampleThe request could not be validated.

error.requestId string

Correlation identifier for support and request tracing.

Example550e8400-e29b-41d4-a716-446655440000

error.details object nullable

Additional structured details about the result or error.

ShowHide 1 property

error.details.issues object[]

Structured field issues returned when request validation fails.

ShowHide 3 properties

error.details.issues[].path string | number[]

Field path where the validation issue occurred.

One of: string alternative 1, number alternative 2

Example0 items

error.details.issues[].reason string

Machine-readable reason for the validation issue.

Allowed values: "expected_type", "required", "unexpected_property", "invalid_value", "invalid_json", "invalid_query", "unsupported_media_type", "body_too_large", "body_timeout", "conflicting_scope", "missing_header", "concurrency_required", "invalid_resource_id", "invalid_request"

Exampleinvalid_request

error.details.issues[].code string nullable

Stable machine-readable error or resource code.

Exampleinvalid_input

{
  "error": {
    "code": "invalid_input",
    "message": "The request could not be validated.",
    "requestId": "550e8400-e29b-41d4-a716-446655440000",
    "details": {
      "issues": [
        {
          "path": [],
          "reason": "invalid_request"
        }
      ]
    }
  }
}

View raw OpenAPI operation

Use the machine-readable contract for client generation and payload validation.

Open OpenAPI contract ↗

curl --include --fail-with-body --request GET "${NQD_API_URL:-http://api.nqd.localhost:1335}/v1/reports/trial-balance" \ -H "Authorization: Bearer $NQD_API_KEY" \ -H "Workspace-Id: $NQD_WORKSPACE_ID"

{ "data": { "report": { "currency": { "id": "01JQ2T5Y5Q3R8W9N6M4K2H7P1F", "code": "SAR", "conversion": { "from": "SAR", "to": "SAR", "rate": "1.00" }, "name": "Saudi Riyal" }, "accounts": [ { "key": "Consulting services", "label": "Operating account", "type": "asset", "status": "resolved", "debit": 100, "credit": 100 } ], "totalDebit": 100, "totalCredit": 100, "difference": 100, "unresolvedCount": 100, "unresolvedAmount": 100 }, "fiscalStart": "2026-01-01", "defaultRange": { "end": "2026-01-31", "start": "2026-01-01" }, "asOfDate": "Consulting services", "generatedAt": "2026-01-15T12:00:00.000Z" } }