Easy Multi-Entity Consolidation in Google Sheets

Key Accounting Reports

Use G-Accon templates to easily generate consolidated Profit and Loss, Balance Sheet, or Cash Flow reports in one spreadsheet.
Multi-Currency

Generate consolidated reports in different currencies by using our built-in currency converter with automatic or custom exchange rates.
Intercompany Eliminations

Easily eliminate intercomany transactions directly in Google Sheets with G-Accon.
Live Exchange Rates

Get the consolidated report generated based on the latest available exchange rate from the exchange rate provider. Every time you refresh this report, the latest exchange rate will be used.
Custom Exchange Rates

Choose “Use Custom Rates” or "Custom Rates for Periods" specify a date, and decide whether to get rates directly or create a separate tab with custom rates. This feature lets you manually adjust exchange rates for the report.
Powerful Automation

Schedule an automatic refresh to generate and email real-time consolidated reports to your team and clients in Google Sheets, Excel, PDF, and CSV files. Automatically save backups to your Google Drive.

Install Free Trial

3 Easy Steps to get started with G-Accon Consolidated Reports

1.

Select Companies

Go to G-Accon for Xero Google Sheets add-on - Consolidated Reports menu option and select your entities to create a group of companies to consolidate. Choose from Profit and Loss, Balance Sheet, or Cash Flow reports.
2.

Create Template

Choose the following options and filters and click Execute:
- Multiple Time Periods
- Multi-Currency
- Tracking Categories
3.

Automate

Use G-Accon Workflow Builder to automatically generate and refresh your consolidated report and email to your team and clients. You can also schedule backups in your Google Drive.

Read Step-By-Step Guide

G-Accon has allowed our company to consolidate multiple Xero books and create reports to help with supporting the consolidated financials.

G-Accon integrated seamlessly with our existing consolidated reporting process in Google Sheets, saving almost a full day's work each month.

This saves so much time each month and enables us to see the effects of transactions on the reports and forecasts, as they happen.

Join this webinar to learn more about the key features of G-Accon for Xero.

Join this webinar to learn more about the key features of G-Accon for Xero.

Try for Free

Try for Free

Select your accounting software to install a free 14-day trial from Google marketplace. No credit card required.