Connect Google Sheets to Xero,
by-directionally. Get data from Xero Accounting, Payroll, Projects, Assets API's. Pull data, reports, and build custom queries.
Make changes and import data into Xero directly from Google Sheets.
Generate reports using our flexible templates with filters and dynamic dates. Compare multiple periods, tracking categories, multi-currency, and more. Create 50+ reports including Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc.
Refresh your reports & dashboards automatically when you are offline using a flexible schedule: hourly, daily, weekly, monthly. Create BI dashboards by connecting your spreadsheets to Google Data Studio and setting auto-refresh.
Create/Update/Delete Invoices, Bank Transactions, Manual Journals, Contacts, Purchase Orders, Payments, etc. and post to Xero. No more hassle with CSV files. Schedule automatic data uploads from Google Sheets to Xero.
Automatically generate and email real-time reports to your team and clients in Excel, PDF, CSV or Google Sheets. Create and send alerts when certain criteria are met.
Easily share spreadsheets and collaborate with your team and clients in Google Drive. Work as a team on a shared spreadsheet, leave comments, and track changes. Your non-Xero users can now see live data!
Connect your Google spreadsheets to multiple Xero accounts - a separate tab will be created for every organisation. Consolidate your data. Refresh all organisations automatically or on demand.
Save your reporting and upload templates in the Cloud. Share with your team members.
History & Notes summary for accounting transactions and user activities. By using this module, G-Accon users will be able to view an audit trail of the notes recorded against their organisation’s transactions.
Convert all reports to the currency of your choice (160 currencies). Generate Account Receivables and Payables reports in the customer's currency.
Make your changes in Google Sheets and upload to multiple Xero accounts in one click. For example, allocate credit notes for all your clients, create invoices, edit the chart of accounts, post transactions, etc.
Use G-Accon's workflow builder to easily automate your manual repetitive tasks and focus more on your clients. Automatically generate reports, emails, exports, and bulk uploads. Easily schedule data backups in your Google Drive.
Fantastic add-on! I've been able to remove a lot of monotonous work that needed detail and I've been able to setup alerts when changes occur on my reports. Very efficient and forward thinking...read more
GAccon allows me to prepare the most requested report NOT in Xero - profit and . loss by tracking category with filters. Without it I would be lost in excel for hours pulling this report together. GAccon is a crucial and indispensable tool for Xero...read more
Great add on, which had allowed me to automate a substantial part of my workflow. There was a report I needed that was unavailable however I spoke to Andrey at G-Accon and the report was added to their feature set within 2 weeks...read more
We're steadily building out our G-Accon powered set of Google Sheet based reporting systems across our CFO clients. The automated Xero report pulls feeding into our weekly and monthly reporting are saving us a whole lot of time so that we're more real-time and proactive than ever....read more
G-Accon is a fantastic plugin! As a cloud integrator specialist I can't express how magical this plugin has been in delivering important and relevant data to my clients all with a click of a button. Andrey is a fantastic developer and excellent at taking feedback and providing quick fixes to any bugs you may come across. You can't go wrong with this plugin...read more
I cannot overstress/-sell how this add-on has helped us! We have 3 entities in a group that needs to be consolidated and reported on on a fairly regular basis. 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...read more
Every Wednesday at 10 AM EST.
Join our weekly webinars to see G-Accon in action and ask us any questions. Register Now
Contact us at support@accon.services