List transactions
list_transactionsRetrieve YNAB transactions newest first and filter by date, amount, category, payee, status, or text to review spending and find specific entries.
Instructions
List transactions, newest first, with filters that can be combined.
Example queries this tool can answer:
"Show me all transactions over $50 in Dining Out this year" → category_id=, max_amount=-50, since_date=2024-01-01
"What do I still need to review?" → status="unapproved"
"What hasn't been categorized?" → status="uncategorized"
"How much did we spend at Amazon in March?" → payee_id=, since_date=2024-03-01, until_date=2024-03-31
"Find the soccer registration fee" → text_search="soccer"
Filtering by category or payee returns each part of a split transaction as its own row, with parent_transaction_id set.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of transactions to return per page (default: 25) | |
| offset | No | Number of transactions to skip for pagination (default: 0) | |
| status | No | "unapproved" for transactions waiting for the user's review, or "uncategorized" for transactions with no category (optional) | |
| payee_id | No | Only transactions with this payee (optional) | |
| account_id | No | Only transactions in this account (optional) | |
| max_amount | No | Only transactions with amount <= this, in currency units. Spending is negative, so -50 means "spent at least 50" (optional) | |
| min_amount | No | Only transactions with amount >= this, in currency units. Spending is negative, so -50 means "spent at most 50" (optional) | |
| since_date | No | Only transactions on or after this date (optional) | |
| until_date | No | Only transactions on or before this date (optional) | |
| category_id | No | Only transactions in this category (optional) | |
| text_search | No | Only transactions whose payee name, memo, or original bank payee contains this text, ignoring case (optional) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pagination | Yes | Pagination information | |
| transactions | Yes | List of transactions |