If you offer third-party delivery at your restaurant, you already know the end-of-week nightmare: DoorDash or Uber Eats deposits money into your bank account, but the number on the bank feed never matches the gross sales on your Point of Sale (POS) system.
Why? Because delivery platforms automatically deduct commission fees, marketing promos, tablet fees, and customer refund adjustments before sending you the net payout.
If you simply record the bank deposit as “Sales Revenue,” your income statement will be wildly inaccurate. You’ll be underreporting revenue, missing out on valuable tax-deductible expense write-offs for commission fees, and potentially messing up your sales tax liabilities.
Here is a step-by-step guide to properly reconciling delivery app payouts in QuickBooks so your numbers stay accurate and your stress stays low.
The Big Mistake Most Restaurants Make
The most common mistake is recording the net bank deposit directly as revenue.
- Example: DoorDash deposits $1,000 into your bank account.
- In reality, your gross sales were $1,300, DoorDash kept $260 in commission fees (20%), and $40 was deducted for a customer refund.
If you just record $1,000 as revenue:
- Your sales look $300 lower than they actually were.
- You lose out on claiming $260 in deductible commission expenses.
- Your POS inventory and sales tracking will never align with your accounting software.
Step-by-Step Manual Reconciliation Method
To keep your books accurate, you must record the Gross Sales, account for all Deductions, and match the final Net Payout to your bank feed.
Step 1: Create the Necessary Chart of Accounts
Before entering transactions, ensure you have the following accounts set up in QuickBooks:
- Income Account: Delivery Sales (or separate accounts for DoorDash Sales, Uber Eats Sales, etc.)
- Expense Account: Delivery Commission & Platform Fees
- Expense Account: Delivery Discounts / Promotions
- Asset Account: Delivery Clearing Account (an Undeposited Funds / Holding account)
- Liability Account: Sales Tax Payable
Step 2: Record the Daily or Weekly Summary (Journal Entry)
At the end of a payout period, pull the official summary statement from your delivery platform portal (e.g., DoorDash Merchant Portal).
Create a Journal Entry in QuickBooks using the actual numbers from the statement:
|
Account
|
Debit
|
Credit
|
|---|---|---|
|
Delivery Clearing Account (Net Payout Expected)
|
$1,000
|
|
|
Delivery Commission Fees (Expense)
|
$260
|
|
|
Delivery Discounts/Refunds (Expense)
|
$40
|
|
|
Delivery Sales Revenue (Gross Sales)
|
|
$1,200
|
|
Sales Tax Payable (Tax collected by platform)
|
|
$100
|
Note: In “marketplace facilitator” states where DoorDash collects and remits sales tax on your behalf, make sure to adjust your sales tax liability line item according to your state’s local guidelines.
Step 3: Match the Bank Feed Deposit
When the actual cash deposit hits your bank account feed in QuickBooks:
- Go to your Bank Feed / Transactions.
- Do not categorize it as “Sales.”
- Instead, categorize the deposit to your Delivery Clearing Account.
- The balance in your Delivery Clearing Account for that transaction will now drop to $0.00, meaning the payout is officially reconciled!
Handling Order Refunds and Chargebacks
When a customer reports a missing item or cold food, delivery platforms often issue a refund and bill it back to your restaurant.
- Where to log it: Always log refunds under a dedicated Refunds & Allowances or Customer Disputes expense/income-adjustment account rather than reducing gross sales directly.
- Why it matters: This allows you to track exactly how much money your kitchen is losing every month due to delivery order errors, packaging failures, or driver delays.
How to Eliminate the Manual Work Entirely
Manually creating journal entries for every delivery service across multiple locations takes hours each week—and it’s easy to make a typo.
The modern solution is using automated integration tools (or specialized POS integrations) that automatically map gross delivery sales, platform commission fees, and taxes directly from your POS to QuickBooks every night.
When your POS syncs properly, payouts line up with your bank feed in a single click, saving your team hours of manual data entry while keeping your financial statements 100% audit-ready.
Contact Us For A Free Consultation
