Delivery order reconciliation sheet
A delivery order reconciliation sheet checks what you were paid for delivery orders against what you expected. For each order you write the order value, the charges taken and what was paid to you. The sheet shows the difference and the total short-paid.
What you type stays on your device. Nothing is saved or sent, so print it or download the CSV before you close the page. To make a PDF, choose "Save as PDF" in your browser's print window.
What it is for
A delivery order reconciliation sheet checks what you were paid for delivery orders against what you expected. For each order you write the order value, the charges taken and what was paid to you. The sheet shows the difference and the total short-paid.
Read more: Delivery partner cost per order · Daily sales reconciliation sheet
How to use it
- Write one line for each order from the payout statement you receive for your delivery orders.
- Write the order value and the charges taken. Leave Expected payout empty to use order value minus charges. Or type the amount you expected from your agreement.
- Write the amount paid to you for that order. If it has not been paid yet, leave it empty. The sheet shows it as waiting.
- Read the Difference. A minus figure means you were paid less than expected. Use the Note box to write what you asked and when.
- Look at the total short-paid at the bottom and take the list to the provider. Print the sheet or download the CSV.
Delivery order reconciliation sheet
Zentaro Serve · serve.zentaro.cloud/templates/delivery-order-reconciliation-sheetExample, not real data. Press "Clear all" to start your own sheet.
| Order ID | Order value (₹) | Charges taken (₹) | Expected payout (₹) | Paid to you (₹) | Difference (₹) | Note |
|---|---|---|---|---|---|---|
- Orders listed
- Total order value
- Total charges taken
- Total expected
- Total paid to you
- Total short-paid
- Paid more than expected
- Still to be paid
Worked example
Five made-up orders. Expected payout was left empty, so the sheet used order value minus charges taken. These are not real orders. Press "Fill with the example" to see them in the sheet.
- ORD-1001: ₹650 minus ₹162.50 charges is ₹487.50 expected. Paid ₹487.50. No difference.
- ORD-1002: ₹1,200 minus ₹300 is ₹900 expected. Paid ₹840. Difference -₹60. Short-paid.
- ORD-1003: ₹480 minus ₹120 is ₹360 expected. Paid ₹360. No difference.
- ORD-1004: ₹682.50 expected. Not paid yet, so it is waiting and not counted as short.
- ORD-1005: ₹300 minus ₹75 is ₹225 expected. Paid ₹240. Difference ₹15. Paid more.
- Total short-paid ₹60 on 1 order. Paid more than expected ₹15. Still to be paid ₹682.50.
Calculators that go with this
Questions about this sheet
What does Expected payout mean?
It is what you think you should be paid for the order. If you leave it empty, the sheet uses order value minus charges taken. Type your own figure if your agreement works differently.
Why is a waiting order not counted as short-paid?
Because it has not been paid yet. It may still arrive. The sheet adds it to a separate total called still to be paid, so you can chase it later.
Is what I type saved or sent anywhere?
No. What you type stays on your device. Nothing is saved or sent. Print the sheet or download the CSV before you close the page.
Want this done for you, every day?
Zentaro Serve launches in 2027. It keeps your sales, cash, stock and recipes in one place. Tell us what you run today and we will get in touch.
Last updated: