Client Overview
Our client is a well-established global consumer goods company within the beauty & wellness industry, and is headquartered in India and is represented in over 25 countries in Asia and Africa. The company had a combined revenue of over USD 1.2 billion in the last fiscal year, significantly bolstered by the overseas markets.
Challenge
The client experienced marked efficiencies in managing their GST R2A (Reconciliation to Agreement) through a laborious manual process. Crucial activities like vendor invoices downloaded from the GST portal or internal ERP solutions took a hit in terms of time and effort. The data was then manually entered into an Excel for reconciliation, which is very time-consuming and error-prone.
Reconciliation of all the vendors reported invoices (GSTR-2A and 6A) with the company’s purchase data was a manual process, and neither an easy one. This was a crucial step that required careful attention and all too often led to errors or missed discrepancies. Such errors increased the potential for the breaches and added to the general complexity of the mechanism.
Reporting delays have been consistently significant with manual work-flow which hindered timely and accurate report generation required for GST filing. Such delays have impacted the ability to meet timescales and could lead to being fined for not adhering to schedules, with both financial and reputational implications.
Additionally, the increased?resource utilization has further aggravated the problem. Much of the finance team’s time has?been spent on repetitive, low-value work, limiting tax strategy, financial analysis, and effective decision making.
As the organization has grown, those constraints have become increasingly apparent. The increasing number of transactions has expanded the existing manual process and increased workload and risk at the expense of efficiency.
These issues point to the necessity of having an automated GST R2A system. This type of solution would help to eliminate data overstress and reconciliation routine, improving accuracy, reducing delays, and enabling the finance team to focus on strategy and contribute to the organization’s growth plan.
Manual Data Collection: Downloading of vendor invoices from the Goods and Services Tax (GST) portal and internal Enterprise Resource Planning (ERP) systems was a requirement. Information in these invoices wer e manually updated into Excel for reporting purposes.
Error-Prone Reconciliation: The reconciliation mechanism that lent vivification or a split screen comparison was quite manual between vendor invoices reported (GSTR-2A) and the data based on your purchases in the organization. This was often a source of mistakes or failure to notice inconsistencies.
Delayed Reporting: The manual process also led to delays in finalizing the accurate GST reports which raised the non-compliance risk from the statutory perspective.
High Resource Utilization: Much of the finance team’s time was spent on repetitive work, significantly limiting the ability to focus on?strategic tax planning and analysis.
Limited Scalability: To accommodate the growing transaction volumes, the reconciliation process struggled to be effectively scalable, which created additional workload and risk.
Solution
We developed an automated process utilising Power Automate for Desktop (PAD) to improve the efficiency and effectiveness of the GST R2A. This mechanism enabled the automation of key processes such as data retrieval, reconciliation, and reporting, streamlining operations and fulfilling GST requirements in a timely and error-free manner.
The process started with automated data-download process, where the PAD bots were programmed to sign-in on one’s behalf onto the GST Portal, and download GSTR-2A data. At the same time, the bots also hacked into the client’s ERP system to retrieve data for purchases. Such automation (minimized manual labor) of the process contributed to not only completion of the data retrieval task, but also to its quality in terms of consistency and timing.
An automatic reconciliation workflow was then created. With the combination of PAD scripting with Excel this solution enabled a comparison of GSTR-2A data with the organization’s purchase records. Differences between the two sources were surfaced and logged into items for action reports, allowing the finance team to efficiently follow up and reconcile any discrepancies.
The system was then appended with error-handling to make it adequately cope with the mismatches. These processes found inconsistencies and sent them to clerks for adjudication. And with lots of the exceptions correctly logged, the process is still “reasonably” accurate and “reasonably” accountable.
Real-time notifications had also been pushed for the automation. PAD issued a reconciliation to the finance team with reconciliation emails out the variance. This functionality also aided in keeping interested parties abreast with time sensitive data which yielded faster dispute resolutions and timely filing compliance.
The entire workflow was built to scale, so it was able to process larger numbers of transactions as the client’s operations were added to the system. This building made the system flexible and up-to-date according to business needs.
Automated Data Extraction: The PAD bots logged in to the Goods and Services Tax (GST) portal to download GSTR-2A. At the same time, purchase data?was abstracted electronically from the client’s ERP product.
Reconciliation Workflow: Reconciliation of the GSTR-2A data with our purchase data of the organization was established using Excel and PAD Scripting. All discrepancies were noted and combined into a summary.
Error Handling: The solution utilized a strong exception handling framework that ensured that any exceptions were logged and brought to the attention of the finance operations team for reconciliation.
Real-Time Notifications: The PAD system allowed for automatic email alerts to finance, containing complete reconciliation reports, each and every flagged exception.
Scalable Design: The architecture was carefully designed to scale with transaction volume, meaning you won’t outgrow it.
Results
By using Power Automate RPA Services, we automated GST R2A process delivered significant improvements in efficiency, accuracy, and compliance.
Key Metrics
| Metric | Before Automation | After Automation | Improvement |
| Manual Effort per Reconciliation | 15-20 hours per cycle | 2-3 hours per cycle | 85% Reduction |
| Error Rate in Reconciliation | ~10% | <1% | Near-Elimination of Errors |
| Reconciliation Time | 2-3 days | Same day | 100% Faster |
| Team Utilization | High due to manual tasks | Focus on strategic analysis | Improved Productivity |
| Scalability | Limited | Seamless for growing volumes | Unrestricted Growth |
Impact on Operations
The intelligent GST R2A process made a paradigm shift for the client’s tax compliance function:
Enhanced Efficiency: Manual effort was cut by 85%, and instead, the finance team is now able to concentrate on strategic tasks, such as tax planning and forecasting.
Improved Accuracy: The solution supported automated reconciliation, which saved time and prevented errors in GST filings, successfully reducing the chance of penalties.
Faster Compliance: What used to take several days could now provide end-of-day reconciliation for GST submission
Cost Savings: Reduced reliance on manual effort translates to lower operational costs and better resource allocation.
Future-Ready Scalability: The scalable design allowed the client to handle increasing transaction volumes without additional resources.
Tools Used
Power Automate Desktop, Power Automate Cloud, Excel, Python, SAP