DataHawk Use Case: Track your Amazon Profit & Loss KPI's

Finding an appropriate Amazon profit and loss analytics tool can be tricky, but DataHawk can help. DataHawk’s Amazon Profit and Loss tracking tool allows you to easily monitor your seller profit on Amazon. 

Monitor your finances on Amazon with DataHawk's profit and loss solution

1. Do I need a Profit & Loss Finance Tool for My Amazon Business?

Our DataHawk data analysts asked hundreds of Amazon and Walmart sellers what their most pressing obstacle in growing their eCommerce business was. More than 80% of these sellers indicated they struggle with accounting and bookkeeping issues. 

Whether you are a new seller or an established brand, determining your true profitability on Amazon as well as other marketplaces can be difficult. 

Not many brands, agencies, and third-party (3P) sellers have a system in place to calculate and monitor their profit and loss metrics. Typically, your sales figures and generated profit fluctuate. Regardless of the key performance indicators (KPI) you use to measure your accomplishments, you need to understand what affects your Amazon profit and loss.

Amazon sales, costs, selling fees, Fulfillment by Amazon (FBA) fees, advertising costs, promotion discounts, and returns are all critical KPIs for measuring profitability and contribution margins. 

 

2.  What Is DataHawk’s Amazon Profit and Loss Dashboard?

DataHawk’s Profit and Loss metrics dashboard is a feature within the Amazon financial solution.  

Amazon Profit and Loss

As part of DataHawk’s Amazon Analytics Solution platform, this tool allows you to keep track of your money in and your money out to determine which of your financial actions will lead to higher and more consistent profits.

3. What is unique about the Profit and Loss dashboard?

This feature is a step up from using a simple top-line dashboard. It is a fully-pimped-out profit and loss tool that includes both top-line and bottom-line.

This product displays detailed information on business operations, income, and expenses, including hidden fees such as:

  • Amazon fees (e.g., FBA fee, commissions)
  • PPC spends, return costs, promotion costs, and your fixed costs
  • You can also view your profits and losses by time period, by account, and by marketplace

Specific Profit and Loss Dashboard features include

Specific Profit and Loss Dashboard features include
  • Fast sync
  • Examine profit and loss across multiple accounts
  • Sync profit and loss data automatically by connecting your seller central and advertising accounts
  • Historically blended with your cost of goods sold (COGS) import
  • Data can be exported to Excel for further analysis

These metrics can be computed by DataHawk’s software when you log in and connect your accounts.

To begin, you will want to log in to your DataHawk account, then open the Finance Analytics tool from the menu on the left-hand side. Once your accounts are connected, your profit and loss data will be ready and waiting for you. 

4.  Examine Seller Profit Analysis With DataHawk

Examine Seller Profit Analysis With DataHawk

DataHawk’s Profit and Loss dashboard provides you with an account-level view of sales, taxes, promotions, refunds, seller fees, and more. Follow the steps in the paragraph above to get started. 

Click here to see how you could connect your account to DataHawk for steller profit and loss reporting.

Below are DataHawk’s top use cases for Amazon Profit and Loss Monitoring.

5. The Amazon Profit and Loss Dashboard & sales performance

To effectively measure your profitability on Amazon, it is necessary to analyze every area of your Amazon business. DataHawk lets you explore essential information on a single dashboard that helps you make sense of your sales, profit, and expense numbers.

It allows you to look at the total product’s sales and revenue generated over a selected time period. To gain insight from this data and understand the peaks and troughs, you can look at the trend lines’ gross sales and units sold. 

For instance, the graph below indicates that sales were at their highest during thanksgiving week. It also demonstrates that throughout the month, sales are higher on weekdays than they are on weekends.

Simple analysis like this could help you make effective decisions regarding increasing PPC spending on specific days of the week.

Amazon Profit and Loss Dashboard for a snapshot of your sales performance

You can also conduct an Amazon seller profit analysis for the desired timeframe, marketplace as well as for the selected account or accounts together (only if each of your seller accounts is connected to DataHawk).

 Amazon seller profit analysis for the desired timeframe

Additionally, DataHawk’s Product Sales Report, accessible from within the Amazon Profit and Loss Dashboard, will help you analyze historical sales data related to each of your products and get the same insights from an ASIN perspective.

Amazon product sales report by DataHawk

6.  Take a Look at Your Amazon Fees

Analyze your Amazon seller fees to understand profit and loss

To do so, run a quick check over your Amazon fees and fulfillment fee to ensure you are not exceeding the decided threshold. 

 Looking at Amazon fees and fulfillment fee using DataHawk's profit and loss tool

Your Amazon revenue, along with the Amazon fee value, helps you benchmark performance targets and avoid any immediate losses. 

Additionally, other factors play a significant role in changing how your profits and loss statement on Amazon will look, refund, storage, and shipping.

7. Identify Expenses That Are Affecting Your Amazon Profits

  • A critical factor you should consider is the return rate and refunds.  
Analyzing return rate and refunds using DataHawk's Profit and Loss solution

DataHawk’s dashboard gives you a clear overview of: 

  • Returned Units
  • Return Rate
  • Commission (refund admin fee retained by Amazon for returned orders)
  • Referral Fees (reimbursed amount related to referral fees charged for returned orders)
  • Promotion (reimbursed amount related to promotional discounts charged for returned orders)
  • Refund Shipping Chargeback
  • Refund Shipping Promotion (reimbursed amount related to shipping promotion fees charged for returned orders)
  • Reversal Reimbursement (fees charged for the reversal of reimbursements that were given in error)
  • Tax (reimbursed amount related to taxes charged for returned orders)
  • Shipping (reimbursed amount related to shipping fees charged for returned orders)
  • Goodwill (concession given to a customer by Amazon on behalf of the merchant)
  • Total Reimbursed Amount
  • Gift Wrap Chargeback

