artificial intelligence company in india, ai companies in india, robotics process automation, automation solutions, rpa service providers, top rpa companies, robotic process automation companies, rpa service companies, cloud rpa, automation roi, technopark rpa company, intelligent automation, pay master rpa company, invoice process automation, iq bot service, rpa service companies in dubai
Demo

Automated GST Reconciliation

Leave a Comment
Automated GST Reconciliation by Alzone Software

Whether companies struggle for achieving financial forecasting by overcoming the complaints and different transactional formalities happen in between the process of GST reconciliation  . Inorder to master this tedious process implement Robotic Process Automation and automate the entire process of financial transactions and GST reconciliation. Our client was India’s largest IT products distributer company who provides distribution solutions and end-to-end supply chain solutions for all categories of Information Technology, Telecom, Lifestyle, Healthcare, and Solar products.  As we all know the process of GST reconciliation was very much hectic and tedious for employees. The process involves many complicated steps like reconciliation of different reports against GST data and it consumes huge time for the processing of enormous number of pre-defined rules. This single process creates so much headaches and make delay in MIS reports generation within the limited time-frame. Now our client is experiencing a trouble-free GST reconciliation process using RPA technologies and the reason behind this success was Alzone. With the help of our experienced professional team we had deployed unattended RPA Bots for the execution of GST reconciliation and MIS Reports generation Process

Financial institutions perform reconciliation of their GST transactions to ensure that the data filed by the suppliers match with those of the recipients and there are no missing or wrongly reported sales or purchases in the GST returns. It takes a lot of human effort but still results with calculation errors, data entry mistakes and unidentified transactions. This ultimately ends up with auditing and accounting issues as well as financial loss. Here the unattended bots can perform 4 major mundane steps involved in this GST reconciliation process like Accounts Payable Reconciliation, Accounts Receivable reconciliation, GSTR2A Reconciliation and finally the MIS reconciliation report. Our bots are designed to trigger automatically at defined intervals to do the entire reconciliation process without any human intervention. Bot identifies the fully matching transactions as well as partially matching and unmatched transactions with reasons or pointers for corrections and sent intimations if any discrepancies are found. Bots do the reconciliation of tax amount / tax bucket in the registers by matching against the GL and reconcile all other transactions on the basis of a set of pre-defined rules. After all reconciliation processes the bot itself share the summary report and Consolidated GSTR2A report with customer via shared folder

 

This effective GST reconciliation has reduced the complexity of the process and improved auditability and standardization. RPA technologies leveraged by Alzone had fasten the financial decision making by accessing the real time GST figures and by automating financial computation tasks, RPA enhanced the skilled officials to focus on higher-value work.  When done manually all these processes takes hours to complete and that will affect the preparation of final reconciliation report, after using RPA technology finance team is able to get the reconciliation report much earlier than before which helps them to follow up with defaulters at the earliest. With the help of our unattended bots officers can frequently access to the tax reports which help the top management to assess the tax liabilities and avoided reworks due to manual errors

Leave a Comment

Your email address will not be published. Required fields are marked *

Our Locations

USA

Alzone Software LLC
651 N Broad St, Ste 205 #6403Middletown, Delaware 19709, United States

UAE

Alzone Software Solutions LLC
HH Shaikh Saud Bin Saqar Al Qassimi Building,
Al Muteena, Plot Number 39-4,
Land DM No 123-702,
Makani No 31044 95966,
Dubai, UAE

INDIA

Alzone Software Pvt Ltd,
ACE 04, 3rd Floor, C-DAC Building, Technopark Campus,
India 695581

Social Links

Linkedin Instagram Facebook Youtube

Links

Get in Touch

(+1) 201-203-9374 (USA)
(91)4713501635 (INDIA)
(+971) 523925029 (UAE)
 [email protected](INDIA)
 Mon – Fri 9:00am – 6:00 pm

Copyright © 2023 Alzonesoftware | USA | INDIA | UAE. All rights reserved.

Web designed and developed by Cpool Digital Learning

$65K Annual Savings due to

Automation of Document processing and Govt portal submission

 

About the Customer
The customer is one of the leading international freight forwarding companies, offering a multitude of services to meet customer’s business needs. They have a customer base over 30 countries around the world, who rely on their expertise to manage the day-to-day logistic needs. They believe in delivering logistics services on time and cost effectively. That’s why customers in over 30 countries around the world rely on their expertise to manage their day to day logistic needs.

About the process
Dubaitrade is a government website. Each freight forwarder has to update the details of each shipment whether they be import or export and make the payment accordingly. Even a slight mistake will cause heavy financial penalties to the freight forwarder. Hence accurate detailing is very essential.

Challenge:
Increased Employee Expense: More than 2000 invoices and supporting documents are received per month for freight forwarding. Skilled resources time are wasted on manually extracting data from each document and updating Dubaitrade website (govt owned) and making the payments. Each document follows a different format. Company incurs increased recruiting and training expense every month since employees are constantly moving out after 3-4 months after they learn the operation.

Solution:
Using RPA, Alzone designed a solution where the bot extracts the data from the documents. The bot has been trained for each invoice format and it functions 24×7 without any hiccups. The employees’ role comes only if the bot encounters any discrepancy in the current invoice or for any new invoice.

Impact:
The number of employees to be maintained reduced to 3 from 15 which resulted in an annual savings of $65K

MIS REPORT GENERATION PROCESS - AUTOMOBILE

Automobile dealerships has shown great signs of improvements and technology upgrade recent times by adopting newest technologies in the market. The OEM provided DMS had severe complexities like delivering real time business critical data, frequent price changes, applicable tax differences, new part additions, part number changes etc and was not provisioned for dealerships to generate the data on a single sheet. Dealerships had an internal ERP application separately to track this data and deployed huge manpower in all multiple locations to update the same manually in ERP which has the below mentioned business challenges.

  • Delay in entering daily report to the application due to large volume data from different subunits.
  • Daily MIS generation report for revenue calculation
  • Inappropriate Tax calculations which resulted in revenue loss.
  • Frequent price changes of parts are not available with the dealerships so has to add manually in ERP.
  • DMS is limited to provide real time stock report from multiple locations.

