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 workbenchAdvisory 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 ScopeRelated solutions
Automating Toast POS to R365 GL Mapping Discrepancies
Automating Toast POS to R365 general ledger mapping. Reconcile sales categories, tips, comps, and discounts against the daily sales summary with reproducible rules.
ASC 842 Lease Termination: ROU Derecognition and Gain/Loss
Walkthrough of ASC 842 lease termination accounting: derecognize ROU asset and lease liability, recognize gain or loss, and document the modification vs termination determination.