Order-Based Profit Report

This feature allows you to download detailed order-based sales and expense data directly from the Store Overview page in MS Excel format, and now also in Google Sheets. Here’s everything you need to know to make the most of this powerful tool.

How to Access and Use the Export Feature

Downloading the Exported File

1. Navigate to the Store Overview page.
2. Locate the export buttons at the right corner of the Donut Charts on the Profit and Amazon Payout cards.
3. Select your preferred format: “Export as MS Excel” or “Export as Google Sheets.”
4. For Google Sheets, provide the email addresses associated with Google accounts to share and authorize viewing.

Viewing the Excel File

1. Download the file from the Store Overview page.
2. Open the file in Microsoft Excel.
3. Click “Enable Editing” to access the detailed data.

Viewing the Google Sheets File

1. Follow the prompts to share the Google Sheets file with the provided email addresses.
2. Access the file through the shared link sent to your email.

Understanding the Exported Data

The exported file includes two tabs: Analytics and Source Data.

Source Data Tab

This tab contains detailed sales and expense information for each order, providing a comprehensive overview of your store’s financials.

Here, you’ll find detailed sales and expense information for each order, including Amazon Order ID, Purchase Date, ASIN, SKU, Order Status, Item Status, Quantity, Principal Amount, Tax Amount, Shipping Amount, FBA/FBM breakdown, Product Cost, FBM Shipping, Additional Cost, Shipping to FBM, FBA Fee, Referral Fee. It also includes Store Level Advertising Cost, Total Storage Fee, and Other Store Level Fees to calculate profit in the selected period.

Analytics Tab

This tab provides a summarized and visualized representation of your sales, expenses, and profit information for the selected period. Key features include:

• Charts: Two types of charts that provide visual insights into your financial data.
• Pivot Tables: Filterable pivot tables that allow you to drill down into specific data points. These include:
  • Daily Sales and Profit: Daily breakdown of sales and profit.
  • Top Profitable ASINs: List of the most profitable products.
  • Most Profit Loss ASINs: List of products with the highest loss.

These tools are designed to give you deeper insights into your sales and expenses, enabling you to make informed decisions and grow your business effectively.

Additional Features

Google Sheets Reports

In addition to the Microsoft Excel format, you can now generate Google Sheets reports for both the Amazon Payout Export and Order-Based Profit Export. This feature allows for easy sharing and collaboration.

Tracking Report Generation

You can track the status of your report generation and access your reports through the report history page and the notification bell.

We hope these enhancements provide you with valuable insights to optimize your business operations. If you have any questions or need further assistance, please do not hesitate to contact our support team using the Chat with Us button on the right side of the page.