While the Settlement Report provides this for each settlement batch on a transaction level (for each merchant account), the aggregate settlement report can be run both on merchant account and company account level. It includes all batches closed in the chosen period, summarized by merchant account, store, payment method, the day of sale and settlement batch.
...
All Settlement reports are also available as Recon Report to reconcile the previous day or any other given timeframe. See details below the table
Sample Reports:
MERCHANT_XXX_AGGREGATED_SETTLEMENT_report_2018-06-01.csv
MERCHANT_XXX_SETTLEMENT_CUSTOM_report_2018-07-11.csv
MERCHANT_XXX_daily_FRAUDREPORT_report_2018-07-27.csv
MERCHANT_XXX_daily_PAYMENT_report_2018-07-18.csv
MERCHANT_XXX_daily_CHARGEBACK_report_2018-07-18.csv
Report Type | Description | Syntax | Frequency | Date / Time Frame | Date Range Sample | Report generated at time |
---|---|---|---|---|---|---|
Settlement Report -31 days | This report is being used when the settlement happens after the regular acquirer settlement in Brazil which is 30 days after the transaction has happened. At PrimeiroPay we pay you on the 30th day from 3pm UTC to the next day 3pm UTC. As a part of our Transparency policy trading will happen at 3pm UTC daily, so you can monitor the FX rates. | MerchantID_ReportID_SETTLEMENT_PREVIOUS_24_FULL_HOURS_MINUS_31_DAYS_report_YYYY-MM-DD.csv The time stamp in the report name refers to when the transaction happened, not to the date when the report was generated Every Monday the report syntax changes to as there is no FX trading possible during the weekend. | Daily on weekdays after initial 31 days | 31 days before report generated Timeframe fixed to: 3pm UTC to 3pm UTC next day | Report Date: October 1 Transaction Date: July 31 3pm UTC to August 1 3pm UTC | 3.00-3.59pm |
Settlement Report previous day | As a part of our Transparency policy trading will happen at 3pm UTC daily, so you can monitor the FX rates. That means transactions will include transactions from the previous day 3pm to today 3pm Fields in a settlement report: | MerchantID_ReportID_SETTLEMENT_PREVIOUS_24_FULL_HOURS_report_YYYY-MM-DD.csv Every Monday the report syntax changes to | Daily on weekdays | Timeframe fixed to: 3pm UTCp previous day to 3pm UTC today | Report Date: October 2 Transaction Date: October 1 3pm UTC to October 2 3pm UTC | 3.00-3.59pm |
Settlement Report previous half month | Settlement that happens bi-weekly without the 30 day delay of settlement of the acquirer Fields in a settlement report: | MerchantID_ReportID_SETTLEMENT_PREVIOUS_HALF_MONTH_report_YYYY-MM-DD | Bi-weekly | 24hrs | Transactions between October 1 to October 15 when report runs on Oct 16 | 8.00-8.59am |
Settlement Report previous month | Settlement that happens for all transactions of the previous month without the 30 day delay of settlement of the acquirer Fields in a settlement report: | MerchantID_ReportID_SETTLEMENT_SETTLEMENT_PREVIOUS_MONTH_report_YYYY-MM-DD | monthly, 10th of each month | 24hrs | All transactions of the previous calendar month | 8.00-8.59am |
Settlement Report month before previous month | Regular settlement term for a full calendar month after funds are received in full from the acquirer for that calendar month Fields in a settlement report: | MerchantID_ReportID_SETTLEMENT_MONTH_BEFORE_PREVIOUS_MONTH_report_YYYY-MM-DD | monthly, 10th of each month | 24hrs | Report Date: October 1 Transaction Date: August 1 to August 31 | 5.00-5.59pm |
Settlement Report half month before previous month | Settlement that happens bi-weekly after the full refunds are received from the acquirer Fields in a settlement report: | MerchantID_ReportID_SETTLEMENT_PREVIOUS_PREVIOUS_PREVIOUS_HALF_MONTH_report_YYYY-MM-DD | Bi-weekly | 24hrs | Report Date: October 1 Transaction Date: August 16 to August 31 | 9.00-9.59am |
Chargeback & Refund Report | The chargeback report is a report that contains all Chargebacks and Refunds to reconsile / treat them. Refunds also may happen due to Fraud Alerts (see below) Fields in a payment reports: PSP Transaction ID,Merchant Transaction ID,Payment Brand,Purchase Amount,Purchase Currency,Net AmountNet, CurrencyTransaction, Timestamp,Country Code, Refund Reason | Merchantname_ReportID_daily_CHARGEBACK_report_YYYY-MM-DD | Daily | Previous day (24hrs) | Report Date October 2 Transaction Date: October 1 00.00 UTC to 23.59 UTC | 7.00-7.59am UTC |
Payment Report | The payment report gives an overview about successful transactions of the previous day. It does not contain any information on Foreign Exchange, Commission (Processing Fee) or any other additional information a Settlement Report provides. Fields in a payment reports: PSP Transaction ID,Merchant Transaction ID,Payment Brand,Purchase Amount,Purchase Currency,Net AmountNet, CurrencyTransaction, Timestamp,Country Code | Merchantname_ReportID_daily_PAYMENT_report_YYYY-MM-DD | Daily | Previous day (24hrs) | Report Date October 2 Transaction Date: October 1 00.00 UTC to 23.59 UTC | 5.00-5.59am UTC |
Aggregated Settlement Report | The aggregate settlement detail report provides a summary specification of all settlements, for example, funds paid out by us in a certain period. It is intended to allow you to perform balance-level reconciliation of funds received against the day of sale. | any |
...