Use G-Accon templates to easily generate consolidated Profit and Loss, Balance Sheet, or Cash Flow reports in one spreadsheet.
Generate consolidated reports in different currencies by using our built-in currency converter with automatic or custom 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.
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.
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.
Choose the following options and filters and click Execute:
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.
G-accon has allowed our company to consolidate multiple Xero books and create reports to help with supporting the consolidated financials. The G-accon team is very responsive and willing to work with us if their are any errors or specific needs we have for our reporting.
The team does an exceptional job. We requested a customer/supplier analysis in foreign currency and they build it as an standard feature. Customer Support is the best of all the applications we tested. We are rolling this out as an standard add-on to all our clients.
Thanks to G-Accon, we've managed to live-link our TBs in Google Sheets, consolidate them and viola - "live" management accounts. This saves so much time each month and enables us to see the effects of transactions on the reports and forecasts, as they happen.