Skip to content
MyToolers

Restaurant Delivery Rider Payout Sheet Template

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.

ColumnWhat to enter
Date—
Rider—
Orders deliveredCompleted deliveries for the day or shift.
Rate per orderWhat you pay per delivery — can differ by distance or rider.
BonusPeak-hour, rain or target bonus, if any.
Delivery payformulaFormula: Orders × Rate + Bonus.
Cash collectedCash-on-delivery the rider collected from customers.
Cash depositedCash the rider handed over at the counter.
Cash shortformulaFormula: Collected − Deposited.
Advance takenFuel or salary advance to deduct.
Net payableformulaFormula: 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.

Related guides

Ready to replace the spreadsheet?

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.

Frequently asked questions

How do I calculate a delivery rider’s pay?

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.