Amazon settlement reconciliation

Amazon Settlements Aren't Revenue

Webgility breaks Amazon settlements into the orders, FBA fees, referral fees, refunds, reserves, adjustments, and payouts your books need to show accurately.

12+ fee types
Each categorized to its own QB account
14-day
Settlement cycle, reconciled automatically
Reserve tracked
Know your actual available cash balance
FBA inventory
Inbound, available, reserved, in QuickBooks
Fee Breakdown

12+ Fee Types. All of Them Captured.

Referral fees, FBA fulfillment fees, monthly storage, long-term storage, shipping, advertising, chargebacks, returns, and settlement adjustments. Each one posts to its own expense account in QuickBooks. None disappear into a single "Amazon fees" lump sum.

When your CPA asks why margins declined in Q3, you can show them exactly which fee category moved, because every line is already in QuickBooks with the right label.

Amazon Settlement · May 1–14 · Fee Breakdown Auto-posted
Gross salesAmazon Sales Revenue · $42,180
Referral feesAmazon Referral Fees · −$6,327
FBA fulfillmentFBA Fulfillment Fees · −$3,844
Storage feesAmazon Storage Fees · −$418
AdvertisingAmazon Advertising · −$2,100
Net payoutBank Deposit · $29,491
Settlement & Reserve Tracking

Every 14 Days. Plus What Amazon Is Holding.

Amazon pays out every two weeks and includes orders, refunds, fees, and adjustments from that period. Webgility matches every line of every settlement to the underlying orders and posts the net deposit to your bank account entry in QuickBooks.

Amazon also holds a reserve against potential returns and chargebacks. That reserve changes. Webgility tracks your current reserve balance and shows your actual available cash, not just your last settlement amount.

AMAZON ACCOUNT STATUS · MAY 20
last_settlementMay 14 · $29,491 · posted ✓
current_reserve$4,820 · held by Amazon
reserve_releaseMay 28 est. · tracked
fba_available847 units · 3 ASINs
fba_inbound120 units · in transit

actual_cash$29,491 cleared · $4,820 pending
Tax Season

Your 1099-K and Your Books Don't Match. Webgility Fixes That.

Amazon's 1099-K reports gross processed volume — including sales tax collected, shipping charges, gift wrap, and refunded orders. It excludes most fees and timing adjustments. The number on your 1099-K is almost never your actual revenue, your deposits, or your profit. Your CPA will ask why the numbers don't match. Without a reconciliation layer, the gap never closes cleanly.

Webgility bridges it automatically. Settlement reports import, fees are broken out by category, refunds and returns are reversed correctly, taxes are separated into the right liability accounts, and everything posts through clearing accounts in QuickBooks. When your accountant runs the numbers at year-end, your books tie back to the 1099-K — because the reconciliation has been running all year.

1099-K RECONCILIATION · 2025 TAX YEAR
1099-K gross volume$284,300
less: sales tax collected−$18,440 (not revenue)
less: shipping charges−$12,180 (pass-through)
less: refunds included−$22,150 (reversed orders)
less: other adjustments−$4,080

taxable revenue$227,450
QuickBooks Amazon revenue$227,450 · matched ✓
variance$0
Explore Sandbox  ·  No Signup Required

See Webgility in Action.

A real instance pre-loaded with sample orders, channels, and accounting entries. Nothing to install. No account needed.

🔒 my-sandbox.webgility.com
Online
CONTACT SALES
PREVIEW MODE
S Shopify Store
Open the Sandbox
Free to explore  ·  No account needed  ·  Sample data only
FBA Inventory in QuickBooks

FBA Inventory Tracked, Not Guessed

Webgility tracks your FBA inventory, inbound, available, and reserved, and reflects it in QuickBooks. When FBA fulfills an order, inventory decrements and the accounting entry posts automatically. Built for Amazon sellers via SP-API. Most are operational in 3–5 business days.

Every fee category separated

12+ Amazon fee types each post to their own QB account. Referral fees are not fulfillment fees are not storage fees. No lump sums.

Settlement + reserve clarity

Each 14-day settlement matched to underlying orders and posted automatically. Reserve balance tracked separately so you know actual available cash.

FBA auto-posted to QuickBooks

When FBA fulfills an order, inventory decrements and the accounting entry posts automatically. Built on Amazon's SP-API. Most sellers are operational in 3–5 business days.

The Demo

Find out what your operational gaps are actually costing you.

Our team of experts will help surface your operations and finance concerns. In 30 minutes, we will discuss your channels, accounting setup, leakages, inventory inconsistencies, and close process.

Operational Snapshot ● Live
Orders reconciled today 1,247 ✓
Amazon payout tied out $47,241 ✓
Exceptions resolved 3 cleared
Inventory synced All channels ✓
Books status Certified ✓