cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Need help updating to Desktop 2022? Visit our updates page to get started.
delerium
Level 2

Inconsistent rounding of amounts

QB is not rounding amounts consistently. If I have two different items with the same quantity and rate, the amount is not the same and off by $0.01 (as per screenshot).

Example: quantity of 3.25 at a rate for $25.50 equals $82.875, which should be rounding up to $82.88. When the first item is entered, the amount is right, but when the second item is entered, it changes the first items to $82.87 and the second item as $82.88.

I really cannot have items that have an identical rate and quantity show different amounts - it does not make any sense. I should note these are taxable items; if I enter them as non-tax items, the rounding works correctly. I've called twice into support, who didn't have an answer and wanted to call back (both times, and both times they didn't call back).

I'm using the 2019 Desktop version (Pro), fully updated, uninstalled and reinstalled (clean install), but QB seems unable to handle this very basic function.

20 Comments 20
LauraAB
QuickBooks Team

Inconsistent rounding of amounts

Hi delerium,

 

I appreciate the detailed response. I can see how having items of the same value and quantity appearing to have different totals is confusing. With what you've described and the screenshot, I was able to replicate exactly what you're seeing, and, in doing so, can offer some insight as to what's happening.

 

In this case, the reason for the change has to do with the penny-rounding you were describing. As you've noted, the program calculates as follows.

 

3.25 x 25.50 = 82.875 — rounded to 82.88

 

Putting two of those amounts back-to-back, the program is essentially allocating the extra 0.005 from the first amount to the second amount so that it's no longer rounding, but actually equaling out to that amount for the second line. If you were to enter these figures on four lines, you'd see the first two switch to the 82.87 while the bottom two retain the 82.88.

 

Great job with the troubleshooting steps you've taken to this point. Since I'm seeing this behaviour as well, it's safe to say it's not just your product. I'm letting my team know about this, and you can do so as well by leaving feedback using the Send Feedback Online option through the Help menu. Explain the situation as you have here and send it off. The teams receives and reviews these comments.

 

While you could manually change the amount so they match, this would then affect the Rate column, which would also cause questions for your customers. Because of that, I invite other members of the community to share any workarounds they have found for this situation.

 

Thanks for bringing this to my attention. In addition to the rounding issue, I'll also be touching base with my team to make sure we're returning calls when promised. Let me know if you have more questions.

delerium
Level 2

Inconsistent rounding of amounts

Thanks Laura, glad I'm not the only one seeing it.

 

I've done as suggested and sent it as a bug report through QB feedback.

 

I can get around it if I don't show the rate column on the printed or PDFed version of the invoice. That works for me because the rate is the same for all line items. A bit cumbersome to adjust the items rounding incorrectly, but I can live with it for now. It's something Intuit needs to fix though, because that is not proper accounting procedure in how they do their rounding.

welderseries
Level 1

Inconsistent rounding of amounts

We use SOS Inventory for our inventory management and it exports to QBO.  An invoice for $609.31 in SOS exported to QBO as $609.33.  SOS says it is a bug in how QBO rounds each item on an invoice.  So I have to go in an make an adjustment for 1 or 2 cents.  Has there been a fix for this problem?

 

delerium
Level 2

Inconsistent rounding of amounts

No, unfortunately not and in the end I had to change my pricing just to avoid this glaring error. It is inconceivable that accounting software is unable to handle something as basic as rounding. I guess when you have the market cornered you can do whatever you feel like.

PatriciaT
QuickBooks Team

Inconsistent rounding of amounts

Hi welderseries, I see you've mentioned using QuickBooks Online, and I'm glad you're taking advantage of the Apps feature to connect any third-party app you use with the program. I know how important it's to have your entries migrated accurately in the system. When it comes to third-party apps, it's important to note that the integration with QuickBooks Online and how your data migrate depends on the Apps developer's design and configuration. After you find an app you're interested in in the Apps menu and select it to initiate a sync, the Overview tab displays the steps needed to properly connect the app to QuickBooks. These steps are also established by the App developer, whose information is on your right. If you encounter any difficulty or concerns during the process, or to ensure that your transactions are uploaded correctly in QuickBooks, feel free to get in touch with the dedicated support team via the Support section in the Overview tab. 

 

I hope this helps! You're always welcome to stop by if you need anything else.

mife
Level 1

Inconsistent rounding of amounts

We are having the same problem and we have Service Fusion send to QBO.

Tax is calculated correctly in Service Fusion and then sends the amount to QBO.

However, QBO in some cases adds 0.01 to the total throwing off our accounting.

I did a manual calculation.  Service Fusion is correct, QBO is incorrect.

When tax on an amount is calculated as .0919, it should not be rounded up, it should remain as .09.

 

QBO needs to address this, not the 3rd party app.

delerium
Level 2

Inconsistent rounding of amounts

Good luck with getting them to fix it. It is a complete joke that QB cannot handle the most basic of rounding principals.

LauraAB
QuickBooks Team

Inconsistent rounding of amounts

Hello,

 

I appreciate you both sharing your concerns about how QuickBooks, including QuickBooks Online, handles rounding on transactions. I'd like to offer some clarity and direction here to help with getting a sense of how QuickBooks works with the amounts entered into the program.

 

As I noted in my original response regarding QuickBooks Desktop's rounding, QBO also handles rounding the same way. The program is designed to do line-by-line rounding, which can sometimes amount to differences depending on how other programs round or how you round using other methods. When it comes to apps or other services that are integrated with QBO, touching base with the app or integration developer is an important first step since those teams are the ones that designed how the information is transferred to and entered in QBO. There may be something on their end that they can look at to help avoid these kinds of issues.

 

From a QuickBooks perspective, I want to assure you both that our developers implement these features to keep in line with government guidelines, but I can definitely see how this would impact your books. The following article talks about penny rounding in relation to QuickBooks Online Payroll, but it can also apply to other transactions in the software: Why do I occasionally notice penny rounding differences?

 

As mentioned previously, the option to share your thoughts about this as feedback for QuickBooks Desktop can be done by going to the Help menu and choosing Send Feedback Online For QBO, we also want to hear your feedback, which you can share by using the steps outlined in the article How do I submit feedback?

 

I hope you enjoy the rest of the day.

delerium
Level 2

Inconsistent rounding of amounts

Hi Laura,

I fail to see how Intuit can justify that something like this is okay. This is not proper accounting. This isn't feedback material, it's a bug in your software, plain and simple.

cap1.png

LauraAB
QuickBooks Team

Inconsistent rounding of amounts

I hear you regarding your perspective on this. For QuickBooks Desktop, you're welcome to use the Bug Report option through the Send Feedback Online menu to let us know your thoughts on this and how it's impacting your books. If you'd prefer, you can also discuss this with our team by reaching out using one of the options mentioned in the Intuit QuickBooks Desktop software support policies article.

Eriatilos
Level 1

Inconsistent rounding of amounts

Here we are six months later and this hasn't been addressed.

 

This is affecting my gst calculations for the end of the year.

delerium
Level 2

Inconsistent rounding of amounts

Six months later? Try two years later, since I started this thread in June 2019, and also reported it as a bug at the same time. Two years later, Intuit has done nothing. I do not need to contact support, Intuit need to fix their sloppy product and do basic math. What is so difficult to understand about this issue?

I have since switched to QBO, where the problem does not occur, so it is obvious that Intuit does not care about the Desktop product.

Anyone from Intuit: do not tell me to contact support. You know about the problem, and in fact you were able to duplicate it yourself, so just do what needs to be done to fix QuickBooks.

Eriatilos
Level 1

Inconsistent rounding of amounts

Im using QBO as well and its still happening to me.

 

I've wroked around it, but its not proper accounting procedure.

 

Not much i can do other than complain i guess.

LauraAB
QuickBooks Team

Inconsistent rounding of amounts

Hello to you both,

 

I know this is a long-standing thread, and I appreciate the concerns about how QuickBooks products handle rounding on your sales forms and the differences this can make in your books. QuickBooks Desktop and QuickBooks Online are both designed similarly when it comes to handling rounding, and I'm with you on how these rounding situations can cause discrepancies.

 

Submitting feedback for either product is the best course of action here so that our product team can really get a sense of the impact and consider making changes. I see I've shared the steps for submitting feedback in QuickBooks Desktop a few times, but I also wanted to make sure that the steps for submitting feedback in QuickBooks Online are also available for folks. You can see those here: How do I submit feedback? For QuickBooks Online as well, we have a page, updated quarterly, that highlights the new features for you. Feel free to bookmark it here: QuickBooks Online Feature and Product Updates

 

Similarly to QuickBooks Desktop, if you do come across a situation where you want to change how the program is handling the rounding, it's possible to edit the amount calculated in any of the given fields. It's good to hear you've worked around the rounding issues, @Eriatilos, and maybe what I've just mentioned is a part of the process you've taken. If you'd like to go into more detail about it, feel free to reply to this thread with the steps you've taken and some screenshots.

 

@delerium, I'm glad to hear that you're not seeing the same rounding behaviour when you're using QuickBooks Online. All the same, I recommend keeping an eye out for it since, as I noted, QuickBooks Online and QuickBooks Desktop are programmed to handle rounding the same in this regard. It doesn't hurt to keep an eye on things.

 

Wishing you both the best moving forward.

 

[Edited]

delerium
Level 2

Inconsistent rounding of amounts

Hi Laura,

My issue was never with sales tax, it was with the rate multiplied by the quantity giving different results for the same calculation. There is a screenshot earlier in the conversation: 1.25 x 25.50 is ALWAYS going to be 31.875, which should ALWAYS be rounding to 31.88.

This is simple math and simple rounding, I can't be any clearer about this. The fact that QBO does it correctly and Desktop does not shows an obvious bug, something support has known about for two years, but Intuit in unwilling to fix.

LauraAB
QuickBooks Team

Inconsistent rounding of amounts

Thanks for highlighting that, delerium. I do remember our prior conversation. I misspoke when I mentioned sales tax in the response I've given today, and I've edited my last response to reflect that. I do see what you're saying about how QBO is handling it the way you're expecting versus QuickBooks Desktop, which is good, and I encourage you to continue to use this version of the program if it suits your needs better.

Rene9
Level 1

Inconsistent rounding of amounts

Hi,

 

Same problem here. On my Invoice, I have 2 items with 3 decimal price and they don't round the same way (See screenshot). My team needs to spend HOURS every month adjusting the situation because our invoices are send from our PSA software and then imported to QB Desktop (we are often of balance by 0,01$). Last month we had to ajust 127 invoices. I need help resolving this issue. The problem is not our PSA. 

 

Thank you,

raphjutras
Level 2

Inconsistent rounding of amounts

I'm experiencing the exact same problem..

Henock K
QuickBooks Team

Inconsistent rounding of amounts

Hi raphjutras,


Thanks for joining this thread. It's essential to be able to record the exact amount of transactions with decimals to ensure the balance of your books. I'll be glad to provide with some information on the rounding option.
 

In quickBooks Desktop, the correct setup is to configure the items with 3 decimal price under the items list. Doing this will allow the system to round the 3 decimal price amount once it's been selected in the transaction. To access the Items list, you can refer to the following steps below.
 

1. Click on the List tab at the top left of your screen.
2. Select Items list.
3. Choose the item concerned, enter the 3 decimal price.
4. Click on OK.
 

If you're still experiencing the same issue, I recommend that you contact our customer support team as they can have a closer look at how to resolve this.


Let me know if you have any questions, I'll be happy to help.

userid12
Level 1

Inconsistent rounding of amounts

Same issue importing sale numbers from Lightspeed Accounting to QBO. Every quarter I have to adjust hundreds of items in QBO as I report from multiple locations (amounts are correctly reported by Lightspeed Accounting and then they are "rounded up" by QBO. Really annoying.

Need to get in touch?

Contact us