Alzone digitalized the entire operations by deploying MIS BoT and allowed for real-time monitoring of Stock Maintenance, generation of MIS reports featuring Parts Sales, DSR with revenue details, accurate tax calculations as per prevailing rules. This helped the business to enhance smooth running of business operations, effective utilization of resources increasing operational efficiency and maintaining business critical necessities which resulted in :

  • Helped for seamless integration between DMS & internal application.
  • Fastened the process of generating real time MIS reports daily to the top management.
  • Operational backlogs has been reduced almost to “ZERO”.
  • Each and every changes within DMS will get notified and updated automatically in internal application without any human intervention which includes changes in pricing, parts, tax amounts
  • Financial critical data like tax paid, revenue gain through service, part sales, accessories sales in each unit individually are made available to the management anytime anywhere.
  • Automation helped to monitor the parts movement on a daily basis and helped the dealership to identify the parts availability at respective locations to maintain inventory management ensuring better customer service.

BANK TRANSFER PROCESS AUTOMATION

Our client is one of the largest energy company who are into production and exploration of oil and energy and suppliers around the world.

Business Challenge

Being a whole time energy company they are into production and distribution of energy supplies around the globe. Most of their clients are spread across the world the payment realization is done through transfers and in destination currencies as well. For realization they deal with almost 20 bank accounts and most of the back activities are done manually as well. They receive 20 emails per day with cash realization and expense reports. Manual labourers are deployed to read the mail and download the statement and are assigned to do matching and reconciliation tasks manually. Theses tasks includes :

  • Has to read the statements and understand the transfer details.
  • Verify the same with the master sheet using account numbers.
  • Need to identify the counter transfer using transfer id.
  • Verify the same with transferred account and received account.
  • Those matched records has to be updated in their ERP system on a daily basis as well.

These activities take 6 hours day and has manual entry errors and missing entries as well. As a part of Digital Transformation Journey, Our client has decided to automate the Bank Account – Counter Transfer process.

Solution

Alzone’s RPA team has done a detail discovery of the process and developed a BoT to do the Bank Account Transfer Process. The developed BoT read the emails and downloads the statements send by the finance team. The BoT will then log into the ERP system using necessary credentials. The BoT will extract the data from excel sheet using counter transfer as the key word and validates using account number, date, amount and transaction id. Then the Bot will search for the similar transaction details in received accountusing the same credentials and matches the records. Thus matched records will be updated in the ERP – Bank transfer successfully by the BoT without errors and in less than 10 minutes per day.

  • No human Intervention
  • Made 100% error free process
  • Faster processing and data updations.
  • Reduced workload and processing time from 6 hours to 6 minutes for the whole transaction.

VENDOR ONBOARDING AUTOMATION - DATA EXTRACTION & COMOS UPDATION

The client is an upstream Oil and Gas company who is an active explorer, driller, Producer, Refiner and Distributor for petroleum products in India market.

Business Challenge

Being a pioneer among in Oil and Gas industries, they have large machineries used in the plants, explorations fields and refineries as well. These machines are sold and serviced by multiple vendors at different refineries. These machines requires repairs, parts replacements and annual maintenance frequently. Also for each parts of the machinery they have different service vendors. So the refinery receives almost 500 multiple formats of drawings from those service vendors with their details. These records has to be maintained at the refinery for any service purposes. Currently almost 20 people has been deployed to scan and update these documents within their internal COMOS application. They have to process almost 500 documents on a daily basis. As a result the current process cycle they had backlogs and the associated manual activities resulted in data entry errors, excess time consumption for data reading and manual entries as well.

Solution

We Alzone Software, got engaged and we automated the entire Data creation and SAP upload of engineering drawing using Intelligent RPA Automation and advanced OCR Technology. We designed and created Attended RPA BoTs for Real Time automations. Once the document is scanned and saved into the system, our advanced OCR technology will read and extracts the relevant data from scanned sheet and saves it into a folder. The our validation BoT will read the data and validates for errors if any and process the sheet for final upload. Then our System BoT will read the validated data and uploads the same within COMOS application.

  • Automated the entire data creation and validation
  • 100 % error free data capture using advanced OCR Technology.
  • Reduced time consumption and man hours by 90%
  • Slashed processing time to 10 Minutes.

INSURANCE CLAIM SUBMISSION

An US based company that provides network-enabled services for healthcare and point-of-care mobile, has a network of more than 160,000 providers and 110 million patients and offers a suite of services to manage medical records, revenue cycle, patient engagement, care coordination, and population health. Currently operations are handled by human and is going to be fully automated and to be handled by automation.

To tackle this challenge an AA RPA digital bot was designed with an WLM (Workload Management) which will divide your automations into small, yet logical work items and process them simultaneously to ensure that time-based Service Level Agreements (SLAs) are met with optimum resource utilization. They are having lakhs of patient details in excel format which are processed manually. Workload Management (WLM) allows the manual prioritization of high-value transactions inside the automated queue management model.

HOSPITAL END TO END AUTOMATION

A hospital network wants to improve their customer relationship management process as a key strategy to increase their business volume. As part of the strategic plan, in order to meet the increased volume of customers with desired customer satisfaction, they decided to decouple the customer engagement activities with various departments such as appointments, front office, billing and payments, pharmacy etc. They realized that their present Hospital Information Management System (HIMS) is a bottle neck to meet the organization goal due to its limitations. Upgrading the legacy HIMS system, to cater the present need is an impossible task as there is no sufficient technical documents present to scale the HIMS system and also no OEM support is available.

Implementing an RPA solution which provides seamless data integration between CRM and HIMS systems without impacting the current operations activities was the best way of overcoming the challenge. The solution consists, a group of attended and unattended bots which handle the data need of both CRM and HIMS in a synchronize and asynchronies mode based on the business nature.

TITLE, TAG & INSURANCE

The external transactions happening in an automobile dealer management system is as tedious challenge as the sale of a vehicle. The process mainly includes the following:

  • Vehicle registration(Title)
  • Extended warranty issuance
  • Insurance issuance
  • Tagging

Once a vehicle is chosen by the customer, then the process of other external transactions starts. But when is done manually, it becomes a very complex process.

