SolariumSolariumDocs
Dashboard
Browse The Docs

Docs/API Reference/Reports

POST

Download Reports (Excel / CSV)

Every report for a date range in one .xlsx workbook: Profit & Loss by period, Balance Sheet, Spending By Vendor, Receivables and Payables (balances as of endDate). Amounts are numeric cells in the organization's currency format, built from the same services as the queries above, so they always agree. With format "csv", returns just the one report named by report (pnl, balance-sheet, vendors, receivable, payable) as plain rows: amounts to the cent with no symbols, ISO dates. Returns the file name, content type and the file as base64.

View as MarkdownOpen in ClaudeOpen in ChatGPT

Parameters

organizationIdUUID!required

Organization ID

startDateDate!required

Start of range (YYYY-MM-DD)

endDateDate!required

End of range (YYYY-MM-DD); balance sheets are as of this date

granularityString

"month" (default) or "quarter" for the P&L and vendor sheets

formatString

"xlsx" (default, every report) or "csv" (one report)

reportString

For csv: pnl, balance-sheet, vendors, receivable or payable

PreviousReceivables & Payables (Aged)NextBalance Sheet
Request
query {
  reportsExport(organizationId: "a1b2c3d4-...", startDate: "2026-01-01", endDate: "2026-03-31") {
    filename
    contentType
    contentBase64
  }
}
Response
{
  "data": {
    "reportsExport": {
      "filename": "Vanilla-Bite-Ltd-Reports-2026-01-01-to-2026-03-31.xlsx",
      "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
      "contentBase64": "UEsDBBQAAAAIA..."
    }
  }
}