You can choose which columns show in a report, so you only see what matters to you.
How to add or remove a column
Open the Profit & Loss report.
Click Run Report.
Click Columns at the top right of the table.
Tick a column to show it. Untick it to hide it.
To move a column, drag its header.
Columns you can add
Product details
SKU, FNSKU, Item ID, Title, Store, Category and Sub Category, Fulfillment Channel, Season, Buyer and Order Type. Shopify stores get Gateway.
Item Category, Brand, Manufacturer and Vendor show when you pick ConnectStock customers or files, or display items by ConnectStock item name.
Sales and units
Net Sales: Sales minus refunds, plus or minus adjustments.
Total Units: units that actually moved in or out of your stock.
Order Count: number of orders (not units).
Ads
Ad Sales (same day), Ad Sales 7 Days and Ad Sales Same SKU.
TACOS: Ad Spend ÷ Sales.
POAS: Profit ÷ Ad Spend.
Organic Sales: Sales minus ad sales from the same day.
Amazon traffic
Page Views: how many times your listing was viewed.
Real Conversion Rate: orders ÷ sessions. (Conversion Rate, shown by default, counts units.)
Each fee on its own
Every fee your store has, such as the FBA fulfillment fee or the referral fee, can be its own column. The same goes for each type of sale, quantity, ad and cost. This list depends on what's in your store.
Frequently asked questions
I don't see a column listed here.
Some columns only show for certain stores. Fee columns only show for fees your store actually had.
Can I save my column setup?
Yes. Save it as a report template. See "Save and Update Report Templates".
What do the default columns mean?