An RPA bot was deployed to solve the situation. The bot will make data entry for the insurance and extracts the policy from the insurance company. Then if the customer has requested for some extended warranty the bot will process it and move on to registration (title) and tagging process. Once all these external transactions are done bot notifies the dealer along with required documents to be downloaded.

AUTOMATION OF DEALER MANAGEMENT SYSTEM

The dealer management system in the process of automobile sales includes the following steps:

  • Enquiry about the vehicle(online or offline)
  • Collecting customer details
  • Submission of necessary documents
  • Details about the accessories purchased(if any)
  • Delivery of the vehicle

In this whole process two ERP systems are involved, the dealer level and the manufacturer level ERP systems. The data extraction from the dealer ERP system to the manufacturer ERP system and vice versa happens in many occasions like on vehicle registration, accessories requirement request raising etc.

The main challenges faced in this process are:

  • Data punching in to these ERP systems
  • Vehicle availability check
  • Raising request for the accessories
  • Manufacture and dealer inventory matching

An RPA bot was designed and trained to overcome these tedious tasks with less human intervention and without much of a time delay. The bot does the data extraction from the one ERP system to the other whenever it is required.

AUTOMATED E-WAY BILL GENERATION

What makes E-way bill generation a difficult process is the possibility of data entry errors, delay in issuance and providing the state specific credentials each time. The process involves logging in and fetching invoices from the company in-house portal, then extracting the required data and finally uploading it into the government E-way bill portal to generate the corresponding E-way bill. On a daily basis when the task is done manually the process could take hours to generate E-way bills for a batch of files causing unproductive use of resources, when they could be allocated for productive work rather than for such mundane tasks.

To solve this challenge an attended bot was deployed with the assigned tasks of:

  • Logging into company portal and downloading the invoices
  • Data extraction from those invoices
  • Logging into the Quicker E-way bill portal
  • Entering the captcha (where bot requires assistance from the operator)
  • Populate the required fields with data
  • Send the bill generated to the respective transporter

ONLINE LICENSE VALIDATION AND PROVISIONING AUTOMATION

Our client is a global technology company which operates in the information technology product distribution business, supply chain solutions and after sales services of information technology products.

Business Challenge

Being a whole time partner for IT product companies, our client is enabled to distribute and provision the IT Product assigned to their region. Our client receives almost 100 Webex customer orders per day from multiple e-commerce applications and need to provision these Webex licenses at the earliest for successful activation. Usually these licenses are valid for a period of one year from the date of activation and provisioning. They do have some credentials which is of alpha numeric code which has to be read and updated manually. Our client has a team of people together to do this function which often results in human errors, not meet with demand and supply requirements which resulted in cancellation and revenue loss as well.

Solution

As a part of Automation Journey, We Alzone Software are assigned to continue with this process for automation as well. Alzone’s Engineers done a detailed process discovery and arrived at a better solution for Webex license Provisioning. We have designed and developed a License provisioning BoT for license validation & provisioning purpose. The BoT will download the data from our client portal in an excel sheet. The BoT will read the data and using the credentials will log into the CISCO WebEx portal. Then the BoT will update the data against the end user details by updating their necessary credentials and will update all the information for successful activation

  • No human Intervention
  • 100% error free license provisioning.
  • Faster processing and data updations
  • Automated 100% license provisioning process

ANALYTICAL REPORT GENERATION

A leading FMCG company implemented RPA solutions in automating the business and sales related reports. There are different types of reports are generated by business people, that are weekly /monthly /quarterly/yearly reports for business analysis. The process involved in extracting input data from different resources (SAP, database, website(oracle cloud ERP system), Excels) and doing different data operations like data validation, reconciliation, and data manipulation as per the requirement of different level business perspective. After that sharing a proper report to the corresponding business persons of different region or sharing the report to the corresponding resources for the backup. There are many employees working to generate these repetitive reports.

A RPA bot was deployed to solve this repetitive report generation problems. The bot will read and understand various inputs from various sources in different formats like spreadsheets SAP Data, applications and/or websites. After collecting the relevant data based on some conditions and formulas, bot performs data massaging to come up with the required data. Finally the required output files will be generated from the collected data and will be shared to the business. This solution perfectly generates the report on a timely manner and without any manual influences.

UNATTENDED AUTOMATION OF PO PUNCHING

The tedious challenges faced during the punching of orders on to the system are its massive volume and the complexities involved. Once the purchase orders of different PDF formats are received, it has to be read and entered to the ERP system for order generation, which usually takes about two weeks to complete. It takes place by converting the PDFs to a standard CXML format to upload it to the business system. Following that a series of validation steps are conducted and finally the orders are punched on to the system. But when a RPA bot is introduced to automate the process of reading PDF purchase orders of different formats using OCR system, the task is completed in a single day. It make use of the Python based AI crafted algorithm to read various formats of OCR outputs. When the bot manages the overall order punching, the processing time is reduced to 20 minutes.

Bot also handle third party business-to-business systems like Ariba and Coupa, sometimes it results in punching of order failure. The failure could happen due to the complex and strict validations and authentications involved. As a result the task to re-punch it manually by identifying and rectifying the error increases the complexity of the process. But the automation solution ensures the successful re-punching of erroneous orders by self identification and rectification of the cause.

HUSTLE FREE PERFORMA INVOICE GENERATION

The challenge was the delay in invoice generation against the purchase enquiries submitted by the customers. This happens because the customers can send these purchase enquiries in any file format such as PDFs, Excel, Word, HTML etc. The file send also shouldn’t have any standardized formats for making the extraction of purchase enquiries details because each customer has different formats. The Oracle ERP system with the punching team enters the extracted data in to the ERP enquiry registration and a corresponding Excel sheet is being downloaded. Some macros are being run at this time and it is passed on to the ODOO ERP system to generate the invoice and finally these invoices have to be send to the corresponding customers. To manually perform these tasks it takes a substantial amount of time.

