List transactions

GET/api/v1/transactions

Retrieve bank transactions with filtering by date, ledger, source account, counter ledger, journal entry, or tags.

Operation ID: list_transactions_api_v1_transactions_get·View as markdown·OpenAPI slice

Authentication

Bearer token authentication. Pass your DayZero API token in the Authorization header and the target business UUID in x-business-id.

Parameters

Query

idarray · stringdefault: []

Filter by specific transaction UUIDs

ledger_idarray · stringdefault: []

Filter by bank account ledger UUIDs

opposing_ledger_idstring

Filter by opposing ledger UUID (the category/expense ledger from journal entry line entries)

source_account_idarray · stringdefault: []

Filter by Teal source account IDs (bank accounts from Plaid)

tag_idarray · stringdefault: []

Filter by assigned tag UUIDs

journal_entry_idstring

Filter by associated journal entry UUID

start_datestring · date-time

Include transactions from this date (ISO 8601)

end_datestring · date-time

Include transactions up to this date (ISO 8601)

searchstring

Search transactions by description or counterparty name (case-insensitive partial match)

amount_directionstring

Filter by amount direction: 'inflow' for positive amounts (money in), 'outflow' for negative amounts (money out)

only_uncategorizedbooleandefault: False

Filter to show only uncategorized transactions (those without a journal entry or linked to system uncategorized ledgers)

missing_counterpartybooleandefault: False

Filter to show only transactions with no counterparty assigned (empty or NULL). Useful for surfacing wires / miscellaneous deposits that the auto-detection pipeline intentionally left blank for the bookkeeper to fill in.

review_statusstring

Filter by review status. Accepts 'reviewed', 'unreviewed', or a comma-separated combination. Must mirror the same flag on the export endpoint so the visible list and the exported file stay in sync.

reconciledboolean

Filter by reconciliation state. true returns only reconciled transactions, false only unreconciled. Omit for all.

posted_statusstring

Filter by bank posting status: 'posted' (cleared activity that affects the books) or 'pending' (unsettled authorizations, read-only awareness layer). Omit to return both.

cursorstring

Cursor for pagination

limitinteger

Pagination limit

directionstringdefault: next

Pagination direction: 'next' or 'prev'

include_total_countbooleandefault: False

Whether to include total count (expensive - avoid if possible)

sort_bystring

Column name to sort by (e.g. 'created_at', 'amount', 'name'). When changing sort, reset cursor to None.

descendingbooleandefault: True

Sort direction: true for descending (newest/largest first), false for ascending

Responses

200Successful Response

successboolean
messagestring
codestring
dataTransactionListResponse

401Unauthorized - Authentication required

403Forbidden - Insufficient permissions

422Validation Error

detailarray · ValidationErrorValidationError
5 fields
locarray · string | integerrequired
msgstringrequired
typestringrequired
inputobject
ctxobject