Navigating the DoorDash portal for necessary financial data can be complex, which is why at Loop, we've streamlined this process. However, self-validation of GL entries can enhance your confidence in the data provided by Loop. This guide helps you understand and validate financial information from DoorDash reports and compare them with your chart of accounts.

Step 1: Generate a Payouts Report from DoorDash

Step 2: Mapping Your Chart of Accounts with columns in the Doordash transactions report.
Understanding the correlation between your chart of accounts and the DoorDash Payouts report is crucial. Focus on the 'payouts_summary' file, which should ideally contain one line entry per store. The file should look something like the below snapshot.

Using the below table you can map the columns in your DoorDash transactions report to your chart of accounts.

Doordash column	Chart of Account	Description
Subtotal	Sales Excluding Tax	This represents the total revenue from sales before any deductions, discounts, or returns.
Error Charges	chargeback	This refers to the amount deducted from your account due to a dispute or a return, often arising from a customer's complaint or a transaction dispute.
Adjustments	reversal	This encompasses any corrections or modifications made to previously recorded transactions. This mostly includes refunds on customer disputes.
Marketing Fees	marketing	Costs associated with DoorDash promotional activities or discounts offered to customers.
Commission	commission	Commission paid to DoorDash for the use of their service.
Net Payout	net_payout	The net amount deposited into your bank account after all deductions.
Tax Subtotal	tax_host	This represents your tax liablity
Tax Remitted by DoorDash to State	tax_witheld	Tax withheld by the marketplace to pay the state on your behalf.

Related Articles: GrubHub Uber

If you have any further questions please reach out to us at support@tryloop.ai