QuickBooks Online Integration | Help (2024)

QuickBooks Online is cloud-based accounting software for small businesses, that helps you automate the process of accounting. Integrate Zoho Subscriptions with QuickBooks Online to account for your customers’ subscriptions with ease.

Here’s what the integration with QuickBooks Online can do:

• Import your accounts and customers into Zoho Subscriptions so you can access customer details in one place.
• Export your invoices and credit notes along with their payments to QuickBooks so that they can be accounted for automatically.
• Generate detailed reports on your business’s financial health.
• Get accurate financial data by doing away with manual bookkeeping.

Set up the integration

• Log in to your Zoho Subscriptions account.
• Navigate to Settings > Integrations > Accounting.
• Click the Connect to QuickBooks button next to QuickBooks.

• You will be redirected to QuickBooks Online sign-in page. Enter your credentials to proceed with the integration.
• Once you sign in to QuickBooks, if you have multiple organizations, you need to select the organization that you want to connect with Zoho Subscriptions.
• After selecting an organization, click Connect to complete the integration.

You will then be redirected back to your Zoho Subscriptions account, where you can configure the integration.

Configure the integration

Now that you’ve connected Zoho Subscriptions with QuickBooks Online, you can go on and choose which data should be imported from and exported to QuickBooks Online.

Importing from QuickBooks Online

Since you need to account for your transactions in Zoho Subscriptions, you need to import the accounts and customers (if any) you have in QuickBooks.

• Accounts: By default, all your accounts in QuickBooks will be imported into Zoho Subscriptions. These accounts will be available when you create a plan or addon in Zoho Subscriptions, so that you’ll be able to choose the account under which all transactions for that item should be tracked in QuickBooks.
• Customers: If you have customers in QuickBooks, you can choose to import them to Zoho Subscriptions so you can create transactions for them. If you enable this option, all your customer contact details in QuickBooks will be created as new customers in Zoho Subscriptions. Your existing customers in Zoho Subscriptions will be retained.

Exporting to QuickBooks Online

You can export your Zoho Subscriptions transactions to QuickBooks, to account for them.

• Choose the modules you want to export from Zoho Subscriptions to QuickBooks. You can export invoices and credit notes along with their payments.
  • Invoices, both paid and unpaid, will be exported to QuickBooks under Sales. Your draft invoices will also be exported.
  • Credit Notes in Zoho Subscriptions can be exported as Credit Memos under Sales.
• Select an account under which you want to record bank charges, write-offs, and adjustments for your invoices.
  • If or when an invoice is written off in Zoho Subscriptions, a credit note is automatically created and associated with the corresponding invoice in QuickBooks.
  • If a payment is recorded with bank charges, the payment amount is initially accounted as undeposited funds and a deposit will be made to the appropriate bank account along with bank charges.

• You can export transactions created with the customers imported from QuickBooks. If you are exporting a transaction created with a customer in Zoho Subscriptions, then the customer will be automatically created in QuickBooks with their basic details such as name, phone number, email, and address.
• The underlying items in each invoice that is exported from Zoho Subscriptions will be created on the fly as Products and Services in QuickBooks.
• Transactions will be exported to QuickBooks as and when they are created/updated/deleted in Zoho Subscriptions.

Mapping Taxes

To ensure that the taxes in your transactions exported to QuickBooks are mapped correctly with your existing taxes in your QuickBooks account, you can map the taxes present in both the apps.

• To map the taxes, make sure that you have enabled taxes in both Zoho Subscriptions and QuickBooks Online.
• Select an existing tax in Zoho Subscriptions or create a new one, and then select the corresponding QuickBooks tax to be mapped.

• Once the initial setup and configuration is done, click Save to return to the details page.

Adding items from QuickBooks Online

When you export a transaction to QuickBooks, the items included in it will be synced to QuickBooks as well. Your other items in Zoho Subscriptions will not be available in QuickBooks.

To bring your existing items in QuickBooks (if any) into Zoho Subscriptions:

• Export all your items in QuickBooks.
• Import them into Zoho Subscriptions.
• Mark your existing items in QuickBooks as Inactive to avoid errors while syncing items from transactions.

View integration details

After you have configured the integration, you can view the details regarding the integration by going to Zoho Subscriptions > Settings > Integrations > Accounting, and then clicking Show Details near QuickBooks Online.

• Any new addition to the list of customers or accounts in QuickBooks will be automatically reflected in your Zoho Subscriptions account by virtue of the auto-sync that occurs once a day.
• If you want something to be reflected in Zoho Subscriptions immediately, you can click the Instant Sync button.
• You can change the configuration at any time by clicking Change Configuration.
• From the details page, you can also check when the next sync will occur, the last synced time, and view the sync historybetween Zoho Subscriptions and QuickBooks Online.

Sync between Zoho Subscriptions and QuickBooks Online

Zoho Subscriptions syncs the following records with QuickBooks Online:

Sync details of transactions

Transactions such as invoices with payments are pushed from Zoho Subscriptions to QuickBooks Online. This sync happens instantaneously, that is, whenever you create invoices in Zoho Subscriptions, they will be synced to QuickBooks immediately.

The following table lists out how the transactions are synced between Zoho Subscriptions and QuickBooks Online.

Sync details of invoice

Invoices created in Zoho Subscriptions will be exported to QuickBooks Online along with their payments.

The following table lists out the fields in an invoice that are mapped with the one created in QuickBooks.

Sync details of customers

Your customer details will be synced from QuickBooks Online to Zoho Subscriptions. A contact created in QuickBooks will be imported into Zoho Subscriptions as a new customer. Whenever a customer is added, edited, or deleted in QuickBooks, it will be reflected in Zoho Subscriptions by virtue of the automatic sync that occurs once a day or via the Instant Sync option.

The following table lists out how each customer’s details are reflected from QuickBooks Online to Zoho Subscriptions.

Delete the integration

If you want to stop using QuickBooks Online for accounting and would like to disconnect it from your Zoho Subscriptions account, you can delete the integration. Once you delete it, customers and transactions will no longer by synced between both the apps, and the integration details will also be deleted.

To delete the integration with QuickBooks Online:

• Log in to your Zoho Subscriptions account.
• Navigate to Settings > Integrations > Accounting.
• Click Aceesd
• Click the hamburger menu in the top right corner and choose Delete Integration.
• In the following pop-up, click Delete Integration again to confirm the action.

The integration will now be deleted, but all your accounts and customers that are already synced from QuickBooks will continue to remain active in Zoho Subscriptions.

Instead of deleting the integration completely, if you only want to pause the data sync for sometime, you can disable the integration. Your integration details will not be deleted and you can activate the integration at any time.

To disable the integration:

• Log in to your Zoho Subscriptions account.
• Navigate to Settings > Integrations > Accounting.
• Click Show Details near QuickBooks Online.
• Click the hamburger menu in the top right corner and choose Disable Integration.
• In the following popup, click Disable Integration again to confirm the action.

Your integration will now be disabled and you will not be able to account for your transations using QuickBooks Online. You can always click the Enable Integration button to re-activate the integration.