cancel
Showing results for 
Search instead for 
Did you mean: 
zhengzhi8
Level 1

Can we adjust the decimal in the Invoices?

 
10 Comments 10
MaryGraceS
Moderator

Can we adjust the decimal in the Invoices?

Greetings, @zhengzhi8.

 

Welcome to the QuickBooks Community family. I'd be happy to help you adjust the decimal in the invoices in QuickBooks Online. 

 

Let's change the number format in your account settings.

 

Here's how:

  1. At the top right, click the Gear icon.
  2. Select Account and Settings.
  3. On the left pane, select Advanced.
  4. Click anywhere inside Other preferences.
  5. Select your preferred Number format on the drop-down.
  6. Click Save.
  7. Hit Done.

That also changes the dollar amount's format in other transactions and reports. 

 

I've attached a screenshot for your reference. 

 

That should do it. Feel free to leave a comment below if you have any other questions about adjusting the decimal in the invoices. I'll be happy to help you further.

 

kalghanim
Level 1

Can we adjust the decimal in the Invoices?

Hello,

 

I'm not using USD as home currency, and I need to change the current format to 3 digit decimal.

I couldn't find this option, is there any other way ?

SophiaAnnL
Moderator

Can we adjust the decimal in the Invoices?

The number format option is available in all QBO versions, kalghanim.

 

You'll see this option even if the home currency is not USD. However, if your access to the company file is limited or view-only, you won't be able to change the number format. 

 

Please know that QuickBooks Online does not have an option to change the decimal format to three digits. When you edit the number format, the changes will only take effect on how the numbers are displayed on the reports.

 

If you have additional questions, just let me know. 

savio
Level 1

Can we adjust the decimal in the Invoices?

Hello Admin

 

Im too having the same issue with 3 decimal places....

Your screen shot shows also 2 decimal places....there is no 3 decimal places to selelct from the dropdown

Pls assist

Thanks

Savio

 

Kristine Mae
Moderator

Can we adjust the decimal in the Invoices?

Let me take out your confusion, Savio.

 

You can adjust the decimal in invoices. However, three digits format is unavailable. 

 

I'll include this video to help you with customizing your invoice: How to Customize Invoices and Sales Forms.

 

If you have additional questions, don't hesitate to let me know. We'll be right here to help you. Take care!

SumitV
Level 1

Can we adjust the decimal in the Invoices?

Greetings,

 

We are facing an unusual issue. We are in the printing business and just adopted QBO. When we input the value of the order, the quantity comes up with decimals running into 7 to 8 places. Ideally speaking if I am sending a fractional order out of the total order (eg if we are sending a quarter of the total order), it should tell me x.25, but what we are seeing is x.2500678. In the case of our format, we have chosen the format xxx,xxx.00

 

The issue comes up when we are printing Quotes, POs and Invoices for sending them to our customers.

 

Just need to understand what we are doing wrong.

 

BR

Ethel_A
QuickBooks Team

Can we adjust the decimal in the Invoices?

Welcome to the Community, @SumitV.

 

As much as I would like to help you manage your invoices, I would appreciate it if you provide me with more information. You can attach a screenshot of how you set up the item. Does it have multiple digits? Or just 0.25?

 

Feel free to click the Reply button below to add more information. I'm always here to help. Have a great day. 

cbaize
Level 1

Can we adjust the decimal in the Invoices?

I believe this is the issue the previous member is having, and I am as well. QBO will only allow us to enter invoice information as a dollar amount or a percentage, then it calculates the quantity. Choosing the number format in the gear icon's settings only updates how the dollars show on an invoice. It does not help me format the quantity column to a specific format or number of decimals.

 

I would prefer to enter the quantity and have QBO calculate the dollar amount. I am including screen shots from our timekeeping system and from the invoice screen for your reference.

markr6880
Level 1

Can we adjust the decimal in the Invoices?

I am having this problem as well. After entering the partial invoice dollar amount QBO calculates the quantity to eight decimal places. It is not necessary and it looks bad. What's the fix???

SimoneatNBBM
Level 1

Can we adjust the decimal in the Invoices?

NOPE!!!!

Need to get in touch?

Contact us