The ConnectBooks Profit & Loss (P&L) report gives you detailed information about each item in your e-commerce store. It shows all the fees for each item and lets you use filters to see how each item impacts your finances. This helps you understand the financial effect of every item you sell.

The report includes several default columns that detail various aspects of sales and fees.

Item	The product being sold.
Sales Qty	The total number of units sold (financial transactions).
Sales Amount	Total revenue generated from sales before refunds.
Refund Qty	The total number of units refunded (financial transactions).
Refund Amount	The total dollar amount refunded.
Net Sales	Sales Amount minus Refund Amount and adjustments.
Average Sale Price	The average selling price per unit (Sales Amount ÷ Sales Qty).
Return Rate	The percentage of sold units that were refunded.
Total Units	Net units that impacted inventory (Sales, refunds, adjustments etc. actual inventory movement).
Fees	All marketplace and related fees combined into one total column.
Ad Spend	The total cost spent on advertising the item.
Ad Sales	Sales generated from ads within 14 days of the ad click (standard attribution window).
Cost (COGS)	The total cost of goods sold for units that left inventory.
Cost per Item	The average cost per unit sold.
Profit	Net Sales minus Fees, Ad Spend, and Cost.
Profit per Item	Profit divided by Sales Qty.
ACOS	Ad Spend ÷ Ad Sales.
ROI	Profit ÷ Cost × 100.
Profit Margin %	Profit ÷ Net Sales × 100.
% of Sales	Percentage of total account sales attributed to this product.

Detailed Breakdown

To view a detailed breakdown for any item, click the + next to the product.

You’ll see two organized views:

Financial Transactions
Shows all financial activity, including Sales, Refunds, and Adjustments.
This reflects what happened from a dollar and transaction perspective (for example, 10 refunds issued).

COGS Transactions
Shows the actual inventory impact.
This reflects how many units physically moved in or out of inventory (for example, 7 units returned to stock).

This separation makes it easy to understand why financial quantities and inventory units may differ.

You can also see a breakdown of all fees in the fees column by clicking the fees box

Reports Used for P&L Generation

ConnectBooks utilizes multiple Amazon reports to generate a comprehensive P&L statement, ensuring every aspect of your Amazon sales and related expenses are accounted for. The key reports include:

Settlement Report: Captures overall transactions and account settlements.
Storage Report: Provides details about storage costs for inventory.
Advertising Report: Offers insights into advertising-related expenses.
Removal Report: Reflects item removal costs. These reports ensure a cohesive and accurate picture of revenue and expense dynamics.

Limitations

While ConnectBooks delivers comprehensive financial details, some limitations exist:

Certain fees, including Coupon Fees are not itemized due to restrictions in Amazon’s API data.
Bulk categorization is applied where individual itemization isn't available, particularly under "unitemized fees." These limitations should be kept in mind when interpreting specific financial details in your reports.

Discover how to customize and filter the Reports Here.

Customize Columns:

For your convenience, you can sort and rearrange all columns by dragging the header to your preferred spot.