Settlement

April gathers together payments over a period of time and transfers them to the merchant's primary bank account in bulk as a net settlement. April makes payouts every week day excluding public holidays. Payments made on weekends or public holidays are bundled together with payments from the following business day.

Payments are aggregated at the day level with the cut-off being midnight in the time zone configured for the merchant.

The following table shows what payments you will receive on each business day.

Country \ Payout Date Monday Tuesday Wednesday Thursday Friday
Australia Thursday Friday Saturday
Sunday
Monday
Tuesday Wednesday
New Zealand Tuesday Wednesday Thursday Friday Saturday
Sunday
Monday

Payouts are initiated at 1pm AEST on each business day.

Settlement reports

There are two main endpoints for generating settlement reports:

  • Query Settlement Entries - Returns a paginated list of all settlement entries matching the given search criteria
  • Report Settlement Entries - Returns a list of all settlement entries matching the given search criteria in either JSON or CSV format

Each endpoints takes a number of filter query parameters to help you refine the content of the generated report. Broadly you can either query by a given payout identifier or provide a date range of matching entries.

For payouts, you can use the Query Payout Summaries endpoint to retrieve a list of all payouts that have been generated for the given search criteria.

Get Payout Details is also available to provide an aggregated breakdown of the money movements included in the payout along with details of the disbursement itself. This provides a great summary view where you can quickly see the number of entries of each type (such as payments, payment fees and refunds) included in a particular payout. It also provides opening and closing balances for payouts. These are typically zero, but can be negative if a large refund brings a payout into a negative balance. In this case the negative balance is carried forward to the next payout.

The Report Settlement Entries can generate either JSON or CSV output. Set the Accept request header to either application/json or text/csv to determine the output format.

Here's a sample of what the CSV report would look like:

Copy
Copied
EntryTimestamp,EntryType,SettlementDate,TransactionType,OrderId,TransactionId,Currency,NetAmount,GrossAmount,PlatformFeesInclTax,PlatformFeesTax
2023-08-12T06:35:02+10:00,Payment,2023-08-21,PayPlan,32715707,tran_ZNVJ7FhZDGsibcAj,AUD,200.00,200.00,0.00,0.00
2023-08-12T06:35:02+10:00,PaymentFee,2023-08-21,PayPlan,32715707,tran_ZNVJ7FhZDGsibcAj,AUD,-9.13,0.00,-9.13,-0.83

Additionally, for CSV you can customise the columns to include in the report using the column query parameter:

Copy
Copied
GET /transactions/settlement/report?payoutId=payout_ZO6DGc1G7CabUdYa&merchantId=mcht_Ya2b2blPdwCAhSkt&column=EntryDate&column=EntryDescription&column=MerchantName&column=Currency&column=NetAmount&column=TransactionId

Order custom fields

Merchants can specify custom fields that can be included in the order metadata for a payment. Custom fields can be configured either via the merchant dashboard or via the API endpoint Update Merchant UpdateOrderCustomFields action.

Custom fields are automatically included in settlement reports.

Copyright © April Solutions 2023. All right reserved.