COUNTCOUNT
Sign Up
ReportsGenerate sales by customer

Generate sales by customer

POST/partners/reports/sales-by-customer

Summarizes invoice line revenue and quantity by customer.

Sales-only aggregation of invoice line items over a date range. Distinct from customer activity, which nets all journal entries per customer.

HMAC signature + Bearer access token
Try this request
Chart of Accounts APITags APIWorkspace Stats API

Query parameters

startDatedateoptional

Report period start.

endDatedateoptional

Report period end.

currencystringoptional

Report currency. Defaults to workspace currency.

transactionStatusenumoptional

Filter transactions by review/reconciliation state.

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

customerUuidsstringoptional

Comma-separated customer UUIDs.

reportTypeenumoptional

Accounting basis for the report.

One of: accrual, cash

Responses

200Sales by customer report generated.
400Invalid filters.
401Missing or invalid HMAC signature, expired timestamp, or invalid Bearer token. Troubleshoot
403The credential does not have access to this workspace or resource. Troubleshoot
429Rate limit exceeded (100 requests per minute per clientId). Retry after the Retry-After header. Troubleshoot
POSThttps://api.getcount.com/partners/reports/sales-by-customer
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 ACCESS_TOKEN = process.env.COUNT_ACCESS_TOKEN;

const method = 'POST';
const signingPath = '/reports/sales-by-customer';
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}/partners/reports/sales-by-customer`, {
  method,
  headers: {
    'x-client-id': CLIENT_ID,
    'x-timestamp': timestamp,
    'x-signature': signature,
    Authorization: `Bearer ${ACCESS_TOKEN}`,
  },
});

console.log(await response.json());
Response · 200
{
  "status": "success",
  "message": "Success on generating sales by customer report",
  "data": {
    "customersSales": [
      {
        "uuid": "dfa3219e-6af8-4c53-997a-037534f63a35",
        "name": "Acme Corporation",
        "totalSales": 45000,
        "totalQuantity": 120
      }
    ],
    "totals": {
      "totalSales": 45000,
      "totalQuantity": 120
    }
  }
}