Amazon Referral Fee Categories: Mapping Settlement Lines

Two Amazon ASINs in the same settlement show different referral amounts because amazon referral fee categories differ, but QuickBooks has one catch-all Amazon fees expense that hides the category split. The bank deposit matches, yet the bookkeeper cannot explain the referral expense by category without rebuilding the report.

The solution is not a separate bank transaction for each category. Preserve the link between each fee line and its supported marketplace classification, group the charges consistently, and post them through Amazon clearing. The payout remains one settlement transfer; the fee detail stays available for review.

Reading amazon referral fee categories in settlement reports

Start by separating two questions: what kind of charge is this, and which category does it belong to? A settlement description identifying a referral or commission charge answers the charge-type question. It does not necessarily answer the second. Report layouts vary, and a category label may not appear on the settlement line itself.

Amazon's referral fee classifications are marketplace classifications used in determining charges. They are not automatically identical to storefront browsing categories, your inventory groups, or the expense names in QuickBooks. Avoid assigning a fee category just because an ASIN looks like a particular kind of product.

Retain the settlement reference, marketplace, currency, order or transaction reference, SKU or ASIN where available, fee description, signed amount, and supporting category evidence. Where the export lacks a needed field, use related Amazon transaction or fee records. An order with multiple items may need item-level support rather than an order-level assumption.

The Amazon settlement report guide covers the broader report structure. Here, the objective is a traceable category grouping, not a reconstructed fee schedule. Use Amazon's current documentation and actual transaction records to investigate a charge; do not replace posted amounts with a remembered rate.

Build a category bridge before mapping accounts

Create a working schedule that connects each referral line to its evidence and accounting destination. Useful columns include the original description, transaction reference, ASIN, supported fee category, signed amount, mapped expense account, and review status. Preserve the raw export separately so another reviewer can retrace the grouping.

In this guide's scenario, supporting records establish that the two ASINs belong to different fee categories. In another settlement, different charges might reflect different sale amounts or adjustments instead. Confirm the classification before treating a difference as a category issue.

If the evidence is incomplete, leave the fee in a clearly identified unresolved referral group. Do not spread it across categories merely to make the report look complete. The unresolved amount still belongs in the settlement reconciliation, with a documented follow-up.

Keep fulfillment, storage, closing fees, and other charges outside the referral grouping. A category schedule is useful only if its total agrees to the referral lines being analyzed. For the basic charge mechanics, see Amazon referral fees; this guide focuses on preserving their category detail.

Choose where the category detail will live

There are two practical approaches. One option is to use a parent referral fee expense account with category subaccounts. Each supported category total posts to its own subaccount, giving QuickBooks a visible split. Use stable names and document how Amazon's classifications connect to them.

Second, post one referral expense total and retain the detailed category schedule as supporting documentation. This keeps the chart of accounts smaller, but the QuickBooks expense line alone will not answer category questions. The schedule must remain linked to the settlement and available for review.

Either approach can reconcile through one Amazon clearing account for the relevant marketplace and currency. Clearing represents the amount moving between settlement activity and the bank; it does not need a separate account for every product category. Preserve category detail in the journal's expense lines and supporting records rather than expecting the clearing balance to provide it.

A catch-all Amazon fees account goes further than a combined referral account: it can mix referral charges with unrelated fee types. Before changing that setup, distinguish fee types before deciding how much category detail the referral expense needs.

Illustrative journal example: preserve the category split

All amounts below are illustrative examples, not Amazon fee rates or a fee schedule. Assume the supporting records confirm two fee categories, represented here by placeholder labels Category A and Category B. This simplified settlement has only sales and referral charges; a real entry must include every applicable settlement component.

The following illustrative entry preserves both category groups. Debits and credits each equal $2,000.00.

The category names are placeholders, not claims about Amazon's official labels. Replace them with your supported mapping. If you use one referral expense account instead, combine the two expense debits into $250.00 and retain the same category split in the attached schedule. The clearing amount stays unchanged.

When the illustrated payout reaches checking, record the transfer. This second illustrative entry has equal debits and credits of $1,750.00.

Match the bank-feed deposit to that transfer rather than recording sales again. If the opening clearing balance was zero and no other activity exists, these entries leave clearing at zero. Category reporting comes from the expense lines and schedule, not from splitting the deposit.

Steps to preserve category detail in QuickBooks

1. 1

   Identify the settlement scope

   Confirm the settlement reference, marketplace, currency, and payout. Keep the category review within that scope rather than comparing a whole month's fees with one bank deposit.

2. Extract referral lines: Separate referral or commission activity from other charge types using the report descriptions and supporting records. Preserve signs so credits and reversals do not become additional expenses.

3. Link the category evidence: Match transaction and item references to the available Amazon category support. Mark uncertain matches for review, especially where an order contains multiple ASINs.

4. Group and cross-check: Total the supported categories plus the unresolved group. Their combined signed amount must equal the referral total in the settlement. Keep original charges and related credits traceable within each group.

5. Apply a consistent mapping: Use category subaccounts or one referral expense account with an attached schedule. Check existing imports and manual entries before posting so the settlement is not recorded twice.

6. Post and match: Record the complete settlement through clearing, then match its payout to checking. Retain the export, category bridge, journal reference, and any unresolved review notes together.

The Amazon settlement reconciliation walkthrough provides the surrounding bank-matching process. Category mapping adds reporting detail to that process; it does not replace the settlement-level reconciliation.

Troubleshooting category totals and clearing differences

The bank matches, but category reports do not

Inspect the mapping rather than changing the deposit. A fee posted to the wrong expense category can leave clearing perfectly balanced. If the original entry is already posted, use a documented expense reclassification under your bookkeeping policy, not another settlement import. Moving an expense between categories should not create a new bank movement.

The category schedule exceeds the referral total

Look for duplicated joins, particularly when one order has several items. Also check whether the schedule includes fulfillment charges or treats fee credits as positive charges. Compare the original line count and signed total with the grouped output before investigating category names.

A fee credit has no obvious category

Trace the credit to its original transaction where supporting records allow. Use the established category when supported; otherwise retain it in the unresolved group. Do not force a credit into the largest category just to simplify the report.

Clearing still has a balance

Review the complete settlement for omitted adjustments, reserves, duplicate postings, or a payout not yet matched. A category relabeling cannot explain a missing cash movement. Document what the remaining balance represents and how it will be resolved rather than using an unexplained balancing expense.

Keep category reporting connected to the payout

A useful category report connects the Amazon charge, its classification evidence, the QuickBooks expense, and the settlement payout. Keep that trail intact even if you choose a compact chart of accounts.

If you are reviewing a settlement-based workflow, explore the ClearPayout Amazon–QuickBooks integration. Compare the mapping detail you need with your existing process before making changes. The goal is a payout that reconciles and a category split you can explain without rebuilding the same evidence each month.