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:
Column | Sample Value | Notes |
---|---|---|
payment_session_id | 72071046-d044-4952-8bdf-da262f1b82ba | |
refund_id | b035e670-e2e8-49e1-bfc9-f4fe044c93c0 | |
transaction_id | 53e7db26-1afe-4427-b5cc-5667334230d8 | |
batch_id | 100234 | The batch_id will be part of the description in your bank statement. It can be used to reconcile with the corresponding DISBURSEMENT record. |
type | PURCHASE | Can be one of PURCHASE, REFUND, REFUND_FALLBACK and DISBURSEMENT |
customer_reference | order-1234 | |
credit | 120.00 | In dollars |
debit | 200.75 | In dollars |
fee | 1.20 | In dollars |
currency | AUD | |
created_at | 18/1/2024 11:02 | |
timezone | Australia/Sydney | Timezone used in created_at |
ext_field_1 | For POLi transactions, this field will contain POLi transaction ID | |
ext_field_2 | For in-store transactions, this field will contain the till ID | |
ext_field_3 | Reserved for future use | |
ext_field_4 | Reserved for future use | |
ext_field_5 | Reserved for future use | |
ext_field_6 | Reserved for future use | |
ext_field_7 | Reserved for future use | |
ext_field_8 | Reserved 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,,,,,,,,
Updated 4 months ago