How do I reconcile Amazon and marketplace settlements?
A settlement report is built around the marketplace's own accounting period, not your orders, and it is full of fees and adjustments that need real interpretation to trace back. Doing that by hand every settlement cycle is not a task that scales as volume grows. It needs to happen inside your system, automatically.
Why a settlement report never lines up on its own
A settlement report is not an order list
Amazon and bol.com settlement reports are built around their accounting periods and fee structures, not around your orders, so lining the two up takes real interpretation.
FBA fees are their own puzzle
Storage, pick and pack, and long-term storage fees change over time and rarely map cleanly to a single order, which makes true per-order profitability hard to see.
Adjustments arrive with no context
Reimbursements, returns processing fees and inventory adjustments show up as line items with little explanation, weeks after the order they relate to.
Two marketplaces, two settlement formats
Amazon and bol.com structure their settlement data differently, so a process built for one rarely extends cleanly to the other without duplicating the work.
Fees and adjustments matched to the order that caused them.
Every settlement line, whether it is a sale, a fee, a reimbursement or an adjustment, is matched automatically back to the order it belongs to. Real per-order profitability becomes visible instead of buried inside a settlement total, and the reconciliation is done before anyone opens a report.
Odoo parses the settlement and matches it for you
We build your accounting on Odoo, the open-source commerce ERP, and connect your marketplaces to it with connectors we build and maintain ourselves, including our own bol.com connector and the open-source bol.com API client we maintain for UK and NL sellers, plus Amazon marketplace integration. Settlement fees and adjustments are parsed and matched to orders automatically, so the reconciliation work is already done by the time you look.
George Mountanos at Technotrading has relied on our bol.com connector as order volume grew, specifically because reconciling marketplace orders and fees by hand stopped being realistic past a certain scale.
See how the pieces fit
How do I reconcile Shopify, Stripe & PayPal payouts?
The same reconciliation discipline, applied to payment processors.
Why don't my Shopify sales match my accounts?
The wider reconciliation problem marketplace fees sit inside.
Odoo for marketplace sellers
How we support sellers running Amazon, eBay, bol.com and Mirakl together.
Reconciling payment processors too? See how to reconcile Shopify, Stripe and PayPal payouts →
Ready to fix your ops?
Book a free discovery call. We'll look at your current setup and tell you honestly whether Odoo is the right move and what it would involve.