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.
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.