Skip to main content

Reports

Report endpoints take one JSON query parameter, reportFilter.

reportFilter​

FieldTypeNotes
dateFilterobjectSee dateFilter.
accountFilterstring[]Account IDs.
contactFilterstring[]Contact IDs.
itemFilterstring[]Item IDs.
tagsFilterstring[]Tags.
txnTypestringA transaction type.
ledgerTypestringFor example CustomerInvoice, SupplierBill, IncomingPayment, OutgoingPayment, Journal, GeneralEntry.
accountingTypestringAccrual or Cash.
reportTypestringCustomerBase, VendorBase or CombinedBase (for contact reports).
onlyCashEntries, includeRetainedEarnings, includeBalanceboolean
branchIdstringRead a specific branch instead of the main branch.

Only the fields relevant to a report are used; leave the rest out.

curl -G "$BASE_URL/reporting/getDashboard" \
-H "x-api-key: YOUR_API_KEY" \
--data-urlencode 'reportFilter={"dateFilter":{"predefinedDateFilter":"ThisMonth"}}'

Report endpoints​

EndpointPermissionDescription
GET /reporting/getDashboardFinancialReport · ReadBusiness summary for the period: income, expenses, receivables/payables and related totals.
GET /reporting/ledger-entriesRead on a transaction typeGeneral-ledger entries matching the filter. Returns Ledger[].
GET /reporting/ledger-entries-with-balanceRead on a transaction type · Advanced Reports plan featureLedger entries with a running balance.
GET /reporting/ledger-totalsFinancialReport · Read or LedgerReport · Read · Advanced Reports plan featureTotals aggregated by account — the building block for trial balance, profit and loss, and balance sheet views.
GET /reporting/contact-txnsSalesReport, PurchaseReport or LedgerReport · ReadTransactions grouped by contact for a period (use contactFilter and reportType).
GET /reporting/contact-statementSalesReport, PurchaseReport or LedgerReport · ReadCustomer or vendor statement of account with opening balance, entries and closing balance.
POST /reporting/reportPdfAny report permission · ReadRenders rows you supply as a PDF. JSON body: { "object": "<report name>", "list": [ ...rows... ] }. Returns the file.
POST /reporting/reportExcelAny report permission · ReadSame input, returns an Excel file.

For the exact response schema of each report, see the OpenAPI document.