1. Start with the finalized DoorDash payout export
For bank reconciliation, use the DoorDash Payouts export rather than an order-level transaction file. The payout export represents the amounts that should eventually appear in the deposit account. Transaction Detail is useful later when you need to explain what made up a payout.
2. Export the bank account that receives DoorDash deposits
Use a bank CSV that covers the payout period plus a few days after the end of the period. A payout created near month-end may post to the bank after the calendar month closes.
3. Match amount first, then use date and payout reference as constraints
The payout amount and bank deposit amount should agree within the tolerance you choose. If both files contain dates, limit matches to a reasonable date window. A reliable payout ID found in the bank description can narrow otherwise valid candidates, but it should not override an amount or date mismatch.
4. Review DoorDash-only rows
A DoorDash-only result means a finalized payout exists but no eligible bank deposit was found. Common causes include a deposit outside the selected date window, the wrong bank account, a bank amount sign issue, an overly strict description filter, or a genuine deposit that has not arrived yet.
5. Review bank-only rows
A bank-only result means a candidate bank deposit was not matched to a payout in the uploaded DoorDash export. Check whether the bank filter is too broad, whether the export period is incomplete, or whether the deposit belongs to another platform or settlement source.
6. Do not silently resolve duplicate candidates
If two payouts or two bank rows could satisfy the same match, treat that as a review item. Choosing one automatically can make the totals look clean while assigning the wrong deposit to the wrong payout.