Generate aged receivables
/firm-partners/workspace/reports/aged-receivablesGenerates an AR aging report as of a date.
Computes open invoice and credit-memo balances off the Accounts Receivable control account. Returns detail `rows`, per-customer `counterparties` summaries, bucket `totals`, and a `reconciliation` block against the control account GL balance. Filters are query parameters only.
Headers
count-workspace-iduuidrequiredUUID 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
asOfDatedateoptionalAs-of date for aging (YYYY-MM-DD). Alias for endDate — supply one.
endDatedateoptionalAlias for asOfDate.
currencystringoptionalReport currency. Defaults to workspace currency.
agingBasisenumoptionalAge documents off due date (default) or posted/document date.
One of: dueDate, postedDate, documentDate
tagUuidsstringoptionalComma-separated tag UUIDs to filter by.
Responses
200Aged receivables report generated.400Missing or invalid query parameters.401Missing signing headers, an invalid HMAC signature, or a timestamp more than 5 minutes off. Troubleshoot403The 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. Troubleshoot404No workspace exists with the `count-workspace-id` UUID.429Rate limit exceeded (100 requests per minute per firm user of each app, or 10,000 per minute per app). Troubleshoothttps://api.getcount.com/firm-partners/workspace/reports/aged-receivablesimport 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-receivables';
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-receivables`, {
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());{
"status": "success",
"message": "Success on generating aged receivables report",
"data": {
"totals": {
"notYetOverdue": 2500,
"lessThanOrEqaulTo30": 0,
"between31And60": 0,
"between61And90": 0,
"moreThan90": 0,
"totalAmount": 2500,
"unpaidTax": 200,
"monthTotals": {
"current": 2500,
"oneMonth": 0,
"twoMonths": 0,
"threeMonths": 0,
"fourMonthsOrOlder": 0,
"totalAmount": 2500
}
},
"asOfDate": "2026-03-20",
"currency": "USD",
"agingBasis": "dueDate",
"controlAccountUuid": "1a2b3c4d-5e6f-4a7b-8c9d-0e1f2a3b4c5d",
"reconciliation": {
"controlAccountBalance": 2500,
"agedDocumentsTotal": 2500,
"difference": 0
},
"rows": [
{
"rowKey": "document:receivable:1042",
"source": "document",
"documentUuid": "f6a7b8c9-d0e1-2345-fabc-456789012345",
"counterpartyUuid": "dfa3219e-6af8-4c53-997a-037534f63a35",
"counterpartyName": "Acme Corporation",
"documentNumber": "INV-1042",
"documentDate": "2026-03-01",
"dueDate": "2026-03-31",
"agingDate": "2026-03-31",
"ageInDays": -11,
"ageInMonths": 0,
"bucket": "notYetOverdue",
"bucketInMonths": "current",
"amount": 2500,
"unpaidTax": 200,
"documentStatus": "unpaid",
"documentType": "invoice",
"isCredit": false,
"description": "Consulting retainer",
"notes": null
}
],
"counterparties": [
{
"counterpartyUuid": "dfa3219e-6af8-4c53-997a-037534f63a35",
"counterpartyName": "Acme Corporation",
"notYetOverdue": 2500,
"lessThanOrEqaulTo30": 0,
"between31And60": 0,
"between61And90": 0,
"moreThan90": 0,
"totalAmount": 2500,
"unpaidTax": 200,
"months": {
"current": 2500,
"oneMonth": 0,
"twoMonths": 0,
"threeMonths": 0,
"fourMonthsOrOlder": 0,
"totalAmount": 2500
}
}
]
}
}