Reconciliation Report

You get the policy and premium report per connection from the API to reconcile with your provider. The report on the panel's Reconciliation screen is built from the same data: Insurance Menu › Reconciliation.

• The figures are read from your insurance orders themselves. For the same filter, the totals of the summary endpoint equal the sum of the rows of the rows endpoint and of the CSV file.
• Statuses are the statuses at the time you get the report.
• Orders created in the Checkout Form and through the API are all in the report; the premium may have been collected in a Lunixi payment, outside Lunixi or by the provider.

Authentication and signing: Flows › Authentication.

Filter

The three endpoints take the same filter:

• The period applies to the order creation time and is half-open: from inclusive, to exclusive. The period is at most 366 days.
• In a query string, write the + sign of a time zone as %2B.

A request that breaks the period rules returns 422 insurance.validation.invalid:

If from or to is missing, connectionId is not a UUID, or currency or insuranceType is malformed, the request returns 400 VALIDATION_ERROR.

Summary: GET /api/v1/insurance/reconciliation/summary

Returns the totals of the period, grouped by connection, currency and who collects the premium.

source lunixi-sign.sh
REQ_PATH="/api/v1/insurance/reconciliation/summary?from=2026-09-01T00:00:00Z&to=2026-10-01T00:00:00Z"
lunixi_sign GET "$REQ_PATH"
 
curl "https://api-gateway.lunixi.com$REQ_PATH" \
  -H "X-Key-Id: $LUNIXI_KEY_ID" \
  -H "X-Date: $DATE" \
  -H "X-Nonce: $NONCE" \
  -H "X-Signature: $SIGNATURE"

data carries these fields:

groups[]:

totals, amounts in minor units:

Collection and refund totals are per order; policy totals are per policy.

Rows: GET /api/v1/insurance/reconciliation/orders

Returns the orders behind the summary together with their policies, newest first, in cursor-based pages. In addition to the filter parameters:

In the response, the rows are in the data.items array; pagination information is in pageInfo.

policies[]:

A malformed cursor returns 422 insurance.validation.invalid (field: cursor).

CSV: GET /api/v1/insurance/reconciliation/export

Returns the report rows as a CSV file. The filter parameters are the same; it also takes cursor to continue a truncated file.

source lunixi-sign.sh
REQ_PATH="/api/v1/insurance/reconciliation/export?from=2026-09-01T00:00:00Z&to=2026-10-01T00:00:00Z"
lunixi_sign GET "$REQ_PATH"
 
curl "https://api-gateway.lunixi.com$REQ_PATH" \
  -H "X-Key-Id: $LUNIXI_KEY_ID" \
  -H "X-Date: $DATE" \
  -H "X-Nonce: $NONCE" \
  -H "X-Signature: $SIGNATURE" \
  -o reconciliation.csv

• The file is UTF-8 and starts with a BOM. Amounts are in minor units.
• Each policy is one line. Order columns repeat on each policy line of the order; an order without a policy yet is a single line with empty policy columns. For the order total, sum orderPremiumAmountMinor once per orderId; for the policy total, sum policyPremiumAmountMinor.
• A file holds at most 20,000 orders. When the limit is reached, the last line of the file is # truncated=true orderCap=20000 nextCursor=<cursor>; for the remaining orders, repeat the request with the same filter and cursor=<cursor>.
• If the export is interrupted, the last line of the file is # export-aborted=true and the file is incomplete; download it again.
• If the request fails validation, the response is not CSV but the JSON error envelope. Check the response's Content-Type header.

Errors

Common codes: Flows › Responses and errors.

Related

• Insurance Menu › Reconciliation: the report in the panel
• Orders and Payment Binding: the order object
• Concepts and Statuses: status axes