Bookkeeping6 min read

Amazon FBA Bookkeeping: Reconciling Settlements and Tracking True COGS

An Amazon payout is not a sales report. Separate settlement activity from inventory costing before judging product margin.

Reconcile an Amazon payout to its settlement activity, then reconcile inventory separately. Sales, refunds, fees, advertising and held funds do not all represent the same kind of transaction. A product-margin report also needs a documented cost policy, not just the amount deposited.

An Amazon payout answers a cash question: how much reached the bank? It does not, by itself, answer how much you sold or earned. Keep settlement reconciliation and inventory costing as two connected workpapers so an unexplained payout difference does not become a made-up product cost.

How do you reconcile an Amazon settlement?

Start with the period, marketplace, currency and settlement identifier. Save the transaction detail and statement, then match the transfer to the bank. Group product sales, refunds, selling fees and other adjustments into the approved accounts. Include beginning and ending balances; do not force every settlement to zero when Amazon still holds funds.

Check an existing connector before posting a manual settlement journal. If it has already created sales or fees, importing the same activity again duplicates the books. Keep a mapping log and investigate unmatched transactions before changing the mapping for every future payout.

Where should reserves and advertising appear?

A held balance is not automatically a loss or new revenue when released. Compare the reserve or deferred balance with Amazon's current account reports and investigate changes. Amazon's payment guide describes held funds and payment timing; the account's actual statement determines the reconciliation.

Advertising is not always deducted from the settlement. Amazon Ads lists payment methods that vary by account. Match the advertising invoice and the actual seller-balance, card or invoice payment once. Booking both the ad invoice and an unexplained settlement deduction as expenses would double count the same charge.

Which costs belong in inventory?

Separate inventory acquisition costs from selling and fulfillment expenses before designing a SKU report. Supplier invoices, inbound freight and applicable duties support landed-cost calculations. IRS Publication 334 discusses freight-in and inventory costs, but it is not a rule that every Amazon charge belongs in inventory.

Do not automatically capitalize all fulfillment and storage fees into unsold units. Your accountant should approve the treatment under the applicable reporting and tax methods. A management contribution report can show product cost, marketplace fees, fulfillment, storage and advertising separately even when their financial-statement classifications differ.

What happens when unit costs change?

Keep units and costs by SKU, purchase batch and inventory location. Reconcile opening units, receipts, sales, returns, removals and documented losses to closing quantities. Use a consistent, approved valuation method rather than assuming FIFO is required for every seller.

Damaged inventory and reimbursements need their own evidence. A reimbursement is not permission to leave missing units in stock. Preserve the claim, quantity adjustment and payment so the reviewer can see both the inventory event and its financial settlement.

What should a margin report explain?

Illustration only: net product sales of $12,000 less $4,800 product cost leave $7,200 before marketplace and other operating costs. If identified fees, fulfillment and advertising total $3,100, the remaining contribution is $4,100 before other costs. Neither number is the bank payout or final business profit.

What should you agree before cleanup?

Confirm report access, affected periods, connector history and who approves accounting policies. Keep marketplace tax collection, tax-return treatment and inventory-method decisions with the appropriate professional. This retained guide does not promise marketplace integrations, automatic data access or tax filing.

For a general starting point, read Daxable's bookkeeping cleanup guide. Existing ecommerce bookkeeping information remains available; confirm current fit and a written scope before sharing account access.

Separate the report questions
QuestionEvidenceResult
Did the transfer arrive?Settlement and bank statementMatched payout
What remains held?Reserve and transaction reportsExplained marketplace balance
What did sold units cost?Invoices and inventory movementSupported product cost
What remains after selling costs?Sales, costs, fees and adsDefined contribution report

Each report answers a different question; a matched bank transfer alone does not establish profit.

Sources

Frequently Asked Questions

Is my Amazon payout the same as revenue?

No. Match it to the settlement activity and held balances. Sales, refunds, fees and transfers need distinct treatment; the net payout alone is not a revenue report.

Are all FBA fees inventory costs?

No blanket classification applies. Separate acquisition costs from fulfillment, storage and selling charges, then have the accountant approve the applicable cost policy.

Should Amazon advertising always be in a settlement?

No. Check the account's current payment method and invoice. Match charges paid through the seller balance, a card or an invoice without recording the same cost twice.

Can a reserve release be booked as another sale?

Not merely because cash was released. Reconcile the release against the recorded held balance and investigate differences.

Rental Property 1099s: Records Before Fi...Bookkeeper vs. Accountant: Which Work Do...

Want books you can actually trust?

Book a discovery call and our team will show you what it takes to get caught up and stay current.

Book a Call