Skip to content

Reports and statements

Reconcile each payout to your sellers, declare your commission, and hand each seller a yearly statement in your brand.

Your accountant matches each payout to your sellers with your bank or operator statement, and declares your commission. Ask Wajub for a report, under Sync, Reports or with POST /sync/reports: it is built in the background, usually within a minute or two, then

  • report.ready reaches your endpoints;
  • the member who asked in the Dashboard gets an e-mail, with a link to the Dashboard, never to the file;
  • it is kept 30 days, and downloaded through a link signed for 15 minutes.

The five reports

typeFormatsContains
payout_reconciliationcsv, xlsxEvery element of every payout to every seller, one row each
seller_summarycsv, xlsxPer seller and currency: sales, refunds, lost disputes, commission taken, returned and net, paid out; and, as it is built, what they are owed, what is withheld, their cover debt
platform_commissioncsv, xlsxYour commission per month, seller and currency: taken, returned, net
relay_duescsv, xlsxYour Relay sellers' dues: their state, and the payout that paid them
seller_statementpdfOne Lite or Relay seller's statement for the period
Rule
PeriodUTC days, from period_start at midnight to the end of period_end, 366 days at most
AmountsMajor units with their currency, as exact decimals with the currency's decimals (19000.00, -286.50). A negative amount stays a number
DatesISO 8601 UTC with offset (2026-11-06T07:00:00+00:00); a day alone as YYYY-MM-DD
Stable columnsformat_version (today 1) is in the report and in the file's name: payout_reconciliation_v1_2026-11-01_2026-11-30.csv. A column never changes meaning within a version
Personal dataThe seller's name only. No e-mail address, no phone number, no identity document
CSVUTF-8 with BOM, comma, RFC 4180 quoting, column names on the first line. A text cell starting with =, +, - or @ gets a leading apostrophe, so it never runs as a formula
XLSXOne sheet, "Report", bold frozen header; text as strings, never formulas; amounts and counts as numbers. Past 1 048 576 rows it fails with too_many_rows: ask for CSV
Test keyBuilt from test data (rpt_test_…), with report.ready in test
Waiting5 reports at most at a time, being built or queued. A report still pending can be cancelled under Sync, Reports: it turns failed with cancelled and frees its place

Ask for one

November's payouts, as CSV
curl https://api.wajub.com/sync/reports \
  -H "Authorization: sk.xxxxxxxxxxxxxxxx…" \
  -H "Content-Type: application/json" \
  -d '{"type":"payout_reconciliation","format":"csv","period_start":"2026-11-01","period_end":"2026-11-30"}'
Field
typeRequired: one of the five above
period_start, period_endRequired, YYYY-MM-DD, UTC; period_end on or after period_start
formatcsv or xlsx for an export, required; pdf for a statement, the default
accountThe seller's acc_…, required for seller_statement: a lite or relay account of yours, in the same environment
localeThe language of a seller_statement: en, the default, or fr. Exports are the same in both: their columns never change. Any other value answers 422

The answer is 202 with the report, pending. Called with your own key, never with X-Sync.

error_codeStatusWhen
format_not_available422pdf for an export, csv or xlsx for a statement, or no format for an export
period_too_long422More than 366 days
account_required422seller_statement without account
statement_not_available400A statement for a direct account: they have their own Wajub reports
too_many_reports4295 reports already waiting
404account unknown, another platform's, or of the other environment

Download it

When report.ready arrives, GET /sync/reports/{id} returns the report with url, a link signed for 15 minutes (url_expires_at). Call it again for a fresh one, and never store the link.

status
pending, buildingOn its way. A year of a large platform can stay building a few minutes: you still get one file, and one report.ready
readyurl, row_count (exports, header not counted), file_name, file_size in bytes, completed_at, expires_at
failedfailure_reason: too_many_rows (an XLSX past Excel's last row, ask for CSV), build_failed (three attempts failed, ask again) or cancelled (cancelled in the Dashboard). A failed report no longer counts among the 5
expiredThe file was deleted after 30 days

report.ready is sent once per report. It is a Sync lifecycle delivery: list it by name. Its body is event, sandbox, timestamp and the report, without a link. A report that failed sends nothing: read it with GET.

The columns of payout_reconciliation

One row per element of each payout Wajub made to your sellers. A payout is in the period by its value date, or, not paid yet, by its creation. The amount of a payout's rows add up to its payout_amount, to the centime. The payouts follow each other in that same order, by value date (or creation), then payout by payout, and a payout's rows keep their order (line).

Column
payout_id, payout_statuspo_…; pending, processing, succeeded, failed or cancelled
payout_created_at, payout_value_dateCreation; value date, empty until it succeeded
operator_referenceThe operator's reference, the one on your statement
payout_amount, currencyWhat the payout paid
account, account_type, seller_nameThe seller
line, element, amountThe row's rank in the payout, what it is, and its signed share of the payout
payment, refund, disputeThe public ids concerned
occurred_atWhen the element happened
escrow_amount, hold_status, hold_released_atThe hold until delivery of the sale concerned
elementSign
sale, share+A sale, or a part of a shared payment, gross
wajub_fee−Wajub's fee on it
commission−Your commission
refund, dispute−What a refund or a lost dispute took back
commission_returned+Your commission given back with it
cover, recovery+ / −What you covered for the seller, and what you took back
debt−A Relay seller's debt, netted
payout_fee−The payout's own fee
reserve_brought_forward, balance_brought_forward+What the previous payout left
reserve_held, balance_carried_forward−What this payout leaves for later
adjustment±A balance movement no other element explains
rounding±A centime's difference between gross, fees, commission and what was paid
escrow_released0A held Lite sale released since the previous payout, paid through balance_brought_forward; escrow_amount says how much
unreported+A payout whose detail was never written: one row of its whole amount

The other exports list their columns in the same way, in the file's header: seller_summary (balance_due, withheld and cover_debt are as the report is built, as_of, and empty for a direct seller; its last column, card_reserve, is what the seller's card sales keep against chargebacks, included in withheld), platform_commission (one row per month, seller and currency) and relay_dues (one due per row, outstanding as GET /accounts/{id}/dues reads it).

Your sellers' statements

A seller_statement is a PDF for one Lite or Relay seller, in your brand: per currency, what was collected for them, refunded, lost to disputes, kept as your commission and paid to them, then month by month. It says it is a record for their accounts, not a tax return; Wajub's fees are in each payout's detail. Through the API it is in English unless you ask for locale: fr; from the Dashboard, in the language of the member who asks.

A dispute the merchant accepted is counted once, among the lost disputes, never also among the refunds: in the statement, in seller_summary and in the seller's figures. Ordinary refunds stay under refunds.

WhoWhere
YouThe seller's page in Sync, Accounts, one button per year since they connected; or POST /sync/reports with any period up to 366 days
A Lite sellerTheir portal, under Payouts
A Lite or Relay seller, in your pagesThe payouts component shows their statements by year

What did you think of this content?