jiesen.ai

Solution

Reconciling DoorDash Marketplace Payouts to POS Gross Sales

DoorDash's marketplace payout report bundles gross orders, commissions, marketing fees, adjustments, and chargebacks into a single net deposit. jiesen.ai decomposes that deposit into discrete GL postings and reconciles to the POS gross sales line.

The Blueprint

Worked example — weekly payout decomposition

One $7,412.88 net deposit broken into its GL postings.

DoorDash gross orders$12,840.00 → 4030 Third-Party Revenue
Commission (30%)($3,852.00) → 6200 Third-Party Commission
Marketing fee($612.00) → 6210 Third-Party Marketing
Promotion adjustments($420.50) → 6220 Promo Adjustments
Chargebacks / refunds($246.62) → 4030 Third-Party Revenue (contra)
Sales tax remitted by DD($296.00) → memo only · marketplace facilitator
Net ACH deposit$7,412.88 → 1010 Operating Cash
RECONCILE doordash_payout
  expect: cash_in = gross_orders - commission - marketing - promo - chargebacks - mpf_tax
  if |delta| > 1.00 then flag("DD payout variance", attach=payout_csv)

Marketplace Facilitator tax is memo-only; never posted to revenue or sales tax payable.

Run this scenario in jiesen.ai workbench

Open the home workbench with this exact scenario already loaded in the search box.

Open this scenario in the workbench

Advisory escalation

Dealing with systemic, multi-entity exposure or historical cleanup? Skip the manual adjustments. Initiate a 1-business-day advisory scope directly with Jiesen Li Advisory.

Transition to Advisory Scope

Related solutions