Transaction Details by Date

Overview

This report is a monthly report which provides revenue and expense transaction details by account.

For answers to general questions about using Sellercloud’s Financial Reporting Suite, see the Reports FAQs.

Filters

There are numerous filters to include the exact data you want in your report. Most filters offer single-choice and multiple-choice fields.

To access this report in Sellercloud:

  1. Go to Reports > Transaction > Transaction Details by Date.
  2. Choose your filters > Click Run Report.transaction details by date

 

After clicking Run Report to show these transactions, you can see each specific filter you applied. If a filter is not shown, you left it blank or choose All from the drop-down menu.

The table below defines each of these filters:

FILTER FILTER DESCRIPTION
Company Include only the orders from one or more companies, or include orders from all companies.
Company Groups* Include orders from only one group of companies, or include orders from all companies.

*This filter is only shown if you enabled the company group setting and grouped companies together. Learn how.

Channel Include only the orders from one or more sales channels, or include orders from all channels.
Date Range
  • Custom (default)- Enter the Start and End dates. For a single date, choose the same Start and End date.
  • Date ranges (presets) – There are 22 choices from Yesterday to the Last Year.
Start Date and End Date If you chose a custom date range, choose the starting and ending dates. (If you chose a default date range, these will auto-populate.)
Transaction type  Select a transaction type from the drop-down menu.
Manufacturer Filter by a specific manufacturer.
Settlement ID Filter by transactions from a specific settlement.
SKU Filter by specific or multiple SKUs.
Show products by Original (Shadow) SKU Show transactions for shadow products – TRUE/FALSE.
Show precise item cost (up to 4 decimal places) TRUE/FALSE.
Profit Calculation toggle Calculate profit in one of two ways:

  • Cash – Shows profit based on Payment of the orders.
  • Accrual – Shows profit based on Grand Total amount of the orders.

Note: If you choose Cash Profit, you can still see each order’s Accrual Profit by opening the order and hovering over Cash Profit on the P&L tab, and vice versa.

Orders Status toggle Include Amazon/FBA orders in one of two ways.

  • All Orders – Show profit for all orders regardless of settlement status.
  • Settled – Show profit only for orders that have settlement data.

The Grid Data

Take a look at a sample grid report:grid data transaction by date

You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon.export to excel 1

The table below defines each of these columns:

COLUMN DESCRIPTION
Transaction Date The date the transaction occurred.
Transaction Type
  • Order transactions – These are listed as either Debit or Credit
  • Non-order transactions – These are listed individually by transaction type; for example, Warehouse Lost, Warehouse Damage, FBA Disposal Fee, FBA Inbound Shipping Cost, Product Ad, etc.
Movement Type The specific movement type (Order, PO, etc.).
Order #  Sellercloud’s order number.
Order Date The date the order was placed.
Ship Date The date the order was shipped.
Channel The channel for the transaction.
Channel Order # The channel order number.
Order Subtype The order subtype.
SKU Product number.
Qty The total quantity of items sold.
Subtotal The total amount of the items before any discounts, shipping, tax, etc.
Shipping The amount the buyer paid for shipping on the order.
Tax The amount the buyer paid for tax on the order.
Other Charges Total handling, insurance, gift wrap, discount, and shipping discount.
Grand Total The total amount of the order.

Grand Total = (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).

*Only shown if you set the filter’s Profit Calculation toggle to Accrual.

Payments The actual amount the buyer paid (usually the same amount as Grand Total unless there was an underpayment or overpayment).

*Only shown if you set the filter’s Profit Calculation toggle to Cash.

Refunds* Total refund amount from orders.

*Only shown if you set the filter’s Profit Calculation toggle to Cash.

Items Cost Cost of the items on the order.

Items Cost is based on A) The item cost on the Order Date, and B) The method used to calculate cost, which is determined by the Client Setting Order Profit & Loss Calculated Using (either Average Cost, Site Cost, or Last Cost). Here’s how P&L is calculated and tracked on an order.

Watch how Sellercloud calculates item cost.

If the cost of an item on an order is manually changed, follow these steps to have the updated cost reflected in the order’s profit and loss.
Shipping Cost Cost for outbound shipping.

  • For FBA – This includes the following types of fees: FBA Per Unit Fulfillment Fee, FBA Weight Based Fee, FBA Per Order Fulfillment Fee, Shipping Chargeback, Gift Wrap Chargeback, and Cross-Border Fulfillment Fee.
Commission Channel selling fees.
Total Fees Total of shipping cost, commission (channel selling fee), transaction fees (Paypal processing fee), posting fees (eBay listing fee and Reverb bump fee), dropship fees, co-op fees, and tax payable.
Other Channel Fees Non-order-related transaction fees, including:

  • FBA disposal
  • FBA inbound shipping
  • Amazon product ads’ per-day Spend amount (if imported from Seller Central’s Sponsored Product Ad report)
  • Product-related transactions from the Amazon and eBay settlement reports
Profit Profit in $. Either Cash Profit or Accrual Profit based on your filter toggle.

The Spreadsheet Data

Exported spreadsheets include more data than the grid report. Spreadsheets also let you manipulate data, such as filter within a column, sort with advanced parameters, etc. You can even create custom bar graphs and pie charts; for example, to show daily sales trends for a selected date range.spreadsheet transaction

The table below defines each of these columns:

COLUMN DESCRIPTION
Transaction ID Unique transaction number.
Transaction Date Date the transaction occurred.
Transaction Type
  • Order transactions – These are listed as Debit or Credit
  • Non-order transactions – These are listed individually by transaction type; for example, Warehouse Lost, Warehouse Damage, FBA Disposal Fee, FBA Inbound Shipping Cost, Product Ad, etc.
