Now Live:
SearchCreating a Custom Approval System to Overcome Finance Challenges in ManufacturingCA Siddhartha AgrawalMar 213 min readRated NaN out of 5 stars.Managing expense approvals in a manufacturing company can be surprisingly complex. When the Chief Financial Officer (CFO) relies on informal tools like WhatsApp for approvals, the process becomes prone to errors, lacks transparency, and exposes the company to audit risks. This post explores how a tailored approval system built with Google Apps Script helped a manufacturing firm solve these challenges quickly and affordably. Finance leaders will find practical insights on improving approval workflows without investing in costly enterprise software.
!Eye-level view of a computer screen showing a custom approval form interface
Challenges Faced by the CFO Using WhatsApp for Expense Approvals
The CFO of a mid-sized manufacturing company faced growing frustration with the existing expense approval process. The team used WhatsApp groups to submit and approve expenses, which seemed convenient at first but soon revealed several problems:
Expense requests and approvals were buried in chat threads. Tracking who approved what and when became difficult, especially when messages got deleted or lost in long conversations.
Auditors require clear documentation of approvals and controls. WhatsApp provided no way to generate reports or logs, increasing the risk of audit failures.
Without a structured system, the CFO had little visibility into pending approvals or potential policy violations. This made it hard to enforce spending limits or compliance rules.
HR struggled to reconcile payroll with expense reimbursements due to inconsistent submission formats and missing information.
These issues created bottlenecks, delayed reimbursements, and raised concerns about financial governance.
Building a Lightweight Approval System with Google Apps Script
The CFO wanted a solution that would:
Provide a clear, auditable approval workflow
Be easy for employees and managers to use
Avoid the high cost and complexity of enterprise software
Be implemented quickly to address urgent audit concerns
The finance team partnered with an internal developer to build a custom approval system using Google Apps Script. This scripting platform integrates with Google Workspace apps like Sheets, Forms, and Gmail, making it ideal for lightweight automation.
Key Features of the Custom System
Employees submit expense requests through a Google Form with required fields such as amount, category, and justification.
The script routes requests to the appropriate manager based on department and amount thresholds.
Approvers receive email alerts with links to approve or reject requests. Reminders are sent for pending approvals.
All submissions, approvals, and comments are logged in a Google Sheet with timestamps, creating a transparent record.
The CFO and auditors can easily generate reports showing approval history and compliance status.
Implementation Timeline and Cost
The system was built and deployed within two weeks. Since it used existing Google Workspace tools, there were no additional software licensing costs. The main investment was developer time, which was minimal compared to purchasing and customizing enterprise solutions.
Positive Outcomes from the Custom Approval System
After launching the new approval system, the manufacturing company saw immediate improvements:
Streamlined Submission Process for HR
HR received standardized expense data, reducing errors and speeding up payroll reconciliation.
The CFO could track approval status in real time and identify bottlenecks or policy breaches.
During the next audit, the company provided detailed approval logs and reports, satisfying auditors and avoiding any compliance issues.
Employees appreciated the clear instructions and quick feedback, replacing the confusion of WhatsApp messages.
This case shows how a simple, tailored system can solve real-world finance challenges without heavy investment.
Why Tailored Systems Matter More Than Expensive Enterprise Software
Many finance leaders feel pressured to buy large, complex software packages to manage approvals and controls. These systems often require months of setup, extensive training, and ongoing costs. For many manufacturing companies, especially those with straightforward approval needs, this approach is inefficient.
A custom-built solution using accessible tools like Google Apps Script offers several advantages:
The system can be designed exactly for the company’s processes, avoiding unnecessary features.
Development and rollout happen in days or weeks, not months.
No licensing fees and minimal development resources reduce total cost of ownership.
Internal teams can modify the system as needs evolve without vendor dependency.
Finance leaders should evaluate whether a tailored system can meet their approval challenges before investing in expensive software.
