Totals of invoices and bills, grouped (aging)
query_invoicesRead-onlyIdempotent
Adds up invoices you sent (owed_to_you) and bills you received (you_owe), grouped by up to two of: counterparty, aging (current, 1-30, 31-60, 61-90, 90+ days overdue), status, company, side, due_month, issue_month. Measures per currency: outstanding, total, paid, count, avg_days_overdue. By default only unpaid ones (open, overdue, partially paid, disputed); include_paid adds paid ones. Example: who owes the most, by aging: side owed_to_you, group_by ["counterparty","aging"]. search_invoices lists the invoices behind a group.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| side | No | both | |
| limit | No | ||
| order | No | largest (default): by outstanding; key: by group (default when grouping by aging or a month). | |
| company | No | Company name or id, "Personal", or "all". Omit for every company this connection can see. | |
| group_by | No | ||
| measures | No | ||
| counterparty | No | ||
| include_paid | No |