When you manage multiple Xero organizations or pay bills in different currencies, your payables can get scattered very fast. You export one report here, another one there, then try to piece everything together inside a spreadsheet. It works for a while, but it is hard to keep clean and consistent.

The Consolidated Aged Payable Detail report in G-Accon for Xero is built to solve that problem. You pull all the detailed vendor bills you need from Xero straight into Google Sheets, you see amounts in the supplier’s own currency, and you keep one template that you can refresh again and again. If you want the technical reference while you read, you can check the wiki here: Aged Payables Detail in the Customer Currency.

This article walks you through how to design the template, refresh it automatically, and tweak it later. You will also find a step-by-step video right below that shows the full process on screen, so you can follow along while you set it up.

(more…)

There are moments in business that make you stop, take a breath, and really see how far you’ve come. This is one of those moments for us.

G-Accon has been selected as a Finalist in the Xero Global App Awards 2025, and honestly, it still feels a bit surreal. Not because we didn’t believe in what we were building, but because recognition like this reminds you that the long nights, the support tickets, the planning calls, the tiny improvements nobody notices but everyone feels, they all add up.

And now, here we are. A finalist in three categories:

• Global Practice App of the Year
• Australia Practice App of the Year
• UK Small Business App of the Year

Seeing our name listed across multiple regions brings a quiet sense of pride. It means real people, in real firms, across different parts of the world, trust and rely on us every single day. That trust matters!

Why This Moment Means More Than a Trophy

Awards are special, but we didn’t start G-Accon thinking about stages or celebrations. We started with simple goals:

• Help accountants save time.
• Help small businesses get control of their numbers.
• Make automation feel easy, not overwhelming.

If you’ve ever watched a finance team try to manage endless spreadsheets, reports, and system updates, you understand why this work matters. Accountants and bookkeepers serve as the quiet engine behind many successful businesses. People depend on them, and they depend on tools that don’t slow them down.

So yes, this finalist recognition feels big to us. It tells us our mission is working. And it reminds us that the effort to build something useful, even if it takes time, is always worth it.

How We Got Here

Someone once said real progress looks boring while it's happening. We get that. Most of our journey didn’t look like a highlight reel. It looked like:

• Suggestion emails at midnight
• Customer calls squeezed between development sprints
• Solving tiny bugs that only show up once in a blue moon
• Rewriting parts of the product because “good enough” wasn’t really enough
• Asking users, “What would make this easier for you?” and then quietly building it

Every improvement came from listening to real people doing real work.

A large accounting firm in London asked us for faster consolidation tools… we built them.
A small startup in Sydney needed smoother client reporting workflows… we listened.

A bookkeeper in Toronto just wanted one place to move Xero data into Sheets without all the manual steps… so we kept improving that flow, over and over again.

This is how you grow software, one helpful update at a time.

What Our Users Proved

Anyone can build software. But building software that fits naturally into the day-to-day life of accountants and business owners? That takes patience. It takes curiosity. And honestly, it takes a team that cares.

Our community taught us things we could never have guessed on our own. They showed us:

• Automation isn’t about replacing people; it’s about respecting their time
• Simple design beats complicated dashboards every time
• Reports should be fast, flexible, and easy to adjust
• Even the best tech needs a human support system behind it

And maybe the most important lesson of all:

"When people feel heard, they stick with you, not because they have to, but because they want to."

We never forget that.

What the Xero Global App Awards Represent

To us, being named a finalist isn’t only about our product. It represents:

• Trust from accountants and small business owners
• A strong ecosystem built by Xero and its partners
• A shared commitment to making work smoother and more human
• Proof that thoughtful tools win over flashy tools

The awards focus on apps that make a real difference, and that’s what makes this honor special. It means we’re contributing something meaningful to the industry, and that's the part we’re proud of.

What Happens Next

The final award winners will be announced in November. We’ll be watching, we’ll be cheering, and yes, we’ll be hopeful. But whether we take home the top award or not, this moment already feels like a win. Right now, our focus stays exactly where it has always been:

• Building features that save time and reduce stress
• Making reporting easier and faster
• Supporting accountants, bookkeepers, and small businesses
• Improving based on real feedback, not trends

