Marketplace Order & Fee Reconciliation / Settlement

Key Features

Import marketplace settlement and disbursement reports (Amazon SP-API/Seller Central flat files, eBay payout reports, Walmart settlement CSV) via upload or scheduled fetch, with format-aware parsers per channel

Automatically match each settlement line to the originating Odoo sale order and its account.move invoice, using order IDs, transaction references and amount tolerances

Split every net payout into its components — gross sales, referral/commission, FBA and fulfillment fees, storage, advertising, refunds, chargebacks, promo rebates, reserves and adjustments

Auto-post each fee category to the correct GL account via configurable mapping, generating balanced account.move journal entries per settlement batch

Reconcile the net disbursement against the real bank deposit on account.bank.statement, so cleared payouts tie out to the general ledger

Discrepancy detection: flags settlement lines that don't match any Odoo order, amount mismatches beyond tolerance, and fees with no GL mapping — surfaced in a review queue instead of silently posting

Missing-payout detection: identifies shipped/invoiced orders that never appeared in any settlement, and settlement periods with gaps, so unpaid or lost transactions are caught

Per-channel profitability reporting — net margin after all commissions, fulfillment, storage and ad fees, sliced by marketplace, brand, product and period

Currency and fee-in-transaction handling, including marketplace FX, multi-currency settlements and per-line tax treatment aligned to your Odoo tax configuration

Reserve and rolling-balance tracking so held funds and their later release are modeled, not dropped, keeping the marketplace clearing account accurate

Computed reconciliation-status fields (matched, partial, unmatched, disputed) with @api.depends recomputation and colour-coded list/kanban views for the finance team

Automated actions (ir.cron) to pull, parse and pre-match settlements on a schedule, plus configurable email alerts on discrepancies and missing payouts

QWeb settlement reconciliation report per payout — a printable/PDF statement showing gross-to-net bridge, fee breakdown and matched orders for audit and month-end close

Role-based security via ir.model.access.csv and record rules (finance can post, ops can view), keeping settlement posting locked down

XML-RPC / JSON-RPC endpoints and clean model APIs so external tools, BI or your own scripts can push reports and read reconciliation status

Multi-company and multi-marketplace support — separate clearing accounts and mappings per legal entity and per channel within one Odoo database

Built to order, done for you

No DIY setup — a working app, built, installed and supported by ECOSIRE.

You order

Start with a one-time build price. We scope it with you at kickoff.

We build & install

ECOSIRE builds, configures and installs it on your Odoo.

Go live + support

You go live in about 2–4 weeks, with a post-launch support window.

About this Product

If you sell on Amazon, eBay or Walmart, your payouts never match your invoices. Every disbursement is a net figure — gross sales minus referral commissions, FBA/fulfillment charges, storage, advertising, refunds, chargebacks, promo rebates and reserve adjustments — landing in your bank as one lump sum days or weeks after the sale. Trying to reconcile that against Odoo's Sales and Accounting by hand is how controllers lose their month-end.

Marketplace Order & Fee Reconciliation / Settlement is a build-to-order Odoo module that ECOSIRE designs, builds, installs and supports for your specific channels and chart of accounts. It ingests each marketplace's settlement/disbursement report, matches every line back to the originating Odoo sale order and its account.move invoice, books each fee category to the correct GL account, and reconciles the net payout against the actual account.bank.statement deposit — so the money in your bank finally ties to the numbers in your books.

This is NOT an existing apps.odoo.com download and there is no instant download. After purchase, an ECOSIRE Odoo engineer scopes your marketplaces, report formats and accounting rules, then delivers a tailored module with a typical lead time of 2–4 weeks. The module is built the Odoo-native way: proper models.Model objects, computed fields with @api.depends, ir.model.access.csv plus record rules for security, XML/OWL views and dashboards, QWeb reconciliation reports, scheduled automated actions for imports, and a documented XML-RPC/JSON-RPC surface for automation. It runs on Odoo 17, 18 and 19, on Community or Enterprise.

The result: a settlement is imported, matched, posted and reconciled in minutes instead of days; discrepancies and missing payouts surface automatically; and you get true per-channel profitability after every fee — not a gross-sales illusion.

What you get

A complete, installable Odoo module (custom addon with __manifest__.py, models, views, security and reports) scoped to your marketplaces and chart of accounts, delivered as source you own

Configuration of fee-to-GL account mappings, marketplace clearing accounts, matching tolerances and per-channel settings for your live Odoo 17/18/19 database

Parser setup and validation for each of your actual settlement/disbursement report formats (Amazon, eBay, Walmart or others in scope)

Installation and deployment into your environment (Odoo.sh, ECOSIRE-managed hosting, or your own server) with a smoke-tested first reconciliation run

End-user and administrator documentation covering the import → match → post → reconcile workflow, discrepancy handling and the GL mapping model

A live training session for your finance/controller team, plus a recording and quick-reference guide

A defined post-go-live support and bug-fix window, with clear terms for Odoo version compatibility and future updates

Who this is for

