- What is the Deposit Reconciliation Report?
- How to Generate the Report
- Deposit Reconciliation Report - Terminology
What is the Deposit 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.
Deposit Reconciliation Report - Terminology
Summary Details
| 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 |
Sum of all the refunds and adjustment for a given date range. |
| SALES_TAX | 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. Total 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 Fees and Commission = Delivery Fee + Processing Fee + Ordering Platform Commissions |
| TOTAL_MARKETING _SPEND_NET |
The total of marketing credit, spend on discounts, and promotions. Total Marketing Spend = Marketing Credit + Discounts + 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 |
| TOTAL_PAYOUT_AS_ LISTED_THIRD_PARTY |
The actual amount listed by the third party in its statements as a 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 that were paid back by an ordering platform. |
| TOTAL_CANCELLED _NOT_PAID |
The total number of cancelled orders that are 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 that were paid back by an ordering platform. |
| CANCELLED_NOT_PAID | The total value of cancelled orders that are 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 Bev 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 who 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 Recivable = Gross Sales + Gratuity Tips To Store |
| GENERAL_COMMISSION | The fee an ordering platform charges to restaurants to make their store visible to potential customers and provide support and other related services. |
| COMMISSION_PERCENTAGE | The General Commission expressed in % of total Net Sales. Commission % = (General Commission / Net 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 total Net Sales. Processing Fee % = (Processing Fee / Net 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 total Net Sales. Delivery Fee % = (Delivery Fee Commission / Net 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 |
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 |
| 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 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.