---
title: "Generate aged payables · Reports · Practice Manager API · COUNT Partner API"
description: "Generates an AP aging report as of a date. POST /firm-partners/workspace/reports/aged-payables"
canonical: "https://developers.getcount.com/practice-manager/reference/reports/generate-aged-payables"
source: "https://developers.getcount.com/practice-manager/reference/reports/generate-aged-payables"
---
[Reports](https://developers.getcount.com/practice-manager/reference/reports) / Generate aged payables

# Generate aged payables

POST `/firm-partners/workspace/reports/aged-payables`

Generates an AP aging report as of a date.

Payables mirror of aged receivables: open bills and vendor memos aged off the Accounts Payable control account. Query filters match aged receivables.

HMAC signature only

[Chart of Accounts API](https://developers.getcount.com/practice-manager/reference/chart-of-accounts) [Tags API](https://developers.getcount.com/practice-manager/reference/tags) [Workspace Stats API](https://developers.getcount.com/practice-manager/reference/workspace-stats) [Fixed Assets API](https://developers.getcount.com/practice-manager/reference/fixed-assets)

#### Headers

`count-workspace-id` uuid required

UUID of the client workspace to act on. It must be one of your firm's client workspaces (or the firm's own workspace) and within the API key's client workspaces.

#### Query parameters

`asOfDate` date optional

As-of date for aging (YYYY-MM-DD). Alias for endDate — supply one.

`endDate` date optional

Alias for asOfDate.

`currency` string optional

Report currency. Defaults to workspace currency.

`agingBasis` enum optional

Age documents off due date (default) or posted/document date.

One of: `dueDate`, `postedDate`, `documentDate`

`tagUuids` string optional

Comma-separated tag UUIDs to filter by.

#### Responses

`200` Aged payables report generated.

`400` Missing or invalid query parameters.

`401` Missing signing headers, an invalid HMAC signature, or a timestamp more than 5 minutes off. [Troubleshoot](https://developers.getcount.com/practice-manager/authentication#errors)

`403` The key is inactive or its scope does not allow this request, the workspace is not managed by your firm or is outside the key's client workspaces, the workspace has no active subscription, or it is portal-only and the route needs bookkeeping. [Troubleshoot](https://developers.getcount.com/practice-manager/authentication#errors)

`404` No workspace exists with the `count-workspace-id` UUID.

`429` Rate limit exceeded (100 requests per minute per firm user of each app, or 10,000 per minute per app). [Troubleshoot](https://developers.getcount.com/practice-manager/authentication#errors)

[Previous POST Generate aged receivables](https://developers.getcount.com/practice-manager/reference/reports/generate-aged-receivables) [Next POST Generate sales by product/service](https://developers.getcount.com/practice-manager/reference/reports/generate-sales-by-product-service)

POST `https://api.getcount.com/firm-partners/workspace/reports/aged-payables`

Request

```javascript
import crypto from 'node:crypto';

const BASE_URL = 'https://api.getcount.com';
const CLIENT_ID = process.env.COUNT_CLIENT_ID;
const CLIENT_SECRET = process.env.COUNT_CLIENT_SECRET;

const method = 'POST';
const signingPath = '/workspace/reports/aged-payables';
const timestamp = Math.floor(Date.now() / 1000).toString();
const bodyString = '';

const bodyHash = '';
const baseString = `${method}:${signingPath}:${timestamp}:${bodyHash}`;
const signature = crypto.createHmac('sha256', CLIENT_SECRET).update(baseString).digest('hex');

const response = await fetch(`${BASE_URL}/firm-partners/workspace/reports/aged-payables`, {
  method,
  headers: {
    'x-client-id': CLIENT_ID,
    'x-timestamp': timestamp,
    'x-signature': signature,
    'count-workspace-id': '5e4d3c2b-1a09-4f8e-8d7c-6b5a49382716',
  },
});

console.log(await response.json());
```

Response · 200

```json
{
  "status": "success",
  "message": "Success on generating aged payables report",
  "data": {
    "totals": {
      "notYetOverdue": 0,
      "lessThanOrEqaulTo30": 0,
      "between31And60": 900,
      "between61And90": 0,
      "moreThan90": 0,
      "totalAmount": 900,
      "unpaidTax": 0,
      "monthTotals": {
        "current": 0,
        "oneMonth": 900,
        "twoMonths": 0,
        "threeMonths": 0,
        "fourMonthsOrOlder": 0,
        "totalAmount": 900
      }
    },
    "asOfDate": "2026-03-31",
    "currency": "USD",
    "agingBasis": "dueDate",
    "controlAccountUuid": "2b3c4d5e-6f7a-4b8c-9d0e-1f2a3b4c5d6e",
    "reconciliation": {
      "controlAccountBalance": 900,
      "agedDocumentsTotal": 900,
      "difference": 0
    },
    "rows": [
      {
        "rowKey": "document:payable:2042",
        "source": "document",
        "documentUuid": "e5f6a7b8-c9d0-4e1f-a2b3-c4d5e6f7a8b9",
        "counterpartyUuid": "aa11bb22-cc33-dd44-ee55-ff6677889901",
        "counterpartyName": "Office Supplies Co",
        "documentNumber": "BILL-2042",
        "documentDate": "2026-01-15",
        "dueDate": "2026-02-14",
        "agingDate": "2026-02-14",
        "ageInDays": 45,
        "ageInMonths": 1,
        "bucket": "between31And60",
        "bucketInMonths": "oneMonth",
        "amount": 900,
        "unpaidTax": 0,
        "documentStatus": "unpaid",
        "documentType": "bill",
        "isCredit": false,
        "description": "Printer paper and toner",
        "notes": null
      }
    ],
    "counterparties": [
      {
        "counterpartyUuid": "aa11bb22-cc33-dd44-ee55-ff6677889901",
        "counterpartyName": "Office Supplies Co",
        "notYetOverdue": 0,
        "lessThanOrEqaulTo30": 0,
        "between31And60": 900,
        "between61And90": 0,
        "moreThan90": 0,
        "totalAmount": 900,
        "unpaidTax": 0,
        "months": {
          "current": 0,
          "oneMonth": 900,
          "twoMonths": 0,
          "threeMonths": 0,
          "fourMonthsOrOlder": 0,
          "totalAmount": 900
        }
      }
    ]
  }
}
```
