Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
dvonderburg
February 4, 2020
Question

Sales price is not showing zeros past decimal if 00

  • February 4, 2020
  • 5 replies
  • 65 views

A lot of our sales prices are zero cents. But if we run item report with the "Sales Price" field it always show the whole rounded number. How do I get it to stick. For example we have one item that is $65.00 but if I enter in 65.00 and save, it reverts to the whole number 65 with no .00 on the end. Then in the reports it shows the number as 65 and not 65.00.

 

 

5 replies

Catherine_B
Level 9
February 4, 2020

We can set your preference to show the cents of your price, dvonderburg. 

 

It's possible that the report settings is set not to show the decimals. We can set it up to show the decimals of your amounts and prices. Let me show you how: 

  1. Go to the Edit menu and click Preferences. 
  2. From the left menu, select Reports & Graphs. 
  3. Click Company Preferences and hit the Format button. 
  4. From the the Fonts & Numbers tab, uncheck the Without Cents box under the Show All Number section.
  5. Click OK and then OK again.

I'll be around if you need anything else!

 

    dvonderburgAuthor
    February 4, 2020

    That is the way I have it set but in our reports it still shows nothing past a decimal. 

    KhimG
    Level 7
    February 4, 2020

    Thanks for getting back to us and providing an update of what's showing on your end, @dvonderburg.

     

    With the same preference, my Item Price List report shows a decimal value. Since the option isn't working like the way it should, I recommend checking if the issue is with the company data or QuickBooks itself. 

     

    You can start by opening a sample company file. Here's how:

    1. Open QuickBooks Desktop.
    2. From the No Company Open window, select Open a sample file.
    3. Select any sample file on the list, then click Open.

    Right after, create a sample item with a decimal amount. Test the solution by running the same report. 

     

    If it works, the company file may be damaged. Let's open it and run the Verify and Rebuild Data Utility Tool to fix the problem. 

    1. Go to the File menu.
    2. Select Utilities, then Rebuild Data.
    3. Click OK on the QuickBooks Information window. 
    4. Follow the prompt to save a backup.
    5. Hit OK when you see Rebuild has completed.

    Once done, follow the steps above except select verify instead of rebuild. Check out this article for more information: Fix data damage on your company file.

     

    However, if the problem persists on the sample file, I suggest repairing the software. Doing so can fix any program-related issues or errors.

     

    Prepare the Desktop installation CD or Download the installer from the website if it's purchased through the phone or online. Once done, perform these steps:

    1. Restart the computer.
    2. Back up your QuickBooks company file.
    3. Go to Start and then Control Panel.
    4. Select Programs and Features. 
    5. In the list of programs, select QuickBooks.
    6. Choose Uninstall/Change, then click Continue and Next.
    7. Click Repair and then Next. Wait for it to complete.
    8. Once done, hit Finish.

    Here’s an article for your reference: Fix QuickBooks Desktop (Windows).

     

    I want to make sure this gets taken care of. Please leave a comment if you need further assistance. I'm here to help. Take care!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement