Kapoq uses the Finance API to pull in all payment transaction details and displays that information in a month view at the account level (Margin Details by Month) and SKU level (Margin Details by SKU). Within those tabs we also offer two different ways to review the information in the form of P&L and Classic.

For the most accurate margin calculations, we recommend ensuring your Cost of Goods are up to date. There are two options for updating your COGS. The first option is to set an account level COGS percentage that will calculate based on list price. We use this as the default value for any new accounts, and it's set at 20%. You also have the option to submit a bulk upload by SKU and choose between a percentage or a currency value. The bulk upload also has the added functionality of allowing you to provide a start date, so you can actually add historical COGS in this manner and we will apply them according to the date(s) provided.

Please note that the Finance API does not provide transaction period dates.

The Month tab allows you to view your finance data at an overall account level, allowing aggregation across multiple accounts by utilizing the Account filter in the top right. The brand filter does not have any effect here, as your account fees are shared across them regardless of how many brands exist in a single account. You'll be able to see all fees encompassing both account level and SKU level here.

The SKU tab allows you to dive down into specific items and view their performance over time. Account fees are not included here, as they come through as a lump sum and it's unclear how much should be applied and which SKUs they should be applied to.

The Classic View was the original version of the Margin Details by Month and SKU tabs, and offers a breakdown of SKU-level costs and margin side-by-side with account-level costs and margin. Detailed transaction types for each column can be viewed by selecting an underlined value in any column that contains it. In the Margin Details by Month tab for this view, you can also drill down to the SKU level and see performance over time without having to navigate to the Margin Details by SKU tab. When filtered to a SKU in Margin Details by Month, the Account Fees section will disappear. There is no side-by-side view of other months for Margin Details by SKU.

The P&L View is the newest version, and is closer to a true invoice-style layout. Each transaction type has its own line and is rolled up into a related transaction group. Users can use the carrots to expand or collapse these sections if they'd like to view all transaction details. We also display the trailing 12 months so you can easily identify areas that may need further attention; for Margin Details by SKU, this display only exists in the new P&L view.

Both of these options offer Excel exports that mimic their layout within the platform.

The Finance API provides us with two levels of transaction details - account and SKU. Account fees will encompass transaction types that come through as a lump sum with no SKU applied such as your monthly subscription fee. The following is a list of account level fees for reference:

It's worth noting that we pull in transaction data every day, but do not receive complete data for any open transaction periods. Amazon also does not provide transaction period dates via the Finance API, which is one of the reasons why we display the Margin Details tabs by month instead.

Advertising charges also do not flow through the Finance API if a seller is using a credit card as their payment option instead of deducting directly from the account. Because of this, Kapoq is supplementing that data in the Margin Details by Month view with the advertising invoice API to ensure all advertising charges are captured regardless of payment method. However, that data does not come through at the item level so we are using spend from the Advertising API for the Margin Details by SKU view which allows us to allocate by item. Note that the Product Ads Fee/Ad Spend amounts in the by SKU view do not necessarily reflect what was charged to the account for that month due to the difference in the data source.