Table of Contents
Summary
Payment Difference View
Basic View - Difference Summary
Difference summary details
Advanced View - Order Summary
Advanced View - Transaction Summary
Glossary
Frequently Asked Questions
Summary
The Reconciliation feature, in the Financials Application, enables restaurant operators to easily identify any possible leaks in their payouts for orders fulfilled by them. Specifically, it helps them easily identify if there are orders that didn’t get paid for from the OFO or if there are any discrepancies in the payout amount for an order.
Payment Difference View
Features include:
-
Universal filters for Month or Brand/Stores.
-
Last payment date for the selected channels
-
Metric Values for
-
Payment Difference
-
Total Revenue
-
Calculated Payment
-
Actual Payment
-
-
A waterfall chart showing a breakdown of total revenue by
-
Total Revenue
-
Delivery Charges
-
Discounts
-
Tax Withheld
-
Calculated Payment
-
Difference
-
Actual Payment
-
Example Image:
Basic View - Difference Summary
Features included:
-
Toggle to change to Advanced View
-
Button to export data
-
High-Level metrics
-
Unpaid Orders
-
Partially Paid Orders
-
Pending Orders
-
-
Button to view order details
Difference summary details
|
Column |
Details |
|---|---|
|
Order Date |
associated date in MM/DD/YYYY format |
|
Order ID |
unique ID for completed order |
|
Order Status |
last known delivery/pickup status of an order |
|
Payment Status |
last known status of the payment from the ofo to the user |
|
Cancellation reason |
The specific reason the order was cancelled |
|
Platform |
The online food ordering platform this order came from. |
|
Revenue |
Subtotal + (tax + tax withheld) + delivery fee paid to restaurant + tips + positive adjustments + discount |
|
Calculated Payment |
The amount the user should be paid out for this order. |
|
Difference amount |
The difference between Calculated payment and the actual payment. |
|
Actual Payment |
The actual amount that was paid out to the user after adjustments. |
|
Brand |
The brand associated with the order. |
Example Image:
Advanced View - Order Summary
Features included:
-
Toggle to change to Transaction Summary View
-
Toggle to change to basic View
-
Button to export data
-
High-Level metrics
-
Received Orders
-
Delivered Orders
-
Cancelled Orders
-
Missed Orders
-
-
Button to view order details
Order Summary Details:
| Column | Details |
|
Order Date |
associated date in MM/DD/YYYY format |
|
Order ID |
unique ID for completed order |
|
Order Status |
last known delivery/pickup status of an order |
|
Payment Status |
last known status of the payment from the online food ordering platform to the user |
|
Cancellation reason |
The specific reason the order was cancelled |
|
Platform |
The online food ordering platform this order came from. |
|
Revenue |
Sales + Tax + Delivery Fee |
|
Calculated Payment |
The amount the user should be paid out for this order. |
|
Difference amount |
The difference between Calculated payment and the actual payment. |
|
Actual Payment |
The actual amount that was paid out to the user after adjustments. |
|
Brand |
The brand associated with the order. |
Example Image:
Advanced View - Transaction Summary
Features included:
-
Toggle to change to Order Summary View
-
Toggle to change to basic View
-
Button to export data
-
High-Level metrics
-
With Orders
-
Without Orders
-
Transaction Summary Details:
|
Column |
Details |
|---|---|
|
Transaction ID |
The unique identified associated with the payment for this order. |
|
Platform Order ID |
The unique identifier used by the food ordering platform for this order. |
|
Transaction Date |
The date the payment was paid out to the end user. |
|
Subtotal |
Value of the aggregate subtotal of the transaction excluding tax. |
|
Sales Tax |
The sum of any sales tax applicable for the transaction. |
|
Tax Withheld |
The sum of any tax withheld by the online food ordering platform for the transaction. |
|
Delivery Fee |
The sum of any delivery fees paid by the eater associated with the transaction. |
|
Delivery Commission |
The amount taken out by the online food ordering platform from the merchant payout to cover the delivery cost, or Delivery fee for restaurants. |
|
Processing Fee |
The sum of any additional fees charged by the online food ordering platform. |
|
Discounts |
The sum of any discounts initiated by the operator to promote sales |
|
Tips |
The sum of the tips that the restaurant receives |
|
Error Charges |
The sum of the error charges deducted from the payout. |
|
Adjustments |
The sum of any adjustments from the online food ordering platform post order completion. Generally due to disputes or order issues. |
|
Commission |
The sum of the commission paid to the online food ordering platform. For Grub Hub, this also includes delivery commission. |
|
Payout |
The sum of the total paid out to the merchant. |
Example Image:
Glossary
Frequently Asked Questions
1. Where do the numbers come from? Are they accurate?
Most of the data comes directly from your delivery partners. Otter analyzes them to show you in a much more understandable format where your money went. That way, the report is as accurate as what your delivery partners can provide.
For more details on how each field is calculated, refer to the glossary or the in-app tooltips.
2. How often is the report updated?
Each delivery partner has its own payment schedule, usually weekly. Once payout data is available, it will take 3-4 days to show in the reconciliation dashboard. In some cases, it could take longer than that.
3. Are all the reports automated?
Yes! You’ll be able to see the most recent date when the data became available.
4. How far back in time can I review my transactions?
This will depend on your delivery partner’s limitations.
If you need additional help or information, you can contact support via the following:
- Chat - Our live agents are available 24/7 to help you through your Otter device. Tap the chat button on the top right corner of the home screen.
- SMS/Text or Telephone - Send us a text or give us a call anytime at 1-888-681-8837 for prompt service from our support experts.
Updated