What do the columns in the exported settlement CSV file mean?

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.