Skip to main content
GET
/
service
/
general-ledger
/
reports
/
ar-aging
curl -X GET "https://kube.acho.io/service/general-ledger/reports/ar-aging?as_of_date=2024-12-31" \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "report": "AR Aging",
  "as_of_date": "2024-12-31",
  "generated_at": "2024-12-31T10:00:00Z",
  "bucket_size_days": 30,
  "summary": {
    "current": 45000.00,
    "1_30_days": 20000.00,
    "31_60_days": 10000.00,
    "61_90_days": 5000.00,
    "over_90_days": 3000.00,
    "total_outstanding": 83000.00
  },
  "by_customer": [
    {
      "customer_id": "customer-001",
      "customer_name": "ABC Corporation",
      "current": 25000.00,
      "1_30_days": 10000.00,
      "31_60_days": 0,
      "61_90_days": 0,
      "over_90_days": 0,
      "total": 35000.00
    },
    {
      "customer_id": "customer-002",
      "customer_name": "XYZ Industries",
      "current": 15000.00,
      "1_30_days": 8000.00,
      "31_60_days": 7000.00,
      "61_90_days": 3000.00,
      "over_90_days": 2000.00,
      "total": 35000.00
    }
  ],
  "detail": [
    {
      "invoice_id": "INV-2024-200",
      "customer_name": "ABC Corporation",
      "invoice_date": "2024-12-20",
      "due_date": "2025-01-19",
      "amount_due": 12000.00,
      "days_outstanding": 0,
      "bucket": "current"
    },
    {
      "invoice_id": "INV-2024-150",
      "customer_name": "XYZ Industries",
      "invoice_date": "2024-11-10",
      "due_date": "2024-12-10",
      "amount_due": 8000.00,
      "days_outstanding": 21,
      "bucket": "1_30_days"
    }
  ]
}

Request

Generate an accounts receivable aging report showing outstanding invoices by due date buckets.

Query Parameters

as_of_date
string
Date for aging calculation (YYYY-MM-DD). Default: today
start_date
string
Filter out invoices with due_date before this date
size
integer
Days per bucket. Default: 30
buckets
integer
Number of buckets. Default: 3
curl -X GET "https://kube.acho.io/service/general-ledger/reports/ar-aging?as_of_date=2024-12-31" \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "report": "AR Aging",
  "as_of_date": "2024-12-31",
  "generated_at": "2024-12-31T10:00:00Z",
  "bucket_size_days": 30,
  "summary": {
    "current": 45000.00,
    "1_30_days": 20000.00,
    "31_60_days": 10000.00,
    "61_90_days": 5000.00,
    "over_90_days": 3000.00,
    "total_outstanding": 83000.00
  },
  "by_customer": [
    {
      "customer_id": "customer-001",
      "customer_name": "ABC Corporation",
      "current": 25000.00,
      "1_30_days": 10000.00,
      "31_60_days": 0,
      "61_90_days": 0,
      "over_90_days": 0,
      "total": 35000.00
    },
    {
      "customer_id": "customer-002",
      "customer_name": "XYZ Industries",
      "current": 15000.00,
      "1_30_days": 8000.00,
      "31_60_days": 7000.00,
      "61_90_days": 3000.00,
      "over_90_days": 2000.00,
      "total": 35000.00
    }
  ],
  "detail": [
    {
      "invoice_id": "INV-2024-200",
      "customer_name": "ABC Corporation",
      "invoice_date": "2024-12-20",
      "due_date": "2025-01-19",
      "amount_due": 12000.00,
      "days_outstanding": 0,
      "bucket": "current"
    },
    {
      "invoice_id": "INV-2024-150",
      "customer_name": "XYZ Industries",
      "invoice_date": "2024-11-10",
      "due_date": "2024-12-10",
      "amount_due": 8000.00,
      "days_outstanding": 21,
      "bucket": "1_30_days"
    }
  ]
}