To solve this challenge, a cognitive RPA solution was designed, by which the bot will fetch data from the purchase enquiries that comes in multiple formats by making use of machine learning and NLP techniques. The punching of data into the Excel file and running some macros are also done by the bot. Once the data is extracted the bot passes it on to the ODOO ERP system for generation of performa invoices for each purchase order. On generation of these performa invoices the bot itself will be sending it to the corresponding customers. Thus invoices for purchase orders can be sent on a timely manner, without much of human interventions.

CHARGE ENTRY PROCESS

Our client is one of the leading revenue cycle management and medical credentialing verification processes company in India having their headquarters in US. They improved the internal billing efficiencies for about 80 customers by deploying robots to manage the Charge Entry process. This created staff efficiencies and reduces the error rate due to human data entry which led to 100% claim settlement.
Business Challenge
They need to process thousands of scanned records/ excel sheets per day from multiple clients to post charge entries into several Billing Application systems. For which they have to identify, verify data using CPT Codes and subsequent DX codes before posting charge entries in respective applications. While performing charge entry posting process using Current Procedural Terminology codes and medical codes, they have to consider a set of Customer specific rules to consider priorities on hierarchy. Currently all these data validation processes like identifying, verifying and posting charge entries are done manually and almost 40+ people are deployed to do this activities. The major business challenges include:

  • Medical coders has to read, copy and extract data and also has to double-check your information for accuracy before entering it into the system.
  • Identify areas of information that are typically missing or incorrect.
  • Huge time is required to complete the process from data extraction to posting charges.
  • Data validation process has huge back logs due to high volume of data coming in which created issues in better customer service & payment processing as well.
  • Medical Coders/Resources has to be trained and must have the latest information on the recognized medical coding systems.

Alzone deployed 10 Human collaboration CPT BoT’s instead of Coders/billers to address the above said major business challenges. The CPT BoT’s understanding the CPT codes and subsequent medical codes will review the superbill and entered procedures. The BoT’s then considering customer specific rules verifies the data and post charge entries in subsequent Billing Applications.
Business Highlights:

  • Automated the entire Charge entry process using CPT BoT.
  • Faster processing of records without any backlogs.
  • Reduced human error rate to almost “ZERO”.
  • Data accuracy maintained to 100%.
  • FTE reduced by 30%.

TROUBLE-FREE GST RECONCILIATION

Financial institutions perform reconciliation of their GST transactions to ensure that the data filed by the suppliers match with those of the recipients and there are no missing or wrongly reported sales or purchases in the GST returns. The reconciliation process is complex, as it must keep track of every discrepancy or mismatches between the book of business and the GST system. It takes a lot of human effort but still results with calculation errors, data entry mistakes and unidentified of transactions. This ultimately ends up with auditing and accounting issues as well as financial loss.

Some of the common reasons for mismatches of tax entries are:

  • Filed under wrong tax bucket
  • Mismatches due to decimal precision
  • Incorrect Invoice date
  • Incorrect Invoice number

An unattended bot is designed to trigger automatically at defined intervals to do the entire reconciliation process without any human intervention. The bot will first identify the transactions based on the GSTIN numbers provided by the supplier and match them based on invoice number, invoice date and CGST/SGST/IGST tax amounts corresponding to each tax brackets. Bot identifies the fully matching transactions as well as partially matching and unmatched transactions with reasons or pointers for corrections. Issues in the book of business and the errors from the supplier end are clearly classified for the accountant to make necessary corrective steps.

LETTER OF CREDIT SCRUTINY OF SUPPORTING DOCUMENTS

A letter of credit (LC) or letter of undertaking (LoU) is the payment mechanism used in international trade  to provide an economic guarantee from a creditworthy bank to an exporter of goods. It is extensively used in the financing of international trade, where the reliability of contracting parties cannot be determined easily. So a bank will be introduced as a guarantor, where it assumes the counterparty risk of the buyer paying the seller for goods. Document scrutiny is the most important step in the process where all the supporting documents undergo verifications which results in the following challenges when performed manually:

  • Missing of critical rules
  • Human error possibility
  • Highly repetitive and uninteresting
  • Rule complexity and documents volume

The solution was to automate the process using a cognitive RPA bot with advanced OCR technology in place. Bot will extract necessary information from LC and cross check with the supporting documents based on the master rule book. The bot is trained to read the additional rules mentioned in the LC in natural language and run corresponding algorithms by applying the necessary conversions to complete the validations.

TRADE FINANCE ISSUANCE PROCESS

Trade finance issuance is a tedious banking process with sequence of steps involved. This process includes:

  • Letter of credit or bank guarantee application submission along with required documents
  • Branch level data entry and verification in BPM
  • Head office document scrutiny by TFCPC user
  • Entry to daily excel register as well as Finacle core banking system
  • Extraction of data from BPM and inserting it to the Finacle under the ODCM/OGM menu
  • TFCPC user verification of the Finacle entry against the BPM
  • Status update to authorize messaging
  • Issuance of message using SWIFT/SFMS
  • LC or BG issuance to branch & customer

Unattended RPA robot can simplify the complexity of this process. The bot will be scheduled to start every day at a predefined frequency. The bot does data entry to the Finacle core banking system and updating of the daily excel register with LC and BG details.

Once the TFCPC user verification is successful, the bot changes the status authorization and the message about successful authorization of LC is transmitted to SFMS or SWIFT. Then the bot will login to SFMS and shares the soft copy of LC or BG to branches through email. Bot is capable to cater both inland and foreign LC and BG issuances.

ONLINE ORDER PROCESSING AUTOMATION

Our client is a global technology company which operates in the information technology product distribution business, supply chain solutions and after sales services of information technology products.

Business Challenge

Being a whole time partner for IT product companies, our client is enabled to distribute and provision the IT Product assigned to their region. Our client receives almost 100 customer orders for CISO Webex per day from multiple e-commerce applications. As per the current scenario, to process these orders many a people has been allocated to read this mail and download the reports initially. Then they have to log into the product company portal to update the order one by one for these 100 Webex orders. Also pricing and product packaging will be different as per the customer requests. The concerned team has to manually update the data which as data entry errors, value errors and also this action will create backlogs for product delivery and license provision as well.

Solution

