Live connection to Xero in Google Sheets
Connect and sync Google Sheets with Xero Accounting, Payroll, Assets, Projects data. Refresh automatically or manually.
Xero & Custom Reports
Get Detailed Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Read more>>
Connect to multiple organizations and consolidate data in one sheet. Refresh reports for all companies in one click
Automatic Data Refresh
Refresh your reports & dashboards automatically when you are offline up to every hour. Build powerful BI dashboards by connecting your spreadsheets to Google Data Studio and setting auto-refresh. Read more>>
Collaborate in Google Drive
Share spreadsheets with anyone and let your non-Xero users see live data! Work as a team in Google Drive and track changes.
Data Monitoring & Alerts
Create alerts and receive notifications if certain criteria is met. Read more>>
Send real-time reports to your clients automatically in Excel, PDF, CSV or Google Sheets format. Read more>>
Secure: We use secure OAuth 2.0 protocol, SSL encryption and Xero API. You will be redirected to Xero.com to enter your credentials. You can securely share your spreadsheets with anyone.
Easy To Use: Instantly install Add-On in your Google Drive, connect to Xero and start pulling your data in seconds. Edit your data directly in Google Sheets or create new records and upload to Xero
Automation: Automatically refresh & email the latest Xero reports & data to your clients. No more hassle with manually downloading reports from Xero.
Latest Product Releases
Connect to Xero New Zealand Payroll directly from Google Sheets
Separate login for NZ Payroll users
Export Timesheets, Pay Stubs, Pay Items, Employees, etc.
Refresh data automatically or manually
Xero Projects are now available in your Google Drive. Easily extract and refresh data from Projects, Users, Tasks, Time in Google Sheetsread more >>
Watch this video on how to consolidate information across multiple companies into a google sheet.read more >>
August Release: now you can customize your user and reports settings.
Stay logged in to Xero
Report and Data Pull Settings
Redesigned Cash Summary Reportread more >>
Automatically generate and email Xero reports
Backup Historical Dataread more >>
Now you can modify, update or delete query or report metadata
Added Dynamic Date Range
New Pull Settings
Multiple Organization Support
Fiscal and calendar years are now supportedread more >>
New Report: Custom Date Range Balance Sheet
New Report: Cash Summary
Balance Sheet report can now display previous comparable periods
Revised Detailed Account Transaction reportread more >>
Watch our video tutorials to get started
G-Accon connects Google Sheets to Xero & automates Xero Reporting to save time
Enhance your Xero Cloud Accounting with Cloud-Based spreadsheets to increase efficiency, save time & collaborate with others
Reduce errors - no more manually copy-pasting into Excel - instantly pull & refresh your live Xero data in Google Sheets
Use the power of Google Sheets to customize reports, build charts and share with your non-Xero users in Google Drive Cloud
Connect you spreadsheets to Google Data Studio to design beautiful & interactive Xero dashboards
Schedule automatic data refreshes to keep your reports updated for all organizations when you are offline
Setup alerts to monitor your data based on threshold and make business decisions in real-time
View your Google Spreadsheets on almost any device - Iphone/Ipad/Android. Export to various file formats - Excel, PDF, CSV
Xero is world-leading online accounting software built for small business.
- Get a real-time view of your cashflow. Log in anytime, anywhere on your Mac, PC, tablet or phone to get a real-time view of your cash flow. It's small business accounting software that's simple, smart and occasionally magical.
- Run your business on the go. Use our mobile app to reconcile, send invoices, or create expense claims - from anywhere.
- Get paid faster with online invoicing. Send online invoices to your customers - and get updated when they're opened.
- Reconcile in seconds. Xero imports and categorises your latest bank transactions. Just click ok to reconcile.
Find out more or try Xero Accounting Software for free.