Received Transactions Report

GET

https://api.mpay.com.au/receivables/v6/report/{date}

Returns a report of all received transactions for the day with associated details, this includes Direct Entry and NPP Receivables. If requested multiple times on the current date (calendar day, AEDT), the report is cumulative. E.g. if, on the same day, a report is requested at 10am and another one at 1pm, the report at 1pm will contain all the transactions already contained in the 10am report, in addition to any new transactions. Direct Entry transactions arrive in batches 7 times throughout the day, 8.30am, 11.30am, 14.30pm, 17.30pm, 19.45pm, 21.45pm and 22.50pm (emergency), business days only. NPP Transactions may arrive at anytime, we recommend subscribing to a webhook to receive new transaction notifications.

The report is an application/octet-stream, columns are comma separated. Where a comma (,) or double quote (") is present in any of the below fields, the field will be encased in double quotes and/or escaped as per RFC4180.

Report format: https://developer.monoova.com/receivables-reporting#report-format

datestringRequired. Format: 'yyyyMMddHHmmss'. The date and time from which transactions are reported. This becomes the start date of the report if the report is being fetched for a date range.

endDatestringOptional. Format: 'yyyyMMddHHmmss'. Use this to fetch the report for a date range. When supplied, it is the inclusive end of the range that starts at the date path parameter.

skipstringOptional. Number of records to skip. 0 is the first record. Use together with take to page through large reports.

takestringConditional. Number of records to take. Conditional upper limit: if endDate is provided the maximum take is 10000.

accountNumberstringOptional. Payee bank account number. Filters the report to transactions received into this account.

clientUniqueIdstringOptional. The unique identifier for the account, as supplied by you when the account was created.

transactionTypestringOptional. Filters the report by rail. Possible values: 'DE' for Direct Entry or 'NPP' for New Payments Platform.

transactionCodestringConditional. Industry standard transaction code, only applicable when transactionType is 'DE'. Possible values: '13' for debit, '50' for credit. Refer to the Direct Entry standard for definitions 51-57.

payIdstringOptional. Email address for the PayID. Filters the report to transactions received against this PayID.

payIdNamestringOptional. Name displayed to the payers when they address a payment to the PayID.

200200 OK. Successful validation. The report was generated and returned.

400400 Bad Request. The request could not be processed because one or more supplied values are missing or incorrectly formatted, for example a date that does not match the required format.

401401 Unauthorized. Authentication failed. The API key passed as the basic authentication username is missing, invalid, or not permitted to access reporting.

500500 Internal Server Error. An unexpected error occurred while generating the report. Retry the request; if the error persists contact Monoova support quoting the status description.

curl --request GET \
     --url 'https://api.mpay.com.au/receivables/v6/report/{date}?endDate=20260824235959&skip=0&take=1000&accountNumber=410000123&clientUniqueId=CUID-000123&transactionType=NPP&transactionCode=50&payId=payments%40yourcompany.com.au&payIdName=Your%20Company%20Pty%20Ltd' \
     --header 'accept: application/json'