How to reconcile Swiggy and Zomato payouts, order by order

Why totals aren't enough

Aggregator payouts arrive as one bank credit covering hundreds of orders, net of commission, taxes and a list of deductions. Many restaurants check that the weekly total looks roughly right and move on.

The trouble is that totals can look right while individual orders are wrong: a cancelled order charged a penalty, an order missing from the statement entirely, or a promotion cost you didn't agree to. Order-level reconciliation is the only way to see these.

The five-step method

1. Pull orders from your POS. Export aggregator orders for the payout period, with the aggregator's order ID, gross value and status.
2. Download the payout statement. From the partner dashboard, get the order-level statement for the same period, not just the summary.
3. Match on order ID. Every POS order should appear in the statement, and every statement line should match a POS order. List anything that appears on only one side.
4. Break down each deduction. For matched orders, separate commission, GST on commission, TDS, packaging or delivery charges, penalties and promotion costs.
5. Match the net to the bank. The statement's net payout should equal the bank credit. If it doesn't, find the adjustment line that explains it.

Getting the accounting right

For restaurant services supplied through an e-commerce operator, GST is paid by the operator under Section 9(5). The restaurant doesn't charge output GST on those orders, so they should be booked differently from dine-in sales.

The aggregator also deducts TDS under Section 194-O on the payout. Record it against the aggregator so it can be claimed when you file your income tax return. Commission is an expense, and GST charged on the commission is recorded according to your input tax credit eligibility.

Raising disputes

Keep an exceptions list with the order ID, the issue, the amount and the date raised. Disputes are far easier to win when raised within the same payout cycle, with the POS record attached. Review closed disputes monthly to see which kinds of deductions come back most often.

Doing this every week

Done by hand, order-level reconciliation takes hours per brand per week, which is why it gets skipped. DeepRestaurantAI takes orders from your POS, reads the uploaded statement, matches every order, posts commission and TDS, matches the bank credit and lists the exceptions for your team.