To download a detailed report for each pay period:
- Log in to your Merchant Toolkit.
- Go to the Account section.
- Under the Account section, select Payments.
- Use the tabs or the "Previous Period" and "Next Period" links to browse to the specific pay period.
- Click the Download CSV link to download the file for the relevant period.
This will give you a file in CSV (Comma-Separated Value) format, which you can open with any spreadsheet software, including Microsoft Excel, Apple Numbers, or Google Sheets.
The file will include every order that had any payment and/or fee for a given timeframe. For example the file would include an order that returned in the pay period, even if it was ordered in another, previous period.
(Check the Payment Schedule document for an explanation of how we assign payments and fees to specific pay periods.)
How to read the Payment Report
- Each row in the payment report represents one item from an order. An order containing 2 items will display as 2 distinct rows (see the Order ID listing, below, for more details).
- Product information, like SKU and Item Price, is recorded when the order is placed - subsequent product changes won't affect pre-existing order and payment data.
- All dates and times are in Eastern Standard Time, in MM/DD/YYYY format.
- For each order event (order, return, etc.) we've included 2 dates:
- The date when the event occurred
- The date of the affected payment, which we generally label the "processed date."
- MoreCommerce removes trailing zeroes from the cents on prices, so a $10.00 product would display an Item Price of 10 and a $0.40 fee would display a Total Fee of 0.4.
We've organized the columns in the sequence of their likely occurrence — the initial order, cancellations, shipments, returns, and return cancellations — with details for each step.
|The initial order|
|A||Order ID||102984483-2||For a multi-item order, you'll see a suffix like "-2" at the end of the Order ID to differentiate the items.|
|B||Order Source||OpenSky||The Site where the order was placed, e.g. OpenSky or Dot & Bo.|
|C||SKU||SHIRT-001||The product SKU.|
|D||Order Date||8/26/2016 2:54:30 PM||The date and time that the shopper placed the initial order.|
|E||Item Price||10.99||The Site Price for the item.|
|F||Shipping Price||10.99||The item's shipping price.|
|G||Handling Price||0||The item's handling price. We don't currently allow handling prices on products - this is included for merchants with old order data.|
|H||Credits||-10.99||The dollar amount of any credits that the shopper applied to the order.|
|I||Discounts||-10.99||The dollar amount of any discounts that the shopper applied to the order.|
|J||Sales Tax||10.99||The dollar amount of any sales tax that you charged for the order.|
|K||Item Total||10.99||The dollar amount paid by the shopper: item price + shipping price + handling price - credits - discounts + sales tax|
|L||Fee Date||9/15/2016 12:01:00 AM||Date when the fee is included in one of your payments; this will always be the 15th or last day of a month.|
|M||Credit Card Fee||-10.99||The dollar amount charged as a credit card processing fee.|
|N||Transaction Fee||-10.99||The dollar amount charged as a transaction fee; will only appear on orders placed on or after May 1, 2017 (when the fee agreement took effect).|
|O||Total Fee||-10.99||The total dollar amount for the credit card fee and transaction fee.|
|P||Commission||-10.99||The commission; will only appear on orders placed before May 1, 2017 (before the fee agreement took effect).|
|Cancellations, where applicable|
|Q||Cancelation Date||8/26/2016 2:54:30 PM||Date the order was canceled, whether by the shopper, us, or the merchant.|
|R||Cancelation Processed Date||9/15/2016 12:01:00 AM||Date when the cancellation refunds are included in one of your payments; this will always be the 15th or last day of a month.|
|S||Cancelation Refund - Credit card processing fee||10.99||Dollar amount refunded to the credit card processing fee due to the cancellation.|
|T||Cancelation refund - Transaction fee||10.99||Dollar amount refunded to the transaction fee due to the cancellation.|
|U||Shipment scan date||8/26/2016 2:54:30 PM||Recorded date of the order's shipment scanned and in motion.|
|V||Payment Date||9/15/2016 12:01:00 AM||Date when the order payment is paid to you; this will always be the 15th or last day of a month.|
|W||Payment||10.99||The dollar amount paid to you for the order.|
|Returns, where applicable|
|X||Return date||8/26/2016 2:54:30 PM||Date when the order return was processed.|
|Y||Return process date||9/15/2016 12:01:00 AM||Date when the return refunds are included in one of your payments; this will always be the 15th or last day of a month.|
|Z||Return refund - Transaction fee||10.99||Dollar amount refunded to the transaction fee due to the refund.|
|AA||Return deduction - Payment||-10.99||Dollar amount reduced from the payment due to the refund.|
|Return cancelations, where applicable|
|AB||Return cancelation date||8/26/2016 2:54:30 PM||Date when the order return cancellation was processed.|
|AC||Return cancelation process date||9/15/2016 12:01:00 AM||Date when the return cancellation fees and payments are included in one of your payments; this will always be the 15th or last day of a month.|
|AD||Return cancelation - Credit card processing fee||-10.99||Dollar amount charged as a credit card processing fee due to the return cancellation.|
|AE||Return cancelation - Transaction fee||-10.99||Dollar amount charged as a transaction fee due to the return cancellation.|
|AF||Return cancelation - Payment||10.99||Dollar amount paid due to the return cancellation.|
|AG||Total payment||10.99||Total dollar amount you've received for this order for all time. If you received payments and fees across multiple pay periods, they'll all be included in this column.|
|AH||Payment This Period||10.99||Total dollar amount you've received for this order for the specific pay period of this report (meaning the date for which you downloaded the CSV).|