Latest updates from the Dubsado team
Update

Quickbooks Updates

Becca avatar
Shared by Becca • October 14, 2022

Originally posted: July 16th, 2020

Today we are releasing some awesome improvements to our Quickbooks Integration! With these upgrades, sending over invoices to your Quickbooks account becomes both easier and more reliable!

What's new:

QuickBooks Online Locale

Getting started with connecting your Quickbooks account to Dubsado is largely the same. One key difference is that we have removed the toggle for Quickbooks Online Locale, or the setting for you to choose whether you are using a U.S. or Non-U.S. version of Quickbooks. This setting affected how taxes would need to be applied in Dubsado in order for an invoice to sync over. Our system will now automatically detect that same information right when you connect your Quickbooks account!

QuickBooks Online Tax Codes

If you add tax to your line items in Dubsado, the invoice must have a QuickBooks tax code to sync with QuickBooks. This step is still necessary

<a href=https://dubsado.intercom-attachments-1.com/i/o/201618695/f9b995e6284e0f094eec14f0/Screen_Shot_2020-04-15_at_3.44.44_PM.png"/>
<a href=https://dubsado.intercom-attachments-1.com/i/o/201618700/65fa2de5a68b86d9f2effe29/Screen_Shot_2020-04-15_at_3.45.42_PM.png"/>

When you connect these taxes to Dubsado, new Dubsado tax items will be created to correspond with each of the Quickbooks taxes brought in. In some cases, multiple Dubsado tax items will be created to account for different agencies that make up a single tax.

For example, the Quickbooks Tax for Burbank, CA creates 4 different Dubsado Tax items: CA State Tax, Los Angeles County Tax, Los Angeles County District Tax, and Burbank City District Tax. Collectively, these add to the 10.25% tax rate in Burbank.

Applying QuickBooks Tax Codes to Invoices

In order for an invoice from Dubsado to sync to Quickbooks, any tax on that invoice will need to be a Dubsado Tax item created when Quickbooks was connected. When making an invoice, you can still apply a Quickbooks tax to your invoice the same you are currently! This method has you click on the "QuickBooks Tax Codes" button dropdown underneath the line items on your invoice and selecting which tax code you wish to apply.

In addition to this method, you can now apply the taxes directly on to your line items! When editing a line item, you can select which taxes you wish to apply directly in the tax section. The taxes created when you synced your Quickbooks account will appear on this list and are able to be applied to your line item!

This change my seem small but it has some big implications! Since the taxes can be applied directly onto the line items, you can now have the QuickBooks tax applied to Packages and any other template! This is especially useful for invoices that are created by proposals, schedulers, or recurring invoices and can ensure that these invoices are synced to Quickbooks right away!

Invoice List page

We also made some pretty big changes to the Invoices page to help manage your all of your invoices as a whole! The first addition to this page is the new Date filter that will allow you to find all of the invoices whose invoice date falls within the entered date range.

The Invoice list gives information the specific parts of each invoice such as invoice date, payments made, and due dates of upcoming or missed payments, but will include information on the QB sync status more clearly.

This page will also show the sync status of each invoice within the brand if Quickbooks is connected. There are 4 different statuses for each invoice:

  • Synced - Information has been successfully sent from Dubsado to Quickbooks. This status will show if an invoice was manually synced even if the payments are not sent over.
  • Not Synced - No information has been sent to Quickbooks.
  • Pending - Information from this invoice is in queue to be sent over to Quickbooks. Once the information has been sent over, this status will update to "Synced". If there is an issue that prevents the sync, this status will update to "Error"
  • Error - An attempt to sync over information was made but was not successful. Invoices that have this error state will have the option for users to attempt to retry to sync that invoice.

This page can be used to sync over invoices manually! If you have Quickbooks connected, you will see the "Sync Invoice" option and the "Sync Invoice and Payments" option in the action dropdown to the right of the Sync status.

New to this page is the option to sync information over to Quickbooks in bulk! You can use the checkboxes to the left of each invoice to select a group of invoices you wish to sync over. Once selected, the dropdown option in the header of this column will give you the option to sync over all of the selected invoices! There are options to just have the invoices brought over and to have the invoices brought over with any payments attached.

Clients in Dubsado and Quickbooks

We will attempt to match Dubsado clients to Quickbooks clients when an invoice is synced over. If a new client in Dubsado makes a payment, we will now search that user's connected Quickbooks account to see if there is a QB client with the same email address. If there is a match we will sync the invoice to that client. If there are multiple Qb clients with the same email address, we will create a new client rather than choosing one or the other. In this scenario the user can manually make the newly created client a "sub-customer" of the correct QB client in your account

Disconnect. Quickbooks and Reconnect Quickbooks options

Previously, if there was an Quickbooks account in Dubsado, one of the suggested steps we would tell users would be to disconnect and reconnect their account. We found that doing so often fixed the issue but would sometimes create more issues in a user's account since we were not resetting the QB data within Dubsado.

In place of this, we added a Reconnect button to reset the connection between your Dubsado and Quickbooks accounts that will not remove any of the data. This Reconnect button will appear on the Quickbooks Integrations page when there is an error syncing an invoice to Quickbooks. If you encounter an error but do not see the reconnect option, please reach out to support and we will gladly help!

Note: If you do disconnect your Quickbooks account from Dubsado, any QB data in theDubsado will be completely removed. We only recommend this option if you are switching over to a new Quickbooks account. If you do so, you will need to go through the entire sync process over again for each invoice.