Sales Summary Report

Overview

In this article, you will learn about Sellercloud’s Sales Summary Report, which provides a detailed analysis of your sales data for a selected date or date range. You can summarize the report by:

Channel
Company
Manufacturer
Order Date
Product Group
Product Type
Purchaser
Sales Rep
Ship Date
Ship From Warehouse
Vendor
Wholesale Customer

The report includes key metrics, such as:

Sales: Units Sold and Number of Orders (When filtering by Channel or Company).
Revenue: Payment, Subtotal, Grand Total, Shipping, etc.
Profit: Profit and Profit Margin.
Costs: Items Cost, Total Fees, Tax Payables, etc.
Refunds: Cash Refunds or Accrual Refunds, Tax Refunds, etc.

You can run this report automatically on a regular basis with Scheduled Tasks.

For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the report:

Go to Reports > Sales > Sales Summary Report.
Select your date filters (Date Range or Date), and choose the right Date Type filter for your search. This filter affects which orders are returned by the search. Select Order to see sales data for orders placed in the selected range or Ship to see sales data for orders shipped in the selected range.
Set up the other Default or Custom filters for the report to show precisely what you need.
Click Search. Each filter you apply is highlighted in orange, and it turns green after you click Search. If a filter is gray or not displayed at all, it’s not active.
To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. This report allows showing up to 19 columns at a time. You can:
1. Reorder columns by dragging them up or down in the list.
2. Hide columns by clicking the Trash icons.
3. Add columns by clicking Add column.
To sort the data differently, use the Sort by menu.
To save your filtering and sorting options, click Save view, type a Name, and click Save.
To export the full report to a spreadsheet, click Actions on the bottom right and select Export to Excel. You can also export to CSV or PDF. Exports always include all columns, even those hidden in the grid due to the 19-column limit.

Filter Definitions

Default Filters


FILTER	DESCRIPTION
Company	Include only orders from one or more Companies.
Channel	Include only orders from one or more Channels.
Date Range	Select a preset time range from Yesterday to Last Year.
Date	Enter the Start and End dates. For a single date, choose the same Start and End date.
Date Type	Choose a date type based on which orders and their associated activity appear in the report: - Ship - View all orders and their associated activity where the Ship Date is in your selected range. - Order - View all orders and their associated activity where the Order Date is in your selected range.
Summarize By	Choose how to summarize sales in the report. Your choice will determine the grouping of the sales data.

Custom Filters


FILTER	DESCRIPTION
Accounting Basis	Choose how your profit is calculated. This filter also affects which columns appear in the report. - Cash - Show Cash Profit and Cash Profit Margin in the report. - Accrual - Show Accrual Profit and Accrual Profit Margin in the report. See Order Profit Calculation – Cash vs Accrual to learn about these options.
Brand	Include sales data only for products from one or more Brands.
Company Groups	Include sales data only for orders from one or more Company Groups.
Manufacturer	Include sales data only for products from one or more Manufacturers.
Order #	Include sales data only for specific order(s).
Product Groups	Include sales data only for products from one or more Product Groups.
Product Type	Include sales data only for products from one or more Product Types.
Purchaser	Include sales data only for products with a specific user assigned as Purchaser.
Settlement Status	Include sales data for Amazon, FBA, Walmart Marketplace, and WFS orders in one of two ways: - All Orders - Show sales data for all orders regardless of Settlement status. - Settled - Show sales data only for orders that have settlement data.
Show Precise Item Cost	Show the precise item cost up to 4 decimal places.
Vendor	Include only products that have their Default Vendor set to any of the selected.

Report Data


COLUMN	FIELD DATA	DESCRIPTION
Name of Summarize By	N/A	Shows how you are grouping the report data based on the Summarize By filter.
Orders	Count of OrderID	Shows the total number of orders.
Units	Sum of Qty	Shows the number of product units sold.
Subtotal	Sum of SubTotal	Shows the total amount of the items before any discounts, tax, shipping, etc.
Shipping Price	Sum of Shipping Price	The total amount paid for shipping all orders.
Tax	Sum of Tax Amount	The total tax collected for orders.
Discounts	Sum of Discount	Shows the total amount of all discounts applied to the orders.
Adjustments	Sum of P&L Adj	The sum of all positive and negative adjustment amounts applied to orders.
Items Cost	Sum of Item Cost	The sum of the Item Cost on sales minus the Item Cost on Returns received on orders shipped or placed in this date range.
Item Cost Total	Sum of Total Cost	Shows the sum of all item costs.
Total Fees	Sum of all Fees	Shows the total sum of all fees incurred for the orders.
Shipping Cost	Sum of Original Shipping Cost	Shows the sum of all costs for outbound shipping.
Gift Wrap Charge	Sum of Gift Wrap	The sum of charges for gift wrapping orders charged to the customer.
Handling Fee	Sum of Handling	The sum of all handling fees charged to the customer.
Insurance	Sum of Insurance	Shows the total amount charged to customers for order insurance.
Shipping Discount	Sum of Shipping Discount	Shows the sum of all shipping discounts.

Accounting-Specific Columns

The following columns appear by default depending on your configuration of a Client Setting called Accounting Basis. However, you can change which columns appear anytime by updating the Custom Filter.

Cash Columns

These columns appear only if you set the Accounting Basis Custom Filter to Cash:


COLUMN	FIELD DATA	DESCRIPTION
Cash Profit	(Payment – Refunds + Adjs) – TotalCost	The sum of your profit from all orders, recorded when the payment is received.
Cash Profit Margin	Cash Profit / (Payment – Refunds + Adjs)	Your overall profit margin from all orders.
Payment	Sum of Payments	Shows the sum of the actual amounts the buyers paid.
Refunds	Sum of Refunds	Shows the total refund amount from all orders.

Accrual Columns

These columns appear only if you set the Accounting Basis Custom Filter to Accrual:


COLUMN	FIELD DATA	DESCRIPTION
Accrual Profit	(Grand Total – Returns Grand Total) – Total Cost	The sum of your profit from all orders, recorded at the time of order.
Accrual Profit Margin	Accrual Profit / (Grand Total – Returns Grand Total)	Your overall profit margin from all orders, based on the Grand Total.
Grand Total	Sum of Grand Total	Shows the sum of all orders’ Grand Total.
Accrual Refunds	Sum of Accrual Refunds	Shows the Grand Total on items returned from all orders.