Work out each rider’s pay from orders delivered, bonus, cash shortages and advances — with the net payable calculated for you.
Download the template
Free, no sign-up. Opens in Excel, Google Sheets, LibreOffice and Numbers, with the formulas already working.
What’s in the template
11 columns, a row of example entries you can overwrite, and a TOTAL row at the bottom. Columns marked “formula” are calculated for you — don’t type over them.
Column
What to enter
Date
—
Rider
—
Orders delivered
Completed deliveries for the day or shift.
Rate per order
What you pay per delivery — can differ by distance or rider.
Bonus
Peak-hour, rain or target bonus, if any.
Delivery payformula
Formula: Orders × Rate + Bonus.
Cash collected
Cash-on-delivery the rider collected from customers.
Cash deposited
Cash the rider handed over at the counter.
Cash shortformula
Formula: Collected − Deposited.
Advance taken
Fuel or salary advance to deduct.
Net payableformula
Formula: Delivery pay − Cash short − Advance.
How to use the rider payout sheet
Add one row per rider per day (or per shift). Enter the deliveries completed, the rate you pay per order and any bonus, then the cash the rider collected from customers and the cash they deposited. The sheet works out delivery pay, any cash shortage and the net amount payable after advances. Filter by Rider and read the TOTAL row to settle a rider for the week or month.
Keeping pay and cash in the same row means a rider is never paid in full while still holding the restaurant’s cash, and any shortage is visible on the day it happens rather than at month end.
Choosing a pay structure
Restaurants usually pay riders a fixed monthly salary, a rate per order, or a smaller salary plus a per-order rate and fuel. Per-order pay rewards busy riders but needs accurate delivery counts; fixed pay is simpler but costs the same on quiet days. Our guide to paying restaurant delivery riders compares these models. Whatever you choose, write it down and share it with riders so payouts are never a surprise.
From sheet to system
Once orders come from WhatsApp, phone, your website and delivery apps, counting deliveries by hand gets error-prone. A restaurant order system assigns each order to a rider, records cash on delivery, and gives you the payout totals automatically — so this sheet becomes a report instead of a daily task.
Restaurant Order CRM takes website and WhatsApp orders, assigns a rider in one tap, shows cash on delivery or online payment, and works out each rider’s commission, base salary and total payable.
Multiply the orders delivered by the rate per order and add any bonus. Then deduct any cash the rider collected but did not deposit, and any advance already paid. This template does all three steps for every row.
Can I use it for a monthly salary plus per-order rate?+
Yes. Keep a row per day for the per-order part, and add the monthly fixed salary as a Bonus entry on the payday row, or add a separate “Fixed pay” column and include it in the Delivery pay formula.
Does it work in Excel and Google Sheets?+
Yes. The file is a standard CSV with formulas, so it opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers. In Google Sheets you can also use “Copy for Google Sheets”, click cell A1 and paste. Save it as .xlsx or keep it in Google Drive so your formatting and new rows are kept.
Is the template free?+
Yes — free to download, change and use in your business, with no sign-up. The file is created in your browser, so nothing you type is sent to us.