What is the Transaction Details Report?
The Transaction Details Report provides a comprehensive, transaction-level breakdown of all orders, refunds, adjustments, and other activities for a given date range. It includes raw data for each transaction, regardless of whether it has been paid out, making it ideal for in-depth analysis and reconciliation
This report includes the following tables:
- Transactions Summary: This table summarizes all transactions at a location and ordering platform level, for the date range selected ensuring all transactions are aggregated and accounted for correctly.
- Transactions Summary - Daily: The Transactions Summary - Daily report summarizes transactions across various ordering platforms such as Uber Eats, DoorDash, and Grubhub for each day.
- Transaction Details: This table provides transactional level data for each individual order from Uber Eats, Grubhub, and DoorDash, unified into one table.
Note: This is raw data from the ordering platform and not a reconciled report. The final deposits may differ from the expected deposits because of refunds or additional ordering platform fees.
How to Generate the Report
To learn how to create Reconcile Reports that offer relevant data for your needs, please refer to the guide on how to use Reconcile reports here. This page will guide you through generating the report and filtering for additional details.
Note: This report is currently available only upon request. Please contact our customer support team for access to this report.
Transaction Details Report - Terminology
Transactions Summary
This table summarizes all transactions at a location and ordering platform level, for the date range selected ensuring all transactions are aggregated and accounted for correctly.
| Column Name | Definition |
|---|---|
| BRAND | The name of the restaurant brand owns the location. |
| LOCATION_ID | The location ID where the transaction occurred. |
| STORE_ID | The Store ID for the transaction. |
| THIRD_PARTY | The name of the third-party ordering platform processing the transactions (e.g., Uber Eats, DoorDash, Grubhub). |
| POS_SALES | Total sales recorded at the Point of Sale (POS), excluding taxes and adjustments. |
| POS_TAX | The tax calculated on POS sales. |
| POS_SALES_ INCL_TAX |
Total sales recorded at the POS, including taxes. Sales = POS_SALES + POS_TAX |
| TOTAL_SALES | The total sales amount after all adjustments (e.g., refunds or deductions) are applied. |
| TOTAL_REFUNDS _AND_ADJUSTMENTS |
The sum of all refunds and adjustments applied to the total sales. |
| SALES_TAX | The sales tax charged on the adjusted sales value, including any modifications due to refunds or adjustments. |
| SALES_TAX_ WITHHELD |
Sales tax withheld by the ordering platform under marketplace facilitator laws. Negative values indicate tax withheld. |
| GRATUITY_TIPS _TO_STORE |
Tips or gratuity paid directly to the restaurant or store by customers. |
| TOTAL_STATEMENT _GROSS_RECEIVABLE |
The total receivable amount from the ordering platform, combining gross sales and gratuity tips. Total Receivable = TOTAL_SALES + GRATUITY_TIPS_TO_STORE |
| TOTAL_FEES_ AND_COMMISSIONS |
The sum of all fees and commissions charged by the ordering platform (e.g., service fees, delivery fees). Negative values represent deductions. |
| TOTAL_MARKETING _SPEND_NET |
The net marketing expense incurred, accounting for discounts, coupons, and credits. Total marketing spend = Marketing Spend Fee - Marketing Spend Credit |
| TOTAL_DEPOSIT _EXPECTED |
The total amount expected to be deposited into the restaurant's account after deducting fees, commissions, and adjustments. Total Deposit Expected = TOTAL_STATEMENT_GROSS_RECEIVABLE + TOTAL_FEES_AND_COMMISSIONS + TOTAL_MARKETING_SPEND_NET |
Transaction Details
This table provides transactional level data for each individual order from Uber Eats, Grubhub, and DoorDash, unified into one table.
| Column Name | Definition |
|---|---|
| BRAND | The name of the restaurant brand owns the location. |
| LOCATION | The location ID where the transaction occurred. |
| STORE_ID | The Store ID for the transaction. |
| ORDERING_PLATFORM | The third-party platform (e.g., DoorDash, Uber Eats) through which the order was placed. |
| ORDER_NUMBER | A unique identifier for each order generated by the ordering platform. |
| ORDER_TYPE | Indicates the type of order (e.g., "Order," "Refund"). |
| ISSUE | Describes any issues reported with the order (e.g., missing items, late delivery). |
| ORDER_DATE | The date on which the order was placed. |
| ORDER_TIME | The exact time when the order was placed. |
| DEPOSIT_DATE | The date when the payout was made to the restaurant's bank account. |
| FOOD_AND_ BEV_PRE_ADJ |
The total cost of food and beverages before any adjustments (e.g., refunds or discounts). |
| ADJUSTMENTS _TO_SALES |
The sum of all adjustments (e.g., discounts or refunds) applied to the sales. |
| FOOD_AND_ BEVERAGE_SALES |
The net sales amount after adjustments have been applied to food and beverage items. Sales = FOOD_AND_BEV_PRE_ADJ - ADJUSTMENTS_TO_SALES |
| NET_SALES | Total revenue after including delivery fees and service charges. NET_SALES = FOOD_AND_BEVERAGE_SALES + DELIVERY_FEES_TO_RESTAURANT + SERVICE_CHARGES |
| GROSS_SALES | Net sales including other income and sales tax (if not withheld). GROSS_SALES = NET_SALES + OTHER_INCOME_TO_RESTAURANT + SALES_TAX |
| TOTAL_DEPOSIT _EXPECTED |
The final amount expected to be deposited into the restaurant's account after all deductions and adjustments. Deposit Expected = OP_STATEMENT_GROSS_RECEIVABLE + TOTAL_FEES_AND_COMMISSIONS + TOTAL_MARKETING_SPEND_NET |
Transactions Summary - Daily
The Transactions Summary - Daily report summarizes transactions across various ordering platforms such as Uber Eats, DoorDash, and Grubhub for each day.
| Column Name | Definition & Formula |
|---|---|
| BRAND | The name of the restaurant brand owns the location. |
| LOCATION_ID | The location ID where the transaction occurred. |
| STORE_ID | The Store ID for the transaction. |
| THIRD_PARTY | The name of the third-party ordering platform processing the transactions (e.g., Uber Eats, DoorDash, Grubhub). |
| DAY | The date of the transaction activity, represented as DD-MM-YYYY. |
| POS_SALES | Total sales recorded at the Point of Sale (POS), excluding taxes and adjustments. |
| POS_TAX | The tax calculated on POS sales. |
| POS_SALES_ INCL_TAX |
Total sales recorded at the POS, including taxes. Sales = POS_SALES + POS_TAX |
| TOTAL_SALES | The total sales amount after all adjustments (e.g., refunds or deductions) are applied. |
| TOTAL_REFUNDS_ AND_ADJUSTMENTS |
The sum of all refunds and adjustments applied to the total sales. |
| SALES_TAX | The sales tax charged on the adjusted sales value, including any modifications due to refunds or adjustments. |
| SALES_TAX_ WITHHELD |
Sales tax withheld by the ordering platform under marketplace facilitator laws. Negative value indicates tax withheld. |
| GRATUITY_TIPS _TO_STORE |
Tips or gratuity paid directly to the restaurant or store by customers. |
| TOTAL_STATEMENT _GROSS_RECEIVABLE |
The total receivable amount from the ordering platform, combining gross sales and gratuity tips. Gross Receivable = TOTAL_SALES + GRATUITY_TIPS_TO_STORE |
| TOTAL_FEES_ AND_COMMISSIONS |
The sum of all fees and commissions charged by the ordering platform (e.g., service fees, delivery fees). Negative values represent deductions. |
| TOTAL_MARKETING _SPEND_NET |
The net marketing expense incurred, accounting for discounts, coupons, and credits. Total marketing spend = Marketing Spend Fee - Marketing Spend Credit |
| TOTAL_DEPOSIT _EXPECTED |
The total amount expected to be deposited into the restaurant's account after deducting fees, commissions, and adjustments. Total deposit Expected = TOTAL_STATEMENT_GROSS_RECEIVABLE + TOTAL_FEES_AND_COMMISSIONS + TOTAL_MARKETING_SPEND_NET |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.