The work doesn’t stop, and honestly, we wouldn’t want it to. Progress is a habit, not a phase.

Thank You for Being Part of This

To our users, partners, and supporters, thank you.

Every conversation, every feature suggestion, every “can this be faster?” message shaped us. And if you’ve ever reached out to our team, you know we don’t forget those moments. We take your feedback seriously because we understand what’s at stake for you and your clients.

If you celebrate this milestone with us today, know that you helped create it.

The Road Ahead

We have more updates on the way, more improvements planned, and more ways we hope to support your work. But for a moment, we’re simply grateful. It feels good to pause and acknowledge a milestone before getting back to the build-test-learn rhythm that made it possible.

Thank you for trusting us. Thank you for choosing us. And thank you for believing in a product built around real needs, not buzzwords. The journey continues, and we're glad you’re on it with us.

If you work in accounting, you’ve probably heard the buzz. People say things like, “AI will replace accountants,” or “automation will take over our jobs.”

But that’s not the full story.

The truth is, AI isn’t here to take your place; it’s here to take off the pressure. It’s built to handle the repetitive work that eats up your time so you can focus on what actually matters: helping clients, solving problems, and giving advice that numbers alone can’t.

At G-Accon, we see it every day. The real advantage of following AI Trends In Accounting isn’t about replacing humans—it’s about working smarter. When you connect tools you already use, like Google Sheets, QuickBooks, or Xero, with G-Accon’s automation, you get the best of both worlds.

You stay in control, and your workflows become faster, clearer, and easier to manage. Because at the end of the day, AI should work for you, not the other way around.

If you manage more than one company in QuickBooks Online (QBO), you already know how painful Consolidating Financial Data can be. Exporting balance sheets, profit and loss reports, and trial balances from each QuickBooks account and then combining them manually eats up time and increases the chance of errors.

Research shows that 71% of organizations using automation complete their close in six days or fewer. But among those using little or no automation? Just 29% can say the same, often costing teams several hours each week in data cleanup and reconciliation.

Many accountants and finance teams turn to third-party consolidation tools like LiveFlow or Joiin. But what if you could do everything—pull, consolidate, and refresh your financial data—right inside Google Sheets, with a tool that connects directly to QuickBooks Online and offers more control and flexibility?

That’s where G-Accon comes in.

(more…)

QuickBooks Online (QBO) has always been about giving businesses more control over their numbers, and this has covered everything from tracking sales to managing invoices. It helps people stay organized without needing to be accounting experts. But until now, there was one area where users felt limited: custom fields.

That’s changing. Intuit has opened up the Custom Fields API, but only to its Platinum Partners. And since G-Accon became a Platinum Partner in May, we’re among the very few who can bring this powerful new feature directly to you. We’ll explain what custom fields are, why they matter, and how they can save you time, and what makes G-Accon’s access unique.

What Are Custom Fields in QuickBooks Online (QBO)?

Custom fields are exactly what they sound like: extra fields you can add to your QBO forms and reports. These fields let you capture information that doesn’t normally appear in standard QuickBooks templates. Think about an invoice. Normally, it has basics like customer name, date, item, and total. But what if you also want to track:

• A project code
• A delivery date
• A client’s internal reference number
• A sales rep’s name

With custom fields, you can add those details. They appear on your invoices, sales forms, and even in your reports, giving you more flexibility. For accountants and bookkeepers, these fields are a game-changer. They allow firms to track details that matter to their clients without relying on workarounds or messy notes outside the system.

Why the Custom Fields API Matters

QuickBooks has allowed some custom fields for a while, but the new Custom Fields API takes things much further. An API (application programming interface) is what lets software connect and share information.

By using the API, apps like G-Accon can now:

• Sync custom fields directly into Google Sheets
• Automate reporting that includes those fields
• Consolidate data across multiple companies while keeping unique details intact
• Build templates that use client-specific information

Before, many firms had to manually add extra notes into spreadsheets or re-enter information that didn’t fit into QBO’s built-in categories. That meant wasted time, more errors, and less clarity. The API fixes that problem by making custom data part of the normal workflow.

