Profit Tracking
Profit Tracking creates a profit and loss view for a selected period. sellerfox combines revenue, Amazon fees, and refunds from your Amazon order and transaction data with the COGS, income, expenses, and FBM costs you maintain.
Owners and Admins can edit COGS, income, expenses, and FBM cost rules. Viewers can use Profit Tracking and export COGS, but Viewers cannot import, edit, or reset costs. See the Permissions matrix for details.
Check the profit calculation for completeness
Check these inputs first:
- Every sold SKU has COGS configured for the full evaluation period on each marketplace. The badge on the “COGS” tab shows how many SKUs still have no value.
- Business overhead is recorded under “Income & Expenses”.
- Merchant-fulfilled pick, pack, return, and shipping rules are configured where they apply.
- Settings → Workspace → Input VAT recoverable matches your tax status. When enabled, Profit Tracking uses VAT-bearing P&L costs net of VAT. Otherwise, VAT remains part of the cost.
- Recent Amazon fees can still be estimates, and advertising follows its own daily refresh.
During the initial order and transaction import, Profit Tracking displays a notice with the current progress. The figures remain incomplete until the import finishes.
Missing costs are not deducted
sellerfox does not substitute a value for a cost you have not entered. Net profit will therefore be too high until you add the missing cost.
Read the profit overview
Select a period
Choose one of the preset period tiles or a “Custom” range. The start and end of the period follow your browser's time zone.
The percentage beside “Sales” compares each tile with its own previous period, not with the neighboring tile. Calendar ranges use the preceding calendar period. Rolling and custom ranges use the immediately preceding range of the same length.
Refunds appear in the settlement period
sellerfox assigns refunds to their Amazon settlement period, not the order date. You cannot change this assignment.
Understand the profit tiers
The “Default” view shows the headline figures. “Waterfall table” shows the full calculation from Gross Revenue to Net Profit. Select “%” to switch between amounts and each row's share of net revenue.
Gross Revenue is not Sales (Total)
Gross Revenue is based on orders. Sales (Total) comes from the Sales & Traffic Business Report. The values can therefore differ.
The four result rows progressively deduct further costs from revenue. This shows where margin is created or lost:
Net revenue after refunds and promotions, minus COGS. DB1 shows the margin before Amazon fees, shipping, gift wrap, advertising, and other costs.
DB1 minus Amazon fees, shipping, and gift wrap. DB2 shows the margin after these deductions, but before advertising and other costs.
DB2 minus ad spend. DB3 shows the margin after advertising, but before other costs. When ad spend cannot be determined for a row, as with SKU rows in the overview table, sellerfox shows "–" instead of a result that excludes the ad budget.
DB3 minus other costs. Net Profit is the result after the last cost tier in the Waterfall table. When ad spend cannot be determined for a row, as with SKU rows in the overview table, sellerfox shows "–" instead of a result that excludes the ad budget.
Inspect cost details
Expand a cost row with an arrow in the waterfall view to see its subcategories. You can click subcategories that have a dot in front of them.
The modal uses the profit overview's date range and filters. The filters determine which entries appear, but each entry retains its full original amount. With marketplace or product filters, the waterfall table instead includes only the share allocated to the selection. For example, an expense of EUR 90 assigned to DE, FR, and IT appears as EUR 90 in the modal but contributes only its allocated share of EUR 30 to a profit overview filtered to DE.
Read grouped values correctly
You can group the table by marketplace, SKU, Child ASIN, Parent ASIN, or product list.
The full cost scope is available only in the unfiltered marketplace view
Only marketplace grouping without additional marketplace or product filters contains the full cost scope. Product-based rows include only values that sellerfox can attribute to that product, so they do not form a complete P&L.
The displayed total row is calculated separately. If you add the detail rows yourself, the result can differ from that total depending on the grouping:
- When grouping by SKU, Child ASIN, or Parent ASIN, an order can be counted in multiple rows. For example, an order containing two different SKUs contributes to
Ordersin both SKU rows, but only once in the total row. - When grouping by product list, every product-related KPI value can appear more than once because a product can belong to multiple lists. sellerfox therefore does not show a total row for this grouping.
| Display | Meaning |
|---|---|
| “Not assignable to any row shown” | costs or revenue that cannot be assigned to the current grouping |
– | the value cannot be determined at this grouping; the dash does not mean 0 |
0.00 | the calculated value is 0; this does not confirm that all costs and data are complete |
Unassigned amounts are already included in the total row. Do not add “Not assignable to any row shown” to that total again. Averages and percentages from individual rows cannot be added to produce a total either.
Ad spend, DB3 (Marketing Margin), and Net Profit are unavailable at SKU level because Amazon reports ad spend per ASIN, not per SKU. sellerfox therefore cannot reliably determine an individual SKU's share. You can use Child ASIN grouping for a product-level view of ad spend; only the unfiltered marketplace view contains the full cost scope.
When you filter by specific marketplaces or products, sellerfox includes only costs that can be assigned to that selection. General costs may therefore be missing from the filtered view. Check your income and expense allocation before comparing filtered figures.
Compare Profit KPIs over time
Choose a period tile, then select “Show development over time”. The chart uses exactly that tile's period and the active marketplace and product filters. The chart does not show a comparison period.
The chart starts with Gross Revenue. Use “Add KPI” to combine up to three available Profit KPIs, change the KPI order, and display each KPI as a line or column. The initial granularity follows the period tile. You can switch between “Hour”, “Day”, “Week”, and “Month”.
“Hour” is available only for periods of up to 14 days. Ad spend and manually entered income and expenses are available only by day, so KPIs that depend on those daily figures cannot display an hourly line. sellerfox marks the affected KPIs in the chart and recommends switching to “Day”.
With hourly granularity, values for the current day may appear with a delay of up to 15 minutes. The data status in the chart shows the latest time included.
Enter COGS per SKU
COGS is the cost per unit sold, not the purchase value of an entire shipment. You maintain it per SKU and marketplace. Ten variants with one SKU each on a single marketplace therefore need ten entries. The same SKU on two marketplaces needs a separate entry for each marketplace.
Enter the unit cost exactly as it should be included in the P&L.
Open the cost list and date points
The “COGS” tab lists your workspace's SKUs.
The list shows the value of the latest configured date point. The cost applied to an order depends on its order date instead. To find missing costs, filter the view by “Missing” under “COGS status”.
Click a row or select “Edit COGS” to open the SKU's configured COGS:
- “Beginning” has no date and applies before the next date point.
- “Add date point” sets a further value. The new value applies from its “Effective from” date, inclusive, through the day before the next date point.
- Use the trash icon beside a dated point to remove it. The preceding value then continues until the next remaining date point.
Changing an existing date point changes the COGS and profit of affected past orders. To keep earlier costs unchanged, retain the existing date points and add a new one.
Select checkboxes and reset costs
Use the checkboxes in the list to select those SKUs whose configured COGS you want to delete completely. The export function is not affected by this selection and follows the active filters instead. You cannot select SKUs without configured COGS.
The header checkbox selects the currently loaded rows with costs. Scrolling loads more rows, so this does not automatically select every SKU in the workspace. Check the displayed selection count before choosing “Reset COGS”.
Resetting removes the entire cost history
After confirmation, “Reset COGS” removes every date point for the selected SKUs. This also applies when resetting a single SKU in its edit dialog and cannot be undone. Export the costs first if you want to keep a backup.
Currencies when entering costs
When you enter COGS directly in sellerfox, the workspace currency applies.
For a file import, set each row's currency in Currency. A blank cell also uses the workspace currency.
Imported COGS retain their original currency when you edit them later. To change the currency, re-import the same date point.
sellerfox converts the source currency to the target currency using the cost date point. See Currency conversion for details.
Import and export COGS
Use the export as a template to maintain many SKUs or cost periods at once:
- Set the filters on the “COGS” tab and select “Export”. The export follows these filters, not the checkboxes.
- Open the CSV or XLSX file. Change only costs, effective dates, and currencies where needed. Leave the reference columns unchanged.
- Duplicate a SKU's row to add further cost periods.
- Select “Import”, upload the file, and review the preview, particularly removals and invalid rows.
- Select “Start import” and wait for the result. Check the affected products even if the import was partly successful. Then reload the profit overview.
Multiple periods in one file
The same SKU can appear more than once in the file when its rows describe different cost date points. Copy the exported row, including all reference columns. Keep the ASIN, SKU, and marketplace unchanged; edit Effective From (YYYY-MM-DD), COGS, and, if needed, Currency.
This example shows three rows for the same SKU on the same marketplace. Only the editable columns are shown here for clarity; keep every column in the import file:
| Effective From (YYYY-MM-DD) | COGS | Currency | Applies to |
|---|---|---|---|
| leave blank | 8.00 | EUR | beginning through March 31, 2026 |
| 2026-04-01 | 9.50 | EUR | April 1 through June 30, 2026 |
| 2026-07-01 | 10.00 | EUR | July 1, 2026 onward |
There is no end date to enter: the next date point ends the preceding period. Use only one row per date point for each SKU and marketplace.
Add, change, or remove existing values
The import merges with stored COGS:
| Change in the file | Result |
|---|---|
| New date point for a SKU | adds to its history |
| Existing date point with a different amount or currency | updates that date point |
| SKU or date point absent from the file | remains unchanged |
COGS is 0 | sets a unit cost of 0 |
COGS is blank | removes the SKU's entire cost history |
A blank COGS cell is a removal instruction
Do not leave COGS blank to skip a row. Remove the whole row from the file instead. To reset a SKU, use a single row without mixing it with new cost date points for that SKU.
The preview classifies each row as an update, new entry, removal, product not found, invalid, or unchanged.
If a row fails validation or currency conversion, sellerfox applies none of the rows for the same ASIN on that marketplace. This can affect multiple SKUs. Other products continue to import.
Correct the affected rows and import them again. After a general error, check the stored date points first: the import does not automatically roll back every change already applied. See COGS import troubleshooting for further help.
File format and columns
You can import one CSV or XLSX file up to 10 MB. CSV files must use semicolons as delimiters. You can use a comma or period as the decimal separator, but thousands separators are not supported.
The current export format contains these columns:
| Header | Edit? | Purpose |
|---|---|---|
ASIN (readonly) | no | product identity |
SKU (readonly) | no | SKU identity |
Marketplace (readonly) | no | marketplace identity |
Product Name (readonly) | no | reference only |
Effective From (YYYY-MM-DD) | yes | date point; blank means “Beginning” |
COGS | yes | unit cost as a plain number |
Currency | yes | three-letter source-currency code |
Converted COGS (readonly) | no | converted reference value |
Converted Currency (readonly) | no | workspace target currency |
Leave every column marked (readonly) unchanged.
Currency conversion
If the COGS currency differs from the Workspace currency, the COGS are converted into the Workspace currency for analysis. For a dated COGS point, sellerfox prefers the closing rate for its “Effective from” date. If the closing rate is unavailable, it uses that day's midday rate or the latest available closing or midday rate from the two preceding days. “Beginning” uses the earliest available rate. The converted export columns are for reference only; edit the amount in COGS and the source currency in Currency.
Record income and expenses
Use “Income & Expenses” to record amounts Amazon does not report, such as software, accounting, agency fees, or one-time adjustments.
| View | What it shows |
|---|---|
| “Automatic” | entries reported by Amazon; they are not editable |
| “Manual” | entries you recorded and entries already generated from recurring templates |
| “Scheduled” | daily, weekly, or monthly templates for further entries |
Create an entry
- Select “Add expense” and “One-time”.
- Choose “Income” or “Expense” as the type, then enter a date and title.
- Enter “Net amount” and “VAT” as monetary amounts, not a tax rate. For EUR 100 net plus EUR 19 tax, enter 100 and 19.
- Select the category and choose the marketplaces or SKUs the amount applies to.
- Save the entry.
The entry list shows the gross amount: EUR 119 in this example. The P&L includes EUR 100 with input VAT recoverable enabled, or EUR 119 otherwise. This is why the list amount can differ from the profit overview.
Allocate amounts
| Scope | Effect on the analysis |
|---|---|
| All marketplaces | a general workspace amount; not split across individual marketplaces or products |
| Selected marketplaces | divided evenly among the selected marketplaces |
| Selected SKUs | divided evenly among the selected SKUs |
For example, an expense of EUR 90 assigned to DE, FR, and IT contributes EUR 30 to each marketplace. Assigned to all marketplaces instead, the EUR 90 remains a general workspace amount. It is excluded from a view filtered by specific marketplaces or products, even if you select several marketplaces.
Manage categories
Under “Manage P&L categories”, create, rename, or delete your own cost categories, or assign them to a P&L “Main category”. This assignment determines the profit tier at which entries are included. Changing the assignment also applies to existing entries.
Deleting a category does not delete its entries. Without that assignment, they appear under “Other Costs”. Amazon-defined categories do not appear in this dialog; automatically recorded entries cannot be edited.
Manage recurring entries
Choose “Recurring” when creating an entry, then set “Start date” and “Frequency”. The template appears under “Scheduled”, while generated entries appear under “Manual”.
- Daily: one entry per day.
- Weekly: on the start date's weekday.
- Monthly: on the start date's day of the month. If that day does not exist, sellerfox uses the last day of the month, such as February 28 instead of the 31st.
If the start date is in the past, creating the template generates the start-date entry. The intervening recurrences are not filled in automatically. Check historical expenses and add missing entries individually.
Edit the template under “Scheduled” to change future entries. Entries already generated remain unchanged; edit an individual entry under “Manual”.
When deleting the template, choose between:
- “Stop future expenses”: ends the recurrence and keeps every entry already generated.
- “Delete all expenses”: removes the template and every entry generated from it.
Set your own FBM costs
Use Profit Tracking Settings to configure merchant-fulfilled costs. These rules apply only to FBM. For FBA, sellerfox uses the fees reported by Amazon.
Pick & Pack
On the “Pick & Pack Costs (FBM)” tab, configure order handling and packing:
| Input | Calculation |
|---|---|
| “Processing fee per order” | once per order |
| “First pick” | once per order |
| “Each additional unit” | per unit after the first, regardless of the number of distinct SKUs |
| “Carton”, “Flyer”, “Packing service” | each configured amount added once per order |
For example, three units incur one first pick and two additional units. This applies to three units of the same SKU as well as three different SKUs.
Return costs
On the “Return costs” tab, configure handling and return-label costs once per refunded order, plus a cost per refunded unit. Multiple return shipments for one order do not incur the fixed fees more than once.
sellerfox estimates return costs from the refunded quantity reported by Amazon. This does not mean that the items were actually returned. If Amazon reports no refunded unit, for example for a price-only adjustment, no return costs are estimated.
Shipping templates and priority
Open the “Shipping costs” tab and select “Create First Template”, or “Add Template” if templates already exist:
- Name the template.
- Choose the marketplaces, destination countries, and products it covers. With a restricted product selection, every product in the order must be included.
- Choose a flat rate, weight tiers, or size tiers, and enter the costs.
- Save the template and check its position in the list.
sellerfox checks active templates from top to bottom. The first matching template applies; matching prices are neither added together nor compared to find the cheapest. Drag active templates into the desired order. Inactive templates are skipped.
If no template matches, the “Default Template” applies to all marketplaces, destinations, and products. If its price is set to 0, sellerfox includes no estimated shipping costs.
When Amazon has reported actual shipping-label costs for an order, sellerfox does not also deduct the estimated FBM shipping amount for that order. Pick & Pack costs are unaffected.
Weight and size tiers
| Method | Value used |
|---|---|
| Flat rate | one amount per order |
| Weight-based | sum of the weights of all units in the order, in grams |
| Size-based | the largest single product dimension, in centimeters; not the sum of dimensions or a parcel volume |
A tier includes both its lower and upper bound. If the value falls outside every tier, sellerfox checks the next template and finally the default template.
Missing weights or dimensions do not automatically exclude a template. Missing values contribute nothing to the combined weight or largest dimension, so a tier that is too low may match. Check the product data and the simulator result.
Price changes and earlier orders
Use “Add rate change” to set a new price from its “Effective from” date. Keep existing prices if earlier orders should remain unchanged. Editing or removing an existing price can also change profit for past periods.
Changes trigger recalculation of the affected estimated FBM costs. See Changes to costs for when to check the new values.
Simulate shipping costs
Use the Shipping Cost Simulator to check a configuration: select products, a “Marketplace”, and a “Destination”, then choose “Calculate Shipping”. The result names the template that applied, the tier that matched, and the reason any template was skipped.
The simulator uses today's date and one unit of each selected product. The simulator therefore does not recreate a specific historical order. To compare the result with an earlier order, account for that order's date, quantities, and the prices that applied then.
Where the figures come from
Changes to costs
The time needed for a cost update depends on the amount of data. After changes to FBM cost rules, an orange update banner indicates that recalculation is still running:
| Change | Typical time and completion signal |
|---|---|
| COGS saved, imported, or reset | usually within a few seconds for an individual change and within a few minutes for a larger import; wait for the operation to finish successfully, then reopen or reload the profit overview |
| Income or expense saved | usually within a few minutes; the entry appears in the list first and is then reflected in the profit overview |
| FBM cost rules changed | usually within a few minutes, but longer for large data volumes; recalculation is still running while the orange update banner is visible |
For COGS, the update is part of saving or importing. You do not need to wait after the success message.
During the FBM update, estimated costs may still be incomplete. If neither the orange nor a red banner appears after reloading, the update has finished. A red banner means the update failed; the last known values may still contain old costs. Follow FBM update troubleshooting.
Amazon data and your own inputs
| Input | Source and timing |
|---|---|
| Revenue, order fees, refunds | Amazon order and transaction data; final fees can replace estimates later |
| Other Amazon charges | if Amazon identifies a specific marketplace or product for a charge, sellerfox assigns it accordingly |
| Advertising | the daily Ads API refresh; Profit Tracking does not trigger an extra advertising refresh |
| COGS, income, expenses, FBM rules | entered by workspace users; nothing is assumed when a value is absent |
See Data refresh schedule for schedules and history ranges, and the KPI Explorer for exact Profit KPI definitions.
Use the MCP server to analyze profit and costs through an authorized AI client. The guide explains how to connect the client and what limits apply to cost attribution.
Related
- Orders — inspect the individual order behind a period figure.
- Seller Central comparison — reconcile date, scope, attribution, currency, and freshness.
- Permissions — who may change Profit Tracking inputs.
- Profit Tracking troubleshooting — check import errors, profit differences, missing entries, and shipping rules.