Skip to main content
H
HelloRose
July 22, 2024
Question

Decimal Calculation ERROR

  • July 22, 2024
  • 2 replies
  • 0 views

Quickbook is calculating my rates wrong all of a sudden. I didn't have this issue before. 

 

Quickbook is telling me $10.30 * 0.60 = $6.19 (supposed to be $6.18). I tried it with $10.28 * 0.60 = $6.174, but QB rounded to $06.18. I also tired it with $10.30 * 0.70 = $7.22 (supposed to be $7.21). 


Anyone encounter this issue before?  And how do I fix it?

2 replies

S
Sherrie_F
July 22, 2024

I appreciate the detailed information you've provided about your experience with the decimal calculation, @HelloRose.

 

Firstly, I'd like to ask what transaction you are trying to pull up. Any additional information would be greatly appreciated.

 

Let's open a sample company file in your account when making the transaction. This way, you can determine if there are any errors with the decimal calculation.

 

However, if there are no errors with the decimal calculations, we can verify and rebuild your data. This process resolves errors and other issues in the software.

 

Furthermore, here's an article you can browse just in case you need a guide on backing up your accounting data in QuickBooks Desktop: Back up your QuickBooks Desktop company file.

 

You can always count on me if you need a hand managing your calculations in QuickBooks Desktop. I'd be happy to assist you at any given time.

H
HelloRoseAuthor
July 22, 2024

I just tired it, it doesn't fix the calculation error. 

    K
    KimberlyS
    July 22, 2024

    We can troubleshoot your data to resolve issues with your rate decimal calculation, HelloRose. I'm here to provide a detailed process to help keep your amounts accurate.

     

    Damaged data can cause issues when utilizing QuickBooks Desktop (QBDT), including the error you received with the decimal calculation. To get this resolved, ensure to update QBDT to the latest release.

     

    After that, let's run the Verify and Rebuild tool. Verifying your data allows us to identify discrepancies within your company file that need further troubleshooting.

     

    Here's how to verify your company file:

     

    1. Proceed to the Window tab, then select Close All.
    2. Click on File and select Utilities.
    3. Choose Verify Data, then OK.

     

    Then, follow these steps to rebuild your company data:

     

    1. Head to the File menu, then Utilities.
    2. Select OK once asked to create a backup of your company file.
    3. Choose where you want to save your backup and click OK.
    4. Once you get the message Rebuild has completed, select OK.

     

    You may also refer to this article for the detailed process: Verify and Rebuild Data in QuickBooks Desktop.

     

    If the issue persists, I recommend contacting our customer support team. With their tools and expertise, they can dig deeper into this issue and provide the most relevant resolution or workaround to get you back to business.

     

    On the other hand, you might want to scan these materials to help keep track of your customer and vendor transactions:

     

     

    I'll get back to you immediately if you require additional assistance fixing the calculation error of your rates in QuickBooks Desktop. I can always provide the help you need in any way.

    BigRedConsulting
    BigRedConsulting
    July 23, 2024

    I've not seen it before.

    What type of transaction are you seeing this on?  What type of item are you using where it happens?

     

     

    H
    HelloRoseAuthor
    July 23, 2024

    This is when I'm doing sales order and invoices. When I do sales order, I type in customer name, so QB auto populate the discount rate. Then the discount rate is multiple by the item pricing. The discount multiply by the item pricing is NOT coming our correctly. There shouldn't even be a rounding issue.

    BigRedConsulting
    BigRedConsulting
    July 23, 2024

    RE: When I do sales order, I type in customer name, so QB auto populate the discount rate.

     

    I don't see a discount rate, but QB does calculate that right rate based on the price level set on the customer record. Is that what you mean?

     

    RE: Then the discount rate is multiple by the item pricing.

     

    I don't know what you mean by that.

     

    RE: Quickbook is telling me $10.30 * 0.60 = $6.19 (supposed to be $6.18). I tried it with $10.28 * 0.60 = $6.174, but QB rounded to $06.18.

     

    Questions:

    - What is the regular price for the item?

    - What are the price level settings for the level you're using?  Is any rounding applied?

     

     

     

     

     

     

    Terms & ConditionsAccessibility statement