Troubleshooting QuickBooks Online

Having issues with your QuickBooks Online integration? Below are some common errors explained.

This article will cover the following topics:

 


 

Contacts Push Limitation

The QuickBooks Online system has a known limitation that does not allow 2 individual contacts with the same name to be pushed through to QuickBooks.

Consider the following scenario:

In QuickBooks there exists a contact with name 'John Doe', with the email johndoe@bigcommerce.com

When integrating with another system, we get another 'John Doe' contact, however with a different email address and contact details (johndoe2@bigcommerce.com)

Because of this we will treat both John Doe records as separate contacts. However if we try to push the new John Doe into QuickBooks, the QuickBooks API rejects this on the basis that the name is a duplicate.

When this happens, we'll automatically append the second contact with a '-1' (John Doe-1) to send it through to QuickBooks Online.

Back To Top

 


 

Invoice Rounding Error

 

There is currently a known limitation with the QuickBooks Online system, where we sometimes run into calculation errors when dealing with tax codes.

Consider the following example:

Bigcommerce push's the following data through your QuickBooks Online integration:

1. Unit price for the item is $14.90 with 10% GST already applied

2. When we push this to QuickBooks Online, we are asked for an excluding tax total

3. we calculate this by $14.90 divided by the GST amount

4. This comes to $13.545454...

 

However we cannot give that sort of tax total over to QuickBooks Online, so we have to narrow this down to 2 decimal places:

1. As a result the ex-tax total is rounded to $13.55

2. we try to assign 10% GST on top of the excluding tax total

3. $13.55 plus 10% GST is $14.905

4. Then we need to apply rounding again to get $14.91

As you can see, there is a $0.01 discrepancy in the total. For now, we have reached out to QuickBooks Online about this, and hope to find a solution!

Back To Top

 


 

Inventory Starting Date Error

Error Could not push Invoice [INVOICE NUMBER]: Transaction date is prior to start date for inventory item
Transactions with inventory (QOH) products cant be dated earlier than the Inventory Start Date for the product

These errors are being reported by the QBO system directly and is not something we can control.

It looks like the items you have created in QBO have an Inventory start date that is dated later than the invoices we are trying to push through.

For example, if invoice ABC123 is dated 3rd June 2014. You need to make sure that all items in the invoice have a starting earlier than 3rd June 2014.

You may need to delete the item in QBO and then re-create them. If you do that, please contact Support so we can try to adjust your integration for this.

The same scenario can also happen in reverse, where we're unable to push an item if invoices containing the item already exist in QBO with an invoice date after the inventory start date of the item. This is fixed by changing the items start date to after the date of any invoices containing the item.

Back To Top

 


 

Country Limitations

You will only be able to connect your QuickBooks Online to our integration if you're using the US, Canadian, UK, or Australian version of QuickBooks. If you're not using the above versions, you'll receive an error with the below message:

"This app is not set up to allow connections from your country"

Back To Top

 


 

Currency Limitation

Currently there is a limitation where one customer cannot order in multiple currencies - please consider the following scenario:

  1. Customer makes a sale in AUD
  2. We add the customer to QBO with AUD as their default currency
  3. Customer makes another sale in USD
  4. We hit an error as this is not the customers default currency

We're currently working on a way to handle this better, however for now please be aware the above scenario can occur if a customer orders twice in different currencies. You will have to process any invoice that hits this limitation manually.

Back To Top

 


 

SKU Field Limitation

Although Quickbooks Online has added an SKU attribute to their products / items, OneSaas is not currently using this field to match products across connected apps.


The reason for this is that this field is not mandatory, nor unique and it doesn't have the properties of an SKU field. Main point being that the Quickbooks Online system currently allows multiple items to have the same SKU.


The Name field instead has all the properties of an SKU type field, meaning they are unique and our system is using this field to match.
Hence, items are matched by their source system SKU / Product Code to Quickbooks Online Product Name.

 

Back To Top

 


 

