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
![Document image Document image](https://images.archbee.com/qnusS2w7bjJqCW9OlUPrb/TkmXtc8mW8v_dXpRPb5Ja_screenshot-2024-02-18-at-53608-pm.png?format=webp)
Choose the file to be opened:
![Document image Document image](https://images.archbee.com/qnusS2w7bjJqCW9OlUPrb/H46aIca5OikKDdc1ZiTiX_screenshot-2024-02-18-at-53636-pm.png?format=webp)
Choose Delimited and change File Origin to Unicode (UTF-8)
![Document image Document image](https://images.archbee.com/qnusS2w7bjJqCW9OlUPrb/tvWINmkr_0FwkmumU-AfF_screenshot-2024-02-18-at-53648-pm.png?format=webp)
Chnage Delimiters to Commaand click Finish
![Document image Document image](https://images.archbee.com/qnusS2w7bjJqCW9OlUPrb/zeYcbNkNAguPpJIRgnkl6_screenshot-2024-02-18-at-53659-pm.png?format=webp)
Now click import
![Document image Document image](https://images.archbee.com/qnusS2w7bjJqCW9OlUPrb/AGnCObOR5L8etBdnLDRgq_screenshot-2024-02-18-at-53707-pm.png?format=webp)
Updated 18 Feb 2024
Did this page help you?