Xebia - Restaurant Reconciliation

Restaurant Reconciliation

Use Case Description

Restaurant Reconciliation is a Use-Case in which the restaurant reconcile is done for the restaurant with online sale using 3rd parties such as Swiggy and Zomato. The use-case verifies if the payment is done and received correctly from the delivery partner correctly.

Problem:
The reconciliation is a tedious job for a big restaurant with lots of sub-chain around the world.

Solution:
The bot does the reconciliation at the start of the day and extracts detailed reports from all the delivery portals for all different region. After the extraction is done, the bot extracts the report from the SAP or restaurant billing tool.

After the whole process is done, the bot tallies all regions of sale with the amount extracted from the portal. In case of any mismatch, the bot then does a deep dive into the report and verifies all the records of sale with online portal to find the mismatch.
Once the mismatch is found or missing entry is noticed the bot reports the same to the team for further steps.

Frequency of run - Every Day
FTE saved - 3 FTE Saved
Time for execution - 10 minutes per run
Pros - The team receives the final report and they don’t need to check everything manually.

AS-IS WORKFLOW, TO-BE WORKFLOW

Restaurant Reconciliation.pdf

Other information about the use case

Industry categories for this use case: Compliance, Finance, Operations, Other Sector

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio, UiPath Orchestrator

Other applications that were used: Chrome, Office 365, SAP

Other resources: Components Used:

What is the top ROI driver for this use case?: Minimize risk and ensure compliance in operations

Sorry, couldn’t read the whole thing.

hi @vikasrawat911
What were you not able to read, can you please clarify ?