Financials: Reconciliation

Jordan Sahmaunt
Jordan Sahmaunt
  • Updated

 

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.

 

Financials-


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:

Screen

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:

Screen

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:

Screen

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:

Screen

 


Glossary

image-20230427-225747.png

image-20230427-225805.png


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.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.