Zomato is a popular food aggregator app in India. It provides a platform for people to contact restaurants and order food online. As a restaurant, you can rely on Zomato to deliver food to customers as it difficult to take care of delivery yourself that too in multiple locations across the city. Additionally, your restaurant will get more exposure thus increasing the number of people that visit your restaurant.

When you put up your restaurant on Zomato all the order payments get processed through the Zomato app. But sometimes Zomato may collect an incorrect payment or miss out on some payments. Then you end up incurring a loss for an order that is delivered. So it is important to check and verify all payments processed through Zomato. Another issue that occurs is that the fee charged by Zomato could be incorrect or overcharged. In this case, you end up paying more than required.

You can now use our reconciliation software to get rid of these issues by automating the reconciliation of Zomato with MIS. The software automates data load while accepting multiple file formats such as CSV, XML, XLXS etc. It links and reconciles the POS report with the Zomato report to get a summarized view of all the payments and charges. It does so by cleaning and transforming the data so that you can see the total payments made and total charges at a single place. So, the finance teams can easily analyse the final output without much effort.

Reports Required for Reconciliation:

Zomato Order Report

This report includes information on every Zomato payment transaction and all fees charged

Client’s Internal Report

 The applicable fees and payments for each order are present in this report

Zomato MIS Reconciliation Result

The software links the Zomato report with the MIS/ POS report so as to provide a summary of all transactions. You will be able to view all the total payments and total charges in a single place. These charges are displayed store-wise for every month. This helps you systematically view the summary and check results.

Restaurant ID(res_id):

This is the unique identification number for each restaurant according to the location and store. This ID serves as a link between reports.

Transaction Month (Txn_month):

The relevant month of the transactions is displayed.

Sales as per POS Report

Shown here are the total sales recorded as per the POS/MIS system.

Sales as per Zomato order report:

These are the total sales reported in accordance with the Zomato orders.

The software, as seen in the columns above, links the POS/MIS report and the Zomato report and displays a summary of all charges levied. The total commission, GST, TCS and TDS charges at the store level are all displayed here. Restaurants will be able to see the total of all fee calculations in a single place with the help of our software.

Total Deductions

The sum of total commission, total GST, total TDS, and total TCS is the calculation of the total deductions.

Cancellation Refund

These are the orders which are cancelled by customers for which a refund is given.

Calculated Zomato Payable:

Total Sale Amount – Total deductions are the calculated Zomato payable amount. This is the amount that is supposed to be paid to you by Zomato.

Net Receivable Amount as per Zomato Report

The exact sum that Zomato has to pay is displayed as recorded in the Zomato report.

Difference

Calculated Zomato Payable- Net Receivable Amount as per Zomato Report calculation is used to show the difference in this column.

The amount for Current Month

This is the total payment amount settled in your bank account by Swiggy for this month.

Amount Settled in Bank in Subsequent Month

Shown here is the total sum that is paid to your bank account in the following month is depicted

Amount Pending to be Settled in Bank

This is the total amount that has to still be sent to your bank account.

The software simplifies Zomato with the MIS reconciliation process by automating it. The software automates the data load of necessary files in multiple formats (CSV, XML, PDF, XLXS, etc.) which you can choose as per your convenience. It then cleans the data and transforms it after the logic application. Once all these steps are done, the software produces  the reconciliation result as shown above. It displays the result in such a way that is easy to analyze for finance teams. You can also share the results with other relevant teams in your organizations. They can then get a summarized view of store-wise Zomato with MIS reconciliation every month without any manual effort. You can use this to keep a track of all the transactions processed through Zomato so that you never miss out on any payments.

Get started with Cointab!

Related Post