Alzone’s Engineers done a detailed process discovery and Business Process Standardization for Online Order Processing. Our team first decided to automate the Online order processing by way of RPA Un attended automation. Here Alzone developed an Order processing BoT will log into our client application and downloads the customer orders in an excel sheet. This BoT will read the data and then logs into the IT Product portal using credentials and updates the same for Order creation for those which are on payment completed status. Once the order is created the BoT will update the product type and price using the captured data from excel sheet. The Bot then confirm the order by updating the end customer details and reseller details as well. Thus the BoT will process the online order and this way for almost 1500 orders per day.

  • No human Intervention
  • Automated 100% online order process.
  • 100% error free processing.
  • Accuracy maintained to 100%
  • Faster processing.

AIR TICKET FARE CALCULATOR

A leading airlines shared customer service company was looking out for an attended RPA solution, which can assist customer service representatives to  pull PNR information  and related policies  of their customer’s ticket when dealing with cancellation, rescheduling etc. operations from different system such as ODEGOE, Amadeus and tax systems.

To submit a solution for assisting customer care agents when dealing with fare calculation policies. An automation especially with AI driven attended robot was deployed which will understand policies written on the ticket and translates to respective mathematical formula to calculate applicable fare.

Main challenges faced are:

  • Enormous number of policies
  • Heterogeneous systems
  • Sequence of commands
  • Lengthy policy statements
  • Unstructured and distributed data
  • In natural language

An integrated banking group based out of Saudi Arabia, also having branches across different regions has been looking for digital transformation. As part of their digital transformation journey, they collaborated with Alzone for automating some of their time consuming and repetitive financial tasks. Alzone had automated the ATM Setup Process, by implementing RPA technologies for processing setup request of 700 to 800 ATM outlets for the client. The setup of an ATM involves several steps to ensure its proper installation, configuration, and integration into the banking or financial system.

Integrating an ATM (Automated Teller Machine) with a banking system can present various challenges due to the complexity of the financial ecosystem, security considerations, and the need for seamless communication.

Here are some common challenges associated with ATM integration:

  • Ensuring daily that the ATM system (900 to 1000 numbers) can effectively communicate and interoperate with different banking systems, including core banking systems, payment gateways, and transaction processing platforms
  • Adhering to regulatory requirements and compliance standards specific to the financial industry, which may vary across regions and jurisdictions.
  • Integrating with existing legacy systems within the banking infrastructure, which have different technologies, architectures, and data formats.
  • Managing transaction processing and settlement processes to ensure accurate and timely recording of financial transactions.
  • Designing the integration in a way that allows for scalability as the number of ATMs and transaction volumes grow Manually processing 100 to 200 requests daily within a specified time

Automating the integration of 1000 ATMs with the banking system can offer numerous benefits, improving efficiency, security, and overall operational effectiveness. Here are some key advantages:

  • Reduced Manual Effort: Automation eliminates the need for manual intervention in the integration process, reducing the risk of human errors and streamlining the overall deployment. This is particularly crucial when dealing with a large number of ATMs.
  • Time Savings: Automation significantly accelerates the integration timeline. Tasks that might take a considerable amount of time if done manually can be completed quickly and simultaneously for multiple ATMs through automation.
  • Consistency and Standardization: Automation ensures a consistent and standardized approach to the integration process across all ATMs.
  • Cost Efficiency: By reducing the need for manual labor and expediting the integration process, automation contributes to cost efficiency. It minimizes the expenses associated with prolonged deployment timelines, potential errors, and the need for extensive human resources.
  • Scalability: Automated systems are inherently scalable. They can handle the integration of a large number of ATMs without a proportional increase in the effort required. Real-time Monitoring and
  • Reporting: Automation allows for real-time monitoring of the integration process. Any issues or anomalies can be quickly identified and addressed, enhancing the ability to proactively manage the entire ATM network.
  • Faster Response to Changes: When updates or changes are necessary, an automated system allows for quick and efficient implementation across all ATMs.
  • Minimized Downtime: Automation can contribute to minimizing downtime during the integration process. With automated testing and deployment, disruptions to ATM services can be reduced, leading to improved availability for users.
  • Enhanced Data Accuracy: Automated processes are less prone to data entry errors, ensuring accurate and reliable data integration between ATMs and the banking system. Centralized Control and
  • Management: Automation allows for centralized control and management of the entire ATM network. This centralized approach simplifies monitoring, updates, and maintenance activities.

Some of the substantial impact in automating the ATM setup processes are

  • Number of skilled resources reduced to 2 from 10 resulting in annual savings of $480K
  • Time taken reduced from 3 hours to 20 minutes

ANALYTICS & BI

Business intelligence and analytics are extremely connected and interlaced in their approach towards resolving business issues and providing insights on past and present data, and defining future decisions. While some experts try to underline that business analytics focuses, also, on predictive modelling and advanced statistics to evaluate what will happen in the future, BI is more focused on the present moment of data, making the decision (and future of a company) based on current insights.

Alzone business analytics solutions provide insights for all departments of a company, providing immediate access to strategic information from organizations of any size or segment.

Data analytics helps businesses convert their historical and real-time, traditional and big data into actionable insights. Alzone has been offering companies a comprehensive kit of data analytics services to improve their decision-making process and win the competition.

Customized analytical solutions we design and implement allow our customers to achieve up to:

  • 20% revenue Increase
  • 80% reduction of operational cost
  • 25% reduction of churn rate
  • 100 times faster data analysis & reporting

Also, it helps our customers to:
  • Elimination of the guesswork out of your business processes
  • Faster and accurate reporting, analysis and planning
  • Identification of profit opportunities
  • Enhanced customer experience

An integrated banking group based out of Saudi Arabia, also having branches across different regions has been looking for digital transformation. As part of their digital transformation journey, they collaborated with Alzone for automating some of their time consuming and repetitive financial tasks. Alzone had automated their Financial Position Validation process

Financial position validation is a crucial aspect in banking for several reasons:

  • Risk management
  • credit decision making
  • regulatory compliance
  • fraud prevention
  • customer relationship management
  • portfolio management
  • capital adequacy
  • asset quality

