How to Account for FBA Fees Per SKU: Step-by-Step

Table of Contents

• Why FBA Fees Per SKU Break Your Profitability Numbers
• What You'll Need Before You Start
• Step 1: Pull Your FBA Fees Per SKU from the Fee Preview Report
  • Reading the Fee Preview Columns
• Step 2: Break Down Amazon FBA Fees by Product
  • Referral Fees and How They Are Calculated
  • Fulfillment Fees by Size Tier and Weight
• Step 3: Cross-Check Estimates With an Amazon FBA Fee Calculator
• Step 4: Post Fees to Your Books With a Per-SKU Accounting Workflow
  • Map Each Fee Type to a Chart-of-Accounts Line
  • The Monthly Posting Sequence
  • Sample Journal Entries
  • Handling Refunds, Reimbursements, and Adjustments
  • Why Automation Matters Here
• Step 5: Amazon Settlement Report Reconciliation for Every SKU
• Step 6: Build a Repeatable Amazon SKU Profitability Review
  • The Per-Unit Profit Formula
  • Worked Example: Three SKUs, Three Outcomes
  • Spreadsheet Formulas You Can Paste In
  • Bulk SKU Analysis: Scaling Past 50 SKUs
  • A Reusable Template Structure
• Frequently Asked Questions

Last Updated: October 14, 2026

Why FBA Fees Per SKU Break Your Profitability Numbers

Most sellers treat FBA fees as one lump expense, hiding which products actually make money. Amazon charges fees at the SKU level, so your books should match, otherwise a losing product can look like a winner for months.

After 15 years in ecommerce operations, the pattern is always the same: sellers who track fees per SKU find margin others miss.

The core problem:

• Amazon reports fees per SKU, per transaction
• Most bookkeeping tools lump them into one account
• You cannot fix a margin problem you cannot see

This guide walks through six steps, from rough estimate to reconciled numbers.

What You'll Need Before You Start

Gather four things before you touch a spreadsheet:

• Seller Central access with Reports permissions
• Your fee preview report, downloaded as a CSV
• Your cost of goods sold and landed cost per SKU

Landed cost is the total you pay to get one unit into a warehouse: product cost, freight, duties, and prep.

The IRS recordkeeping guidance for small business recommends keeping supporting documents for every transaction you record. Fee reports count as supporting documents.

Step 1: Pull Your FBA Fees Per SKU from the Fee Preview Report

The fee preview report shows estimated fees for every active SKU. Sort by SKU, each row lists one product with its estimated referral fee, fulfillment fee, and total.

Reading the Fee Preview Columns

Four columns matter most: SKU and ASIN identify the product, referral fee shows the category-based cut, fulfillment fee shows the pick, pack, and ship cost, and total fees shows what Amazon expects to take. These are estimates, treat the report as a forecast and replace it with actual numbers in Step 5.

Step 2: Break Down Amazon FBA Fees by Product

Amazon FBA fees by product fall into three buckets: referral, fulfillment, and storage. Each behaves differently and needs its own line in your books.

Referral Fees and How They Are Calculated

A referral fee is a percentage of the total selling price, set by product category. Amazon publishes the current rates in its official selling fee schedule. Rates vary by category, and some categories carry a minimum per-item charge.

The math is simple. Selling price times category rate equals your referral fee. A $40 item in a 15% category pays $6.

Fulfillment Fees by Size Tier and Weight

A fulfillment fee is the cost to pick, pack, and ship one unit, set by size tier and shipping weight. Tiers split into standard-size and oversize, and weight bands set the rate, a small standard item pays far less than a large oversize one. Dimensional weight matters: bulky but light packages may bill on volume instead of scale weight.

Step 3: Cross-Check Estimates With an Amazon FBA Fee Calculator

Never trust one number. An Amazon FBA fee calculator lets you test fee scenarios before committing to a price, new products before you order inventory, price changes before you make them, size or packaging changes that shift a tier. Enter dimensions, weight, category, and price, then compare against your fee preview report. If the two disagree by more than a few cents, dig into the size tier; misclassified dimensions are the usual cause.

Step 4: Post Fees to Your Books With a Per-SKU Accounting Workflow

This is where most sellers stop, and where the real value sits. A repeatable per-SKU accounting workflow turns fee data into clean books: every fee lands in a named account, tied to a specific SKU, in the period it was incurred.

Map Each Fee Type to a Chart-of-Accounts Line

Before posting anything, decide where each fee lives. Most per-SKU sellers use this structure:

Keeping referral and fulfillment fees in cost of goods sold lets you compute a true contribution margin per SKU. Storage and removal sit below the gross margin line because they are not tied to a single sale.

The Monthly Posting Sequence

Run this sequence every month, in order:

