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