Profit and Loss Reports Overview

Profit and Loss Dashboard
The P&L Dashboard displays profit and loss - totals and per day, as well as the daily averages, across a selected time period. Only orders that have been shipped or paid are included in the Profit and Loss report. The dates used refer to the Ship Date.  
Please Note: These reports calculate the P&L of refunds etc to the ship date. To see P&L based on when the payment or refund occurred, use  the Transaction Reports.
  • Read how Item Cost is calculated here
  • Read how P&L is calculated and tracked on an order here
The dashboard can be be filtered by date range,as well as by Company, Channel, Purchaser, Manufacturer, and Vendor. The filter options set control the data display on all sections of the dashboard.
  1. Graph Chart - Displays profit per day, with total sales and total profit noted at the top. The percentage in the green or red box at the top right of the chart compares profit and loss from the selected date range to the prior identical period, e.g. - past 7 days compared to the prior 7 days. Click on the box to open a sub-dashboard that compares the profit  - total and per day - for the selected date range.  
  2. Pie Chart - Percentage of total profit per channel. Hover over section to reveal percentage and dollar value. Clicking on a channel section will display the details of profit and loss for that channel in the Graph Chart.
  3. Daily Averages
    • Daily Profit - Daily average profits for selected date range (Total profit / No.of sales). The percentage box indicates an increase or decrease in P&L from the prior period of similar range. For example, if profits are calculated for 7 days, it will compare to the 7 day period prior to that. Press on the percentage box to open a sub-dashboard that compares daily average profit.
    • No. of Orders - Daily average number of orders in selected date range. (No.of orders / No. of days).The percentages indicates an increase or decrease in No. of Orders from the previous period of similar range. For example, if No. of orders are calculated for 7 days, it will compare to the 7 day period prior to that. Press on the percentage box to open a sub-dashboard that compares daily No. of Orders.
    • Typical Order - Average profit per order in selected date range. (Average Daily Profit / Daily Average No. of Orders). The percentages indicates an increase or decrease in P&L from the previous period of similar range. For example, if profits are calculated for 7 days, it will compare to the 7 day period prior to that. Press on the percentage box to open a sub-dashboard that compares daily average profit per order.<
  4. Top 5 Products by Profit - displays 5 products that returned the highest profit in dollar value in the selected date range. Click on "View More" to see the full profit list.
  5. Top 5 Product by Profit Margin - displays 5 products that returned the highest profit margin in the selected date range. Click on "View More" to see the full profit list.

Profit and Loss Reports

Frequently Asked Questions About Reports:

Q:  What is the difference between ItemCost and ItemCostTotal?
A:  ItemCost is the cost of the items in the order: 
      ItemCostTotal = (ItemCost + Commission + ShippingCost + PostingFee + TransactionFee + Tax + PromotionCost) - (Adjustment + Rebate)

Q:  What is the difference between SubTotal and GrandTotal?
A:  SubTotal is the total amount of the items, before any discounts, shipping, tax etc.
      GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)

Q:  What is included in Fees?
A:  TransactionFee, PostingFee, Commission

Q:  What is Payment referring to?
A:  Payment is the actual amount that the customer paid. Usually, this will be the same amount as GrandTotal.

Q:  How is Gross Profit calculated?
A:  Profit = Payment - (Refunds + ItemCost + TotalFees)

Q: How Is Profit Margin calculated?
A: Profit Margin is calculated as the "Gross Profit Margin" - ((revenue - costs) / revenue) * 100. 

How did we do?