24 Comments

  • Avatar
    Jeremy Jones

    Hoping to see the invoice rounding error problem solved soon! Surely this should be simple to solve for an accounting application. It does create a big nuisance. Any way I can help up the urgency?

  • Avatar
    Mars Tertop

    The same scenario can also happen in reverse, where we're unable to push an item if invoices containing the item already exist

    Edited by Mars Tertop
  • Avatar
    Elena James

    Thanks for sahreing the info. If you can't sign in to QuickBooks Online and you see one of these messages, don't worry. We have solutions that can help you fix them.

    1. WebPage cannot be found
    2. Error 404: File Not Found
    3. QBO is currently unavailable, please try again later
    You may also read: Troubleshooting Ways to Fix QuickBooks Error Code 15102

  • Avatar
    Shagufta shamid

    Thanks for sahreing the info. If you can't sign in to QuickBooks Online and you see one of these messages, don't worry. We have solutions that can help you fix orthokeratology doctors Glendale them.

  • Avatar
    khalisthings coffee

    The QuickBooks Online system has a known limitation that does not allow 2 individual contacts with the same name to be pushed through to QuickBooks Alight motion mod apk.

    Edited by khalisthings coffee
  • Avatar
    Zulaikha Zaniya

    Yuzu prod key is a crucial element for unlocking advanced features in the Yuzu Nintendo Switch Full download emulator. It acts as a license key, enabling users to access additional functionalities and improve overall emulation performance. Users must obtain a valid prod key to enhance their gaming experience on the Yuzu emulator.

  • Avatar
    Saterfieldson Tinkle

    Thanks for sharing this information! I've been encountering some issues with QuickBooks Online, so your troubleshooting guide is timely fitness passion. Looking forward to resolving these errors with your insights.

  • Avatar
    Colby cann

    Great tip on overcoming Troubleshooting QuickBooks Online push limitation. The automatic appending of '-1' for duplicate names is a clever workaround. Thanks for sharing is it cool insight.

  • Avatar
    ErmiasJoey

    The same scenario can also happen in reverse, where we're unable to push kfc price list item if invoices containing the find out more already exist.

    Edited by ErmiasJoey
  • Avatar
    Amir Qureshi

    I appreciate you giving this information. I've been having some problems with QuickBooks Online, so your guide on troubleshooting is quite helpful, fitness enthusiast. I'm eager to use your insights to solve these mistakes. https://thealightmotion.online/

  • Avatar
    Harshbargerson Hammer

    The QuickBooks Online system has a known limitation that does not allow 2 individual contacts with the same name to be pushed through to QuickBooks IESCO.

  • Avatar
    Alex Wood

    Inversely, it is also possible for us to be unable to xnx honeywell item in the event that invoices including the find out more already exist.

  • Avatar
    Harshbargerson Hammer

    With Gyb, the identical situation might also occur in reverse, meaning that if invoices including the item already exist, we won't be able to push it.

  • Avatar
    Alvet Ublix

    When it comes to strands, the same scenario might potentially happen in reverse, which means we won't be able to push it if invoices for the item already exist.

  • Avatar
    Alvim Utmex

    The same thing may also happen with Strands Nyt Unlimited in reverse, which means we won't be able to push it if invoices for the item already exist.

  • Avatar
    Emilio Hidalgo

    Thanks for this troubleshooting guide! QuickBooks Online integration can be tricky sometimes, so having a resource like this is super helpful. I've encountered a few issues in the past, and your article has provided some great insights on how to address them. Keep up the good work! Here is Jollibee Menu Price List if you craving for something yummy.

  • Avatar
    Alcantarsson Profit

    In the same way, having a being vat registered is killing my business, meaning we won't be able to push it if there are existing bills for the item.

  • Avatar
    Atvili Unven

    compare phone insurance may experience the similar issue in reverse, meaning that if invoices for the item already exist, we won't be able to push it.

  • Avatar
    Atvili Unven

    When it comes to https://fiverrpromotion.net/, the same scenario might potentially happen in reverse, which means we won't be able to push it if invoices for the item already exist.

  • Avatar
    Hassan Raza

    I hope the issue with the invoice storysaver rounding error gets resolved soon! It seems like it should be a straightforward fix for an accounting application. This problem is causing quite a hassle. Is there anything I can do to help speed up the process?

  • Avatar
    8 ball Poll

    QuickBooks Online's Contacts Push Limitation prevents the integration of contacts with identical names but different details, appending a '-1' to resolve duplicates.
    An Invoice Rounding Error occurs in QuickBooks Online due to tax calculation discrepancies, leading to rounding issues in the total amount pushed from systems like Bigcommerce more about CANDIVORE read

    .

  • Avatar
    Kafleen Qalmar

    In a similar case, the opposite can happen, making it more difficult to push an item if bills for it already exist. Check out Emergeny roof repair for more in-depth analysis and answers about inventory management issues.

  • Avatar
    Ralex Yalvem

    The same thing may also happen with realtor in pensacola Real Estate in reverse, which means we won't be able to push it if invoices for the item already exist.

  • Avatar
    hamza saqib

    Thank you for providing this detailed troubleshooting guide for QuickBooks Online. It’s been very helpful in understanding and fixing common integration problems. The explanations about contact push limitations, invoice rounding errors, and inventory start date errors are really clear. I also appreciate the easy explanation of country limitations. If you want to see the yummy food, you can read it here.

    Edited by hamza saqib
Please sign in to leave a comment.