How To

Payment Cleared Detail Report

The Payment Cleared Detail report provides product level detail transaction information for orders that have completed payment. This report is a more detailed version of the Payment Cleared report and can be used to relate product level performance to other reports or data sources.

 

Prerequisites


 

Notes on the Payment Cleared Detail Report:


  • Date range on the report refers to the date the payment cleared which may be different from the Invoice Date.
  • Invoices with multiple products sold will be reflected as multiple entries in this report. As a result it is expected that some invoice numbers will appear more than once.

The Payment Cleared Detail report includes the following columns:

Column Name
Description
Invoice NumberThe number assigned to this invoice.
InvoiceIDThis is a unique invoice identifier that is often (though not always) the same as Invoice Number. This internal InvoiceID is also used on the COP report.
Site NameThe location where the transaction took place.
eBay Seller IDFor eBay sales, this will indicate which eBay Seller ID did the sale.
Site Auction IDThe identifier associated with the listing on the specific site.
Invoice DateThe date the invoice has been produced.
Checkout DateThe date the checkout has been completed for the order.
Ship DateDate when the order was first shipped.
BuyerThe user ID of the Buyer, often the same as their e-mail address.
Buyer E-mail AddressThe e-mail address used by the buyer.
Ship To Last NameThe last name of the individual to whom items will be shipped.
Ship To First NameThe first name of the individual to whom items will be shipped.
Ship To AddressThe address where the items will be shipped.
Ship To CityThe city where the items will be shipped.
Ship To StateThe state where the items will be shipped.
Ship To Postal CodeThe postal code where the items will be shipped.
Ship To CountryThe country where the items will be shipped.
PhoneThe customer’s phone number (when applicable).
Payment MethodThe method used to pay for the order.
External Payment Transaction IDThis is the payment transaction identifier supplied by eBay. This field is frequently called "PayPal Transaction ID" however, it may also contain identifiers for credit card transactions.
SKUThe unique value assigned to the product.
ClassificationA grouping of like inventory items, allowing the user to manage groups of similar products.
TitleThe title of the invoice line item.
Quantity SoldThe quantity sold for the individual invoice line item.
PriceThe unit price for the individual invoice line item.
GMVThe extended amount for the line item (quantity multiplied by price).
Unit CostThe unit cost for the individual invoice line item.
Original CostThe extended cost for the individual line item (quantity multiplied by unit cost).
TaxThis is the tax on the ENTIRE invoice – though it is listed on each invoice line item. This field is correct, but is not well-represented in the report and can easily be misunderstood. If Item A has a sales tax of $1 and Item B has a sales tax of $2, then this field, for EACH line item, will display $3 (which is $1+$2). If you added your taxes for this transaction, you would come up with $6, which is double the actual tax of $3. If you add this field, you should only add it ONCE for each invoice – do NOT add it for each invoice line item. Please contact support if you have any questions.
Shipping & HandlingThis is the shipping and handling on the ENTIRE invoice. (See Tax notes.)
InsuranceThis is the Insurance on the ENTIRE invoice. (See Tax notes.)
Additional Cost/DiscountThis is the additional cost/discount on the ENTIRE invoice. (See Tax notes.)
RecyclingFeeThis is a fee that some retailers are required to collect for selling merchandise that will eventually become electronic waste. This fee does not apply to most transactions. "Recycling Fee" is also known as "e-waste tax" and "e-waste fee."
Promotion CodeThe promotion code used by the customer (if applicable).
Promotion ValueThis is the promotion value on the ENTIRE invoice. (See Tax notes.)
Distribution CenterThe warehouse or location the order is shipped from.

 

Reference


  • Glossary of Terms for definitions including formulas for calculations for each column of the report.

The Payment Cleared Detail report provides product level detail transaction information for orders that have completed payment. This report is a more detailed version of the Payment Cleared report and can be used to relate product level performance to other reports or data sources.

 

Prerequisites


 

Notes on the Payment Cleared Detail Report:


  • Date range on the report refers to the date the payment cleared which may be different from the Invoice Date.
  • Invoices with multiple products sold will be reflected as multiple entries in this report. As a result it is expected that some invoice numbers will appear more than once.

The Payment Cleared Detail report includes the following columns:

Column Name
Description
Invoice NumberThe number assigned to this invoice.
InvoiceIDThis is a unique invoice identifier that is often (though not always) the same as Invoice Number. This internal InvoiceID is also used on the COP report.
Site NameThe location where the transaction took place.
eBay Seller IDFor eBay sales, this will indicate which eBay Seller ID did the sale.
Site Auction IDThe identifier associated with the listing on the specific site.
Invoice DateThe date the invoice has been produced.
Checkout DateThe date the checkout has been completed for the order.
Ship DateDate when the order was first shipped.
BuyerThe user ID of the Buyer, often the same as their e-mail address.
Buyer E-mail AddressThe e-mail address used by the buyer.
Ship To Last NameThe last name of the individual to whom items will be shipped.
Ship To First NameThe first name of the individual to whom items will be shipped.
Ship To AddressThe address where the items will be shipped.
Ship To CityThe city where the items will be shipped.
Ship To StateThe state where the items will be shipped.
Ship To Postal CodeThe postal code where the items will be shipped.
Ship To CountryThe country where the items will be shipped.
PhoneThe customer’s phone number (when applicable).
Payment MethodThe method used to pay for the order.
External Payment Transaction IDThis is the payment transaction identifier supplied by eBay. This field is frequently called "PayPal Transaction ID" however, it may also contain identifiers for credit card transactions.
SKUThe unique value assigned to the product.
ClassificationA grouping of like inventory items, allowing the user to manage groups of similar products.
TitleThe title of the invoice line item.
Quantity SoldThe quantity sold for the individual invoice line item.
PriceThe unit price for the individual invoice line item.
GMVThe extended amount for the line item (quantity multiplied by price).
Unit CostThe unit cost for the individual invoice line item.
Original CostThe extended cost for the individual line item (quantity multiplied by unit cost).
TaxThis is the tax on the ENTIRE invoice – though it is listed on each invoice line item. This field is correct, but is not well-represented in the report and can easily be misunderstood. If Item A has a sales tax of $1 and Item B has a sales tax of $2, then this field, for EACH line item, will display $3 (which is $1+$2). If you added your taxes for this transaction, you would come up with $6, which is double the actual tax of $3. If you add this field, you should only add it ONCE for each invoice – do NOT add it for each invoice line item. Please contact support if you have any questions.
Shipping & HandlingThis is the shipping and handling on the ENTIRE invoice. (See Tax notes.)
InsuranceThis is the Insurance on the ENTIRE invoice. (See Tax notes.)
Additional Cost/DiscountThis is the additional cost/discount on the ENTIRE invoice. (See Tax notes.)
RecyclingFeeThis is a fee that some retailers are required to collect for selling merchandise that will eventually become electronic waste. This fee does not apply to most transactions. "Recycling Fee" is also known as "e-waste tax" and "e-waste fee."
Promotion CodeThe promotion code used by the customer (if applicable).
Promotion ValueThis is the promotion value on the ENTIRE invoice. (See Tax notes.)
Distribution CenterThe warehouse or location the order is shipped from.

 

Reference


  • Glossary of Terms for definitions including formulas for calculations for each column of the report.
0
Your rating: None Average: 2.5 (2 votes)
0
Your rating: None Average: 2.5 (2 votes)