Browse the extensions reference

trialBalance

returns TrialBalance

One entity's trial balance for posted entries in a date range.

Arguments

NameTypeDescription
startDateDateStart of the posting window (inclusive).
endDateDateEnd of the posting window (inclusive).
entityIdStringThe entity whose books to read. Omit for the group parent.
dimensionTypeStringA management dimension axis (department, class, location, project) to slice by, with dimension_member_id.
dimensionMemberIdStringThe one member whose lines to sum, or unallocated for the lines no member of the axis tags.

Returns TrialBalance

Trial balance for posted entries in a date range — every CoA account that had activity, plus aggregate totals. Ledger is balanced when total_debits == total_credits. Used as a sanity check before close-period; failure means an unposted / malformed entry slipped through.

FieldTypeDescription
rows[TrialBalanceRow!]!—
totalDebitsFloat!—
totalCreditsFloat!—
slicedBoolean!True when read for one management dimension member (or its axis's Unallocated). Such a balance need not foot: an entry's other side may carry another member or none.

Example

query
{ trialBalance { totalDebits totalCredits sliced } }
curl
curl -X POST "https://api.robosystems.ai/extensions/$GRAPH_ID/graphql" \
  -H "X-API-Key: $ROBOSYSTEMS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"query": "{ trialBalance { totalDebits totalCredits sliced } }"}'