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 columns that detail various aspects of sales and fees.
Item | The product being sold. |
Qty | The total quantity of items sold, returned, and adjusted. |
Gross Sales | The revenue generated from this item, excluding sales tax. |
Average sale price | The average selling price of the item. |
Return rate | The percentage of sold items that are returned. |
Merchant fees | The fees charged by the marketplace for sales. |
Other fees | Any additional fees, such as storage or handling fees. |
Ad Spend | The cost spent on advertising the item. |
Ad Sales | The total sales generated from ads within 14 days. |
Cost | The total cost to produce or acquire the item. |
Cost per item | The cost of this product per unit. |
Profit | The total profit made from selling the items. |
Profit per item | The profit made from each unit sold. |
ACOS | The % ratio of ad spend to sales generated from those ads. |
ROI | profit divided by cost × 100. |
Profit margin % | The % of sales remaining as profit after deducting all expenses. |
% of sales | Percentage of total sales attributed to this product. |
Detailed Breakdown:
To see the detailed breakdown of fees, and view any columns in greater detail select the + next to each item, and select the tab you want to view in detail.
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.