Some of the challenges are

  • Access to accurate and up-to-date financial information is crucial for making informed credit decisions. However, the quality and availability of data can be inconsistent, leading to challenges in risk assessment.
  • Ensuring the accuracy of financial data provided by customers can be challenging, as errors or intentional misrepresentations may occur
  • Adapting to evolving regulatory requirements and compliance standards poses a challenge, as non-compliance can result in legal consequences and reputational damage.
  • Effectively communicating credit terms, risks, and consequences to customers is challenging, as it requires transparency while maintaining a positive customer relationship
  • Allocating sufficient resources, both in terms of skilled personnel and advanced technologies, to conduct thorough financial position validation can be a challenge

Automating the financial validation process in banking and financial institutions can offer numerous benefits, including:

  • Efficiency Improvement:
    • Automation speeds up the validation process, reducing the time and effort required for manual data entry and analysis.
    • Faster processing allows for quicker decision-making in areas such as loan approvals and credit assessments.
  • Accuracy Enhancement:
    • Automation reduces the risk of human errors associated with manual data entry and calculations, leading to more accurate financial validation.
    • Consistency in data processing ensures that validation is conducted uniformly across various cases.
  • Cost Reduction:
    • Automated processes help in cutting down operational costs associated with manual labor, paper-based workflows, and potential errors that may lead to financial losses.
  • Risk Management:
    • Automation enhances risk management by providing real-time data analysis and identification of inconsistencies, enabling quicker responses to potential risks.
    • Automated systems can continuously monitor transactions and financial data for anomalies, contributing to fraud detection and prevention.
  • Regulatory Compliance:
    • Automated processes can help ensure compliance with regulatory requirements by embedding rules and checks within the system, reducing the risk of non-compliance.
  • Data Security:
    • Automation allows for the implementation of robust security measures to protect sensitive financial information, reducing the risk of data breaches and unauthorized access.
  • Scalability:
    • Automated systems are scalable and can handle larger volumes of data and transactions efficiently, accommodating the growth of the business without a proportional increase in resources.
  • Audit Trail and Documentation:
    • Automated systems provide a comprehensive audit trail, documenting every step of the financial validation process. This is valuable for regulatory audits and internal compliance reviews.
  • Customer Experience Improvement:
    • Faster processing times and reduced paperwork contribute to an improved customer experience.
  • Strategic Decision-Making:
    • Automation frees up valuable human resources from routine tasks, allowing financial professionals to focus on strategic decision-making, data analysis, and other high-value activities.
  • Adaptability to Change:
    • Automated systems are more adaptable to changes in regulations, market conditions, and business processes, ensuring that the financial validation process remains effective and up-to-date

Some of the significant impacts of automating the financial validation are,

  • Number of skilled human resources reduced from 10 to 2 resulting in annual savings of $480k
  • Time taken reduced from 3 hours to 10 minutes

 

Bank statement Mirroring & Reconciliation Process

An internationally acknowledged biotechnology company, which is India’s largest stem cell bank with accreditations from WHO, FDA NABL and many more. There are 6 sub-brands owned by them for the preservation of stem cells, Placental Tissues, DNA etc., They have a pan-India presence with 200+ centers with footprints in GCC nations.

Business Challenge
The primary challenge faced by the financial department of the company was updating their internal finance system MS Dynamics with bank transactions and the controlled accounts details hence to perform the reconciliation on time. The large number of transactions having various rules made the system more complicated and error prone. There are 14 banks and 9 controlled accounts involved in the day-to-day financial transactions.
The reconciliation process are mainly divided into such as Bank Statement Mirroring and Bank Statement Reconciliation.
In Bank Statement Mirroring, the statement received from 14 Banks are mirrored after applying a set of validation rules. Thus created Mirror Statement is uploaded to the ERP system.
In Bank Statement Reconciliation, the collection and realization reports received from the 9 bank control accounts are reconciled against the Mirror Statement created for the main bank accounts in the ERP system. To complete this reconciliation, the following activities are being performed;
(a) Deposit slip creation & upload
(b) Banking statement creation & upload
(c) Validation & Posting to ERP
(d) Unique ID & transaction ID identification from Mirror Statement
(e) Realization statement creation & upload
(f) Validation & Posting to ERP
(g) Reconciliation using ERP

Solution
Using Robotic Process Automation (RPA) , Alzone has derived an end to end Bank statement Mirroring & Reconciliation, with zero human intervention. Individual RPA BOTs were deployed to perform the statement mirroring and reconciliation activities on a daily basis as per the schedule.
In Mirroring process the BOT performs the following activities;
(1) Identification of the valid emails and downloading the bank statements attached
(2) Mirror statement creation using a pre-defined ERP accepted template
(3) Validating the mirror statement created for data correctness
(4) Uploading to the ERP

Activities performed by the BOT in Bank statement Reconciliation process are;
1. The collection/Realization reports are downloaded from email/TPA websites
2. Deposit slip creation & upload
3. Banking statement creation & upload
4. Validation against Mirror Statement
5. Realization statement creation & upload
6. Validation & Posting to ERP

Automated Invoice Processing

An aviation and aerospace component manufacturing company, which is a new industry champion focuses on the long-term growth in the global aerospace and industrial sectors. They are a leading provider of aircraft engine Maintenance, Repair and Overhaul (MRO) solutions and have been leading the way in engineering excellence and innovation for more than three decades.   Invoice processing for an aircraft maintenance company involves the handling and management of invoices related to the services, parts, and maintenance activities performed on aircraft. This process is crucial for the financial and operational efficiency of the company. The key aspects of invoice processing are receipt of invoices, verification and approval, matching with purchase orders and contracts, coding and data entry, discrepancy resolution, payment processing, record keeping and compliance and reporting.  

Challenge:

Increased operational expense: Each supplier will be having their own invoice format. To extract details from those invoices, a separate team was maintained who manually reads and enters the details from the invoices. When business volume surges, the number of invoices increases which was creating stress on this team. So, team size has to be increased. Unintentional data entry errors starting coming up and the invoice has to be processed again. This whole process was becoming a big expense for the firm who was looking for a way to reduce it.

