Skip to main content

Payout analysis page - COGS turned off or missing product costs error

Daniel Little avatar
Written by Daniel Little
Updated this week

There are two error message that you may see on the payout analysis page:

This article will explain what these are and how to resolve them.

You do not have COGS tracking turned on

If you are seeing the message "You don't have COGS tracking turned on" as per the below screenshots, this means that you do not have our optional Cost of Goods Sold tracking enabled.

Screenshot of the 'Settlement Details' Analysis page in Link My Books for an Amazon EU Demo account. The dashboard displays metrics including sales (£18.59K), refunds (2.13% of sales), profit before COGS (£6,250), and profit margin before COGS (34%). Other figures shown are average order value (£24.68) and net profit (£6,250). A note at the bottom and within the 'Return on Investment' panel indicates that COGS tracking is not enabled. A P&L statement on the right outlines revenue and expense breakdowns.

Close-up screenshot from the Link My Books dashboard showing a notice under the 'Return on Investment' section. It reads: 'This section requires COGS tracking to be enabled, learn more here.' A similar message appears at the bottom of the page: 'You don’t have COGS tracking turned on, learn more here'.

If you'd like to bring this data through on the Payout Analysis page then you will need to turn on COGS tracking to bring this data through.

To do so head to Settings > Settlement Settings > Cost of Goods Sold where you can turn on Cost of Goods Sold and follow the instructions there.

Screenshot of the 'Settlement Settings' page in Link My Books, with the 'Cost of Goods Sold' tab selected. The option 'Turn on Cost of Goods Sold' is checked, enabling COGS tracking. The description explains that this setting allows the cost of items sold to be sent to QuickBooks as a separate bill, requiring users to enter product landed costs on the Product Costs page

You have missing product costs so these figures will not be accurate

If you are seeing the message "You have missing product costs so these figures will not be accurate" as per the below screenshots, this means that some of your products contained in this payout are missing product costs.

Screenshot of the 'Settlement Details' Analysis page in Link My Books for an Amazon EU Demo account. It displays sales data, refund percentage, profit after COGS (£6,250), profit margin (34%), return on investment (82%), and a detailed P&L statement. A red notice at the bottom states, 'You have missing product costs so these figures will not be accurate, learn more here'

Notification message in a red box stating: 'You have missing product costs so these figures will not be accurate,' followed by a blue hyperlink text 'learn more here'.

To enter your missing product costs head to Inventory > Product Costs where you can toggle to show just the SKUs with no product costs assigned to easily see which costs you need to add:

Product Costs page with a toggle switch labeled 'SHOW ONLY SKUS WITH NO COST' enabled. A red arrow points to a globe icon next to the toggle switch

What is COGS tracking?

Cost of Goods Sold tracking is a feature within Link My Books that allows you to keep a track of the cost of the units sold during any given settlement period. You can learn more about COGS tracking, how it works and how to set it up in this help article.

Why is this relevant to the payout analysis page?

If you don't have COGS tracking turned on or you have missing product costs, the figures shown on the payout analysis page will not show a true reflection of your profits or return on investment.

Profit before COGS

The Profit figure will show before COGS meaning it is a calculation of the following:

Sales

+ Other income (such as FBA inventory reimbursements)

- Refunds

- Fees

- Advertising costs

With COGS tracking enabled and set up with valid product costs, the calculation is as follows:

Sales

+ Other income (such as FBA inventory reimbursements)

- Refunds

- Fees

- Advertising costs

- Cost of goods sold

Profit margin before COGS

The Profit margin figure will show before COGS meaning it is a calculation of net profit (excluding COGS) divided by revenue and shown as a percentage.

Return on investment

If you don't have COGS tracking turned on the Return on investment (ROI) figure will not populate at all. This is because ROI figure is a calculation of net profit divided by the cost of goods sold and shown as a percentage.

With COGS tracking turned off, we can't calculate the ROI figure.

If you're missing product costs then we will calculate the ROI figure with those costs we do have, but it will therefore not be an accurate reflection of your true ROI since some product costs are missing.

If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].

Did this answer your question?