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.
| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||