From Spreadsheets to Software: How 3 NZ Businesses Saved 55+ Hours/Week
Three NZ businesses replaced manual spreadsheet processes with custom software. Combined, they save 55+ hours per week. Here's the ROI breakdown.
Key Takeaways
- Three NZ businesses eliminated manual processes by replacing spreadsheets and calculators with custom software, saving a combined 55+ hours per week.
- A NZ retailer’s custom refund system saves 15 hours/week with 100% data accuracy and 80% faster processing.
- A NZ logistics company’s warehouse automation saves 25 hours/week with 100% order accuracy and real-time logistics sync.
- A major real estate franchise’s commission calculator app saves 95% of calculation time for 200+ real estate agents with zero errors.
- Custom software typically pays for itself within 3–6 months when replacing manual processes. The ROI compounds every month after.
Every business has a spreadsheet problem. Somewhere in your operations, there is a critical process being managed in Excel or Google Sheets that should have been automated years ago. You know it is slow. You know it causes errors. But it works “well enough,” so it stays.
Until it doesn’t.
We have built custom software for three NZ businesses that replaced their spreadsheet-dependent processes. Here is what happened to their operations, their error rates, and their bottom line.
Case 1: NZ Home and Living Retailer — Refund & Returns System
The Spreadsheet Problem
This client is a major NZ e-commerce retailer selling home and living products. Their refund and returns process was managed entirely through Excel spreadsheets. When a customer requested a refund or return, a team member would:
- Open the spreadsheet
- Manually enter the customer details, order number, and reason for return
- Look up the original order in a separate system
- Calculate the refund amount
- Update the spreadsheet status as the return progressed
- Manually trigger the refund through their payment system
This process had three problems. It was slow (each return took 15–20 minutes to process). It was error-prone (manual data entry across multiple systems created mistakes). And it did not scale (as the business grew, the spreadsheet became unwieldy and team members would occasionally overwrite each other’s entries).
The Custom Solution
We built a custom web application that replaced the spreadsheet entirely:
- Relational database storing all return and refund data with proper relationships between customers, orders, and refund requests.
- User-friendly web interface where team members could process returns in 3–4 minutes instead of 15–20.
- Automated workflows that calculated refund amounts, triggered approval chains, and processed payments without manual intervention.
- Multi-user access with proper roles and permissions, eliminating the “two people editing the same row” problem.
The Results
| Metric | Before (Spreadsheet) | After (Custom Software) |
|---|---|---|
| Processing time per return | 15–20 minutes | 3–4 minutes |
| Data accuracy | ~90% (manual errors) | 100% |
| Weekly time spent on returns | ~20 hours | ~5 hours |
| Error rate | Regular | Zero |
15 hours saved per week. At a conservative $30/hour for the team members involved, that is $23,400 per year in recovered productivity. The custom system paid for itself within months.
Case 2: NZ Logistics Company — Warehouse Logistics Automation
The Spreadsheet Problem
This client manages complex supply chain logistics. Orders flowing from their warehousing system to their logistics partner (GSM Tasks) required manual data transfer. A team member would:
- Export order data from the warehouse system
- Reformat it to match the logistics platform’s requirements
- Manually enter or upload the data into GSM Tasks
- Cross-reference both systems to verify accuracy
- Handle discrepancies and errors (which happened frequently)
This manual bridge between two systems consumed 25+ hours per week and introduced errors at every step. A mistyped address meant a package going to the wrong location. A missed order meant a delayed delivery. A formatting error meant the entire batch needed to be redone.
The Custom Solution
We built a custom automation layer that connected the warehouse system directly to GSM Tasks:
- Real-time API integration between the two platforms, eliminating manual data transfer entirely.
- Automatic order flow from warehouse to logistics with zero human intervention.
- Validation checks that catch data issues before they become delivery problems.
- Error handling that flags exceptions for human review rather than silently failing.
The Results
| Metric | Before (Manual) | After (Automation) |
|---|---|---|
| Order accuracy | ~95% (manual errors) | 100% |
| Processing speed | Hours (batch manual entry) | Real-time (instant sync) |
| Weekly time on order transfer | 25+ hours | ~1 hour (exception handling only) |
| Delivery errors from data issues | Regular | Near zero |
25 hours saved per week. The team members who previously spent their days copying data between systems were redeployed to higher-value work. As the client put it: “Orders now flow seamlessly from our warehouse to delivery. What used to take hours of manual work happens automatically.”
Case 3: Major Real Estate Franchise — Commission Calculator App
The Spreadsheet Problem
Real estate agents at a major NZ real estate franchise were calculating their commissions manually using spreadsheets and calculators. Real estate commission structures in NZ are tiered and complex. An agent might earn different percentages on different portions of the sale price, with additional variations for franchise fees, GST, marketing costs, and team splits.
Agents were calculating these during client meetings, which meant:
- Errors were common. A mistake in a commission calculation could cost thousands.
- It was slow. Pulling out a laptop, opening a spreadsheet, and running numbers during a client meeting is not a good look.
- No standardisation. Every agent had their own spreadsheet with their own formulas, and nobody was sure whose numbers were correct.
The Custom Solution
We built a mobile app that handles commission calculations instantly:
- Complex tiered structure built into the app logic, handling all commission tiers, franchise fees, and deductions automatically.
- Mobile-first design so agents can calculate commissions on their phone during client meetings.
- Instant breakdowns showing exactly how a commission is calculated, which builds transparency and trust with clients.
- 200+ active users across the franchise network.
The Results
| Metric | Before (Spreadsheet) | After (Mobile App) |
|---|---|---|
| Calculation time | 5–10 minutes | Under 30 seconds |
| Calculation errors | Regular | Zero |
| Active users | N/A | 200+ agents |
| Time saved | N/A | 95% reduction |
95% time saved with zero errors. For a real estate agent, being able to pull out their phone and show a client an accurate commission breakdown in 30 seconds is a competitive advantage. It builds trust, speeds up decisions, and eliminates the embarrassment of correcting calculation errors later.
The ROI Math: Why Custom Software Pays for Itself
Here is how to calculate whether custom software makes sense for your business:
Step 1: Calculate Your Manual Cost
Formula: Hours per week x hourly rate x 52 weeks = annual manual cost
| Business | Hours/Week | Hourly Rate | Annual Cost |
|---|---|---|---|
| The retailer | 15 hours saved | $30/hour | $23,400/year |
| The logistics company | 25 hours saved | $35/hour | $45,500/year |
| The real estate franchise | ~10 hours saved (across 200 agents) | $50/hour | $26,000/year |
| Combined | 55+ hours/week | $94,900/year |
Step 2: Compare to Development Cost
Custom software projects in this complexity range typically cost $10,000–$50,000 depending on scope. Let’s use conservative estimates:
| Project | Est. Development Cost | Annual Savings | Payback Period |
|---|---|---|---|
| Retailer refund system | ~$20,000 | $23,400 | ~10 months |
| Logistics automation | ~$25,000 | $45,500 | ~7 months |
| Real estate commission app | ~$15,000 | $26,000 | ~7 months |
Step 3: Calculate Ongoing ROI
After the payback period, the savings are pure return. Year 2 savings are 100% ROI. Year 3 is another 100%. The software cost is fixed (plus minor maintenance). The savings compound forever.
By year 3, these three projects will have saved approximately $284,700 in combined labour costs against an estimated $60,000 in development investment. That is a 4.7x return over three years.
And this does not account for the value of eliminated errors, faster customer service, improved employee satisfaction (nobody enjoys manual data entry), and the ability to scale operations without adding headcount.
Signs Your Business Needs Custom Software
You do not need custom software for everything. Here are the indicators that a manual process is ready to be automated:
It takes more than 10 hours per week. If a team member spends more than 2 hours per day on a manual process, the ROI on automation is almost always positive.
It involves transferring data between systems. Anytime you are copying data from one system to another (exporting from A, reformatting, importing to B), there is an automation opportunity.
Errors have real costs. If a mistake in your manual process costs money (wrong refund amount, wrong delivery address, incorrect commission), the cost of errors alone may justify the investment.
It does not scale. If your process worked when you had 10 orders per day but breaks down at 100, you have outgrown the spreadsheet.
Multiple people need to access the same data. Spreadsheets are not designed for concurrent multi-user access. If two people editing the same file is causing version control issues, you need a proper application.
What Custom Software Does Not Solve
Not every problem needs custom software:
If it is a one-off task, use a spreadsheet. Custom software is for recurring processes.
If an existing tool already does it, use that tool. Do not build custom software when Xero, HubSpot, Shopify, or another platform already handles your need.
If the process changes frequently, consider whether the process itself needs standardisation before you automate it. Automating a broken process just gives you broken automation faster.
If the ROI is not clear, do the math first. A process that takes 2 hours per week ($3,120/year at $30/hour) does not justify a $20,000 custom build.
Frequently Asked Questions
How much does custom business software cost in NZ?
Based on our project experience, custom business software in NZ typically costs $10,000–$50,000 for applications that replace manual processes (data management, workflow automation, calculation tools). More complex platforms with user management, integrations, and scaling requirements can cost $50,000–$200,000+. The key is that the development cost should be recoverable through time savings within 6–12 months.
How long does custom software take to build?
Simple automation tools and calculators take 4–8 weeks. More complex web applications with multiple user roles, integrations, and workflows take 3–6 months. Enterprise platforms can take 6–18 months. Our commission calculator app and refund management system were both delivered within standard timeframes for their complexity.
Should I use off-the-shelf software or build custom?
Start with off-the-shelf. If existing tools (Xero, HubSpot, Monday, Asana) solve your problem, use them. Build custom only when: (1) no existing tool handles your specific workflow, (2) you need integration between systems that do not natively connect, or (3) your process is unique enough that generic tools create as many problems as they solve. Our clients came to us after outgrowing spreadsheets and not finding suitable off-the-shelf alternatives.
What technologies do you use for custom software?
We build with modern web technologies including React, Next.js, Node.js, and WordPress depending on the project requirements. For mobile apps, we use Flutter and React Native for cross-platform development. We also build automation workflows using Zapier, Make, and custom API integrations for simpler integration needs. See our workflow development services for more detail.
All case studies in this post are based on actual projects delivered by Lucid Media. View individual case studies: retailer refund system case study, logistics automation case study, commission calculator app case study. For a free consultation about automating your business processes, book a call.
You Might Also Like
Written by
Jason Poonia
Jason Poonia is the founder and Managing Director of Lucid Media, helping NZ businesses grow online since 2018. With over 6 years delivering results for clients across New Zealand and internationally, Jason combines technical expertise with proven marketing strategies to help businesses attract more customers and build scalable systems. Background in Computer Science from the University of Auckland.
