Moment Financial Reports
Moment provides two types of financial reports:- Merchant Reconciliation Report: Lists all transactions processed by Moment during the previous day.
- Merchant Settlement Report: Summarizes transactions organized by settlement rather than a specific time period.
Common Use Cases
- Verifying transactions processed according to client expectations using daily and monthly reconciliation reports.
- Ensuring funds are processed and settled as expected using daily and monthly settlement reports.
1. Merchant Reconciliation Report
The Merchant Reconciliation Report lists all transactions for a merchant that were processed and closed during a given period (typically 24 hours). It includes:- Payment
File Structure
Below are the details of the Merchant Reconciliation Report1. File Name
A Merchant Reconciliation Report name follows this format:- FILE_GENERATION_DATE: The date the file is generated (YYYYMMDD format, e.g., 20241225).
- UNIQUE_FILE_IDENTIFIER: A fixed-value string identifying the system that produced the file.
- PERIOD_END_DATE: The end date of the reporting period (YYYYMMDD format, e.g., 20241225).
2. File Header
| Element | Value | Format | Notes |
|---|---|---|---|
| Report Title | Moment Merchant Reconciliation Report | [A-Z] | Fixed string. |
| Version | Report Version Number | [-~]; length: 20 | Matches the file format version. |
| Merchant | Merchant Alias | [-~]; length: 38 | Unique identifier for the merchant. |
| From | Start of the reporting period | Transactions from this date/time are included. | |
| Start Date | Period start date | Start of the reporting window. | |
| To | End of the reporting period | Transactions up to this date/time are included. | |
| End Date | Period end date | End of the reporting window. |
3. File Body
| Column Name | Field Name | Description | Value Type/ Format | Example Value |
|---|---|---|---|---|
| Transaction Type | transaction_type | The type of the transaction. | string | Payment, Refund |
| Transaction Timestamp | transaction_timestamp | The date and time when the transaction occurred. | datetime | 2024-01-31T14:30:00Z |
| Moment Transaction ID | reconciliation_id | ID of the transaction on the Moment platform. Use this as a reference when contacting our support team. | string | 673bbe2805368010f36e9bee |
| Merchant Reference ID | merchant_reference_id | The unique ID referencing the merchant used when creating the transaction on the Moment platform. | string | 672bbe2805368010f36e123e |
| Payment Method | payment_method | Name of the payment method type used when creating the transaction. | string | Capitec Pay |
| Tender Type | payment_method_tender | Name of the payment method tender used when creating the transaction. | string | Bank Transfer |
| Customer Reference | customer_reference | The unique ID referencing the merchant used when creating the transaction on the Moment platform. In this case, Sanlam policy number. | string | 123456789X1 |
| Country | country | The country where the funds of the transaction were collected from. | ISO 3166 alpha-2 | ZA |
| Presentment Currency | presentment_currency | The currency of the transaction collected from the payer. | 3-letter ISO 4217 code | ZAR |
| Presentment Amount | presentment_amount | The amount collected from the payer, in presentment currency. | decimal | 27.12 |
| Settlement Currency | settlement_currency | The currency of the payment that will be settled to the Moment merchant. | 3-letter ISO 4217 code | ZAR |
| Gross Settlement Amount | gross_settlement_amount | The amount of the payment that will be settled to the merchant, in settlement currency. | decimal | 120 |
| MDR % | mdr_percentage | MDR Percentage. | decimal | 10 |
| MDR | mdr | Merchant Discount Rate - charged to a merchant for the payment processing. | decimal | 12 |
| Fixed Fee | fixed_fee | Fixed fee charged. | decimal | 3 |
| FX Fee | fx_fee | FX Fee. | decimal | 0 |
| Total Fee | total_fee | The total fee charged. | decimal | 15 |
| Fee Currency | fee_currency | The currency of the fee. | 3-letter ISO 4217 code | ZAR |
| VAT Amount | vat_amount | VAT of the total fee amount charged. | decimal | 2.25 |
| Net Settlement Amount | net_settlement_amount | Net settlement amount that will be settled to Moment merchant. | decimal | 102.75 |
2. Moment Settlement Report
The Moment Settlement Report summarizes all settlements performed to the merchant during the period for which the report applies to. The report is generated only when settlement events occur. Details of the amount to be settled to the client’s bank account, on the day the report is generated.File Structure
Below are the details of the Merchant Settlement Report1. File Name
A Merchant Settlement Report name follows this format:- FILE_GENERATION_DATE: The date the file is generated (YYYYMMDD format, e.g., 20241225).
- UNIQUE_FILE_IDENTIFIER: A fixed-value string identifying the system that produced the file.
- PERIOD_END_DATE: The end date of the settlement period (YYYYMMDD format, e.g., 20241225).
2. File Body
| Column Name | Field Name | Description | Value Type/ Format | Example Value |
|---|---|---|---|---|
| Transaction Type | transaction_type | The type of the transaction. | string | Payment, Refund |
| Transaction Timestamp | transaction_timestamp | The date and time when the transaction occurred. | datetime | 2024-01-31T14:30:00Z |
| Moment Transaction ID | reconciliation_id | ID of the transaction on the Moment platform. Use this as a reference when contacting our support team. | string | 673bbe2805368010f36e9bee |
| Merchant Reference ID | merchant_reference_id | The unique ID referencing the merchant used when creating the transaction on the Moment platform. | string | 672bbe2805368010f36e123e |
| Payment Method | payment_method | Name of the payment method type used when creating the transaction. | string | Capitec Pay |
| Tender Type | payment_method_tender | Name of the payment method tender used when creating the transaction. | string | Bank Transfer |
| Customer Reference | customer_reference | The unique ID referencing the merchant used when creating the transaction on the Moment platform. In this case, Sanlam policy number. | string | 123456789X1 |
| Country | country | The country where the funds of the transaction were collected from. | ISO 3166 alpha-2 | ZA |
| Presentment Currency | presentment_currency | The currency of the transaction collected from the payer. | 3-letter ISO 4217 code | ZAR |
| Presentment Amount | presentment_amount | The amount collected from the payer, in presentment currency. | decimal | 27.12 |
| Settlement Currency | settlement_currency | The currency of the payment that will be settled to the Moment merchant. | 3-letter ISO 4217 code | ZAR |
| Gross Settlement Amount | gross_settlement_amount | The amount of the payment that will be settled to the merchant, in settlement currency. | decimal | 120 |
| MDR % | mdr_percentage | MDR Percentage. | decimal | 10 |
| MDR | mdr | Merchant Discount Rate - charged to a merchant for the payment processing. | decimal | 12 |
| Fixed Fee | fixed_fee | Fixed fee charged. | decimal | 3 |
| FX Fee | fx_fee | FX Fee. | decimal | 0 |
| Total Fee | total_fee | The total fee charged. | decimal | 15 |
| Fee Currency | fee_currency | The currency of the fee. | 3-letter ISO 4217 code | ZAR |
| VAT Amount | vat_amount | VAT of the total fee amount charged. | decimal | 2.25 |
| Net Settlement Amount | net_settlement_amount | Net settlement amount that will be settled to Moment merchant. | decimal | 102.75 |
| Settlement Batch ID | settlement_batch_id | The batch id of the settlement. | string | MOM-XXXXX-2024-05-25 |