Skip to main content

Tax Breakdown Reports

Itemized Tax Breakdown​

Report Type - ITEMIZED_TAX_BREAKDOWN

Description​

To provide Merchant the most granular tax imposition and jurisdiction data for each line item, so that Mx can troubleshoot any issues or use it to support audit requests.

Example Report​

Column NameData TypeDefinitionExampleSince Report Version
Business IDnumberDoorDash Business ID1851
Business NamevarcharBusiness nameMetro Pizza1
Store IDnumberDoorDash Store ID247251
Store NamevarcharStore nameMetro Pizza Main Street1
Order IDvarcharDoorDash unique ID given to each order.8ecc6a13-6b54-4a66-abc4-2fd2fb3403e31
Timestamp UTC Date / TimedateThe date and time of the order in Universal Time (UTC)6/16/25 1:131
Timestamp Local Date / TimedateThe date and time of the order in the local time zone of the store6/15/25 21:131
Is MPF StatevarcharIndicates whether the order was placed in a Marketplace Facilitator (MPF) state. Value is TRUE or FALSE.FALSE1
Store ZipvarcharThe ZIP code of the store's location021271
Store CityvarcharThe city of the store's locationBoston1
Store State CodevarcharThe state of the store's locationMA1
Store CountryvarcharThe country of the store's locationUS1
Delivery ZipvarcharThe ZIP code of the delivery location021271
Delivery CityvarcharThe city of the delivery locationBoston1
Delivery State CodevarcharThe state of the delivery locationMA1
Delivery CountryvarcharThe country of the delivery locationUS1
CurrencyvarcharCurrency for the orderUSD1
Item TypevarcharThe line item type for the tax imposed (MENU_ITEM, DELIVERY_FEE, BAG_FEE)MENU_ITEM1
Item NamevarcharThe item name on the order for the tax imposedBuild your own Pizza1
Item IDvarcharThe merchant supplied ID used for referenceSMALL_PIZZA1
QuantitynumberThe item quantity included in the order11
Imposition TypevarcharThe category of tax or fee applied to the item (e.g., Sales Tax, Public Improvement Fee)General Sales and Use Tax1
Imposition NamevarcharThe specific name of the tax or fee imposed by the jurisdiction (e.g., Sales and Use Tax)Sales and Use Tax1
Jurisdiction LevelvarcharThe level of the jurisdiction imposing the tax (e.g., city, county, state)STATE1
Jurisdiction NamevarcharThe name of the jurisdiction imposing the tax (e.g., city, county, state)MASSACHUSETTS1
Taxable BasisnumberThe amount of the item or fee that is subject to tax10001
Non Taxable BasisnumberThe amount of the item or fee that is not subject to tax01
Tax AmountnumberThe total amount of tax applied to the item or fee631
Remittance ResponsibilityvarcharIndicates the party responsible for remitting the tax to the tax authority — either DOORDASH or MERCHANTMERCHANT1

Daily Tax Breakdown​

Report Type - DAILY_TAX_BREAKDOWN

Description​

Summary of the tax breakdown for all orders placed each day

Example Report​

Column NameData TypeDefinitionExampleSince Report Version
Store IDnumberDoorDash Store ID247251
Business IDnumberDoorDash Business ID1851
Store NamevarcharStore nameMetro Pizza Main Street1
Transaction DatevarcharThe date and time of the order in Universal Time (UTC)6/8/251
Payout DatenumberThe date the payout was completedNULL1
CurrencynumberCurrency for the orderUSD1
Jurisdiction NamevarcharThe name of the jurisdiction imposing the tax (e.g., city, county, state)MASSACHUSETTS1
Jurisdiction LevelvarcharThe level of the jurisdiction imposing the tax (e.g., city, county, state)STATE1
Imposition TypenumberThe category of tax or fee applied (e.g., Sales Tax, Improvement Fee)General Sales and Use Tax1
ImpositionvarcharThe specific name of the tax or fee imposed (e.g., Sales and Use Tax)Sales and Use Tax1
Taxable PayervarcharThe party responsible for remitting the tax (e.g., DOORDASH or MERCHANT)DOORDASH1
Subtotal for TaxvarcharSubtotal taxes collected on orders that are passed to the merchant to remit to the appropriate tax authorities36.211
Customer Fee for TaxvarcharCustomer Fee- Sum of small order fee + bottle deposit + bag fee + delivery fee3.991
Taxable BasisvarcharThe amount of the item or fee that is subject to tax36.211
Non Taxable BasisnumberThe amount of the item or fee that is not subject to tax3.991
Tax AmountvarcharThe total amount of tax applied to the item or fee2.171