Key takeaways
- The Amazon fee preview is an estimate for planning and margin review, not a final posting file.
- Settlement lines for referral fees, FBA fulfillment, refunds, reimbursements, and adjustments explain the actual payout.
- Compare preview and actual amounts at SKU and order level before reviewing an overall variance.
- Post gross sales and actual charges through Amazon clearing, then match the net payout to the bank.
- All amounts in examples below are illustrative; Amazon programs, report fields, and charges can change.
A seller budgets margins from the amazon fee preview report, but the settlement charges different fee amounts. QuickBooks then shows fee expense that never matches the estimate, while the Amazon clearing account carries a variance. This is a common result when a planning report is treated like a final accounting source.
Fee Preview is useful for deciding whether an offer appears commercially workable before or around an order. It is not the same thing as a settlement posting. The settlement report records what Amazon actually charged, credited, withheld, or paid for the activity that reached the settlement. For QuickBooks, that actual settlement activity is the source of truth.
The practical workflow is: use the preview to plan, compare it with actual lines by SKU and order, post the actuals through Amazon clearing, and investigate meaningful differences instead of forcing the books to match an estimate.
What the Amazon fee preview is designed to show
Fee Preview helps a seller evaluate expected economics around a product or offer. Depending on the report view and the information available at the time, it may present estimated categories such as referral fees, fulfillment charges, or other expected selling costs. The preview can support pricing and margin planning because it gives a forward-looking view before the complete settlement record exists.
An estimate depends on inputs. Product dimensions, shipping weight, fulfillment method, marketplace, order details, service choices, and other program attributes can affect how a preview is calculated. If an input changes, the estimate may change. Even when the inputs appear unchanged, the later settlement can contain a correction, refund, reimbursement, reserve movement, or another adjustment that was not part of the original preview.
Why preview estimates differ from settlement lines
Common causes include changes in fulfillment or shipping details, a customer refund, a fee reversal, a reimbursement, a correction to an earlier transaction, or a charge appearing in a different settlement period. The settlement may also show separate lines for referral fees, FBA fulfillment, storage, reserves, and other adjustments. A single preview number cannot explain every line that may eventually affect a payout.
The report labels also matter. An estimated fulfillment amount should not be compared with a combined settlement total that includes referral fees and refunds. Compare like with like first. Then compare the complete settlement bridge to the preview-based margin model.
Do not fill a variance with a remembered fee rate or a fixed schedule. Amazon’s charges and report presentation can change by marketplace, program, product, and transaction. Preserve the source description, reference, date, and amount for each actual line. For background on actual charges, see Amazon FBA fees and Amazon referral fees.
Compare preview and actual amounts by SKU
A useful comparison starts with a stable key. Use SKU, order identifier, marketplace, and settlement reference where available. A SKU-only comparison may combine several orders or periods, so add an order or transaction reference when the source supports it.
Build a working table with columns for SKU, order reference, preview date, estimated referral fee, estimated fulfillment fee, actual referral fee, actual fulfillment fee, other actual settlement lines, total preview, total actual, variance, and explanation. The exact columns can vary, but keep estimated and actual values in different fields. Do not overwrite the preview with the settled amount; the preview remains useful for measuring forecast performance.
For each SKU, first compare the same category. If the preview estimated referral fees and the settlement shows a referral-fee line, compare those two values. Repeat for fulfillment. Then list adjustments separately rather than burying them in a single “difference” column. A variance may be a genuine change in a fee, or it may be a new refund or reimbursement that belongs to another category.
Use illustrative labels in internal analysis. For example, an illustrative SKU might show an estimated total of 8.00 and actual settlement charges of 8.40. That 0.40 variance does not identify its own cause. The source lines might reveal an actual fulfillment charge of 5.10 instead of an estimated 4.70, while the referral line matched. Record that explanation rather than changing the estimate to make the columns look equal.
Why QuickBooks should use settlement actuals
QuickBooks needs an accounting entry for activity that actually occurred, not a forecast that may later change. Use the settlement report to identify gross product sales, refunds, referral fees, FBA fulfillment, reimbursements, reserves, and other relevant lines. Map each category to the account structure used for your books.
An Amazon clearing account provides the bridge. The settlement entry records gross sales and the actual charges, resulting in the amount Amazon owes you for that settlement. When Amazon pays the net amount, record or match the bank deposit as a movement from clearing to checking. This prevents the bank feed from creating a second sales entry.
Keep preview estimates in your planning worksheet. If estimates were already posted, review and replace or reconcile those entries under your bookkeeping policy before importing actuals; otherwise expenses may be counted twice.
For the wider process, follow the Amazon settlement reconciliation guide. If you want to review a repeatable import workflow, see the Amazon–QuickBooks integration.
Illustrative journal example: post settlement actuals
The following is an illustrative example only. The amounts do not represent a current Amazon schedule. The entry records gross sales and actual settlement lines, with debits and credits balancing at 1,000.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Amazon clearing | 760.00 | |
| Referral fee expense | 120.00 | |
| FBA fulfillment expense | 90.00 | |
| Refunds and allowances | 30.00 | |
| Product sales | 1000.00 | |
| Total | 1,000.00 | 1,000.00 |
When the payout reaches the bank, use a separate clearing movement:
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Business checking | 760.00 | |
| Amazon clearing | 760.00 | |
| Total | 760.00 | 760.00 |
These entries are examples of the mechanics, not a required chart of accounts. Keep account names and category detail consistent with your bookkeeping policy and source reports.
Steps to reconcile an Amazon fee preview variance
- 1
Save the planning view
Retain the Fee Preview output used for the margin decision, including the SKU, assumptions, date, and estimated categories.
Identify the final settlement: Match the order or SKU to the settlement reference, marketplace, covered period, and payout. Do not compare a single preview with an unrelated combined payout.
Extract actual lines: Pull the settlement detail for product sales, referral fees, FBA fulfillment, refunds, reimbursements, reserves, and other adjustments. Preserve the original descriptions and references.
Compare by category: Put each preview estimate beside its corresponding actual line. Keep new actual categories separate from changes to an estimated category.
Calculate the variance: Subtract the estimate from the actual amount in your working file and label the result as illustrative or internal analysis where appropriate. Add an explanation supported by the settlement reference.
Review duplicates and timing: Check whether a prior import, manual journal, refund, or correction already entered QuickBooks. Confirm that the preview period and settlement period are comparable.
Post the actual settlement: Record gross sales and actual charges through Amazon clearing. The clearing amount should equal the payout represented by that settlement entry.
Match the bank deposit: Connect the net payout to the bank transaction through clearing. Do not classify the deposit as a second sale.
Follow up on open items: Assign unexplained variances to a review list with the source reference and next action. A temporary clearing balance is more useful when it has a documented explanation.
Troubleshooting common mismatches
If every SKU appears to have a variance, check the comparison basis first. A preview may be per unit while a settlement line is for an order quantity, or the preview may cover one fee category while the settlement total includes several. Normalize the unit and category before investigating individual transactions.
If only some SKUs differ, inspect product and fulfillment attributes, order quantities, refunds, and fee reversals. Look for a negative or offsetting line in the settlement. A correction can arrive later and may not appear beside the original order in the export.
If the settlement balances but QuickBooks clearing does not, look for duplicate imports, an omitted fee category, a bank deposit posted as income, or a settlement split across multiple payout transactions. Reconcile by settlement reference rather than by the date a deposit reached the bank.
Keep estimates and actuals in their proper roles
Fee Preview can improve product and offer planning, but it is not a substitute for the settlement report. Use the preview to understand expected margin, use SKU-level comparisons to learn why estimates changed, and use settlement actuals to record the activity that reached Amazon clearing and the bank.
If this workflow fits your needs, review ClearPayout’s Amazon–QuickBooks integration or pricing when you are ready to consider a more repeatable settlement process. Keep actual Amazon activity traceable as you choose your workflow.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.