About SOIL
Sustainable Organic Integrated Livelihoods (SOIL) is a Haiti-based non-profit organization that addresses the country's sanitation crisis by designing, testing, and implementing cost-effective and sustainable solutions. SOIL deploys simple and low-cost container-based toilets that require minimal water, thus providing dignified and safe access to sanitation. It has operated in Haiti since 2006, revolutionizing the sanitation approach by offering a full-circle service, from containment of human waste to reuse.
It capitalizes on the ecological sanitation (EcoSan) process, which helps to convert waste into rich, organic compost that eventually becomes a natural resource for depleted soils in Haiti. The organization transforms conditions by providing sanitation, as well as producing valuable compost for agriculture and reforestation.
It works with communities to create and test socially and ecologically beneficial solutions.
Talk to a GURUS NetSuite Services Expert
The Challenge: Exporting NetSuite Saved Searches to Google Sheets
SOIL started using NetSuite in 2017 for accounting, HR, and other management processes. However, most of their data processing and reporting was done on Google Sheets. While they were now able to manage all the main business processes through the ERP, manipulating data and exporting saved searches was a problem. Subsequently, they began looking for an easy way to keep their Google Sheets updated with the data from NetSuite.
For non-profits and mission-driven organizations running on NetSuite, this is a common frustration. Teams rely on Google Sheets for collaborative reporting, grant tracking, and donor communications, but getting data out of NetSuite and into Sheets is a manual, time-consuming process. Every hour spent downloading and uploading CSV files is an hour not spent on the mission.
The Solution: GURUS Solutions' NetSuite Data Exporter Tool
Erica Lloyd, Director for Research & Innovation at SOIL, came across the NetSuite Data Exporter Tool designed by GURUS Solutions, and she says "it was a godsend" because it did exactly what they needed. The tool helps businesses to overcome data challenges within NetSuite. It takes saved searches from the ERP and exports them easily to Google Sheets, allowing you to take more control of your data within Google's spreadsheet program.
Key features SOIL leverages with the NetSuite Data Exporter:
-
One-click export of all saved search results to Google Sheets
-
Automated data transfer replacing manual CSV downloads and uploads
-
Custom dashboards and dynamic reports built in Google Sheets Charts, tables, and pivot tables for visual reporting
-
Scheduled exports to keep data current without manual intervention
Results: How the NetSuite Data Exporter Transformed SOIL's Reporting
Our NetSuite Data Exporter tool helped SOIL to automate and accelerate the process of exporting NetSuite saved searches to Google Sheets. Today, they can move all their saved search results at the click of a button. They can easily manipulate saved search data and quickly prepare reports about specific information.
SOIL's staff are also able to leverage the powerful tools within Google Sheets. They now use these tools to process saved searches and generate beautiful charts and tables. They can also create custom dashboards and dynamic reports. Our tool saves them the time they used to spend on manually downloading saved searches before uploading them on Google Sheets.
Having timely information makes it possible for SOIL's managers to make informed decisions, which helps them to develop better approaches to sustainable sanitation service and innovative service delivery models. SOIL has been able to reduce its cost per toilet per month and serve more customers with the same budget.
The impact goes beyond operational efficiency. By automating data transfer and giving the team faster access to accurate reporting, SOIL can spend less time on administrative tasks and more time delivering on their mission of providing sustainable, dignified sanitation in Haiti.
About GURUS Solutions
GURUS Solutions is one of the largest NetSuite ERP solutions providers across North America. As a NetSuite Partner, GURUS specializes in implementations, integrations, project rescues, and support. Our team is recognized by Oracle NetSuite as an award-winning partner for over 20 consecutive years.
Is your non-profit struggling to get data out of NetSuite and into the tools your team actually uses? Talk to GURUS Solutions today about the NetSuite Data Exporter