Exports

DayZero provides Excel (.xlsx) export endpoints for downloading business data in bulk.

Export Transactions

Download bank transactions as an Excel spreadsheet:

bash

curl "https://api.ondayzero.com/api/v1/export/transactions/excel?days=90" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID" \
  -o transactions.xlsx

Parameters

Parameter	Type	Default	Description
`days`	integer	30	Number of days of history to include
`ledger_id`	UUID	—	Filter to a specific bank account

Export Customers

Download all customer records:

bash

curl "https://api.ondayzero.com/api/v1/export/customers/excel" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID" \
  -o customers.xlsx

Export Orders

Download inventory orders:

bash

curl "https://api.ondayzero.com/api/v1/export/orders/excel" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID" \
  -o orders.xlsx

Financial Reports

For more detailed exports (P&L, balance sheet, trial balance, etc.), use the Reports API which supports both CSV and Excel output formats.