The Tazapay settlements CSV file includes details like Settlement ID, Amount, Fees, and Dates, along with new fields* such as Destination Name, Country, Payment Counts, Gross Amounts, Net Amounts, and more, for comprehensive transaction tracking.
When you export a settlements CSV file from the Tazapay Dashboard, it contains several columns with detailed information about each transaction. Here's what each column represents:
Column | Definition |
---|---|
Settlement ID | Unique identifier for the settlement transaction. |
Status | Current status of the settlement transaction. |
Settlement Currency | The currency in which the settlement is made. |
Settlement Amount | The amount being settled, before fees are applied. |
Settlement Fees | Fees associated with the settlement transaction. |
Final Settlement Amount | The amount after the settlement fees have been deducted. This is the amount which a merchant spots in their bank account |
Settlement Date | The date when the settlement transaction was initiated by Tazapay |
Last Update Date | The most recent date on which the settlement details were updated. |
Destination Name | The name of the entity or account where the settlement is being sent. |
Destination Country | The country of the destination account. |
Destination Last4 | The last four digits of the destination account number. |
Total Payment Count | The total number of payments processed for the period of settlement |
Successful Payment Count | The number of payments that were successfully processed for the period of settlement |
Payment Gross | The total gross amount of payments before fees for the period of settlement |
Payment Fees | The total fees deducted from the payments. |
Payment Net | The net amount of payments after fees are deducted. |
Refund Count | The number of refunds processed for the period of settlement |
Refund Gross | The total gross amount of refunds before fees. |
Refund Fees | The total fees deducted from the refunds. |
Refund Net | The net amount of refunds after fees are deducted. |
Adjustment Count | The number of adjustments made to the settlements for the period of settlement |
Adjustment Net | The net amount after adjustments. |
Total Count | The total count of transactions including payments, refunds, and adjustments for the period of settlement |
Total Gross | The total gross amount of transactions before fees. |
Total Fees | The total amount of fees from all transactions. |
Total Settlement Fee | The total fees applied for the settlements made in a certain period. |
Total Net | The net amount after all fees and adjustments have been applied to the total gross amount. |