Templates and checklists · Delivery order reconciliation sheet
Free sheet to print

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

Last reviewed 18 November 2026. A working tool for your own team, not legal advice.

How to use it

  1. Write one line for each order from the payout statement you receive for your delivery orders.
  2. 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.
  3. 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.
  4. Read the Difference. A minus figure means you were paid less than expected. Use the Note box to write what you asked and when.
  5. 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-sheet
Order IDOrder 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.

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.

Talk to us Join the early access list

Last updated:

Pricing is coming soon

We are keeping pricing simple. We will share it when Zentaro Serve launches in 2027. Join early access and we will tell you first.