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

Progress Invoices based on percentages rounding Discount items to nearest whole percent number

I've been working with a client to fix some issues on the invoicing/payment side of their QuickBooks Desktop Pro installation. We're using Estimates for a customer's quote, then generating Progress Invoices for payment amounts (e.g. first a $750 line-item retainer payment, a 50% payment due ~60 days prior to the final payment, and the final payment). Most of the time, the company's customers adhere to this 3-part payment system. However, some of this company's customers pay numerous times with non-rounded percentage payments (e.g. on a $12,985.26 estimate total, the customer pays $850, which is 6.55598% of the estimate total). We enter in the calculation to the furthest decimal place and create the invoice.

 

Unfortunately, every time we've created an invoice with one of these non-whole number percentage (from the Estimate, "Create invoice" > "Create invoice for a percentage of the entire estimate"), QuickBooks rounds only Discount items to the nearest whole number—in the above example, the discount item turns to 7.00%. The other percentages do apply evenly across any of our regular, non-discount items (with slight variations in the 100ths place due to rounding differences). We can usually fix this issue by manually overwriting the discount items, but it is time consuming and irksome when generating an invoice for every payment. Is there a setting that we don't have turned on affecting the rounding of only the Discount items, or some other issue at hand?

Solved
Best answer March 31, 2022

Best Answers
AlcaeusF
Moderator

Progress Invoices based on percentages rounding Discount items to nearest whole percent number

Hello @CalebE,

 

Thank you for posting here in the Community. I'm here to help you with your concern about progress invoicing in QuickBooks Desktop.

 

Currently, a specific setting to disable the rounding is unavailable. For now, the only workaround is to overwrite the discount items manually.

 

We continue to improve the features in QuickBooks, and this preference might be available in the future. As we assess this, I suggest sending feedback to our product engineers.

 

Here's how:

 

  1. Open QuickBooks Desktop.
  2. Click the Help tab at the top menu bar.
  3. Hover your cursor to Send Feedback Online, then select Product Suggestion. Feedback

 

Also, you can visit this link for more information about Discount, like how to discount for multiple items using the Subtotal item: Use discount and subtotal items on an Invoice.

 

Fill me in if you have additional questions or concerns about entering invoices or adding item discounts. The Community and I will be around to help. Take care.

View solution in original post

3 Comments 3
AlcaeusF
Moderator

Progress Invoices based on percentages rounding Discount items to nearest whole percent number

Hello @CalebE,

 

Thank you for posting here in the Community. I'm here to help you with your concern about progress invoicing in QuickBooks Desktop.

 

Currently, a specific setting to disable the rounding is unavailable. For now, the only workaround is to overwrite the discount items manually.

 

We continue to improve the features in QuickBooks, and this preference might be available in the future. As we assess this, I suggest sending feedback to our product engineers.

 

Here's how:

 

  1. Open QuickBooks Desktop.
  2. Click the Help tab at the top menu bar.
  3. Hover your cursor to Send Feedback Online, then select Product Suggestion. Feedback

 

Also, you can visit this link for more information about Discount, like how to discount for multiple items using the Subtotal item: Use discount and subtotal items on an Invoice.

 

Fill me in if you have additional questions or concerns about entering invoices or adding item discounts. The Community and I will be around to help. Take care.

CalebE
Level 1

Progress Invoices based on percentages rounding Discount items to nearest whole percent number

Ahh, that's very unfortunate, and behavior I wouldn't expect, since rounding those percents affect no other items on invoices. Is this also an issue/behavior in QuickBooks Online?

DivinaMercy_N
Moderator

Progress Invoices based on percentages rounding Discount items to nearest whole percent number

Hi there, @CalebE. Thanks for getting back here.

 

I'm here to provide further information about the feature you need. 

 

In QuickBooks Online (QBO), you can only change the number format of the amounts by adding a separator. I'll guide you on how:

 

  1. In your QBO account, go to the Gear icon and select Accounts and settings.
  2. Once opened, click the Advanced tab to see the Other preferences section.
  3. From there, click the pencil icon so you can edit the settings.
  4. Then, select the drop-down arrow beside the Number format field and choose how you'd like the numbers to show.
  5. When finished, click Save and then, Done. numberformat.PNG

 

Also, QuickBooks will only accept flat amounts as rates rather than a percentage. As a workaround, you can manually update and change the rate on the invoice. 

 

QBO has a ton of customer reports that you can run. This will further help you get a detailed view of customer transactions as well as their existing balance. To get started, simply go to the Reports menu and scroll down to the Who owes you section. From there, choose whichever report you need. 


I'm just a post away if you have any other concerns about managing your invoices. I'd be glad to assist you once more. Take care always. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us