Here is an example of the analysis you can make from the metrics: If you observe that the daily return rate is around 10%, you can determine how many stocks to order. Given that you already have the estimated sales refunded based on the return rate trend, day over day or month over month (more advisable), you can meet your revenue targets without any shortfall.

This will also help you establish when to order inventory from your suppliers without wasting any time waiting. 

The table above is valuable when it comes to detecting unusual transactions that would otherwise go unnoticed, for instance, “Goodwill amount.” Since Amazon is in charge of sending some extra cash to the “refund customer” on your behalf, it is easy for you to lose track of these pennies that Amazon owes you. With this tool, you can track them regularly.

Another important expense to consider is shipping and storage.

Shipping and storage costs analysis using profit and loss tool

When coupled with insights on return rate and stocks, you can determine the financial impact from each of the above factors and achieve your high-level targets with ease. 

But that is not all. There is another significant expense that needs regular monitoring and optimization. Keeping an eye on this expense is supercritical to increasing profits on Amazon.  

  • Amazon Advertising

Another critical factor to look at when monitoring your Amazon profit and loss

Another area worth examining when monitoring your Amazon profit and loss is comparing the growth of your expenses with the growth of your revenue. However, you must not let your high revenue hide the growth of your expenses. The problem occurs when your revenue growth rate is lower than your expense growth rate, and by the time you come around to tracking it, it is too late. A common outcome of this problem is the sheer fact that you end up losing money.

Advertising is one such area. As your revenue grows, you might be paying more for advertising. Therefore, comparing the growth curves of these two is very important. By doing this, you can make informed decisions about your advertising efforts on a brand, product line, or a particular ASIN. The goal is to find and maintain a healthy balance between revenue and expense growth. 

Amazon advertising costs analysis using DataHawk profit and loss analytics solution

With DataHawk’s Amazon Profit and Loss dashboard, you have a comprehensive overview of your advertising expenses along with your sales and revenue, all in the same table, making it easy to measure the efficacy of your advertising efforts at large. The dashboard also provides you with a breakdown of the total amount you spend on each advertising initiative, such as the type of advertising, sponsored products, sponsored brands, sponsored display, and sponsored brands video cost. 

And, if you want to dig deeper on an ASIN level, the dashboard also gives you access to an Amazon Sales and Ads History Report. 

DataHawk Profit and Loss Tool dashboard

The report combines historical changes of account-level sales and advertising metrics with monthly, weekly, and daily views. By combining account-level sales and advertising metrics in a centralized view, this report builds a dashboard that provides a comprehensive overview of selling performance efficiency after advertising spend and before any other costs. Analyzing these metrics correctly and correlating them helps you identify where to make improvements to optimize your ads and sales efficiency. Here is how you can “measure selling performance efficiency post ad spend using DataHawk.”

  • Cost of Goods Sold (COGS)

This aspect refers to the cost of procuring the product and getting the product to market. So, what should you be looking at?

  • Production costs
  • Procurement costs
  • Taxes and duties

When fully accounting for COGS, you should be adding those costs to the balance of the inventory asset in accrual accounting and reducing the inventory asset as you expense the COGS over time.

As an option, you can upload your COGS. You will see on the right-hand side a button that reads "import expenses."

How to import expenses on DataHawk in the Profit and Loss tool dashboard

This is where you can import excel files, for example, with your COGS so that DataHawk can work its magic. 

import excel files with your COGS on DataHawk

Do not be concerned if the data takes a few hours to upload- this is normal as it goes through massive amounts of datasets with a fine-tooth comb to provide relevant information. You can also filter your data to zoom in on specific metrics based on date, product, etc.

Download the template to have a look.

8. Compare Sales Metrics Across Amazon Marketplaces

Compare Sales Metrics Across Amazon Marketplaces

Once downloaded, your data is aggregated by international marketplaces. Depending on your selected date range, that data is automatically converted into a single currency based on the historic daily exchange rate. 

 

9. Additional Tips to Fix Your Profitability Leaks on Amazon

  • The SKU (stock keeping unit) quantity sent from your vendor is incorrect: Check to ensure that the amount you receive from your vendor is the same as the quantity you are expecting.
  • You do not receive your refunds: When a customer returns one of your products to Amazon, Amazon immediately refunds the customer the amount they paid for the item. However, your dedicated refunded payment never makes it back to your seller’s account.
  • Returned items that are lost or damaged: Occasionally, items returned by customers are either lost or damaged in transit, and the seller of those items never receives them.
  • Amazon does not receive your shipments in full: It is common for parts of your shipment to get lost or damaged along the way to Amazon’s fulfillment centers. Therefore, it is crucial to confirm that the SKUs you sent over to FBA correspond to Amazon’s shipment.

 Now that you are familiar with the most common profitability leaks and their necessary metrics, start tracking and calculating your exact profitability on Amazon to stay on top of the competition. 

10. Conclusion

To achieve profitability and maximize growth in eCommerce, you must understand each variable that impacts your profitability, from refunds to COGS. Doing so will help you optimize such efforts by proactively finding ways to increase revenue or reduce your costs.

DataHawk helps you stay aware of the impacts that specific costs and fees can have across every facet of your Amazon operation. Using our Amazon Profit and Loss Analysis lets you unveil how much additional overall profit you can capture on the marketplace — and scale accordingly.

Get the latest eCommerce and Amazon insights and trends delivered straight to your inbox


IE Notice
Please note that DataHawk no longer supports Internet Explorer.

We recommend upgrading to the latest Microsoft Edge, Google Chrome, or Firefox.