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.
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.
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.