Skip to main content
GET
/
service
/
general-ledger
/
reports
/
ap-aging
curl -X GET "https://kube.acho.io/service/general-ledger/reports/ap-aging?as_of_date=2024-12-31" \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "report": "AP Aging",
  "as_of_date": "2024-12-31",
  "generated_at": "2024-12-31T10:00:00Z",
  "bucket_size_days": 30,
  "summary": {
    "current": 25000.00,
    "1_30_days": 15000.00,
    "31_60_days": 8000.00,
    "61_90_days": 3000.00,
    "over_90_days": 2000.00,
    "total_outstanding": 53000.00
  },
  "by_vendor": [
    {
      "vendor_id": "vendor-001",
      "vendor_name": "Acme Supplies",
      "current": 10000.00,
      "1_30_days": 5000.00,
      "31_60_days": 0,
      "61_90_days": 0,
      "over_90_days": 0,
      "total": 15000.00
    },
    {
      "vendor_id": "vendor-002",
      "vendor_name": "Tech Solutions",
      "current": 8000.00,
      "1_30_days": 6000.00,
      "31_60_days": 4000.00,
      "61_90_days": 2000.00,
      "over_90_days": 1000.00,
      "total": 21000.00
    }
  ],
  "detail": [
    {
      "bill_id": "BILL-2024-100",
      "vendor_name": "Acme Supplies",
      "bill_date": "2024-12-15",
      "due_date": "2025-01-14",
      "amount_due": 5000.00,
      "days_outstanding": 0,
      "bucket": "current"
    },
    {
      "bill_id": "BILL-2024-085",
      "vendor_name": "Tech Solutions",
      "bill_date": "2024-11-15",
      "due_date": "2024-12-15",
      "amount_due": 6000.00,
      "days_outstanding": 16,
      "bucket": "1_30_days"
    }
  ]
}

Request

Generate an accounts payable aging report showing outstanding bills by due date buckets.

Query Parameters

as_of_date
string
Date for aging calculation (YYYY-MM-DD). Default: today
start_date
string
Filter out bills 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/ap-aging?as_of_date=2024-12-31" \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "report": "AP Aging",
  "as_of_date": "2024-12-31",
  "generated_at": "2024-12-31T10:00:00Z",
  "bucket_size_days": 30,
  "summary": {
    "current": 25000.00,
    "1_30_days": 15000.00,
    "31_60_days": 8000.00,
    "61_90_days": 3000.00,
    "over_90_days": 2000.00,
    "total_outstanding": 53000.00
  },
  "by_vendor": [
    {
      "vendor_id": "vendor-001",
      "vendor_name": "Acme Supplies",
      "current": 10000.00,
      "1_30_days": 5000.00,
      "31_60_days": 0,
      "61_90_days": 0,
      "over_90_days": 0,
      "total": 15000.00
    },
    {
      "vendor_id": "vendor-002",
      "vendor_name": "Tech Solutions",
      "current": 8000.00,
      "1_30_days": 6000.00,
      "31_60_days": 4000.00,
      "61_90_days": 2000.00,
      "over_90_days": 1000.00,
      "total": 21000.00
    }
  ],
  "detail": [
    {
      "bill_id": "BILL-2024-100",
      "vendor_name": "Acme Supplies",
      "bill_date": "2024-12-15",
      "due_date": "2025-01-14",
      "amount_due": 5000.00,
      "days_outstanding": 0,
      "bucket": "current"
    },
    {
      "bill_id": "BILL-2024-085",
      "vendor_name": "Tech Solutions",
      "bill_date": "2024-11-15",
      "due_date": "2024-12-15",
      "amount_due": 6000.00,
      "days_outstanding": 16,
      "bucket": "1_30_days"
    }
  ]
}