Sample CSV Reports

Sample CSV Reports

Payment Activity Summary Report

The following Payment Activity Summary report shows all purchases and refunds, fees, and adjustments processed for the SampleMerchant merchant ID on July 29, 2008.


Payment Activity Summary, 1, SampleMerchant (101011000241000110001), 101000000000000000000, Jul 29 2008, Jul 29 2008 Refunds, Settled, MasterCard, 3, -21, USD Purchases, Settled, Subtotal, 5, 41, USD Purchases, Conveyed, Subtotal, 00, USD Refunds, Settled, Subtotal, 3, -21, USD Refunds, Conveyed, Subtota, l00, USD Net_Purchase_Refund, Settled, Subtota, 8, 20, USD Net_Purchase_Refund, Conveyed, Subtotal, 00, USD Fees, Settled, Subtotal, USD Chargebacks_Representments, Settled, MasterCard, 1, -10, USD Chargebacks_Representments, Settled, Subtotal, 1, -10, USD Net_Total, Settled, Total, 10, USD

Purchase & Refunds Report

The following Purchase & Refund Details Report lists transaction level data for all purchases and refunds processed by the SampleMerchant merchant for July 28, 2008.


request_id, cybs_mid, processor_mid, hierarchy_level, trans_ref_no, merchant_ref_no, transaction_type, submission_date,,,,,, 2.17272E+21, SampleMerchant, 8610000000000, 101011000000000000000, 20846410061, 33557799, Purchases, 7/28/2008, 10, USD, MasterCard, credit card, 444, 043631610, 7/28/2008, 2.17272E+21, 10, USD, 831000, 7/28/2008 14:04, 2500000000000000, 50, 1213, 5, 0, USD

Chargeback & Representment Details Report

The following Chargeback & Representment Details Report lists all chargeback and representment events that occurred for the SampleMerchant merchant on Juy 29, 2008.


orig_capture_request_id, cybs_mid, processor_mid, hierarchy_level, cybs_exception_id, processor_case_id,,,,,,,,,, 2.17271858000016E+21, SampleMerchant, 8610000000000, 101011000000000000000, 107459000000000000, 20980575494, 10, USD, 4387, DB, First Chargeback, 7/29/2008, 9/7/2008, MasterCard, 4444, 1.23456789012084E+22, Refund, 20846410061, 33557799, 10, USD, 7/28/2008, 1043631610, 7/28/2008, 1,

Transfer Log Report

The following Transfer Log Report provides a listing of all funds transfers posted to SampleMerchant’s bank account for July 29, 2008.


transfer_ref_no, origination_date, processor_mid, cybs_mid, effective_date, amount, currency_code, type_description, hierarchy_level, masked_dda, routing_number, transfer_method, acquirer 107526000000000000,7/29/2008, 8610000000000, SampleMerchant, 7/30/2008, -10, USD, Chargebacks/Representments, 101011000000000000000, xxxxxx7717, 26012881, ACH, CyberSource

Chargeback Analysis Report

The following Chargeback Analysis Report provides a summary of chargeback counts and amounts for a sample reason code for MasterCard.


Chargeback Anaylsis Report, 1, SampleMerchant (101011000031000110003), Sep 10 2008, MasterCard, 4387, test reason code, 2, 22, USD

Authorization Analysis Report

The following Authorization Analysis Report provides a summary of authorization counts and amounts for a sample reason code for American Express.


Authorization Anaylsis Report, 1, SampleMerchant (101011000031000110003), Oct 01 2008, Oct 30 2008, American Express, 234, test reason code, 1, 1, USD, 100, 100