How to reconcile a Zomato settlement report
· 7 min read
Zomato settles restaurants weekly and sends a settlement report with each payout, plus a monthly report. Reconciling it follows the same idea as Swiggy — rebuild what the payout should have been and compare — but the report is laid out differently, and reading it the Swiggy way leads to wrong answers.
What is in the report
- A payout breakup that summarises the period, starting from the net order value and ending on the net payout.
- An order-level sheet with one row per order and its fees, taxes and payout.
- Adjustment sheets for deductions and additions applied to the week rather than to an order — recoupments, penalties, credit notes, refunds.
Where Zomato differs from Swiggy
| Swiggy | Zomato | |
|---|---|---|
| Sign of a charge | Written negative | Written positive, and subtracted |
| Period charges | Growth Investment in Ads, Other Charges and Refunds | Investment in growth services, other charges and refunds, and deduction and addition sheets |
| A cancelled order | The basket is credited, then recovered | The basket is dropped and a refund is settled |
The sign matters most. On Zomato, a deduction of ₹500 is written as 500 under a Deduction heading, and an addition as 500 under an Addition heading. Only the heading tells you which way it goes. Reading the numbers alone turns a credit into a charge.
If the summary shows zeros
Much of Zomato's summary sheet is built from formulas. Opened in some tools, those cells can show zero or blank because the calculated values were not saved in the file. Open the report in Excel and let it recalculate before relying on the summary — or work from the order-level sheet, which holds plain values.
Checking each order
- Take the order's net order value.
- Subtract service fees and payment mechanism fees, and the tax on those fees.
- Subtract any other tax withheld on the row.
- Compare with the order's payout. Zomato rounds each line to two decimals before adding them up, so a few paise of difference across a whole week is normal; rupees on a single order are not.
Then the week
Add up the order payouts, subtract the week's deductions, add the additions, and you should land on the payout Zomato declares. A week can settle with no orders at all and still carry a deduction — a recoupment from an earlier order, for instance — which is exactly the kind of line that is easy to miss.
MenuMetrics does this for every order in every file you upload: it rebuilds each payout from the platform's own columns, checks it against what settled, and lists what does not tie — with the arithmetic — ready to raise as a claim.
Reconcile every payout, not a sample
MenuMetricsreads the Swiggy and Zomato reports you already download and checks every order against what settled. Start with last month’s file.