Settlements
File Format
3min
The settlement file provided by Moyasar is a CSV file (Comma Separated Values) encoded using UTF-8.
This file contains the following columns:
Column | Possible Values |
---|---|
payment_id | UUID v4 |
description | Text |
scheme | visa, mastercard, mada, amex |
source | Credit Card, Apple Pay |
type | pay or refund |
currency | ISO 4217 Currency Code |
amount | Payment amount |
net_amount | Amount after taking out fees |
fee | Transaction fee |
vat | Value Added Tax |
total_fee | Fee including VAT |
transaction_date | Transaction date (UTC) |
To open the CSV file in excel, please follow these steps:
Open a new empty document in Excel, the click on Data -> Get Data -> From Text

Choose the file to be opened:

Choose Delimited and change File Origin to Unicode (UTF-8)

Chnage Delimiters to Commaand click Finish

Now click import

Updated 18 Feb 2024
Did this page help you?