Iconis Group isn’t your typical back-office partner. They’re a modern, systems-focused consulting firm that helps small businesses untangle messy workflows. Their work sits at the intersection of technology, marketing, and accounting, often building smart, custom setups that enable tools to communicate with each other when they wouldn’t normally do so.
So when one of their field service clients ran into a syncing issue between QuickBooks Online and ServiceTrade, Iconis didn’t start by writing code; they started by asking, “What’s the fastest, cleanest way to pull this off?”
The Problem: Payments Got Stuck Between Systems
The client used ServiceTrade for field operations, quoting, and sending initial invoices, but payments didn’t always follow the same path if a customer paid directly through the ServiceTrade invoice link, that payment synced over to QuickBooks without issue. But once the initial billing period passed, follow-up reminders went out through QuickBooks. And if customers paid through those reminders, whether by credit card, cash, or check, those payments stayed stuck in QBO.
They didn’t sync back to ServiceTrade, which meant the original invoices remained marked as unpaid. That disconnect created reporting headaches and left the team manually cross-referencing systems just to know who had actually paid. But QBO’s built-in reports didn’t go deep enough. They couldn’t see the payment application data. Partial payments were a black box. And nothing connected invoices to their corresponding payment records in a way that could be used for automation.
Instead of a proper sync, staff had to log payments manually in both systems. Every time someone paid an invoice, the team entered the transaction in QuickBooks, then turned around and did it again in ServiceTrade. No exports. No automation. Just tedious, error-prone double entry that ate up valuable time and increased the risk of mismatched records.
The Fix: G-Accon and Google Sheets = Clarity in Minutes
That’s when Iconis Group brought in G-Accon. With G-Accon’s QuickBooks Online integration for Google Sheets, they were able to extract everything they needed, including fields not available in QBO’s default exports. And best of all, they didn’t need to write custom code. Here’s how the workflow came together:
Step 1: Connect QBO to Google Sheets
G-Accon’s secure Sheets add-on gave Iconis real-time access to the client’s accounting data — right inside Google Sheets.
Step 2: Build Queries to Pull the Missing Fields
- Invoices, including balance, customer info, and status
- Payments, including amounts, dates, and payment-to-invoice links
- Metadata that tied it all together
Step 3: Automate the Data Pulls
Daily refreshes were scheduled. No more exporting files or waiting on reports. Everything stayed up to date automatically.
Step 4: Prep the Data for Sync
Inside Sheets, they used formulas like VLOOKUP to transform the structure to match ServiceTrade’s expected format. That meant the final data was ready to sync, clean and mapped correctly.
Step 5: Push to ServiceTrade
The final dataset was sent to ServiceTrade via its API. Once live, the entire sync loop ran automatically in the background, and payments flowed from QBO to ServiceTrade with no extra effort from staff.
The Results
- Sync Confidence: ServiceTrade and QBO show the same info, no more mismatches.
- Zero Manual Entry: The team no longer wastes hours fixing exports or rekeying data.
- Accurate Reporting: With fewer moving parts, reconciliation is faster and cleaner.
- Future-Proof Setup: The workflow is flexible and can be reused for other platforms later on.
Why G-Accon and Google Sheets Worked So Well
According to the Iconis team, G-Accon hit a sweet spot:
- It gave them access to the right QBO fields, even the ones standard reports can’t reach
- It didn’t require development time or external tools
- It paired perfectly with a flexible tool like Google Sheets, letting them build exactly what the client needed
In the end, what started as a frustrating data limitation turned into a clean, scalable system without a single line of custom code.
From Patchwork to Process
When reporting tools fall short and systems refuse to connect, G-Accon provides power users and consultants with a way to bridge the gap without complexity. Iconis Group didn’t just patch the problem — they built a smarter process that saved time, reduced friction, and gave their client control over their data again. And they did it all with tools they already had.
Want to see more success stories like this? Browse more of our case studies here.
