Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
CoffeeShopBookeeper
Level 2

How to record a delivery service fees for Grub Hub, DoorDash and UberEats

I have seen the article: How to book Grubhub Sales for a restaurant? but wasn't quite satisfied with the answer. This is my situation. 

I am recording sales via a Daily Sales Receipt. UberEats, DoorDash and Grubhub are payments being placed in a clearing account not unlike cash on hand or credit card clearing account on the sales receipt which I want to reconcile.  Clover is my POS and all 3 delivery services are connected - no tablets. When a customer cancels an order or if we make an error that results in a refund for a specific item this information is not reflected in Clover reports. All the orders placed by the delivery services are part of  Net Sales Revenue. Payment in Clover is recorded as the full payment for the order inclusive of tax. Clover does not capture or account for the 30% delivery commission or fee. Tax is payable on the entire order prior to commission/delivery fee. When UberEats and DoorDash pay it is: Total Sales - refunds + Sales Tax, then Commission is subtracted to get the net payment. Net refunds and cancellations are relatively small. I have made the decision to record these items on the day of the week I receive my statement from the delivery providers by having it reflect as a refund on the Daily Sales receipt.  

I want to capture the commission/delivery fee as an expense not a discount on their sales.  I am not sure how balance this transaction since the delivery providers pay net and everything in the clearing account is the full amount. I would be interested in learning how other folks are handling this issue. 

1 Comment 1
JessT
Moderator

How to record a delivery service fees for Grub Hub, DoorDash and UberEats

Hi there, CoffeeShopBookeeper!

 

You quite have a tricky scenario, so I've summarized everything to be sure we're on the same page.

 

Here's what I'm getting: You have a restaurant that accepts orders from Grubhub, DoorDash, and Uber Eats. All sales (tax inclusive) are recorded in your Clover POS and are accounted for in a clearing account that you also want to be reconciled. Each sale is reduced by a 30% commission and a refund if there's one, but these deductions aren't reflected in Clover reports.

 

Process-wise, putting the sales in a clearing account can work, but I suggest having an accountant review this. Then, to deduct the commission or refund, include it as an additional line item when you transfer the payment from clearing to a business account. We can record this via a journal entry because you use a clearing account, not the Undeposited Funds.

 

On the other hand, the sales tax is already included in the sales receipt, so let's omit it from the discussion.

 

Let's transfer one payment transaction from clearing to a business account:

 

  1. Click +New and choose Journal entry.
  2. On the first line, select your clearing account and enter the payment amount in the CREDITS field.
  3. On the second line, select your business account (checking, savings, COH) and enter the net amount (deducted by commission or refund) in the DEBITS field.
  4. On the third line, select the commission or refund account and enter the amount in the DEBITS field. Create an expense account for commissions and refunds if you don't have one yet.

 

journal entry.PNG

 

The total refund in a week can be recorded as a separate journal entry. Just use the clearing and refund accounts on it.

 

Lastly, it's better to have this checked by an accountant, especially that we're manually posting amounts to accounts with the use of journal entry.

 

Comment below if you have questions along the way until you're all set. We're just right here to always assist you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us