1. [    Home ](/)
2. [Integrations](/integrations)
3. Daily Order Settlement Feed
 
  SFTP / Batch file feed  

# Daily Order Settlement Feed

 

  Overview  File formats 1  Documentation Connection 

 Finance teams reconcile marketplace activity against this nightly settlement feed. Each file contains one row per completed order with amounts, fees, and payout references. Files are dropped on the SFTP endpoint after the daily close and retained for 90 days. The column reference and a machine-readable JSON Schema of the record format are attached.



 

  Service type SFTP / Batch file feed 

  Tags sftp finance settlement 

  ### Formats

 `CSV` 

### Filename patterns

 `orders-YYYYMMDD.csv` `orders-YYYYMMDD.csv.done` 

 csv orders-feed.csv 

   orderIdamountcurrencycreatedAt   ORD-100149.99USD2026-07-01T10:00:00Z ORD-100215.00GBP2026-07-01T11:30:00Z ORD-1003120.50EUR2026-07-02T08:15:00Z   

 json schema Order record 

One order line in the daily batch feed.

   FieldTypeRequiredDescription    `orderId` `string` yes Unique order identifier.   `amount` `number` yes Order total in minor units.   `currency` `string` no ISO 4217 currency code.   `createdAt` `string (date-time)` no Order creation timestamp.    

  Authenticate with your provisioned SSH key. Poll after 02:30 UTC; the file for day D is named orders-YYYYMMDD.csv with a .done marker written when the upload is complete. Never process a file without its marker.



 

   Host`sftp.settlement.example.com:22`

Remote path`/outbound/settlement`

DirectionOutbound — files published for pickup

AuthenticationSSH key

ScheduleDaily at 02:00 UTC (available by 02:30 UTC)

 ### Specification files

- [ CSV orders-feed.csv ](/sites/default/files/service-specs/demo-settlement-sftp/orders-feed.csv)
- [ JSON order-record.schema.json ](/sites/default/files/service-specs/demo-settlement-sftp/order-record.schema.json)