Solution: Using Robotic Process Automation (RPA), Alzone has derived an end-to-end solution for invoice processing of flight engine repairs and maintenance. In the first phase, the set of invoices for training was selected based on the volume of transactions and a consolidated invoice data sheet with the track of all the financial workings is shared with the business for their review and feedback. In the second phase, the bot picks up the confirmed invoice data sheet and converts it into the invoices. These invoices are shared with the respective customer via email/designated websites in the last phase of the bot process. This way, only the invoices which was not trained was handled by the team. This helped the firm reduce the team size and save the cost.

Impact: The impact of automating invoice processing is,

  • Human resources reduced to 1 from 5
  • Time taken reduced to 10 mins from 2 hours per invoice

Bank statement extraction and reconciliation

Bank reconciliation is a process of reviewing all the AP and AR transactions between the core financial systems and banking accounts for a specific period, it is a useful financial internal  auditing tool to ensure accuracy and to avoid fraudulent or missing transactions.

A leading NBFC from India who is associated with 40 different banks for its massive daily transactions was facing the challenge of periodical bank reconciliation. The account statements were taken periodically for the review, but these statement formats varies from bank to bank. Using the statements, respective closing balance sheet and the statement sheet were prepared and uploaded to an ORACLE fusion built ERP system called ORION. Followed by the four different types of reconciliations were performed:

  • Bank vs Book
  • Book vs Bank
  • Book vs Book
  • Bank vs Bank

 Only when all these comparison gets successful, the process gets completed. Any mismatches were manually reconciled, which increased the process complexity.

To tackle the situation an unattended bot was deployed. Now the bot will do statement extractions and its conversions irrespective of their formats to the closing balance sheet and the statement sheet. It does the required validations without any human interventions. Then the bot will log on to the ORION financial systems, and upload the sheets under the specified menus. Then the tedious work of four type matching process and reconciliation is done by the bot in minutes.

PROFESSIONAL SERVICES

We have a strong pool of talented and experienced engineers of various roles eager to take up challenging assignments. Our professional services include discovering, developing, implementing and training robotic solutions to our clients and partners. Together with our extensive multi-domain expertise, standards and methodologies that we follow, we ensure our deliverables with highest quality, robustness, scalability and maintainability. We accelerate the automation journey of our clients by reducing the TCO and achieving higher ROI and faster time-to-market.

Some of our delivery advantages are:

  • Highly talented resources of various roles
  • Accountability is with Alzone
  • Supervised delivery by Alzone Account Manager
  • Technical and Communication support by our COE
  • Flexible and Cost effective

24/7 SHARED SUPPORT

Alzone’s RPA maintenance and support services follows an industry standard framework with phased stages for transition, stabilization, and services delivery.

These phases are powered and supported by our exhaustive program management and service enablers to ensure risk free, continuous delivery of high-quality services that consistently meet all service levels (SLAs) and at the same time provides business value contributions with structured innovation and continuous optimizations and improvements.

Artificial Intelligence

Alzone has designed an Intelligent RPA the way you think. A revolutionary feat of software technology set to become a core component of all modern software over the coming years and decades. RPA enabled Artificial intelligence (AI) emphasizes the creation of intelligent machines that work and react like human workforce.

An Integrated Robotic Process Automation platform which comes bundled with key essential technologies like Artificial Intelligence, Machine Learning, and Natural Language Processing for front office, middle office, back office and IT operations automation. It helps in reducing cost, improve response time, grow business and achieve compliance. Ready bots and development environment are available to build new bots.

Alzone has derived a matured cognitive automation model that makes RPA even better. Firstly, cognitive RPA can be used to improve data. Natural language processing and text analytics, transforms unstructured data into structured data. Then, an RPA system use this data in automated processes. Secondly, cognitive automation can be used to make automated decisions. Predictive analytics can enable a robot to make judgment calls based on the situations that present themselves.

Finally, a cognitive ability called machine learning can enable the system to learn, expand capabilities, and continually improve certain aspects of its functionality on its own. So, to sum up, the power of cognitive RPA comes from its ability to process unstructured data, such as documents and emails, and then use that data to drive higher levels of automation

INWARD INTERNET SERVICE ORDER PROCESSING REQUEST

A leading ISP was encountering issues in inward Internet service order processing request. The ordering process involves complex approval processes and processes in various environments such as web, desktop, ERPs and citrix environments. The process is susceptible to fallouts, hence each individual request may not get completed on time. Not only the fallouts but the enormous number of requests flooding in, that are yet to be handled on time, makes this process complex, stressful and large resource crunching task. This created lower customer satisfaction .

To tackle these issues a state of the art RPA solution was deployed whereby the bots monitor email inboxes for requests and reads every incoming request in various formats(PDF, Email, HTML, Word, etc) containing purchase enquiries.

The bots then login to the an ODOO ERP system to create a lead and later convert it to opportunity. The bot then login an Oracle ERP system and register an enquiry in registry record. It updates customer information and services and generates pricing details, which are the downloaded. Bot performs excel operations to validate this downloaded sheet and obtain the final sheet to upload to the ODOO ERP and finally a performa invoice is generated and an email is sent to the customer. Ensuring quick and efficient request handling and processing.

ROBOTIC PROCESS AUTOMATION

RPA (Robotic Process Automation) is a software virtual workforce to perform repetitive tasks that are currently being done by humans. The bots emulate the activities using the existing platforms and applications that a company is currently using.

To sum things up, here’s what a RPA software can do for you:
Perform repetitive, structured transactions processes
Scale up operations and processes rapidly in your company
Interact with and update multiple applications in a transactional manner to keep everything in sync
Validate data in places that are complex for people to understand
Perform calculations faster than humans

Robotic Process Automation (RPA) for Profit & Loss (PnL) calculations are quickly evolving as the most efficient process automation systems with extremely small value realisation time for finance companies.

The cost of implementing RPA are significantly lesser than building a custom solution to eliminate human tasks that can be error prone.

FCR INCREASE AND ERROR DEDUCTION

An internet service provider was facing the cumbersome issue of poor FCR( First- call Resolution) rates. The main culprits for such poor FCR rates were data inaccuracy in data entered by customer relationship agent, the cumbersome ordeal of interacting with multiple systems real time while on the call. Processing each and every request from customer requires a series of steps involving data entry and validation across ERP, CRM and internal/external systems leading to inaccuracies, validation errors, poor FCR rates and an unhappy customer.

