- What is the Sales Reconciliation Report?
- How to Generate the Report
- Sales Reconciliation Report - Terminology
What is the Sales Reconciliation Report?
This report is derived from the unified transactions of all Ordering Platforms. It helps bridge the sales per your Ordering Platform statement to the deposit in your bank account based on the date of the deposit. This report lists all the sales that constitute the deposit for a given date/date range.
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.
Sales Reconciliation Report - Terminology
Summary Table
| 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. |
| TOTAL_SALES | The total food sales for a location for an ordering platform for a given date range. |
| TOTAL_REFUNDS_AND _ADJUSTMENTS |
The sum of all the refunds and adjustments for a given date range. Total Refunds and Adjustments = Refunds + Adjustments |
| SALES_TAX | The sum of sales tax for transactions in a given date range. |
| SALES_TAX_WITHHELD | The sum of all sales tax an ordering platform withheld to pay in jurisdictions with marketplace facilitator laws of the state. |
| GRATUITY_TIPS_TO_STORE | The sum of all tips paid by customers to the restaurant. |
| TOTAL_STATEMENT_ GROSS_RECEIVABLE |
The total gross sales receivable as per the ordering platform. This includes total sales, gratuity tips, and sales tax if not withheld by the ordering platform. Gross Receivables = Total Sales + Gratuity Tips To Store + Sales Tax (if not withheld) |
| TOTAL_FEES_AND_ COMMISSIONS |
The sum of all fees and commissions. This includes delivery fees, processing fees, and ordering platform commissions. |
| TOTAL_MARKETING _SPEND_NET |
The total marketing credit, spend on discounts, and promotions. |
| TOTAL_DEPOSIT _EXPECTED |
The money expected to be deposited into the account of a restaurant post the commissions, taxes, and other deductions. Total Deposit Expected = Total Statement Gross Receivable - Total Fees And Commissions - Sales Tax Withheld |
| TOTAL_PAYOUT_AS_ LISTED_THIRD_PARTY |
The amount the third party listed in its statements as payout made to the restaurant for a given date range. |
| PAYOUT_DIFFERENCE | The difference, if any, between the calculated deposit, i.e., the expected deposit versus the payout the third party listed. Payout Difference = Total Deposit Expected - Total Payout As Listed Third Party |
Details Table
| Column Name | Column Definition |
|---|---|
| TOTAL_ORDERS | The total number of orders placed at the location through the selected ordering platform for a given date range. |
| TOTAL_REFUNDS | Total number of refunds raised against the orders at a location for a given ordering platform in a selected date range. |
| TOTAL_CANCELLED_PAID | The total number of cancelled orders was paid back by an ordering platform. |
| TOTAL_CANCELLED _NOT_PAID |
The total number of cancelled orders still unpaid by the ordering platform. |
| FOOD_AND_BEV_PRE_ADJ | The total amount of all the orders placed, excluding taxes and adjustments. |
| REFUNDS | The sum of all the refunds for orders in a given date range. |
| ADJUSTMENTS | The sum of all the adjustments for orders in a given date range. |
| CANCELLED_PAID | The total value of all cancelled orders paid back by an ordering platform. |
| CANCELLED_NOT_PAID | The total value of cancelled orders still unpaid by the ordering platform. |
| FOOD_AND_ BEVERAGE_SALES |
Total food sales at a restaurant excluding the refunds, adjustments, and cancelled unpaid orders. Food and Beverage Sales = Food And Beverage Pre Adjustments - Refunds - Adjustments - Cancelled (Not Paid) |
| 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 | The sales tax charged on the order by the ordering platform. |
| TAX_FROM_CANCELLED _NOT_PAID |
Tax charged by an ordering platform for cancelled orders that are not yet paid back to the restaurant. |
| 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 withheld by the ordering platform. Gross Sales = Net Sales + Other Income To Restaurant + Sales Tax Withheld |
| GROSS_SALES_ WITHOUT_WITHHELD |
The Net Sales with other income to the restaurant included but without the withheld tax. Gross Sales = Net Sales + Other Income To Restaurant |
| GRATUITY_TIPS_TO _STORE |
The tip paid by an eater to the delivery agent. Applicable for restaurants that do their own delivery. |
| TOTAL_STATEMENT_ GROSS_RECEIVABLE |
The gross receivable, per the Ordering Platform statement, includes gratuity tips to the store and gross sales. Total Gross Receivable = 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. |
| COMMISSION_PERCENTAGE | The General Commission expressed in % of total Net Sales |
| 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 total Net Sales |
| 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 total Net Sales |
| 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 Commission = General Commission + Processing Fee + Delivery Fee Commission + Other Fees And Taxes + Fee Adjustment |
| 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 Net Sales = (Total Fees And Commissions / Net Sales) * 100 |
| TOTAL_MARKETING _SPEND_NET |
Net spend on marketing activities done for an order by the restaurant. |
| TOTAL_DEPOSIT_ EXPECTED |
The amount is expected to be deposited into the restaurant bank account after all deductions like service charges, commissions, taxes, and adjustments. Total Deposit Expected = Total Statement Gross Receivable - Total Fees And Commissions |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.