How a US Accounting Firm Automated Wayfair Drop-Ship Bookkeeping in Odoo 19
ECOSIRE built a custom marketplace connector for Odoo 19 with scheduled jobs covering orders, deliveries, products, customers, refunds, payouts and more. Settlement matching reconciles each payout automatically — using reference, prefix and exact-amount strategies — and posts one aggregate fee/adjustment journal entry per invoice date so the books follow the matching principle. A backlog of thousands of historical orders and missing purchase orders was recovered to bring every payout to full reconciliation.
关键事实
面临的挑战
Thousands of Orders to Sync
A high-volume marketplace drop-ship operation generated far more orders, deliveries and refunds than anyone could enter or reconcile by hand without falling behind.
Payout Reconciliation by Hand
Each marketplace payout bundled many orders plus fees and adjustments. Matching a settlement back to its invoices and proving it netted to zero was slow and error-prone manually.
Fees Posted on the Wrong Dates
Marketplace fees and adjustments were being booked to the payout date rather than the invoice date, breaking the matching principle and forcing the bookkeeper to hand-edit dozens of journal entries every quarter.
取得的成果
下一步
Further hardening of the settlement parser and optional data clean-up so new marketplace settlements post and reconcile with no manual touch.