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). Each page offers several tabs for reviewing that information, depending on whether you want to see what Amazon has released, what Amazon is still holding, or how your orders performed by order date.
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.
Margin Details by Month vs. by SKU
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.
Tabs
Margin Details by Month has four tabs: Released, All Deferred, Current Deferred, and Order Date View.
Margin Details by SKU has the same four tabs, plus SKU View and SKU Order Date View.
Released shows the transactions Amazon released and paid out during the selected month, regardless of when the original order was placed. This is the closest match to your Amazon payments report.
All Deferred is the log of every transaction Amazon placed on hold, both those still being held and those since released, shown in the month the deferral posted.
Current Deferred shows only the transactions Amazon is holding right now.
Order Date View organizes your transactions by the date the order was placed rather than the date the transaction posted, and combines released and deferred transactions into a single view. For more detail on how this tab works, see the Margin Details: Order Date View article.
SKU View shows all of your SKUs side by side in a column layout, by posted date, for the start and end months you select. You can select any underlined value to see the detailed transaction types behind it, or select the magnifying glass next to a SKU to open that SKU's Released P&L.
SKU Order Date View shows the same layout, organized by order date.
The Released, All Deferred, and Current Deferred tabs use an invoice-style P&L layout. Each transaction type has its own line and is rolled up into a related transaction group. Users can use the carets 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. On Margin Details by SKU, select a SKU at the top of the page to view its P&L, along with a chart of the line items you choose.
The P&L also includes an Unmapped Transactions line, on both Margin Details by Month and Margin Details by SKU, so transactions without an accounting mapping still count toward Net Profit instead of being left out. This line only appears when there are unmapped transactions for the selected period. To see it, along with any other line items that have no activity, turn on Display Empty Line Items from the gear icon next to Export to Excel.
These tabs offer Excel exports that mimic their layout within the platform. The combined released and deferred figures are also included in the Download All workbook and the Reporting margin exports.
For more on how released and deferred transactions work, see the Understanding Accounting Data in Kapoq article.
Account Fees vs. SKU Fees
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:
Amazon Subscription Fee
Coupon Redemption Fee
Customer Return Per Unit Fee
Early Review Enrollment Fee
FBA Inbound Convenience Fee
FBA Inbound Defect Fee
FBA Inbound Shipment Carton Level Info Fee
FBA Inbound Transportation Fee
FBA Inventory Storage Overage Fee
FBA Removal Fee
Misc Item Fee
Misc Item Fee - Returns
Prep Fee - Bubblewrap
Prep Fee - Labeling Fee
Prep Fee - Polybagging
Prep Fee - Returns
Prep Fee - Taping
Removal Order - Reimbursement
Return Shipping Compensation
Limitations
It's worth noting that we pull in transaction data every hour, 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.