Feature | Description | |
Google Sheets Integrations with Cloud Accounting | QuickBooks Online, Xero, WorkflowMax, FreshBooks, Sage | |
Two-Way Data Synchronization | Pull data from your accounting software into Google Sheets, make changes and push back to Xero, QuickBooks or FreshBooks. | |
Multi-Entity Support | ||
Connect Multiple Companies | Sign in one time only to establish a secure connection between Google Sheets and accounting software. | |
Switch Company | Easily switch between your connected organizations in Google Sheets. | |
Instantly Refresh All Companies | Refresh all companies in one click | |
Automatically Refresh All Companies | Schedule an automatic refresh to automatically refresh all companies. | |
Export Data & Reports to Google Sheets | ||
Reports | Pull 100+ reports from QBO, Xero, FreshBooks and Sage | |
Custom Templates | Use our flexible pre-built templates to easily create custom reports: multiple periods, dynamic dates, filters, etc. | |
Multi-Currency Converter | Convert all reports to the currency of your choice using currency converter | |
Deep Links | Click on the link in Google Sheets to open a specific record/object in your accounting software. | |
Flexible Date Range for Accounting Reports | Dynamic, Static, Custom | |
Export Raw Accounting Data | Pull data from 100+ QuickBooks or Xero tables such as Accounts, Bills, Customers, Expenses, Invoices, etc. | |
Upload | ||
Upload Data in Bulk | Upload new records in bulk directly from Google Sheets to Xero, QuickBooks, FreshBooks, WorkflowMax. | |
Delete Data in Bulk | Delete existing records in your accounting software directly from Google Sheets. Easily find and delete duplicates. | |
Edit Data in Bulk | Edit existing records in your accounting software directly from Google Sheets. Great for cleanups and reconciliations. | |
Automation | ||
Schedule Automatic Data Refresh | Automatically refresh your financial data & reports in Google Sheets using a flexible schedule (hourly, daily, weekly, monthly). | |
Automatic Emails & Notifications | Schedule automatic emails to send updated reports to multiple recipients. | |
Alerts | Send an alert when certain criteria/threshold is met in your data & reports. | |
Automatic File Converter | Automatically convert Google Spreadsheets to Excel, PDF, and CSVĀ files and send as an attachment. | |
Workflow Builder | Flexible workflow builder to easily automate your manual tasks. | |
Schedule Backups in Google Drive | Automatically save snapshots of your data & reports to your Google Drive. | |
Multi-Entity Consolidation | ||
Consolidated Reporting | Easily consolidate a group of companies in one click. Choose between Profit & Loss, Balance Sheets or Cash Flow reports. | |
Multi-Currency | Generate consolidated reports in different currencies using built-in converter with live or custom currency exchange rates. | |
Admin Tools | ||
Save & Share your Templates in the Cloud | Save time by saving and loading templates from Cloud. Easily copy & apply to all of your companies. Share with your team members/clients. | |
Add/Remove Users | Add or remove users to your group license. | |
Assign User Roles (Admin, Read, Write) | Control access rights of your team members. Add/Restrict user's ability to generate/view company's financial data through group licenses. | |
Add/Remove Companies | Add/remove connected companies in Manage License menu. |
Install G-Accon Google Sheets add-on to automatically start your Free Trial.
Ready to subscribe? Select your plan in Google Sheets add-on Buy/Manage license menu.
Any questions about our pricing plans? Contact us support@accon.services