invoiceninja_list_expenses
Read-onlyIdempotent
List expenses from Invoice Ninja with filters for client, status, date range, and tags. Sort and paginate results to find and review expense records.
Instructions
List expenses from Invoice Ninja with filtering, sorting and pagination. client_status values: all, logged, pending, invoiced, uninvoiced, paid, unpaid, uncategorized. extra_filters keys: number, amount, categories (category ids, comma separated), vendor_ids, project_ids, payment_type, has_invoices, date_range ('YYYY-MM-DD,YYYY-MM-DD'); created_between / updated_between ('YYYY-MM-DD,YYYY-MM-DD'), tag_ids (comma separated), assigned_user_ids. Related names are resolved automatically (client_name, vendor_name). Use invoiceninja_get_expense with an id from this list for the full record.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number, starting at 1 | |
| sort | No | Sort as 'column|asc' or 'column|desc', e.g. 'date|desc' | |
| fields | No | JSON format only: return just these top-level fields (id is always included), e.g. ['number', 'client_name', 'balance', 'due_date'] | |
| filter | No | Free-text search across the main columns (number, name, contacts, notes…) | |
| status | No | Lifecycle filter, comma separated: active, archived, deleted (e.g. 'active' to skip archived and deleted records) | |
| include | No | Extra relations to embed, comma separated (e.g. 'payments,activities') | |
| per_page | No | Records per page (1-100) | |
| client_id | No | Only records of this client (hashed id) | |
| client_status | No | Business status filter, comma separated; one or more of: all, logged, pending, invoiced, uninvoiced, paid, unpaid, uncategorized | |
| extra_filters | No | Additional API query filters as name -> value (see the tool description) | |
| response_format | No | 'markdown' (default) for a readable summary, 'json' for complete machine-readable data (empty fields removed) | markdown |