How We Fixed 5,000+ Duplicate Time Entries in a QuickBooks API Integration
A misconfigured pagination parameter caused 5,000+ duplicate time entries in a QuickBooks automation. Here's how we diagnosed and fixed the STARTPOSITION bug.
Empowering the team to manage grants and expenses, with granular permissions and data validation
TABLE OF CONTENTS
The Client
A leading environmental NGO that fights climate change by using the combined power of law, data and analysis.
They were looking for support to streamline their Grant and Expense Management, as they needed to track and report on all donations and their destinations.
The Challenge
- Grant and Expense Management (GEM) fall under one person.
- GEM done in Excel, couldn't be done by others:
- Too easy to mess up the data
- Missing granular user permissions
The Solution
- Switch from Excel to Airtable.
- Create ad GEM app on Softr with specific permissions for each user.
- Financial Tracker and Project Management System in a single custom app accessible online.
The Results
- Easier to predict future budget in multiple currencies, Streamlined reporting on fund payments.
Related Posts
Focused Directions - Beyond Email: Modern Client Communication + Client Portal Case Study
Stop using email to manage client workflows. See what modern clients expect and how a boutique advisory firm used a client portal to cut follow-ups and scale.
Crawl, Walk, Run: The Smart Way to Start Automation Projects
Learn the crawl-walk-run methodology for automation projects. Discover why starting simple beats building the perfect system, with real consulting examples from 400+ implementations.
Made with Bullet