This page's content:

Schema

The file is divided in 6 distinct sections. Every section starts with a header row, followed by content rows.

  1. Header: Contains all settlement data summarized into 1 row;
  2. Payments: N rows of payments data, where N is the number of payments in the settlement;
  3. Refunds: N rows of refunds data, where N is the number of refunds in the settlement;
  4. Chargebacks: N rows of chargebacks data, where N is the number of chargebacks in the settlement;
  5. Reversals: N rows of reversals data, where N is the number of reversals in the settlement;
  6. Payout Transfers: N rows of payouts data, where N is the number of payouts in the settlement.

Example:

settlement_code;settlement_currency;country;merchant_id;merchant_name;generate_date;settlement_date;transfer_date;receive_period_from;receive_period_to;nr_payments;nr_refunds;nr_chargebacks;nr_chargebacks_reversal;gross_total;net_total;chargeback_cost;chargeback_reversals_cost;refund_cost;refund_fee;anticipation_fee;boleto_fixed_fee;boleto_variable_fee;cc_fixed_fee;cc_variable_fee;eft_fixed_fee;eft_variable_fee;dd_fixed_fee;dd_variable_fee;return_mdr;amount_others;nr_payout_transfers;payout_transfer_cost
14-2045;USD;Brazil;20;"Demonstration Merchant";"2018-08-09 17:15:13";2018-08-11;2018-08-11;2012-01-02;2018-08-07;9;5;0;0;8732.65;7878.14;0;0;-545.45;-161.75;-2.53;-3.84;-47.15;-41.09;-10.69;-1.76;-0.65;0;0;0;-30;1;0
merchant;settlement;hash;merchant_payment_code;order_number;open_date;confirm_date;receive_date;payment_type;payment_id;customer;original_currency;original_amount;settlement_currency;fx_rate;amount_gross;amount_net;fee_percentual;fee_anticipation;fee_fixed;instalments
"Demonstration Merchant";14-2045;6266fdc145d39cc21920b09039f6f86a822334e21;10;;"2011-12-29 19:59:25";"2012-02-14 13:46:14";"2012-02-14 13:46:14";boleto;6;"ANTONIO MAGANHOTTE JUNIOR";USD;0.5;USD;1;0.5;0.49;0;0;0.01;1
"Demonstration Merchant";14-2045;a8ce6ccf02ba385683f6db8a81a009774e826b5d1;13;;"2012-01-02 19:54:44";"2012-01-02 19:57:44";"2012-01-02 19:57:44";itau;10;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;bdfac3d132ecf9bf3078bf142906d037fe90dcb97;14;;"2012-01-02 19:59:32";"2012-02-08 16:19:39";"2012-02-08 16:19:39";itau;11;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;105a5098312be83b8fe30ed2c10eef3fdaf5ec628d;19;;"2012-01-03 12:54:35";"2012-02-08 16:19:38";"2012-02-08 16:19:38";itau;16;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;110a98e126396a8ffff1b98064144712b6651d1e0b;20;;"2012-01-03 13:26:00";"2012-02-08 16:19:37";"2012-02-08 16:19:37";itau;17;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;13502689ab59db0c64ca65b228f757bd2ad56889cb;22;;"2012-01-04 12:15:04";"2012-01-04 12:17:36";"2012-01-04 12:17:36";itau;19;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;145e906672c6c6f6b873bded13a27ced6b5be4778f;23;;"2012-01-04 12:27:24";"2012-01-04 12:32:31";"2012-01-04 12:32:31";itau;20;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;1653a7191f9e42b9f222c80b4e5b19b613c2c5b7cc;25;;"2012-01-04 17:15:03";"2012-01-04 17:19:37";"2012-01-04 17:19:37";itau;22;"VICTOR EMANUEL SCHEMES DA SILVA";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
"Demonstration Merchant";14-2045;8feab22a094558e52024e928bf540083d1461ce39c;51;;"2012-01-10 18:36:17";"2012-01-10 18:37:52";"2012-01-10 18:37:52";bradesco;143;"JOAO GUILHERME DEL VALLE";USD;0.5;USD;1;0.5;0.47;0.01;0;0.02;1
merchant;settlement;refund_id;request_date;confirm_date;description;payment_hash;payment_merchant_payment_code;payment_order_number;payment_type;payment_customer;payment_open_date;payment_confirm_date;payment_receive_date;original_currency;original_amount;settlement_currency;fx_rate;amount_gross;amount_net;fee;return_mdr
"Demonstration Merchant";14-2045;318;"2013-04-16 16:39:02";"2013-04-25 12:58:12";"the customer does not want it anymore";7d1d2391f9d223086afb2b36d69c8a27258d2c8c57916;100100290;ON100100290;visa;"JOAO GUILHERME DEL VALLE";"2013-04-15 19:49:49";"2013-04-15 19:52:20";"2013-05-18 19:52:37";BRL;20;USD;3.9293;5.09;5.59;0.5;0
"Demonstration Merchant";14-2045;1044;"2013-08-29 22:01:57";"2013-08-29 22:02:30";1;bce4439e3835343120a92d3732c9af1575c4667f1d3c5;"AliPay Test 03";;boleto;"RAFAEL ROCCINI MELLO";"2013-08-19 20:51:54";"2013-08-20 10:43:29";"2013-08-20 10:43:29";BRL;0.11;USD;3.6667;0.03;0.13;0.1;0
"Demonstration Merchant";14-2045;1219;"2013-09-02 22:20:47";"2013-09-12 16:46:07";"teste rafa";bce21c2fe826a74632da157e1c98558b389ffdc72a0f8;"AliPay Test 01";;boleto;"RAFAEL ROCCINI MELLO";"2013-08-19 20:49:05";"2013-08-20 10:43:29";"2013-08-20 10:43:29";BRL;1;USD;4;0.25;0.35;0.1;0
"Demonstration Merchant";14-2045;3561;"2013-09-05 21:27:38";"2013-09-16 22:56:50";teste;d2cc5ba2a8b0800723708bc876a42bd6aa060fdd91bd4;111666666666802;ON111666666666802;boleto;"LICIANE CRISTINA ANDREATTA";"2013-08-28 17:09:18";"2013-08-28 17:14:14";"2013-08-28 17:14:14";BRL;0.1;USD;3.3333;0.03;0.13;0.1;0
"Demonstration Merchant";14-2045;3947;"2013-09-11 23:02:02";"2013-09-11 23:04:47";"teste depois do negocio";bce4439e3835343120a92d3732c9af1575c4667f1d3c5;"AliPay Test 03";;boleto;"RAFAEL ROCCINI MELLO";"2013-08-19 20:51:54";"2013-08-20 10:43:29";"2013-08-20 10:43:29";BRL;0.12;USD;4;0.03;0.13;0.1;0
merchant;settlement;chargeback_id;chargeback_date;description;reason_code;acquirer;nsu_doc;payment_hash;payment_merchant_payment_code;payment_order_number;payment_type;payment_customer;payment_open_date;payment_confirm_date;payment_receive_date;original_currency;original_amount;settlement_currency;fx_rate;amount_gross;amount_net
merchant;settlement;chargeback_id;open_date;time;confirm_date;receive_date;merchant_payment_code;order_number;currency_ext;amount_ext;payment_type_code;customer;settlement_id;hash;reversal_open_date;reversal_set_net;instalments
merchant;settlement;request_date;confirm_date;uid;external_reference;amount