What is the Unreconciled Transactions Report?
The Unreconciled Transactions report displays all transactions that didn't match the integrated POS and Ordering Platform statements, helping identify discrepancies.
This may happen due to any of the below three reasons-
- Transactions with Mismatched Pricing: Transactions where the sales amount reported by the Ordering Platform differs from the POS. Understand the Terminology for Transactions with Mismatched Pricing here.
- Orders Only in OP Statement: Transactions found in our order integration that data do not match an Order ID from the Ordering Platform statement. This could include orders that errored when integrating and, thus, were not directly injected by Checkmate.
Understand the Terminology for Orders only in OP Statement here.
- Orders Only in Checkmate: These transactions can stem from an order with a different Order ID than originally sent to Checkmate. Other orders that fall into this report should be analyzed in more detail to determine the cause, as it could imply that you processed an order you were not paid for.
Understand the Terminology for Orders only in Checkmate here.
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.
Transactions with Mismatched Prices - 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_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_BEVERAGE_ SALES |
The total amount of revenue generated on the sale of an order after the adjustments have been taken into account. |
| FINAL_POS_SUBTOTAL_ INC_ELEVATION |
This is the total of Sales recorded in Point of Sales and Elevation. Final Sales = Sales recorded by Point of Sales + Elevation |
| TOTAL_PRICE_ DISCREPANCY |
The difference between Food and Beverage Sales, i.e., sales on the ordering platform and Final POS subtotal including Elevation, i.e., the sales recorded on the POS. Total Price Discrepancy = Food And Beverage Sales - Final Pos Subtotal Inc Elevation |
Orders only in OP Statement - Terminology
| Column Name | Column Definition |
|---|---|
| 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 | 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 Beverage sales 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 fees 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. 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, as per the OP statement, including gratuity tips to the store and gross sales. OP Gross Receivable = 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. |
| 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 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 in case 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 Spend = Marketing Spend Fee - Marketing Spend Credit |
| TOTAL_FEES_OVER_ NET_SALES |
The total of fees and commissions in the percentage of Net Sales. Total Fee over Net Sales = (Total Fees And Commissions / Net Sales) * 100 |
| 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 Expected Deposit = Op Statement Gross Receivable - Total Fees And Commissions - Sales Tax |
Orders only in Checkmate - Terminology
| Column Name | Column Definition |
|---|---|
| ORDER_NUMBER | Unique ID created by IACM to map the transactions in the ordering platform statements with the transactions in order processing/POS. |
| ORDER_DATE | The date when an order was placed. |
| POS_SUBTOTAL_ PER_POS |
The food and beverage sale amount as recorded in the Point of Sales. |
| TAX_PER_POS | Tax per transaction as recorded in the Point of Sales. |
| EXPECTED_POS_ RECEIVABLE |
The sum of POS subtotal and Tax as per POS. This is the amount to be received by the restaurant as per the Point of Sale. Expected POS Receivable = POS Subtotal + Tax as Per POS |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.