This report shows your sales revenue grouped by the following:

  • Date
  • Sales Store
  • Product Brand
  • Product Tag
  • Order Tag
  • Order Status
  • Customer Country
  • Veeqo User
  • Wholesale Customer

 

Sales columns meaning

Dates

Date period of sales revenue.

Gross Sales
Sales revenue including sales tax, shipping revenue and discounts

Net Sales
Sales revenue including shipping revenue and discounts but excluding sales tax.

Total Tax
Total sales tax.

Shipping Revenue
Total shipping revenue for all your orders. This is already included in the sales revenue column.

Cost of goods sold
The total cost of all products sold. Using products average cost price, excluding any sales tax which is stored in Veeqo. Formula: Products average cost price * qty of items sold.

Gross profit
Sales revenue excluding sales tax - cost of goods sold. There is a switch to decide if shipping revenue should be included or excluded for this column.

Profit
Profit/sales revenue excluding sales tax.

Units Sold
The number of products/items sold.

Total Fees
Amazon and eBay fees. Amazon fees can take 2-4 days to appear after the order date.

Order Qty
The number of orders.

Average order value
Sales including sales tax / number of orders.

Report Views

When opening the Sales report, it defaults to the Overview view and grouped by Date / Time

The overview view gives you a summary of what your sales revenue is made up of, but if you want to more detailed trends of certain metrics (such as sales revenue) then change the view by clicking the Show dropdown.

Filters and options

To filter your sales data, use the left-hand panel to filter by:

  • Order Status
  • Store (Sales Channel)

Include shipping revenue in gross profit? This option allows you to decide if you want any shipping revenue included when we calculate your gross profit.

Filter your sales report by sales channel and order status

 

View a breakdown of your order

You can drill down to see the individual orders that make up the report data. Select a cell (the background turns blue) and then click it.

Scroll down the page you will see a new section called Order history has appeared which lists every order from that cell you clicked.

You can export all those orders by clicking the CSV button to the right.

 

  

How to use the date selector

You can select a date period to see your sales revenue for that and you can also choose to compare to a previous period.

Filter date ranges by:

  • Today
  • Yesterday
  • Last 7 days
  • Last 30 days
  • Last 90 days
  • Last month
  • Last 12 months
  • Week to date
  • Month to date
  • Year to date
  • Custom

To show a custom date range, select the dates you'd like to show in the calendar to switch to those dates: 

 

Comparing against the previous date period

When you choose a previous period to compare against you will see this data in a summary table in small grey font.

Choose from the following option to compare against.

  • Previous Day - The day before.
  • Previous Week - The same day (i.e. Monday) in the week before
  • Previous Month - The same date (i.e. 17th) in the previous month.
  • Previous Year - The same date (i.e. 17th) in the previous year.

Seeing your data grouped by day, week or month

You can change the graph and table to split any time periods into the following:

  • Day
  • Week
  • Month

Please note: If the text for any of these options is greyed out, they cannot be selected for the date range/data values. For example, if you select "Last 12 months" you can not choose "Day" as there is not enough room on the screen to show the data.

 

Sorting by column

Select a column header in the table to then sort the data by that column (highest value to lowest). Select the same header again to sort by lowest value to highest for that column.

 

Showing and hiding columns

Columns can be turned on / off to give you more space or if there are only certain data points you want to view.

(Please note: Turning columns off here will not affect the CSV export, all columns will be included in the export.)

Exporting sales data to a spreadsheet (CSV)

When exporting sales data, it is exported to a CSV file which you can view in a spreadsheet program such as MS Excel or Google Sheets.

There is the option to download the sales summary or the order history.

 

The summary will download a CSV spreadsheet file that includes:

  • The group by type you have selected
  • Gross Sales
  • Net Sales
  • Total Tax
  • Shipping Price
  • Sales Cost
  • Gross Profit
  • Profit Margin %
  • Units Sold
  • Total Fees

The order history will download a spreadsheet file that includes a full Order CSV export with all order details.

 

Important The order history CSV will be created in the background and be ready to download from the notifications bar when ready.

 

 

Sales by Date / Time

This report is the default OVERVIEW when the Sales Report is first opened. To return to this view, select OVERVIEW in the SHOW dropdown and DATE / TIME from the GROUP BY dropdown .

 

 

Sales by Channel

To view a breakdown per sales channel, select CHANNELS in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

When viewing the GROUP BY as CHANNEL, the left hand panel BY CHANNEL filter becomes unavailable. 

 

 

Sales by Product Brand

To view a breakdown per sales channel, select BRANDS in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

 

Sales by Product Tag

To view a breakdown per sales channel, select PRODUCT TAG in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

 

Sales by Order Tag

To view a breakdown per sales channel, select ORDER TAG in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

 

Sales by Order Status

To view a breakdown per sales channel, select ORDER STATUS in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

When viewing the GROUP BY as ORDER STATUS, the left hand panel BY STATUS filter becomes unavailable. 

 

Sales by Country

To view a breakdown per sales channel, select COUNTRY in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

 

 

Sales by User

To view a breakdown per sales channel, select USER in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the gross sales, shipping price, sales cost, gross profit, profit margin percent, units sold, total fees or net sales.

 

Did this answer your question?