Creating a Custom Approval System to Overcome Finance Challenges in Manufacturing

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:

• Lack of Formal Records

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.

• No Audit Trail

Auditors require clear documentation of approvals and controls. WhatsApp provided no way to generate reports or logs, increasing the risk of audit failures.

• Limited Control and Oversight

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.

• Inefficient Payroll Reconciliation

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

• Online Submission Form

Employees submit expense requests through a Google Form with required fields such as amount, category, and justification.

• Automated Approval Routing

The script routes requests to the appropriate manager based on department and amount thresholds.

• Email Notifications and Reminders

Approvers receive email alerts with links to approve or reject requests. Reminders are sent for pending approvals.

• Audit Trail in Google Sheets

All submissions, approvals, and comments are logged in a Google Sheet with timestamps, creating a transparent record.

• Exportable Reports

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.

• Clear Visibility for Finance

The CFO could track approval status in real time and identify bottlenecks or policy breaches.

• Audit Success with Zero Findings

During the next audit, the company provided detailed approval logs and reports, satisfying auditors and avoiding any compliance issues.

• Employee Satisfaction

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:

• Fits Specific Business Needs

The system can be designed exactly for the company’s processes, avoiding unnecessary features.

• Faster Deployment

Development and rollout happen in days or weeks, not months.

• Lower Cost

No licensing fees and minimal development resources reduce total cost of ownership.

• Easier Maintenance and Updates

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.