Why It’s Exclusive to Platinum Partners

Here’s the big part: not everyone has this feature.

Intuit only gave access to the Custom Fields API to its Platinum Partners. That’s the highest tier in Intuit’s program, and there are only a handful of companies in that group.

G-Accon reached Platinum status in May 2025, and because of that, we can release the Custom Fields API to our QuickBooks Online customers right now.

What does that mean for you? It means that by working with G-Accon, you get tools and features that most other QBO users don’t. While others are still waiting, you can already take advantage of:

• More detailed reporting
• Less manual entry
• Stronger customization
• A competitive edge in how you use your data

How G-Accon Puts Custom Fields API to Work

At G-Accon, our mission has always been to connect QuickBooks with Google Sheets in a way that saves time and reduces errors. The Custom Fields API fits right into that mission.

Here’s what you can do now:

1. Smarter Reporting

Let’s say you manage multiple projects for a client. You can create a custom field for “Project Code” in QBO.
With G-Accon, that field syncs directly into Google Sheets. No extra typing, no messy copy-paste.
Your reports show exactly which project each invoice or payment belongs to.

2. Multi-Entity Consolidation

If you handle multiple companies, custom fields let you keep track of company-specific details while still consolidating your numbers. For example, one company might need a “Branch ID” field, while another might need “Sales Territory.” G-Accon can bring them all into one master report.

3. Custom Templates

Want to build a dashboard that includes custom data? With G-Accon’s integration, you can create templates in Google Sheets that pull in both standard QuickBooks numbers and your custom fields. That means your templates reflect the way you work, not just the way QuickBooks works.

4. Real-Time Sync

Custom fields update in real time just like the rest of your QuickBooks data.
Change something in QBO, and it flows into your connected Sheets instantly.

Why This Matters for Accountants and Firms

For firms, the benefits go beyond saving time. Custom fields make it easier to deliver insights that actually matter to clients. Imagine being able to say, “Here’s not just how much revenue you earned, but how much came from Project A versus Project B.” Or, “Here’s your profit margin by sales rep, not just by product.”

That’s the kind of detail that helps clients make better business decisions, and it’s the kind of insight that turns accountants into trusted advisors.

By using custom fields through G-Accon, firms can:

• Offer more valuable reports without extra manual work
• Reduce human error in data entry
• Tailor dashboards to client needs
• Free up staff time for higher-value advisory work

What Sets G-Accon Apart

Yes, other apps will eventually catch up. But right now, G-Accon is one of the only tools that can give you access to the Custom Fields API. That’s because of our Platinum Partner status.

This isn’t just a badge; it’s recognition that G-Accon is trusted by Intuit at the highest level. It also means we get early access to new features, direct support, and the ability to bring these benefits to you before most of the market.

So when you use G-Accon, you’re not just using a connector between QBO and Google Sheets. You’re using a partner with exclusive access and deep integration that others simply can’t match.

Getting Started with Custom Fields API

If you’re already using G-Accon, you can start exploring custom fields in your QBO reports right away. Watch the interactive demo to see how it works step by step.

If you’re new to G-Accon, now is the perfect time to try it. You’ll not only get all the standard sync and reporting features but also access to exclusive Platinum-level tools like Custom Fields.

If you run a small business, you have likely asked yourself: Freshbooks vs Quickbooks, which one should I choose? Both are big names in accounting software, and both handle invoices, expense tracking, and reports.

On August 26th, 2025, the G-Accon team packed up our table signs, swag, and laptops and set out for the Xero Roadshow in New York City.

If you've never been to one of these events before, think of it as a big meetup for people who live and breathe accounting. Small business owners, bookkeepers, CPAs, and software vendors all in one space, talking, learning, and solving real problems.

And yes, we were one of those vendors. But we weren’t just there to pitch. We were there to listen, learn, and show people what G-Accon can really do.

(more…)

Finance automation software is becoming a necessity because every CFO I’ve spoken with, or honestly, just observed, shares a familiar frustration. The month-end close drags on longer than anyone wants to admit.

