Amazon does not transfer each order individually. A payout consists of sales, refunds, commissions, FBA fees, and other movements. The Settlement Report explains how the amount in the bank account is derived from these items.
Basis of the payment reconciliation
Was steht im Amazon Settlement Report?
Der Amazon Settlement Report – auf Deutsch häufig Abrechnungsbericht genannt – dokumentiert die finanziellen Bewegungen einer Abrechnungsperiode. Er bildet die Brücke zwischen den einzelnen Marktplatztransaktionen und dem Betrag, den Amazon tatsächlich auszahlt.
Sales
Revenues, shipping fees, and other order-related amounts are assigned to the existing Amazon orders and invoices in Odoo.
Fees
Commissions, shipping, storage, and fulfillment costs are allocated to the designated accounts based on transaction type.
Refunds
Refunds, credits, reserves, and corrections reduce or shift the payout amount for a period.
Simple numerical example
Why €10,000 in revenue only leads to €8,000 in payout
The bank deposit rarely corresponds to the sum of customer invoices. Fees and refunds have already been offset by Amazon.
The example is simplified. The specific accounting and tax treatment should be coordinated with the responsible tax advisor.
| Sales of the billing period | €10,000 |
| Refunds | −€500 |
| Sales and marketplace fees | −€1,200 |
| FBA fees | −€300 |
| Payout to the bank account | €8,000 |
Two fulfillment models
FBA and FBM in payment reconciliation
The basic logic is identical. However, FBA usually incurs more and more diverse cost items.
FBM Fulfillment by Merchant
The merchant ships themselves. In the reconciliation, sales commissions, marketplace-related fees, and the allocation to self-created invoices are primarily in focus.
FBA Fulfillment by Amazon
Amazon takes care of storage and shipping. Additionally, fulfillment, storage, shipping, and service fees as well as FBA returns must be considered.
Before the first import
What should be prepared in Odoo
Complete documents: Orders, invoices, and credit notes must be available.
Clear allocation: Seller accounts, companies, and marketplaces must be distinguishable.
Fee accounts: Recurring cost types need defined accounts.
Reconciliation: A traceable reconciliation path is needed between documents and bank receipts.
From the report to the bank
The payment reconciliation in four steps
1
Adopt
Import settlement report and assign to the billing period.
2
Classify
Identify sales, fees, refunds, reserves, and corrections.
3
Assign
Link items with invoices, credits, and accounts.
4
Reconcile
Match the remaining amount with the actual bank receipt.
Amazon Report App
Automate recurring assignments
The Amazon Report App from 4EGrowth helps to systematically import settlement data into Odoo and assign recurring transaction types to the designated documents and accounts.
What rules make sense depends on the Odoo setup, the marketplaces, the chart of accounts, as well as the FBA and FBM processes of the company. Therefore, the setup should be tested with real billing reports.
The result
- Verkäufe und Erstattungen werden systematisch verarbeitet.
- Fee types can be consistently accounted.
- Die Auszahlung kann gegen den Bankeingang geprüft werden.
- Unknown items remain visible for control.
Control instead of blind booking
Typical causes for discrepancies
A good process does not book deviations unnoticed. It makes them visible and leads them to a targeted review.
Order, invoice, or credit note is not yet available.
The transaction does not yet have an assignment rule.
Reserve or correction comes from an earlier period.
Small deviations occur during conversion or tax calculation.
More transparency for costs and contribution margins
If Amazon fees are recorded separately, costs can be analyzed by marketplace, fulfillment model, or product group. This turns a necessary accounting process into a better basis for operational decisions.
Answered briefly
Frequently asked questions
What is the difference between the Settlement Report and bank payout?
Der Report enthält die Einzelbewegungen einer Abrechnungsperiode. Die Bankauszahlung ist der daraus resultierende Nettobetrag nach Gebühren, Erstattungen, Reserven und Korrekturen.
Can FBA and FBM transactions be processed together?
Yes. However, FBA incurs additional fulfillment and service fees, for which appropriate allocation and accounting rules are required.
Why does the invoice amount not match the payout?
Amazon deducts fees and refunds and may account for reserves or cross-period corrections.
Can the payment reconciliation be fully automated?
Recurring, clearly assignable items can be largely automated. Unknown transactions and missing documents should still be reviewed.
Does the accounting need to be reconciled?
Yes. The technical processing can automate allocations; however, accounting and tax treatment must fit the company, the marketplaces, and the chart of accounts.
Bringing Amazon and Odoo together
Review settlement reconciliation together
We analyze your process and show how FBA and FBM payouts can be transparently represented in Odoo.