{
"_links": {
"aging_global": "/api/customers/aging?as_of=2026-05-13&bucket_type=standard",
"self": "/api/receivables/to-collect?as_of=2026-05-13&days_overdue_min=30&bucket_type=standard"
},
"as_of_date": "2026-05-13",
"cache": {
"age_seconds": 0,
"cached_at": "2026-05-13T09:12:00-04:00",
"expires_at": "2026-05-13T13:12:00-04:00",
"force_refreshed": false,
"key_hash": "sha1:abc...",
"status": "miss",
"ttl_policy": "current_period_4h",
"ttl_remaining_seconds": 14400
},
"filter": {
"bucket_type": "standard",
"days_overdue_min": 30,
"include_zero_balance": false,
"limit": 500,
"sort_by": "days_overdue_desc"
},
"items": [
{
"_links": {
"customer_overview": "/api/customers/by-id/105/overview",
"customer_statement": "/api/customers/by-id/105/statement?from=2026-01-01&to=2026-05-13",
"invoice_detail": "/api/customers/invoice-ar/by-id/2214"
},
"amount_original": 1500,
"amount_paid": 0,
"amount_remaining": 1500,
"bucket": "days_60_90",
"customer": {
"code": "10005",
"id": 105,
"name": "Atelier Lac Saint-Jean"
},
"days_overdue": 71,
"due_date": "2026-03-03",
"invoice": {
"code": "FAC-2026-00418",
"date": "2026-02-01",
"id": 2214,
"reference": "PO-88931",
"transaction_type": {
"code": "invoice",
"id": 3,
"label": "Facture"
}
},
"is_credit": false
}
],
"metadata": {
"customers_scanned": 187,
"extracted_at": "2026-05-13T09:12:00-04:00",
"limit_applied": 500,
"organisation_id": "constructions_jimmy_roy",
"scope": "open_invoices_only",
"sdk_indexes_used": {
"customer_payment_line": 1,
"invoice_ar": 3
},
"truncated": false
},
"summary": {
"aging_percentages": {
"days_0_30": -0.6,
"days_30_60": 32.3,
"days_60_90": 22.6,
"days_over_90": 45.6
},
"aging_summary": {
"days_0_30": -2350,
"days_30_60": 124500,
"days_60_90": 87200,
"days_over_90": 175750
},
"credits_amount": 2350,
"credits_count": 2,
"currency": "CAD",
"customers_count": 42,
"invoices_due_amount": 387450,
"invoices_due_count": 142,
"net_to_collect": 385100,
"total_amount": 385100,
"total_invoices": 144
}
}