Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
LawsonDambrosio
Level 1

Price list stopped rounding

We set up price rules a couple months back and it's been great - drastically simplified and streamlined our invoicing now that we're not having to update pricing for different accounts. This worked more or less without issue until today, when I was entering invoices for orders that came in over the weekend only to find that the rounding for the price rules was no longer working, resulting in pricing in the 1000ths decimal ($0.00#), which is not at all what we want.

 

Attached is one such example. A product that has a standard list price of $10.25 has a price rule for some of our larger accounts to discount by 3%, rounded to the nearest $0.05, which brings the price to $9.95 and, up until this morning, this price rule worked without issue. Now the pricing on invoices is skipping the rounding and is now listed at $9.943, which has necessitated manually updating the pricing on all our invoices now.

 

Any insight would be greatly appreciated, as this is seriously slowing down our invoicing process and making for lots of error correcting work with the accounts these invoices went out to prior to the issue being caught.

1 Comment 1
JamaicaA
QuickBooks Team

Price list stopped rounding

Maintaining the productivity and accuracy of your invoicing process through price rules is convenient indeed, Lawson. Let's check your audit log and troubleshoot to ensure the correct display of the adjusted price rate on your invoices.

 

If you generate an invoice before setting the Increment option under the Rounding section of a price rule, the item's rate will not adjust to the rounded amount. The invoice will maintain the rate of the item as it was when the transaction was created. For instance, if the rates are changed, it won't update the previous transactions and will only reflect future invoices.

 

However, if there are no modifications to the price rule, check the Audit Log to trace revisions or activities within your company file. I'll show you how.

 

  1. Go to the Gear icon, then select Audit log under the Tools column.
  2. Set the User and Date Changed fields for easy tracking.
  3. On the Events box, choose Lists.
  4. Locate the item under the Event column and click View under the History column to review all changes made within the system. 

 

Otherwise, you can delete the invoice and recreate it. If the issue persists, log into your account through an incognito or private window. This mode doesn't retain cache to verify if it's a webpage issue.

 

Here are the keyboard shortcuts you can use:

 

  • For Firefox, press Ctrl + Shift + P
  • For Chrome, press Ctrl + Shift + N
  • For Safari, hold down Command + Shift + N

 

If it works, clear the browser's cache to start with a clean slate. You can also use other supported browsers as an alternative to your regular one.

 

Additionally, you can seek assistance from QuickBooks Live Expert Assisted to receive appropriate guidance on monitoring sales entries and customer payments.

 

Moreover, check out this article to learn more about its function for transactions, eligibility, and inventory bundles: Set price rules in QuickBooks Online.

 

Furthermore, save this reference to document your receivables in the program: Record invoice payments in QuickBooks Online.

 

We recognize the convenience of the price rules feature in streamlining your business workflow. For additional questions about managing products and services or sales entries, add them below. We'll be here to assist you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us