What is the Unified Transactions Report?
The Unified Transactions Report provides a comprehensive view of all transactions across various Ordering platforms in a single format. All Ordering Platforms are consolidated into one form for convenience so that they can be referenced all in one place. The report combines transaction-level data for all Ordering platforms in one table and format to make it easy to analyze and compare transactions across the various Ordering platforms.
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.
Deposit Reconciliation Report - Terminology
| Column Name | Column Definition |
|---|---|
| BRAND | The brand name that owns the restaurant. |
| LOCATION | Name of the store or restaurant. |
| ORDERING_PLATFORM | Third-party online ordering platform. |
| ORDER_NUMBER | Unique ID created by Checkmate to map the transactions in the ordering platform statements with the transactions in order processing/POS. |
| ORDER_TYPE | The 'order type' indicates the nature of the customer's order. It can have different values, such as order, refund, adjustment, cancelled, etc. |
| ISSUE | The column 'issue' refers to a text field containing a detailed description of an issue that may have resulted in the order being refunded or cancelled. The issue can be related to a missing item, the delivery time, etc. |
| ORDER_DATE | The date when an order was placed. |
| ORDER_TIME | The time when an order was placed. |
| DEPOSIT_DATE | The date on which a payout was made to the restaurant for the order. |
| FOOD_AND_BEV_ PRE_ADJ |
The total amount of the order placed, excluding taxes and adjustments. This column also maps the refunds restaurants refund to the customer when they report order errors. |
| ADJUSTMENTS_TO _SALES |
Adjustments restaurants make to the price of items once an order has been placed (excluding Tax). |
| FOOD_AND_BEVERAGE _SALES |
The total amount of revenue generated on the sale of an order after the adjustments have been taken into account. Food and Beverage Sales = Food And Bev Pre Adjustments - Adjustments To Sales |
| DELIVERY_FEES_TO_ RESTAURANT |
The delivery fees charged by a restaurant for delivering orders to their customers. |
| SERVICE_CHARGES | Any other type of service charged by a restaurant to a customer. |
| NET_SALES | The adjusted food and beverage sale, including any delivery or service charged by the restaurant. Net Sales = Food and Beverage Sales + Delivery Fees to Restaurant + Service Charges |
| SALES_TAX_PRE_ADJ | Tax on total item sales in the order. This also includes Tax on service fees charged by restaurants to eaters. |
| ADJUSTMENTS_TO_TAX | Adjustments to Tax made to balance the adjustment amount for a transaction. This also includes Tax on restaurant promotions applied to the order. |
| SALES_TAX | The sales tax charged on the order by the ordering platform. Also, the final tax amount with adjustments made. Sales Tax = Sales Tax Pre Adjustments - Adjustments To Tax |
| SALES_TAX_WITHHELD | Sales tax an ordering platform withheld to pay in jurisdictions with marketplace facilitator laws of the state. |
| OTHER_INCOME_TO_ RESTAURANT |
Fee charged to eater by the restaurants for the packaging material, utensils, or any other mode of income to the restaurant. |
| GROSS_SALES | The Net Sales with other income to the restaurant included. It also includes Sales Tax if not withheld by the ordering platform. Gross Sales = Net Sales + Other Income To Restaurant + Sales Tax (if not withheld) |
| GRATUITY_TIPS_TO_ STORE |
The tip paid by an eater to the delivery agent. Applicable for restaurants that do their own delivery. |
| OP_STATEMENT_ GROSS_RECEIVABLE |
The gross receivable, per the Ordering Platform statement, includes gratuity tips to the store and gross sales. Gross Receivables = Gross Sales + Gratuity Tips To Store |
| GENERAL_COMMISSION | The fee an ordering platform charges restaurants to make their store visible to potential customers provides support and other related services. |
| GENERAL_ COMMISSION_ PERCENTAGE |
The General Commission expressed in % of Gross Sales. General Commission % = (General Commission / Gross Sales) * 100 |
| PROCESSING_FEE | A flat fee charged by an ordering platform to restaurants for processing every order. |
| PROCESSING_FEE_ PERCENTAGE |
The processing fee expressed in % of Gross Sales. Processing Fee % = (Processing Fee / Gross Sales) * 100 |
| DELIVERY_FEE_ COMMISSION |
Fee charged by an ordering platform to a restaurant for delivering the orders to the end customer. |
| DELIVERY_FEE_ PERCENTAGE |
The delivery fee expressed in % of Gross Sales. Delivery Fee % = (Delivery Fee Commission / Gross Sales) * 100 |
| OTHER_FEES_ AND_TAXES |
Any additional taxes or fees charged for an order. |
| FEE_ADJUSTMENT | Adjustments made to any of the fee components. |
| TOTAL_FEES_ AND_COMMISSIONS |
The sum of all the fees and commissions charged for an order by an ordering platform. |
| TOTAL_FEES_AND _COMMISSIONS_ PERCENTAGE_OF _NET_SALES |
The total of fees and commissions in the percentage of Net Sales. Total Fees and Commission % of Sales = (Total Fees And Commissions / Net Sales) * 100 |
| MARKETING_SPEND_FEE | The marketing expense incurred on an order through discounts, coupons, etc. |
| MARKETING_SPEND _CREDIT |
The marketing expense credited back to the restaurant if there is an order adjustment or cancellation by the restaurant customer. |
| TOTAL_MARKETING_ SPEND_NET |
Net spend on marketing activities done for an order by the restaurant. Total Marketing Spend Net = Marketing Spend Fee - Marketing Spend Credit |
| TOTAL_DEPOSIT_ EXPECTED |
The amount expected to be deposited into the restaurant bank account post all deductions like service charges, commissions, taxes, and adjustments. |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.