E-commerce Controller / Finance Manager

Owns month-end close and can't tie marketplace payouts to the GL. Drowning in net disbursements that bundle sales, fees and refunds. Needs every payout reconciled to Odoo orders and bank deposits with an audit trail — so the books close on time and are defensible.

Multi-Channel Seller / E-commerce Operations Lead

Runs Amazon, eBay and Walmart storefronts and suspects fees are eating the margin. Wants true per-channel profitability after commissions, FBA, storage and ad spend — not gross-sales vanity numbers — to decide which channels and SKUs to push or cut.

Bookkeeper / Accounts Team Member

Manually keys marketplace fees into journal entries and hunts for missing payouts each period. Needs the fee split, GL posting and bank reconciliation automated, with a review queue for anything that doesn't match, to stop the repetitive spreadsheet grind and human error.

How Marketplace Order & Fee Reconciliation / Settlement Compares

Criterion	ECOSIRE	Custom Build	Competitor
Fit to your marketplaces & chart of accounts	Built to order — parsers and GL mappings tailored to your exact channels and accounts	Fully bespoke but you own all design decisions and risk	Fixed to whatever the app author assumed; often US/Amazon-centric
Settlement report import & fee splitting	Format-aware parsers per channel; every fee category itemized	Possible, but you build and maintain each parser	Limited to supported report formats; breaks when marketplaces change them
Payout-to-order & bank-deposit reconciliation	Auto-matches lines to sale orders/invoices and reconciles net deposit to the bank statement	Achievable with significant development effort	Partial — many stop at journal creation, not bank reconciliation
Discrepancy & missing-payout detection	Automatic review queue for mismatches, unmapped fees and orders never paid	Only if you design and build the checks yourself	Rarely included; usually posts whatever it parses
Per-channel profitability after all fees	Net margin by marketplace, brand, product and period, after every fee	Buildable but you define every metric and report	Basic fee reports; true after-fee margin often missing
Odoo 17/18/19, Community & Enterprise	Supported and tested on all three versions, both editions	Depends on how your dev builds it	Version support varies; upgrades often lag or cost extra
Ownership, install & support	You own the source; ECOSIRE installs, trains and provides a support window	You own it but carry all build and maintenance cost	Licensed per-version; support depends on the author
Time & cost to value	2–4 week build, one predictable scope	Long build cycle, uncertain internal cost	Fast to install but slow/expensive to make actually fit

Frequently Asked Questions about Marketplace Order & Fee Reconciliation / Settlement

How long until the module is delivered and live?

This is a build-to-order module, not an instant download. After purchase, an ECOSIRE Odoo engineer scopes your marketplaces, settlement report formats and accounting rules, then builds, installs and tests the module in your environment. Typical lead time is 2–4 weeks depending on how many channels and how complex your fee and GL mapping is. You'll get a scoping call up front and a delivery timeline before we start building.

What happens with support and updates after go-live?

Every build includes a defined post-go-live support and bug-fix window during which we fix defects and help your team get comfortable with the workflow. Because you receive the module source, you own it. We also offer ongoing support and version-compatibility plans — for example when you upgrade Odoo or when a marketplace changes its settlement report format — quoted separately so you only pay for what you need.

Which marketplaces and report formats are supported?

The seed build targets Amazon (Seller Central / SP-API settlement flat files), eBay payout reports and Walmart settlement CSVs. During scoping we validate parsers against your actual exported reports, since formats vary by region and account. Additional marketplaces or custom report formats can be added as part of the scope — that's the advantage of a build-to-order module over a fixed off-the-shelf app.

Does it work on Odoo Community or only Enterprise, and which versions?

It runs on Odoo 17, 18 and 19, on both Community and Enterprise. The core reconciliation, matching, fee-posting and reporting are built with standard framework primitives (models, computed fields, ir.model.access.csv, record rules, QWeb, ir.cron) so they don't depend on Enterprise-only features. If your workflow needs an Enterprise app you already run, we integrate with it during the build.

How does it actually reconcile payouts to my accounting?

For each settlement, the module matches every line to the originating Odoo sale order and its account.move invoice, splits the payout into fee categories, and posts balanced journal entries to the GL accounts you map (commissions, FBA/fulfillment, advertising, refunds, adjustments). The net disbursement is then reconciled against the real deposit on your bank statement, so what hit your bank ties to your books. Anything that doesn't match lands in a review queue rather than posting silently.

What do I need to provide to get started?

Access to your Odoo instance (or a staging copy), sample settlement/disbursement reports from each marketplace you sell on, your chart of accounts and the GL accounts you want each fee type posted to, and a point of contact on your finance team for the scoping call and training. The more representative the sample reports, the tighter the parsers and matching rules we can build.

Can external systems or BI tools read the reconciliation data?

Yes. The module exposes clean Odoo models and works over the standard XML-RPC / JSON-RPC API, so your BI tools, data warehouse or custom scripts can push settlement files and read reconciliation status, fee breakdowns and per-channel profitability. We document the relevant models and endpoints as part of the handover.