Read the selected form's result
Open Profit & Loss, choose one form and the date range. The heading describes Paid orders placed in this period, using the owner's timezone and including both selected dates.
Unpaid and partly paid orders remain visible and editable but do not contribute to the paid totals. Later invoice changes and refunds update the original order's result. A paid order that is later refunded or cancelled can retain incurred costs and show a loss.
Understand the calculation
- Net sales uses recorded sales after invoice reductions and completed refunds, counting each reduction once.
- Order costs are quantity × effective product unit cost, plus shipping, fee and other costs, minus cost credits.
- Profit is net sales minus order costs and dated form expenses, plus dated form credits.
Discounts, customer shipping charges and surcharges are already in the saved sale amount. They are shown in the expanded order without adding them again. What a customer paid for shipping is income; what you paid to ship is a cost.
Refunds do not automatically remove merchandise costs or return processor fees. A refund already reflected in a reduced invoice is not deducted a second time. For example, a 100 invoice reduced to 80 with 20 returned has 80 net sales. A separate 20 refund against an unchanged 100 sale also leaves 80.
Read incomplete values honestly
Profit is based on entered costs. Blank optional costs aren’t included, and you do not need to fill them all in. Optional costs lets you find entries you may want to add, with links to the exact input. Save a form default once to update matching orders. Review orders identifies actual payment or saved-cost conflicts that need attention.
A proof upload or Paid label alone is not proof of received money. The report reads recorded payment and seller collection-confirmation evidence. If payment or refund records cannot support a reliable answer, the affected sales/profit stays incomplete and needs review instead of being silently omitted. Refunds still owed are shown separately from completed refunds.
See profit by product or order
The Products tab shows Units ordered, Allocated sales, Total costs and Net profit, above the existing cost editor. Shared charges, refunds and expenses are divided automatically using saved product sales values. Product-specific discounts use their saved allocation when available; orders with all-zero product sales use quantities. These are allocated figures, not a claim that an unitemized cost belonged to one physical product. Not linked to a product keeps amounts without a reliable product match visible. Uncertain allocations remain incomplete.
Search shows a subtotal for matching products without redistributing other products’ costs. Header totals and downloads still cover the complete selected form/date range. Dated form expenses follow that full period, so changing dates can change a product’s expense share.
On the seller Orders page, expand an order to see Profit (entered costs). Choose Open in P&L beside the result to review that order or edit its costs. The Profit & Loss button opens the selected form's full report. Order profit includes the order’s costs; dated form expenses are included in the whole-form and allocated product report.
No orders, only unpaid orders, expense-only periods and break-even results are distinct states. An empty matching list is not automatically a zero-profit period.
Filters and downloads
Search and Optional costs not entered filter the visible orders. Header totals, Download Excel and Detailed CSV still cover the complete selected form/date range. Search products and sorting in Products only change that list; they do not change report totals or the download. If a range is too large to calculate safely, choose narrower dates; an oversized report does not return partial totals as if complete.
Excel opens on a Summary statement with the same complete product table, with Orders and Expenses on separate sheets. Orders appear once with their product, shipping, fee and adjustment details underneath. Only the order rows populate the Order sales, Order costs and Profit columns; detail costs do not repeat those totals. It is a snapshot of saved values. Unpaid rows have blank financial cells; unentered optional costs are not included, while uncertain saved amounts show Needs review. Very large amounts or quantities remain exact text with a notice instead of silently rounding. The optional Detailed CSV includes named Charge detail rows showing buyer charges and their costs. A line excluded by a manual total is marked Excluded by total override. Use the Order and TOTAL rows for CSV totals; detail rows explain them.
These are working reports: changing a product cost or shipping/fee default changes orders using it. Enter a separate order cost when that order needs a different value. There are no locked accounting periods or profit modes. The old Products, Orders and Business lenses have been replaced by this single report.
Removed orders remain in this workspace when their new P&L facts were retained at deletion. Only their original owner can use those retained records. Previously deleted orders from the retired P&L are not imported.