{
"_links": {
"ap_detail": "/api/payables/to-pay?as_of=2026-05-17&days_to_due_max=27&include_overdue=true&include_zero_balance=false",
"ar_detail": "/api/receivables/to-collect?as_of=2026-05-17&include_zero_balance=false",
"self": "/api/cashflow/forecast?as_of=2026-05-17&weeks=4&group_by=week&include_overdue=true&include_zero_balance=false"
},
"as_of_date": "2026-05-17",
"buckets": [
{
"ap_due": {
"amount": 0,
"credits_amount": 0,
"credits_count": 0,
"invoices_count": 0,
"invoices_due_amount": 0,
"net_amount": 0
},
"ar_expected": {
"amount": 11945.91,
"credits_amount": 0,
"credits_count": 0,
"invoices_count": 4,
"invoices_due_amount": 11945.91,
"net_amount": 11945.91
},
"bucket_index": 1,
"bucket_label": "W1",
"from": "2026-05-17",
"is_partial": true,
"net": 11945.91,
"to": "2026-05-17"
}
],
"cache": {
"age_seconds": 0,
"cached_at": "2026-05-17T09:00:00-04:00",
"expires_at": "2026-05-17T13:00:00-04:00",
"force_refreshed": false,
"key_hash": "sha1:abc...",
"status": "miss",
"ttl_policy": "current_period_4h",
"ttl_remaining_seconds": 14400
},
"filter": {
"include_overdue": true,
"include_zero_balance": false
},
"horizon": {
"from": "2026-05-17",
"group_by": "week",
"to": "2026-06-13",
"weeks": 4
},
"metadata": {
"ap_invoices_excluded_count": 0,
"ar_invoices_excluded_count": 14,
"customers_in_scope": 42,
"customers_scanned": 51,
"extracted_at": "2026-05-17T09:00:00-04:00",
"invoices_beyond_horizon": 0,
"invoices_no_due_date": 0,
"organisation_id": "constructions_jimmy_roy",
"scope": "open_invoices_only",
"sdk_indexes_used": {
"invoice_ap": [
3,
9
],
"invoice_ar": 3
},
"semantic_version": "v3-net",
"suppliers_in_scope": 29,
"suppliers_scanned": 74
},
"overdue": {
"ap": {
"amount": 373083.45,
"credits_amount": 4682.1,
"credits_count": 7,
"invoices_count": 337,
"invoices_due_amount": 377765.55,
"net_amount": 373083.45
},
"ar": {
"amount": 1422682.72,
"credits_amount": 5272.95,
"credits_count": 8,
"invoices_count": 215,
"invoices_due_amount": 1427955.67,
"net_amount": 1422682.72
}
},
"summary": {
"ap_due_total": 0,
"ap_in_horizon_credits": 0,
"ap_in_horizon_invoices_due": 0,
"ap_in_horizon_net": 0,
"ap_overdue_credits": 4682.1,
"ap_overdue_invoices_due": 377765.55,
"ap_overdue_net": 373083.45,
"ap_overdue_total": 373083.45,
"ar_expected_total": 457850.72,
"ar_in_horizon_credits": 0,
"ar_in_horizon_invoices_due": 457850.72,
"ar_in_horizon_net": 457850.72,
"ar_overdue_credits": 5272.95,
"ar_overdue_invoices_due": 1427955.67,
"ar_overdue_net": 1422682.72,
"ar_overdue_total": 1422682.72,
"currency": "CAD",
"net_cashflow": 457850.72
}
}