Fix Your Third-Party Deliveries Through An Automated Reconciliation Process

Blog post

One of the most impactful (and most positive) outcomes from COVID-19 is the dominating presence of third-party delivery services and its continuing growth.

However, with the rise of third-party delivery services like DoorDash and Uber Eats, most companies in this realm have no real third-party delivery reconciliation process. The few that do find their current third-party delivery service reconciliation process is broken, replete with manual interaction, and lack of visibility. This results in frustrated employees, lost revenue, and potential fraud.

Without an automated reconciliation process, at nearly every step there are opportunities for incorrect transactions. From the initial moment a customer places an order via a third-party app, the potential for incorrect food pricing and incorrect tax calculation and collection exists. This is especially true if multi-way matching is involved.

  1. When the point-of-sale (POS) receives that order, duplicate orders or fraud can occur, which could result in higher food costs or lost revenue.
  2. Once the order is received by the customer, the third-party then sends payment, commission, and/or feed data to the restaurant – which overall lacks visibility and control, not to mention the possibility of short payments.
  3. Lastly, if the restaurant manually reconciles revenue and related expenses, it would be a lengthy reconciliation process with limited data followed by a manual journal entry process – with plenty of room for error (e.g., missing revenue and/or third-party expenses).

Without an automated reconciliation process, transaction matching can bury your finance team.

Scenarios you might have come across in your third-party delivery services reconciliation process:

The order number from the third-party delivery service does not match the order number on the POS

The food cost and tax amounts for the day exist, but the order number does not match, causing difficulties when matching transactions by order number.

Tax does not match between the third-party delivery service and POS

In an instance where the calculated tax amount does not match between third-party delivery service and POS, it is important to resolve these tax differences, especially depending on who is collecting and paying the tax, be it the restaurant or the third-party delivery service.

POS subtotal is higher than the third-party delivery service

The POS is showing a larger amount for the food costs than the third-party delivery service. This could be an instance where the third-party delivery service is not charging for a menu item (think about add-on menu items that might not be priced in an external app). The amount will start to become material if this occurs on multiple occasions without notice.

Third-party delivery service food cost is higher than POS

Here we have an instance where the third-party delivery service might possibly show the food cost is higher. We would want to do additional research to understand why the extra amount is missing on the POS.  Did the third-party delivery service have 5 items ordered but only 4 came through the POS, which would explain the variance?  Does something need to be added to the POS to make up the lost revenue?  Also, if the POS is correct, does the third-party delivery service have the correct commissions calculated?

Order is on the third-party delivery service, but not on POS

This could be an instance where either the sync between the third-party delivery software and the POS was broken or the POS is missing the order, thus revenue is not being recorded for this order.  Otherwise, it is possible that the order was canceled through the delivery service app for some reason, but it is not showing on the third-party delivery service transaction file.  This would be an instance where additional research would be required.

Order is on POS, but not on the third-party delivery service

Here we have an order with tax and subtotal on the POS but no corresponding order with the third-party.  Could this have been manually entered into the POS at the restaurant, the food was made, but it never went to a customer?  Did the store employee get free food knowing that the restaurant is going to go back to the third-party delivery service and ask where their money is?  This is the instance of fraud that is most worrisome to restaurants.

Keep track of all your orders with an automated reconciliation process

Adra’s Matcher will automatically perform reconciliation of POS to third-party, eliminating the manpower once necessary for reconciliation. This put a process around an activity that was previously prone to errors and gives back valuable time. Companies can now equip your team with visibility into monies owed by third-party and accurate data with Adra’s automated reconciliation solution. Finally, any potential fraud committed can be identified and researched for resolution.  Learn more about the challenges third-party delivery services face.

[cta-content-placement]

Written by: Jae Kim