The QuickBooks Online Exporter plugin is a one-way sync from Ubersmith to QuickBooks Online. Updates made in QuickBooks will not be transmitted to Ubersmith. Every five minutes, any new or updated data in Ubersmith is exported to QuickBooks Online. It is assumed you already have an established QuickBooks Online company.

The following data is exported:

  • Clients
  • Service plans
  • Invoices
  • Refunds
  • Payments
  • Credits

In order to begin exporting your data from Ubersmith to QuickBooks Online, you need to configure Ubersmith and QuickBooks Online. Once all the necessary pieces have been configured, any new or updated data can be exported. The configuration steps are as follows:

  1. Configure Ubersmith (below)
  2. Enable the QuickBooks Online Exporter plugin.
  3. Configure the QuickBooks Online Exporter plugin (below).
  4. Connect the QuickBooks Online Exporter plugin to your QuickBooks Online account (below).
  5. Export your data (below).
  6. Troubleshoot any export failures or errors (below).


Configuring Your Ubersmith Instance

  • Upgrade to Ubersmith 4.4.0 or later. 

Configuring the QuickBooks Online Exporter Plugin

  1. Access the Plugins page.
  2. Click QuickBooks Online Exporter plugin.

    The QuickBooks Online Exporter page appears.
  3. In the Modules section, click add new instance.

    The Associated Components section appears.
  4. Click in the Brands field to display brand options and select Apply to all brands to export all your brands, or select on or more specific brand to only export to those brands.
  5. In the Mode field, select Sandbox to connect to a test QuickBooks Online account, or select Production to connect to your actual QuickBooks Online account.
  6. Click Save.
  7. Click Show Instances to display your configurations settings.
  8. Click Hide Instances to close your configurations settings.

Connecting to QuickBooks Online

This section describes how to establish a connection between your Ubersmith instance and your QuickBooks Online account. If your login to QuickBooks Online expires, you will need to establish a new connection.

Complete the Connection Tab

The Connection tab establishes a connection between your QuickBooks Online account and your Ubersmith instance.

  1. Click Go to Plugin Home. The Connection tab appears with a message that no connection has been established with QuickBooks Online.
  2. Click Connect. The Intuit QuickBooks Online Sign in page appears.
  3. Sign into your QuickBooks Online account. The QuickBooks Online Authorize Intuit to securely share your data to Ubersmith page appears.
  4. Click Connect. The Ubersmith QuickBooks Online Exporter plugin appears with the Accounts tab active.

Complete the Accounts Tab

 The Accounts tab specifies where services, payments and refunds from Ubersmith are exported to QuickBooks Online. If the appropriate QuickBooks Online accounts are not found, Ubersmith can automatically create a new account, or you can create it in QuickBooks Online yourself. If accounts are found, they are included in the selection fields.

QuickBooks Online account names are unique. If you create a new account multiple times, Ubersmith checks to ensure the name is unique. If not, Ubersmith appends a number to the name, such as Undeposited Funds 1, Undeposited Funds 2, etc.

The default payment and refund account in QuickBooks Online is the Undeposited Funds account. You can keep the QuickBooks Online Undeposited Funds account for both or you can create separate accounts. If you create a new payments account, you can still use the same refunds account by selecting the Use same account as payments option in the Refunds account field.

  1. Click the Accounts tab.
  2. In the Services account field, select either Automatically create new account to have Ubersmith create the Ubersmith Service Account to export your services to, or select a QuickBooks Online Sales of Product Income type account.
  3. In the Payments account field, select either Automatically create new account to have Ubersmith create the Ubersmith Payment Account to export your payments to, or select a QuickBooks Online Other Current Asset or Bank type account.
  4. In the Refunds account field, select either Use same account as payments to use the same payments account, Automatically create new account to have Ubersmith create the Ubersmith Refund Account to export your refunds to, or select a QuickBooks Online Other Current Asset or Bank type account.
  5. Click Cancel to disconnect from QuickBooks Online.
  6. Click Save. The Connection tab appears with your company name and login expiration time.
  7. Click End Session. A confirmation message appears.
  8. Click Yes to disconnect from QuickBooks Online and return to the Accounts tab with no set connection.

Exporting Data

When Ubersmith is connected to QuickBooks Online and the accounts are correctly setup, the Export tab becomes available. When exporting, Ubersmith first verifies if the information already exists. If the information does exist it is updated, otherwise it is created.

Your first export can take a long time to complete. After your initial export, ongoing updates are made every five minutes. While exporting, a lock is created to ensure only one export is running. If your export hangs, you can cancel or unlock the export in order to restart it.

  1. Click the Export tab.
  2. Click Start a complete export. A confirmation message appears.
  3. Click Yes. The Success: Data export will begin shortly message appears. While an export is executing, the Export tab will display information about it, such as when the export started and what data is currently being exported. When the export is finished, the Export tab will display the results of the last export. 

Troubleshooting Failures and Errors

When a failure occurs, it can be logged by the Plugin Logger, once it is enabled. See Managing the Plugin Logger for instructions on enabling and using it.

  • Error:/var/www/ubersmith_root/app/www/plugins/ubersmithplugin/quickbooks_online/vendor/quickbooks/v3-php-sdk/src/XSD2PHP/test/manifest.json not found
  •  Notice: No connection has been established with QuickBooks Online. Click "Connect" to connect.
  •  Should there be a problem and an export is stuck, a Remove lock link is available to remove the current lock so that the export can be restarted. ERROR for this?
  • CAPABILITIES/LIMITATIONS



On this page:


Related Topics 

Using Plugins




Document Stage
Audience
Author
Reviewer
Created Date
Updated Date
Version
Links
Graphics