- What is the Fully Reconciled Transactions Report?
- How to Generate the Report
- Fully Reconciled Transactions Report - Terminology
What is the Fully Reconciled Transactions Report?
This report shows all transactions we could match between what we integrated into the POS and the statements provided by the Ordering Platforms. These are the transactions where the payout aligned with what the POS recorded.
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.
Fully Reconciled Transactions 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 IACM 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 order that was placed by the customer. It can have different values, such as order, refund, adjustment, cancelled, etc. |
| ISSUE | The column name 'issue' refers to a text field that contains 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 |
Total amount of the order placed excluding taxes and adjustments. This column is also used to map the refunds restaurants refund to the customer when they report order errors. |
| ADJUSTMENTS | Adjustments restaurants made to the price of items once an order has been placed (excl tax). |
| FOOD_AND_ BEVERAGE_SALES |
Total amount of revenue generated on sale of an order after the adjustments have been taken into account. Food and Beverage Sales = Food And Bev Pre Adjustments - Adjustments |
| 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 fee charged by restaurants to eaters. |
| ADJUSTMENTS_ TO_TAX |
Adjustments to tax made to balance the adjustment amount for a transaction. |
| 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. 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 who do their own delivery. |
| OP_STATEMENT_ GROSS_RECEIVABLE |
The gross receivable as per the OP statement including gratuity tips to the store and gross sales. Gross Receivable as per OP = Gross Sales + Gratuity Tips To Store |
| GENERAL_COMMISSION | The fee an ordering platform charges to restaurants to make their store visible to potential customers, provide support and other related services. |
| GENERAL_COMMISSION _PERCENTAGE |
The General Commission expressed in % of Gross Sales. 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 |
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 |
| 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 incase there is an order adjustment or cancellation by the restaurant customer. |
| MARKETING_SPEND _NET |
Net spend on marketing activities done for an order by the restaurant. Net Marketing Expense = Marketing Spend Fee - Marketing Spend Credit |
| TOTAL_FEES_OVER _NET_SALES |
The total of fees and commissions of Net Sales. Total fees over sales = Total Fees And Commissions / Net Sales |
| TOTAL_DEPOSIT_ EXPECTED |
The amount expected to be deposited into the restaurant bank account post all deductions like service charges, comissions, taxes and adjustments. Total Deposit Expected = Op Statement Gross Receivable - Total Fees And Commissions - Sales Tax |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.