US Marketplace Facilitator Tax Reconciler
Separate marketplace-collected (Amazon/eBay/Etsy/Walmart) sales tax from your seller-collected tax so self-filed state returns are not double-counted. Per-state, per-period facilitator vs direct reconciliation with settlement import and CSV.
Separate marketplace-collected (Amazon/eBay/Etsy/Walmart) sales tax from your seller-collected tax so self-filed state returns are not double-counted. Per-state, per-period facilitator vs direct reconciliation with settlement import and CSV.
Key Features
Sales-channel master
define each marketplace / direct channel with a single Marketplace Facilitator flag, a marketplace type and a short code.
Per-state facilitator effective dates
facilitator collection switched on state by state on different dates. Record the effective date per channel per state; a sale dated before the law took effect is treated as seller-collected, exactly as it would have been remitted at the tim
Channel tag on invoices
every customer invoice / credit note carries the channel it came through, with a computed facilitator-collected flag.
Per-state, per-period reconciliation engine
walks posted customer invoices for a monthly / quarterly / annual period and splits each one, per US state, into facilitator (marketplace remitted, excluded from your return) and direct (you remit, reported) buckets, with a per-channel brea
Settlement import
import the facilitator tax the marketplaces report in their settlement files (CSV upload or paste) and cross-check it against the facilitator tax computed from your invoices, flagging per-state variances above a tolerance you set.
Worksheet + CSV export
a filing-ready CSV that clearly separates the Direct Tax (Reported) column — the only one you put on your return — from the Facilitator Tax (Excluded) column.
Data-quality guardrails
untagged invoices and invoices with no US state are flagged (never block the computation), so figures still commit.
Screenshots
Run Reconciliation
Sales Channels
Import Settlement Figures
Reconciliations
Run Reconciliation
Import Settlement Figures
Why Choose This Module
Under US marketplace facilitator laws, platforms such as Amazon, eBay, Etsy and Walmart collect and remit sales tax on your behalf. That tax must be excluded from the figures you key into a self-filed state return — otherwise the same tax is reported and paid twice. Tax on your own direct channels is still yours to report and remit.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account
- Support: support@pokutsoft.com
Update date: 2026-07-02