Navigating the UberEats 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 UberEats reports and compare them with your chart of accounts.

Step 1: Generate a Payment Details Report from UberEats

Step 2: Mapping Your Chart of Accounts with columns in the Doordash transactions report.
Understanding the correlation between your chart of accounts and the UberEats payment details report is crucial. After downloading the report, make sure to apply filters specifically for 'Cancelled' and 'Delivered' orders. These categories represent your actual transactional activity.
Using the below table you can map the columns in your UberEats payment details report to your chart of accounts.

UberEats Columns	Chart of Account	Description
Sales (excl. tax)	Sales Excluding Tax	This represents the total revenue from sales before any deductions, discounts, or returns.
Tax_on_sales + Tax_on_Merchant_Fee + Tax_on_price_adjustments + Tax_on_Promotion_on_items + Tax_on_Promotions_on_Delivery	tax_host	This indicates your tax liability. If you have non-zero values under the Marketplace Facilitator Tax column, please disregard the values in these columns. A non-zero value in the Marketplace Facilitator Tax column implies that the third party (3P) would be responsible for the tax.
Marketplace facilitator tax	tax_withheld	Tax withheld by the marketplace to pay the state on your behalf.
Merchant Fee + Marketplace Fee	Commission	Commission paid to UberEats for the use of their service.
Marketing adjustment	marketing_ad_spend	Cost associated with ads run on the UberEats platform
Promotions on items	marketing_promo	Costs associated with UberEats promotional activities or discounts offered to customers.
Tips	customer_tip	This represents the extra money paid by customers over and above the order total as a tip.
Refunds (incl. tax)	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.
Total payout	net_payout	The net amount deposited into your bank account after all deductions.

Related Articles: GrubHub Doordash

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