Merchant Reports

Delivery Method and Frequency

By default, Waave emails settlement reports to email address(es) nominated by the merchants monthly.

Other delivery options will be made available soon, including:

  • sFTP
  • REST API
  • Manual download via Merchant Dashboard

Format

Emailed reports are in CSV format containing the following fields:

ColumnSample ValueNotes
payment_session_id72071046-d044-4952-8bdf-da262f1b82ba
refund_idb035e670-e2e8-49e1-bfc9-f4fe044c93c0
transaction_id53e7db26-1afe-4427-b5cc-5667334230d8
batch_id100234The batch_id will be part of the description in your bank statement. It can be used to reconcile with the corresponding DISBURSEMENT record.
typePURCHASECan be one of PURCHASE, REFUND, REFUND_FALLBACK and DISBURSEMENT
customer_referenceorder-1234
credit120.00In dollars
debit200.75In dollars
fee1.20In dollars
currencyAUD
created_at18/1/2024 11:02
timezoneAustralia/SydneyTimezone used in created_at
ext_field_1For POLi transactions, this field will contain POLi transaction ID
ext_field_2For in-store transactions, this field will contain the till ID
ext_field_3Reserved for future use
ext_field_4Reserved for future use
ext_field_5Reserved for future use
ext_field_6Reserved for future use
ext_field_7Reserved for future use
ext_field_8Reserved for future use

Sample

payment_session_id,refund_id,transaction_id,batch_id,type,customer_reference,credit,debit,fee,currency,created_at,timezone,ext_field_1,ext_field_2,ext_field_3,ext_field_4,ext_field_5,ext_field_6,ext_field_7,ext_field_8
bbdfc0ad-acd5-45f5-a391-31a2f1f15935,"",8dad1349-faed-4921-9683-cb08126e3de5,1004759,PURCHASE,ref-20240606100846,52.36,,0.36326,AUD,06/06/2023 10:15:27,Australia/Sydney,,,,,,,,
dd2f90c8-4e87-465a-b89b-c6c9e9f60e44,"",e06f0bb9-ad06-43b8-93bb-19d859dcf33f,1004759,PURCHASE,ref-20240606181329,52.05,,0.362175,AUD,06/06/2023 18:17:43,Australia/Sydney,,,,,,,,
,,d05458b2-7536-4aef-99a9-930457a6235c,1004759,DISBURSEMENT,,,104.41,,AUD,07/06/2024 01:00:31,Australia/Sydney,,,,,,,,
e810897e-d502-4691-86cf-98f000cdff4b,"",9678294b-7a42-4bce-97cb-35eb947eff1d,1005802,PURCHASE,ref-20240630162730,59.85,,0.389475,AUD,30/06/2023 16:28:47,Australia/Sydney,,,,,,,,
,,45bc1c47-b3c0-4a99-a69f-3e4c714fe9eb,1005802,DISBURSEMENT,,,59.85,,AUD,01/07/2024 01:00:28,Australia/Sydney,,,,,,,,