get_expense_report
Generate expense reports filtered by date range, user, client, project, and category. Group results by dimension and filter by billing status.
Instructions
Generate comprehensive expense reports with filtering by date range, users, clients, projects, and categories. Supports grouping and billing status filtering.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| from | Yes | Start date for report (YYYY-MM-DD) (required) | |
| to | Yes | End date for report (YYYY-MM-DD) (required) | |
| user_id | No | Filter by specific user ID | |
| client_id | No | Filter by specific client ID | |
| project_id | No | Filter by specific project ID | |
| expense_category_id | No | Filter by specific expense category ID | |
| billable | No | Filter by billable status | |
| is_billed | No | Filter by billed status | |
| updated_since | No | Filter by expenses updated since this timestamp | |
| group_by | No | Group report results by specified dimension |