POST

List Transactions

Returns a paginated, filterable list of ledger events. Supports status filtering, date ranges, amount ranges, account/category scoping, and full-text search.

View as Markdown Open in Claude Open in ChatGPT

Parameters

organizationIdUUID!required

Organization ID

status[String]

Filter by status (needs_review, confirmed, synced, reconciled, pending, ignored)

hasDocumentBoolean

Filter by whether a receipt/document is attached

sinceDaysInt

Only return events from the last N days

dateFromString

Start date filter (YYYY-MM-DD)

dateToString

End date filter (YYYY-MM-DD)

amountMinString

Minimum amount filter (inclusive)

amountMaxString

Maximum amount filter (inclusive)

accountIds[UUID]

Filter by expense/income account IDs

categoryIds[UUID]

Filter by category account IDs

searchString

Full-text search on merchant name and memo

limitInt

Page size (default 25, max 200)

offsetInt

Number of records to skip (default 0)

sortByString

Field to sort by (e.g. transactionDate, functionalAmount)

sortDirString

asc or desc (default desc)

PreviousTransactions NextGet a Transaction

Request

query {
  listLedgerEvents(
    organizationId: "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
    status: ["needs_review"]
    dateFrom: "2026-01-01"
    dateTo: "2026-06-30"
    limit: 10
  ) {
    items {
      id
      eventType
      merchantName
      functionalAmount
      functionalCurrency
      transactionDate
      status
      hasDocument
      account { id name }
      paymentAccount { id name }
    }
    totalCount
    pageSize
    offset
  }
}

Response

{
  "data": {
    "listLedgerEvents": {
      "items": [
        {
          "id": "b7c8d9e0-f1a2-3456-b789-cdef01234567",
          "eventType": "expense",
          "merchantName": "Staples Canada",
          "functionalAmount": "127.43",
          "functionalCurrency": "CAD",
          "transactionDate": "2026-06-18",
          "status": "needs_review",
          "hasDocument": true,
          "account": {
            "id": "d3e4f5a6-b7c8-9012-def0-123456789abc",
            "name": "Office Supplies"
          },
          "paymentAccount": {
            "id": "e4f5a6b7-c8d9-0123-ef01-23456789abcd",
            "name": "TD Visa *8821"
          }
        },
        {
          "id": "c8d9e0f1-a2b3-4567-c890-def012345678",
          "eventType": "expense",
          "merchantName": "Tim Hortons",
          "functionalAmount": "14.85",
          "functionalCurrency": "CAD",
          "transactionDate": "2026-06-17",
          "status": "needs_review",
          "hasDocument": false,
          "account": null,
          "paymentAccount": {
            "id": "e4f5a6b7-c8d9-0123-ef01-23456789abcd",
            "name": "TD Visa *8821"
          }
        }
      ],
      "totalCount": 43,
      "pageSize": 10,
      "offset": 0
    }
  }
}