The finance team spends nights patching spreadsheets, re-exporting CSVs, and emailing versions of financial statements that are outdated by the time the CEO opens them. It’s not that people aren’t working hard. It’s that the system itself is broken.

This is where finance automation enters the story. And I don’t mean automation in some vague “robots take over” sense. I mean automation software that actually helps finance teams breathe again.

Tools that move the financial data where it needs to be, automate financial tasks that once took hours, and give CFOs real-time access to financial performance.

I think the truth is simple: the old way of managing financial reporting isn’t sustainable. And maybe it never really was.

(more…)

If you’ve ever tried to consolidate financial data across multiple companies in QuickBooks, you know the pain. On paper, it seems simple: just combine reports and get one clear picture of your business. But in practice, QuickBooks doesn’t offer a native feature to consolidate multiple entities. This is why Consolidation in QuickBooks is often one of the biggest challenges for accounting teams.

That means accountants spend hours every month exporting data, fixing mismatched charts of accounts, and stitching together financial statements in QuickBooks using Microsoft Excel spreadsheets. It’s repetitive, error-prone, and gets worse as your company grows, making Consolidation in QuickBooks harder the bigger your organization gets.

Fortunately, you don’t have to stay stuck in that manual loop. With the help of G-Accon, Consolidation in QuickBooks becomes simple and efficient. Instead of spending hours exporting and fixing spreadsheets, you can bring all your company data into Google Sheets, combine reports from multiple entities, create clear consolidated dashboards, and even automate the entire process.

Can You Consolidate Automatically in QuickBooks Online?

The short answer is no. QuickBooks Online (QBO) is excellent at running a single business, but it doesn’t allow you to consolidate multiple company files into one. If you manage more than one entity, QuickBooks requires you to create separate accounts. This keeps information secure, but makes consolidating multiple entities a nightmare.

Even QuickBooks support has admitted there’s no native way to generate consolidated financial statements. The options they suggest? Either combine reports in Excel manually or use a third-party consolidation tool.

One feature you won’t find on QuickBooks’ list is consolidation.

Manual Consolidation in QuickBooks

If you don’t use a QuickBooks app or a consolidation tool like G-Accon, you’re left with the manual process. For most companies, this involves three main steps, but in reality, each step can be far more complex than it looks.

1. Exporting Data

The first step is exporting financial reports from each QuickBooks company file. This is usually done through CSV files or Excel downloads. On the surface, it sounds straightforward, but depending on how many entities you manage, it can take days to gather everything.

For companies that operate across borders, there’s also the added step of converting foreign currencies into one standard reporting currency. If you skip this, your consolidated statements will be misleading. Each export also needs to be checked to ensure you’ve included the right accounts, time periods, and adjustments.

2. Uploading Data into a Spreadsheet

Once exported, the data must be uploaded into a Microsoft Excel spreadsheet or Google Sheet. This isn’t a simple copy-and-paste job. Every number must be placed into the correct columns, formatted consistently, and aligned with your chart of accounts.

If two companies use slightly different account names, for example, one uses “Utilities” while another uses “Gas & Electric,” your team has to standardize them before combining. This step requires precision because even a small mismatch can throw off the final consolidated financial statements. And with so much manual re-entry, errors are easy to make.

3. Fact-Checking for Accuracy

The last step is reviewing the full spreadsheet to confirm accuracy. This includes scanning for missing numbers, duplicate entries, or simple typos like an extra “0” at the end of a figure. Beyond that, you often need to make advanced adjustments such as:

• Eliminating intercompany transactions (to prevent double-counting revenue or expenses).
• Adjusting journal entries to account for partial ownership.
• Reconciling balances across entities to ensure everything ties back to source data.

This is where consolidation gets tricky. It isn’t just “adding numbers together.” It’s aligning financial data across multiple entities so that the final reports are correct and compliant.

Why Manual Consolidation Is Problematic

On the plus side, manual consolidation is cheap; you don’t need special software beyond Excel or Google Sheets. And it’s familiar; most accountants already know how to use these tools.

But the downsides are serious:

