Financial dashboard aggregates

Aggregated data for the finance dashboard, computed with aggregate queries. 'month': current-month panel (by dueDate) per type (payable/receivable) with paid (settled transactions — settledAmount, falling back to amount), pending (PENDING due today or later), overdue (PENDING past due) and total = paid + pending + overdue; CANCELLED transactions are excluded. 'cashFlow': 12-month projection starting at the current month — PENDING transactions grouped by dueDate month (inflow = RECEIVABLE, outflow = PAYABLE, net = inflow - outflow), always 12 entries (zeros for months without data). 'balancete': the last 12 months ending at the current month — PAID transactions grouped by effectedDate month using the settled value. 'currentBalance': sum of the balance of every bank account. Months are formatted as "yyyy-MM" and dates resolved in America/Sao_Paulo.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Responses

Language
Credentials
Header
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
*/*