Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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.
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:
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.
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?
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here