• The process is slow. For larger organizations, it can take an entire accounting team several days every month.
• Errors are common. One wrong entry can throw off your financial reporting and lead to bad decisions.
• It doesn’t scale. As your company adds more entities or grows internationally, manual work only gets heavier.

Manual consolidation is slow, error-prone, and difficult to scale as a business grows. What might start as a few hours of work quickly becomes days of exporting, reformatting, and double-checking spreadsheets. And the risk of mistakes is high. In fact, a review-based study covering 35 years of research found that 94% of business spreadsheets used in decision-making contain errors.

For finance teams, even one wrong number can distort reports, mislead decision-makers, and create compliance issues. This is exactly why many organizations are turning to tools like G-Accon, to replace fragile manual processes with a reliable, automated system that produces accurate consolidated reports in minutes

That’s why many firms eventually move to third-party consolidation software. Tools like G-Accon can consolidate multiple QuickBooks entities in minutes instead of days, automate updates, and remove the need for manual uploads.

Consolidating Multiple Companies with G-Accon

This is where G-Accon changes the story. Instead of juggling reports from multiple company files by hand, you can:

• Connect your QuickBooks accounts directly to G-Accon.
• Pull data from multiple QuickBooks entities into a live spreadsheet.
• Map account names so your chart of accounts aligns properly.
• Generate consolidated reports instantly, including income statements, balance sheets, and cash flow statements.
• Handle intercompany eliminations to clean up duplicate entries across all companies.

The result? Accurate, up-to-date consolidated financial statements without the manual copying and pasting.

How Consolidation in QuickBooks Works Step by Step

1. Connect your QuickBooks

You start by linking your QuickBooks account (either QuickBooks Online or QuickBooks Desktop Enterprise) directly to G-Accon. This makes your data available in Google Sheets without manual exports.

2. Select entities

If you manage more than one company, you can choose which ones to include. G-Accon lets you pull data from several businesses at the same time, whether that’s just a few or dozens, so you can see them together in one place.

3. Map your accounts

Since different company files might name accounts slightly differently, G-Accon lets you group similar accounts. For example, “Office Supplies” in one company and “Supplies” in another can be mapped together, so your consolidated report makes sense.

4. Generate reports

You can either build custom reports or use G-Accon’s ready-made templates. Reports can be filtered by company, time period, class, or location, so you see exactly what matters most.

5. Automate updates

Instead of pulling reports manually every time, you can schedule automatic refreshes. This way, your Google Sheet is always up to date with the latest QuickBooks data.

Big picture: You’re basically turning your spreadsheet into a live financial consolidation tool. No extra software, no complicated steps, just QuickBooks data flowing directly into Google Sheets, ready for analysis and sharing.

QuickBooks Desktop Enterprise Users

If you’re using QuickBooks Desktop Enterprise, there is a built-in feature to combine reports from multiple companies. But it’s limited. You still need to export results into Excel and make adjustments.

With G-Accon, you can push all your data from multiple companies into a single spreadsheet and build accurate, repeatable financial reporting workflows.

Why Use G-Accon for Consolidation in QuickBooks

• Save time: Automate the process of pulling data instead of exporting reports manually.
• Reduce errors: No more manual copying and reformatting.
• Scalable: Works whether you manage a handful of companies or hundreds of entities.
• Customizable reporting: Build reports that fit your business, not just what QuickBooks offers.

In short, G-Accon makes consolidation with QuickBooks practical. You keep working in familiar spreadsheets, but your data updates in real time and are combined into one accurate view.

A Smarter Way Forward

If you need to consolidate financial reports across multiple companies in QuickBooks, doing it manually will only get harder as your business grows. QuickBooks itself doesn’t offer a solution, and relying on combined reports in Excel is not sustainable long term. This is why Consolidation in QuickBooks is a challenge for many businesses.

With G-Accon, you can consolidate data from multiple companies, handle intercompany transactions, and build clean consolidated financial statements in just minutes. It’s a third-party tool designed to fill the gap QuickBooks leaves behind, making Consolidation in QuickBooks faster, more accurate, and far less stressful. It helps you see the full financial picture of your organization without the monthly scramble.

(more…)