ReportsGenerate account transactions report

Generate account transactions report

POST/firm-partners/workspace/reports/account-transactions

Returns journal-line activity grouped by ledger account.

The general-ledger detail report: every journal line in the period grouped by ledger account, with opening and ending balances per account and a running balance on each entry. This is ledger activity, not the bank/register rows returned by GET /firm-partners/workspace/transactions. Each entry carries its transaction reference number as `checkNumber`; filter a check or deposit register by range with checkNumberFrom/checkNumberTo. unknownCustomerAr / unknownVendorAp reproduce the Aged Receivables "Unknown customer" and Aged Payables "Unknown vendor" rows.

HMAC signature only

Headers

count-workspace-iduuidrequired

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

startDatedaterequired

Report period start (YYYY-MM-DD).

endDatedaterequired

Report period end (YYYY-MM-DD).

currencystringoptional

Report currency. Defaults to workspace currency.

accountUuidsstringoptional

Comma-separated ledger account UUIDs whose activity to include. Alias: accounts. Pass UUIDs from GET /partners/accounts, never internal numeric ids.

categoryAccountUuidsstringoptional

Comma-separated source/bank account UUIDs restricting the counterpart account on each line. Aliases: categoryAccount, categoryAccountUuid.

transactionStatusenumoptional

Filter lines by review/reconciliation state.

One of: all, reviewed, unreviewed, reconciled, unreconciled

reportTypeenumoptional

Accounting basis for the report. Defaults to accrual.

One of: accrual, cash

taxenumoptional

Filter lines by tax treatment.

One of: taxable, none, other

customerUuidsstringoptional

Comma-separated customer UUIDs. Alias: customers.

vendorUuidsstringoptional

Comma-separated vendor UUIDs. Alias: vendors.

projectUuidsstringoptional

Comma-separated project UUIDs. Alias: projects.

productUuidsstringoptional

Comma-separated product UUIDs. Alias: products.

tagUuidsstringoptional

Comma-separated tag UUIDs. Alias: tags.

noTagsstringoptional

Pass "true" to return only lines with no tags attached.

checkNumberFromstringoptional

Inclusive lower bound of the transaction reference-number range, 1–18 digits (leading zeros ignored). Accrual basis only.

checkNumberTostringoptional

Inclusive upper bound of the transaction reference-number range, 1–18 digits (leading zeros ignored). Accrual basis only.

unknownCustomerArstringoptional

Pass "true" for the Aged Receivables "Unknown customer" drill-down: Accounts Receivable lines with no customer on the line or its transaction, in the reporting currency unless currency is given. The control account is returned even with no lines in the period. Accrual basis only; cannot be combined with unknownVendorAp, accountUuids, categoryAccountUuids, customerUuids, tagUuids, or noTags.

unknownVendorApstringoptional

Pass "true" for the Aged Payables "Unknown vendor" drill-down: Accounts Payable lines with no vendor on the line or its transaction. Same rules as unknownCustomerAr, with vendorUuids in place of customerUuids.

Responses

200Account transactions report generated.
400Missing startDate or endDate, or invalid filters — including a reference-number bound that is not 1–18 digits, a reference-number range or unknown-counterparty drill-down on a cash basis, both drill-down flags together, or a drill-down combined with a filter it sets itself.
401Missing signing headers, an invalid HMAC signature, or a timestamp more than 5 minutes off. Troubleshoot
403The 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
404Accounts Receivable or Accounts Payable account not found for the drill-down.
429Rate limit exceeded (100 requests per minute per firm user of each app, or 10,000 per minute per app). Troubleshoot
POSThttps://api.getcount.com/firm-partners/workspace/reports/account-transactions
Request
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/account-transactions';
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/account-transactions`, {
  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
{
  "status": "success",
  "message": "Success on generating account transaction reports",
  "data": {
    "categorized": [
      {
        "accountUuid": "c8d9e0f1-a2b3-4567-cdef-789012345678",
        "name": "Business Checking",
        "accountNumber": "1000",
        "type": "Assets",
        "openingBalance": 12500,
        "endingBalance": 15000,
        "balanceChange": 2500,
        "debitTotal": 2500,
        "creditTotal": 0,
        "entries": [
          {
            "entryUuid": "b2c3d4e5-f6a7-8901-bcde-f23456789012",
            "invoiceUuid": "f6a7b8c9-d0e1-2345-fabc-456789012345",
            "transactionUuid": null,
            "billUuid": null,
            "date": "2026-03-04",
            "descriptionEntry": "Invoice INV-1042",
            "descriptionLine": "Consulting retainer",
            "entryType": "debit",
            "entrySpecificType": "invoice",
            "amountDebit": 2500,
            "amountCredit": 0,
            "amount": 2500,
            "balance": 15000,
            "invoiceNumber": "INV-1042",
            "billNumber": null,
            "checkNumber": null,
            "sourceDocumentType": "invoice",
            "sourceDocumentReference": "INV-1042",
            "account": {
              "uuid": "c8d9e0f1-a2b3-4567-cdef-789012345678",
              "name": "Business Checking",
              "type": "Assets",
              "accountNumber": "1000"
            },
            "categoryAccount": {
              "uuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
              "name": "Consulting Revenue",
              "type": "Income",
              "accountNumber": "4000"
            },
            "customer": {
              "uuid": "dfa3219e-6af8-4c53-997a-037534f63a35",
              "name": "Acme Corporation"
            },
            "vendor": null,
            "project": null
          }
        ]
      }
    ],
    "filters": {
      "startDate": "2026-01-01",
      "endDate": "2026-03-31"
    }
  }
}