Order reconciliation

Your billing software's orders against the Swiggy and Zomato settlements

The till says what the kitchen sent out. The settlement says what was paid for. Put the two side by side, order by order, and see which orders one side has and the other does not, which disagree on whether the order happened, and which disagree on what it came to — to the paisa.

What it does
  • Missing orders, from either side

    An order in the billing software that no settlement carries, or a settled order the till never rang up. Only counted as missing where the other side covers that day — a settlement week not yet imported is not reported as a week of missing orders.

  • Status mismatches

    Delivered in one system and cancelled in the other. Both statuses are shown, side by side, for every order where they disagree.

  • Variances to the paisa

    Item total, packing, GST, the outlet's discount and the order total, compared field by field. A matched order that differs by so much as a paisa is listed, with both figures in the cell.

  • Rejected and cancelled orders

    Every cancellation with its reason, and who it is held against — the restaurant, the customer or the platform — where the settlement or its reason says so.

  • The final reconciliation and a summary

    Each settled order's commission, platform charges, government charges and payout, with payout as a share of item total and packing, and a summary by platform and in total.

  • Downloaded to be worked in

    A sheet per tab, the columns you chose on screen, money in rupees with two decimals and dates as dates — so it can be filtered and summed by an accountant without retyping.

How you use it

4 steps

  1. Fill the template

    Download the fourteen-column template and paste your billing software's export under its headings. Order ID and restaurant ID are text columns, so a long id survives as itself.

  2. Upload it

    Rows that cannot be read, or the same order twice, stop the upload with the rows named. A restaurant ID nobody has set up is a question: import the rows that match, or discard the file.

  3. Choose the scope

    A brand, one outlet, the platforms and the period. The settlements you have already imported are the other side — nothing new to upload for them.

  4. Read the tabs, and download

    Missing, status mismatch, variance, cancelled, final and summary — on screen or as one workbook.

Start with one brand and last month’s settlement file.

  • No partner-portal login needed
  • Your data is never sold or shared