Solution to this challenging problem was to deploy an attended bot, equipped with all the validation and processing rules, at every agents’ system. During every call the bot retrieves every information about the customer and all the possible information to assist the customer. The bot waits for the agent to click or type-in the request, upon which the rest of the processing, transactions, validations and the final conformation on the requests are solely done by the bot. Thereby ensuring timely completion of requests with accuracy, efficiency and above all a happy customer.

MAINTENANCE CASE GENERATION

The RPA strategies have been successfully implemented on one of the global companies, engaged in oil and natural gas production and excavation, in automating their Maintenance Communication Process. The maintenance works on their production site were conducted as per request from the workers. These requests were then conveyed to an Analyst who fetches the related diagram from the database to identify the rectification points. The proposal and diagrams were then sent to an IT team along with the proposed changes requiring approval for implementation from the concerning stakeholders.

For an industry such as the oil and gas industry, where time is of the essence our Cognitive RPA solution was deployed for this delicate task. The bot deployment automated the entire process from proposal generation , to problem identification by using the corresponding diagram from database and finally identifying specific points requiring fixes. Bot learns the processes of identifying such point to fix through a continuous learning process. Finally the proposal is sent for approval, all within seconds of request for approval.

COMPARATIVE RATING FOR MGUs (ROBO RATER)

Health care MGUs would need to perform ratings across multiple reinsurers platforms. Robo-Rater steps in as an intelligent digital underwriter and predicts indication premiums and its benefits. Keying in the client details and requested coverage information across all the rating systems is one of the business challenge as it is repetitive task and requires accuracy. Also the underwriters need to perform a number of combinations of coverage, limits, deductibles etc to obtain a premium closer to the clients target premium. These two are areas are automated by the Robo-Rater.

By leveraging the AI abilities of RPA the Robo-Rater provides a solution by fetching the employee data, clients coverage history, providing indication of premiums to requested coverage and alternative options. Underwriter chooses one from this, then the bot will enter details to all rating systems. The final ratings will be much closer to the initial prediction.

AUTOMATED PROGRAMMATIC INVOICE GENERATION

A leading US based digital media company was facing great difficulty in calculating the AP & AR of their programmatic advertisement business on a monthly basis. The company has tie-up with a large number of ad-Networks and each ad-Network has their own analytical websites from where the advertisement related revenue data to be collected for invoicing. On top of that, post downloading the revenue data, the finance team has to perform several calculation rules to arrive at the final invoice amount.
The major steps involved in this process are:

  • Download revenue report from all connected ad-Networks
  • Calculate the final invoice amount for each of the ad-Network
  • Programmatic revenue sheet preparation – the consolidated revenue document from all ad-Networks
  • Journal and invoice sheets creation from the programmatic revenue sheet
  • Input the financial details into the internal finance application “Financeforce”

An un-attended bot is deployed to automate the entire financial activities related to ad-Networks revenue. The RPA solution helped to complete the whole activity within 2 days which used to take 10 days earlier. It also helped in avoiding calculation errors and multilevel of verification needs.

SUPPLIER PAYMENT POSTING TO SAP AND RECONCILIATION

A leading telecom service provider implemented the RPA solutions in automating their payment reconciliations. The process involved extraction of invoice data from PDFs sent via email and reconciling it with supplier payments data .The approved data are then entered into the SAP ERP system on a daily basis. There is also a second level of reconciliation made between the entries in the ERP system and the corresponding banking statements. These levels of reconciliations are time consuming, mundane, stressful and most human error prone when done manually.

Deployment of our cognitive RPA solution was the perfect solution for this challenge whereby an intelligent bot was deployed to read and arrange the PDF invoice by means of OCR engine and fuzzy logic algorithm. The extracted data is reconciled with payment data stored in an excel file. The reconciled payment details are entered by the bot into the ERP system. The bot is also equipped to perform banking reconciliation as per need. When triggered to perform banking reconciliation, the bot will extract banking statements from corresponding portals and transforms statement to the ERP format for uploading into the ERP system. The uploaded banking records are then reconciled with the book record in the ERP system by the bot. Thus the entire process of reconciliation was automated saving our client money and time.

CONTRACT RENEWAL PROCESS AUTOMATION

The task of contract renewal process when done manually include analyzing various parameters for different customers and businesses who grouped under categories such as gold, silver, platinum etc. The manual process took mostly 80 days annually to complete it, which would results in delay of the renewal processes to new service contract. Changing a contract in SAP manually take nearly 8 minutes per renewal transaction, which will amount to a substantial time for more than a million requests.

Our solution for the entire process was to deploy an unattended bot which monitors renewal requests coming via email other document formats. The data extracted from these are used as parameters by bot to prepare a data comparison sheet .The bot compares the data with master contract information from an internal portal. The bot will inform the corresponding authorities regarding the discrepancies on the data received via an email. The ones with matching parameters are entered into an SAP system and contract is updated.

CREDIT LIMIT RAISE THROUGH ATTENDED ROBOT

When a request for credit limit increase is arrived to the customer service representative(CSR), he/she need to navigate between the screens in CRM and other data sources to collect information regarding the customer financial history to determine if the customer indeed is eligible for an increase. After gathering the information, the CSR has to perform validation steps to calculate the eligible amount and communicate the same to the client.

Once approved by the client, the CSR has to process a transaction on mainframe as well as the CRM and send the confirmation email to the customer. It is a time consuming process, and causes customer concerns especially when he/she is on the call with the CSR.  

This business challenge was very delicate and involved handling of highly sensitive databases, systems and rules by the CSR. A secure, attended bot serving as an assistant to the CSR, will simplify the overall services provided by him/her. As soon as the CSR receives the call, bot will pull out all the details of the customer from CRM along with necessary information for the CSR to validate with customer’s financial history.

Bot will then perform all the validation steps to assess the eligibly of credit increase and provide options to the CSR which he/she can immediately communicate to the client. Upon customer’s approval, bot takes care of processing the necessary transactions in the mainframe and CRM systems and sends the summary email to the customer.