vendor_spending_report
Analyze vendor bills over a date range to see total billed, paid, and outstanding amounts per vendor, with optional filters and grouping by month, quarter, or year.
Instructions
Get spending breakdown by vendor for a period.
Analyzes posted vendor bills to show total billed, total paid, and outstanding amounts per vendor.
Returns a compact aligned text table by default. Use verbose=true for the full structured dict (programmatic consumers).
Args: start_date: Start of period (YYYY-MM-DD). end_date: End of period (YYYY-MM-DD). vendor_id: Optional filter to a specific vendor. verbose: If true, return the structured dict. group_by: Optional "month", "quarter", or "year" — split the range into sub-period columns of total billed per vendor and return a multi-period TSV table. Overrides verbose.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| verbose | No | ||
| end_date | Yes | ||
| group_by | No | ||
| vendor_id | No | ||
| start_date | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |