Start a new topic

Third-Party Delivery Fees

I'm looking for advice on how to handle third-party delivery fees in our R365 Accounting module. Does anyone have recommendations?


I can help!!! 


A couple things we want to clarify first:

Does your third Party integrate with your POS?

If yes do the following: 

  1. Map all Payment types to their own Gl account (1201 AR-Uber Eats, 1202 GrubHub, etc.)
  2. Create a Bank Rule mapping all Third party deposits to their AR accounts.  (Uber to 1201 etc.)
  3. Unfortunately their is no way to get the fees from the POS, so you'll have to do this manually.
  4. Logging onto the third party's website obtain the following information to create a JE.
  5. Third party fees, commissions, etc. They should give you a break down for each deposit. 
  6. Create a JE debiting those expense accounts and crediting the AR accounts.
If your third party does not integrate with the POS take the following steps

  1. Manually create a JE based on the information in your third parties website. 
  2. Below is an example JE for every deposit the third party makes: 
Checking Account    90
Delivery Fees          10
                                         Sales 95
                                          Sales Tax Payable 5

If you get stuck let me know. :)

Joe Tidwell 
Partner/Founder
Synergy Restaurant Accounting
                    




3 people like this

Would love to hear your practices on what you do when the data from the third Party Delivery provider doesn't match the actual bank deposit. E.g. Doordash report says it will deposit $3,500, but they actually only deposit $3,450 - suspense account or Cash Over/Short?


Thank you!

The variance should be posted to Sales and Sales Tax. For example, if you get paid $50 less than expected and your sales tax rate is 7%, post $46.73 as a debit to sales (reducing sales) and debit 3.27 to sales tax payable.


If you are not using a 3PD integration to your POS (or manually entering the orders into the POS, typically there should be some way to get the data from the 3PD site to balance to the payment and you should not have a variance.


However, when you use a 3PD integration (or enter the orders manually into the POS), most often the POS totals and do not exactly match the services totals for various reasons:


1. Missing orders from the POS

2. Pricing difference between the POS and the delivery service

3. Credits that do not get posted to the POS.


At the end of the month we compare the GL AR balance (after posting  fees, tips, etc) to the actual check(s) outstanding and post a Sales/Sales tax adjusting entry to get the two to balance.


We have developed a utility to automate much of the process and generate the journal entries to post all the statement adjustments (del fee income, service fees, tips, etc). If you are interested, you can contact me.


Scott Gillman

CEO

Dine Technology

Scott@Dinetechnology.com




2 people like this
Login or Signup to post a comment