Table of Contents
Overview
Benefits of integrating Cone with QuickBooks
Understanding data exchange between Cone and QuickBooks
Navigating to integration settings
Connecting Cone with QuickBooks
Configuring the integration
Mapping tax rates
Setting default account
Understanding integration settings and their impacts
How to disconnect from QuickBooks
Functions not supported by the integration
Invoicing default account
Data synchronization: Timing and settings
1. Introduction
1.a Overview
Welcome to the Cone and QuickBooks Integration Guide. This document is designed to help Cone users seamlessly connect their accounts with QuickBooks to synchronize customer and invoice information. By integrating Cone with QuickBooks, businesses can streamline their accounting processes, reducing manual data entry and ensuring accuracy in financial reports
1.b Benefits of integrating Cone with QuickBooks
Automated synchronization: Automatically sync your customers and invoices from Cone to QuickBooks, eliminating the need for manual data entry
Error reduction: Integration reduces the likelihood of errors caused by manual data entry, ensuring your financial records are accurate
Time saving: Spend less time on bookkeeping and more time on your business with automated data syncing
Improved visibility: With real-time data sync, you have up-to-date financial information at your fingertips, aiding in better decision-making
2. Data Flow Diagram
A comprehensive visual representation showing how customer and invoice information flows between Cone and QuickBooks
3. Getting Started
3.a Navigating to integration settings
Login to your Cone account and access the dashboard
Go to ‘Settings’ by clicking on user avatar icon on the bottom left
Select ‘Integrations’ to view the available accounting software options
Find and click 'QuickBooks' to start the integration process
💡
Only one accounting integration can be connected at a time. If you want to connect to a different accounting integration, you will have to disconnect the existing one first
3.b Connecting Cone with QuickBooks
To connect Cone with QuickBooks:
In the 'QuickBooks Integration' section, click on ‘Connect’
You will be redirected to QuickBooks's login page; enter your QuickBooks credentials to authorize access
Once authentication is successful, you’ll be redirected back to Cone with a message indicating a successful connection
3.c Configuring the integration
Once the integration is connected, you can configure the settings using 'Manage' option
Mapping tax rates:
Click on 'Manage' in QuickBooks integration card
Match each Cone tax rate with the corresponding tax rate in QuickBooks for consistent tax handling
💡
Tax rate mappings between Cone and QuickBooks accounting software are necessary for seamless syncing of invoices from Cone to QuickBooks. If an invoice is created in Cone which is not mapped with an associated tax rate from QuickBooks accounting software, that invoice will fail to sync to QuickBooks. When that happens, you can configure mapping in accounting integration settings
Setting default account:
Select the account to which invoices will be associated with when writing invoice from Cone to QuickBooks
This setting ensures that each invoice created in Cone is automatically categorized in the appropriate account in QuickBooks
Default account dropdown shows only those accounts that have payments enabled. For QuickBooks, Cone shows those accounts that have Bank as the category in chart of accounts. If you want to enable payments to other accounts so they can show up here, please update the category in QuickBooks from here
3.d Understanding integration settings and their impacts
Default account
When an invoice is added in Cone, when configured, an invoice will also be added in QuickBooks. This invoice will be associated with the payment account that's specified in this setting
Tax rate mapping
When an invoice in added in Cone with a tax rate, it will be added in QuickBooks with the mapped tax rate
4. FAQs
4.a How to disconnect from QuickBooks
Go to the ‘Integrations’ section in Cone settings.
Find QuickBooks and click on ‘Disconnect’.
Confirm the action in the pop-up dialog.
The integration will be safely disconnected.
Once integration is disconnected, all integration settings are removed. If you connect it again, you will have to configure the settings again
4.b Functions not supported by the integration
This integration does not support syncing of inventory items, employee records, or custom fields that do not have a direct counterpart in QuickBooks
Real-time updates for deleted invoices are not currently supported; these must be manually removed from QuickBooks
4.c Invoicing default account
Under 'Default accounts` in integration settings, we only show the accounts for which payments are enabled. You can enable this on other accounts in QuickBooks as described here
4.d Data synchronization: Timing and settings
Automatic sync: Enabled by default, invoices and customers are synced in real-time as they’re created or updated in Cone
Pause sync: Users can pause sync from integration settings, by clicking on 'Pause sync'
4.e My chart of accounts aren't showing up in default invoice account dropdown
Default account dropdown shows only those accounts that have payments enabled. For QuickBooks, Cone shows those accounts that have Bank as the category in chart of accounts. If you want to enable payments to other accounts so they can show up here, please update the category in QuickBooks from here