Get Transactions Summary
Return aggregate statistics for transactions matching the given filters (v2, ClickHouse-backed).
Returns total count, income, spending, net total, average, and the largest overall, expense, and income transactions. Accepts the same filter params as the list endpoint.
Authorizations
Bearer authentication with a personal access token (prefix pat_). Generate tokens in the Truv web app under Settings → API keys.
Query Parameters
Start date for the transaction window (inclusive, YYYY-MM-DD).
"2025-01-01"
End date for the transaction window (inclusive, YYYY-MM-DD). Defaults to today.
"2025-12-31"
Comma-separated category slugs to include (e.g. 'income,transfer'). Omit to include all categories.
1000"income,transfer"
Filter by transaction type. Omit to include both debits and credits.
DEBIT, CREDIT "DEBIT"
Comma-separated account IDs to include. Omit to include all accounts.
"acc_001,acc_002"
Minimum transaction amount (absolute value). Inclusive.
"10.00"
Maximum transaction amount (absolute value). Inclusive.
"500.00"
Case-insensitive substring match on merchant name or description.
"starbucks"
Comma-separated category slugs to exclude (e.g. 'transfer,uncategorized').
1000Include user-hidden transactions in the aggregates. Hidden transactions can be unhidden; permanently deleted transactions are never counted regardless.
true
Response
Aggregate statistics for transactions matching filters.
Aggregate statistics for a set of transactions matching the given filters.
Total number of transactions.
142
Sum of all CREDIT amounts.
^(?!^[-+.]*$)[+-]?0*\d*\.?\d*$"3000.00"
Sum of all DEBIT amounts.
^(?!^[-+.]*$)[+-]?0*\d*\.?\d*$"1245.50"
total_income minus total_spending.
^(?!^[-+.]*$)[+-]?0*\d*\.?\d*$"1754.50"
Average transaction amount (absolute value).
^(?!^[-+.]*$)[+-]?0*\d*\.?\d*$"87.72"
Transaction with the highest absolute amount.
DEBIT transaction with the highest amount.
CREDIT transaction with the highest amount.