1. Export the settlement report, filtered to your accounting month, not Amazon's calendar month.
2. Match each transaction to its SKU using the SKU column, not the ASIN, ASINs can map to multiple SKUs when you sell variations.
3. Split referral and fulfillment fees into cost of goods sold, posted against the SKU's cost-of-goods account, not a lumped "Amazon Fees" account.
4. Record storage fees as an operating expense in the month the charge appears, even if the inventory sold in a different month.
5. Post net proceeds to your bank or clearing account; the settlement report's total deposit should match your bank statement to the cent.
6. Flag any SKU where fees exceed your forecast by more than your threshold, and investigate before closing.

Sample Journal Entries

Here are the entries for a single order: a $40 selling price, a $6 referral fee, a $4.75 fulfillment fee, and $1.20 in storage allocated to the unit.

When the order settles:

• Debit: Amazon Clearing Account, $28.05
• Debit: Amazon Referral Fees (COGS), $6.00
• Debit: Amazon Fulfillment Fees (COGS), $4.75

When Amazon deposits the settlement:

Book a Discovery Call →

• Debit: Bank Account, $28.05
• Credit: Amazon Clearing Account, $28.05

The clearing account should net to zero after each settlement. If it does not, you have a missing or duplicated entry.

Handling Refunds, Reimbursements, and Adjustments

Refunds and reimbursements are where per-SKU books usually break. Treat them as reversals, not new sales:

• Customer refund: Reverse the referral fee (Amazon credits it back) and reverse the fulfillment fee only if the unit returns to sellable inventory. Post against the same SKU.
• FBA reimbursement: Post as a credit to the SKU's cost of goods sold, not revenue, it is a recovery of cost, not a sale.
• Fee adjustment: Post the correction in the period it appears and note the original period in the memo field.

Why Automation Matters Here

Manual entry across hundreds of SKUs creates compounding errors, a single mis-keyed SKU can shift margin by hundreds of dollars over a quarter.

Step 5: Amazon Settlement Report Reconciliation for Every SKU

Amazon settlement report reconciliation makes your books trustworthy by comparing what Amazon said it would charge against what it actually charged. Work SKU by SKU: pull the settlement report for the period, sum actual fees for each SKU, compare against your posted entries, record the difference as a fee adjustment, and investigate any SKU with a gap above your threshold.

The GAAP guidance from the FASB supports matching expenses to the period they belong to. Reconciling monthly keeps your margin numbers honest.

Step 6: Build a Repeatable Amazon SKU Profitability Review

Amazon SKU profitability review turns raw fee data into decisions. Run it monthly and you will spot problems while they are small. This section gives you the formulas, worked examples, and a reusable template to review a full catalog in under an hour.

The Per-Unit Profit Formula

For each SKU, calculate in this order:

1. Gross sales = selling price × units sold
2. Minus referral fee = gross sales × category rate
3. Minus fulfillment fee = units sold × per-unit fulfillment rate
4. Minus storage fee = allocated storage for the period
5. Minus cost of goods sold = units sold × landed cost
6. Minus other charges = inbound, removal, advertising allocated to the SKU
7. Equals true per-unit profit

Sort by profit, not revenue. High-revenue SKUs frequently sit near the bottom once real fees land.

Worked Example: Three SKUs, Three Outcomes

Here is the same formula across three realistic SKUs (figures illustrative).

SKU B has the highest revenue of the two standard-size items but the lowest margin. SKU C wins on dollars, but one month of long-term storage on slow-moving oversize inventory can wipe out that advantage. Review per SKU, not per category.

Spreadsheet Formulas You Can Paste In

Build one master sheet with these columns and formulas (row 2 is your first SKU).

• A: SKU
• B: ASIN
• C: Selling price

Sort column L descending. The bottom ten rows are your action list for the month.

Bulk SKU Analysis: Scaling Past 50 SKUs

Past roughly 50 SKUs, manual review stops working. Three patterns help:

• Group by size tier. Fulfillment fees cluster by tier, so a tier-level average flags outliers fast.
• Flag by margin band. Under 15% margin gets a manual look; under 5% gets a pricing or sourcing decision.
• Track fee drift month over month. A SKU whose fees rose more than 10% without a price or dimension change usually has a misclassified dimension or category reclassification.

A Reusable Template Structure

Your template needs four tabs:

1. SKU Master, one row per SKU with price, dimensions, weight, category, and landed cost.
2. Fee Inputs, referral, fulfillment, and storage rates per SKU, refreshed monthly from the fee preview report.
3. Settlement Import, raw settlement data with a lookup column matching to SKU Master.
4. Profitability Dashboard, the formulas above, plus a month-over-month comparison column.

Paste settlement data into tab 3 each month and the dashboard updates automatically. For catalogs in the hundreds of SKUs, this is exactly what Scale Partners AI automates, with weekly recommendations on what to fix next.

Fee errors compound quietly. A wrong size tier or a missed reimbursement can drain margin across thousands of units before anyone notices. Scale Partners AI builds per-SKU tracking systems that connect to your existing stack, flag margin leaks weekly, and give you real-time visibility into true per-SKU profit without a costly rip-and-replace. Book a Discovery Call and let us show you which SKUs are quietly costing you money.