Movement Type The specific movement type (Order, PO, etc.).
Order # Unique order identification number in Sellercloud.
Order Date Date the order was placed.
Ship Date Date the order shipped.
Channel Source of the order.
Channel Order # Unique order number from the channel.
Channel Order # (2) The second unique order number from the channel.
Order Subtype Description of the order type.
OrderSubtypeEnum The order subtype.
Marketing Source Shows the source of the marketing.
Settlement ID ID for Amazon/FBA, eBay, and Newegg settlements.
SCSettlementID The settlement ID that Sellercloud has received.
Company ID Unique number of the company.
Company Company name.
Order Item ID Unique number of the order item.
Product ID Unique number of the product.
Original Product ID Unique number of original product.
SKU* Unique stock keeping unit (SKU) code assigned to the product.

*For shadow products: This is the parent SKU; whereas, this is the original shadow SKU if Show Product by Original (Shadow) SKU is checked.

Original Shadow SKU* The original orders’ shadow SKU.

*Only shown if the Show Products by Original (Shadow) SKU filter is unchecked.

Parent SKU* The orders’ parent SKU.

*Only shown if the Show Products by Original (Shadow) SKU filter is checked.

Product Name The name of the product.
Product Type Category associated with the product.
Vendor Vendor associated with the product.
Manufacturer Manufacturer associated with the product.
Brand Brand associated with the product.
ASIN Amazon Standard Identification Number.

*Only populated if your Channel filter includes Amazon.

Ship From Warehouse Warehouse from which the product shipped.
Sales Rep Sales representative assigned to the order.
Sales Rep (2)* Secondary sales representative.

*Only shown if you select Enable Multiple Sales Reps in the Client Settings.

Purchaser Purchaser associated with the product.
Units The number of units.
NonOrder Qty Product quantity that’s not on an order.
Unit Price Price of a single item.
Subtotal The total amount of the items before any discounts, tax, shipping, etc.
Shipping The amount the buyer paid for shipping on the order.
Tax ​The amount the buyer paid for tax on the order.
Handling The amount the buyer paid for handling the order.
Insurance The amount the buyer paid for insurance on the order.
Gift Wrap The amount the buyer paid for gift wrap on the order.
Discount Amount of discount applied to the order.
Shipping Discount Amount of discount applied to the shipping.
Other Charges ​Total handling, insurance, gift wrap, discount, and shipping discount.
Grand Total The total amount of the order. Unlike the grid, this appears if the filter’s Profit Calculation toggle is set to Cash or Accrual.

Grand Total = (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount). 

Accrual Refund Refund based on the accrual calculation.
Payments The actual amount the buyer paid (usually the same amount as Grand Total unless there was an underpayment or overpayment).

Unlike the grid report, this appears whether you set the filter’s Profit Calculation toggle to Cash or Accrual.

Refunds Total refunds amount from orders.

Unlike the grid report, this appears whether you set the filter’s Profit Calculation toggle to Cash or Accrual.

Adjustments Adjustments, either positive or negative, to orders.
Items Cost Cost of the items on the order.

Items Cost is based on A) The item cost on the Order Date, and B) The method used to calculate cost, which is determined by the Client Setting Order Profit & Loss Calculated Using (either Average Cost, Site Cost, or Last Cost). Here’s how P&L is calculated and tracked on an order.

Watch how Sellercloud calculates item cost.

If the cost of an item on an order is manually changed, follow these steps to have the updated cost reflected in the order’s profit and loss.
Items Rebate Incentive amount the vendor reimburses for a product’s promotion.
Shipping Cost The cost of outbound shipping.

  • For FBA – This includes the following fee types: FBA Per Unit Fulfillment Fee, FBA Weight Based Fee, FBA Per Order Fulfillment Fee, Shipping Chargeback, Gift Wrap Chargeback, and Cross-Border Fulfillment Fee.
Commission Commission fees from orders.
Transaction Fee Paypal processing fee.
Posting Fee eBay listing fee and Reverb bump fee.
Dropship Fee Vendor dropship fee.
Co-Op Fee Allowance fee from select channels.
Tax Payable Tax payable portion of the order.
Total Fees Total of shipping cost, commission (channel selling fee), transaction fees (Paypal processing fee), posting fees (eBay listing fee and Reverb bump fee), dropship feesco-op fees, and tax payable.
Item Cost Total Calculation: (Item Cost – Rebate) + Shipping Cost + Commission + Transaction Fee + Posting Fee + Dropship Fee + ​Co-Op Fee​ + Tax Payable).
Other Channel Fees Non-order-related transaction fees, including:

  • FBA disposal
  • FBA inbound shipping
  • Amazon product ads’ per-day “Spend” amount (if imported from Seller Central’s Sponsored Product Ad report)
  • Product-related transactions from the Amazon and eBay settlement reports
Accrual Profit This is based on the Grand Total amount of an order.

Accrual Profit calculation: Sum(Grand Total) – (Item Cost + Total Fees) + Adjustments + Other Channel Fees.

Cash Profit This is based on the Payment amount of an order.

 

Cash Profit calculation: (Payment – Refunds) – (Item Cost + Total Fees) + Adjustments.

Accrual Profit Margin Accrual Profit Margin calculation: (Sum(Grand Total) – (Order Cost Total + Adjustments)) / Sum(Grand Total) * 100.

 

Note: Sum(Grand Total) = Order Grand Total – Return Grand Total.

Cash Profit Margin Cash Profit Margin calculation: ((Payments – Refunds) – (Order Cost Total + Adjustments)) / (Payments – Refunds) * 100.

 

Was this article helpful?

Related Articles