Skip to main content
November 2, 2021
Solved

Sales Tax Rounding Errors

  • November 2, 2021
  • 1 reply
  • 0 views

I have a very specific problem. All of my sales prices include the sales tax so that I don't have to deal with change. When I have a sale for $60.00, the service price is $56.08. This always rounds up to $60.01. If I change the service price to $56.07, the total changes to $59.99. In this instance I end up having to adjust the final sales tax by a penny, up or down, depending on the service price, to make the total be $60.00 even. This workaround is small and doable for the most part (even if it is annoying) but when I have a credit card sale and don't catch the error, I will tell my clients there is an extra penny on their sale. But when I looked at the merchant account, there was no extra penny. So the sale went through fine, but the invoice in QBO still shows it's off a penny. In order to keep my books accurate, I tried to change the sale to accurately reflect the total, but the card was already processed so I couldn't change the invoice amount. How do I change the customer's invoice without deleting the sale? If I delete the invoice, won't that delete the credit card info? Will that do anything to the transaction in the merchant account? There was no error on the actual sale, just the invoice in QBO.

Best answer by GlinetteC

Hello, C_Heath-Veik.

 

I appreciate you sharing detailed information about your concerns. Let's figure this out together.

 

Deleting the invoice will affect everything. You may edit the invoice or create adjustments on the transaction. Before doing the process, I would suggest consulting your accountant for further guidance on handling this.

 

To edit the invoice:

 

  1. Navigate to the Sales tab and select Customers.
  2. Select the customer.
  3. Locate the Transaction List and find the transaction you want to edit.
  4. Click the invoice and modify it from there.
  5. Select Save.

 

Please reach back out to us if you need anything else.

1 reply

GlinetteCAnswer
November 2, 2021

Hello, C_Heath-Veik.

 

I appreciate you sharing detailed information about your concerns. Let's figure this out together.

 

Deleting the invoice will affect everything. You may edit the invoice or create adjustments on the transaction. Before doing the process, I would suggest consulting your accountant for further guidance on handling this.

 

To edit the invoice:

 

  1. Navigate to the Sales tab and select Customers.
  2. Select the customer.
  3. Locate the Transaction List and find the transaction you want to edit.
  4. Click the invoice and modify it from there.
  5. Select Save.

 

Please reach back out to us if you need anything else.

November 4, 2021

I just ended up adding a .01 credit to the deposit and linked it to the client who had the extra penny on their sale. 

January 25, 2022

Hi, I have the same problem as you. I am wondering if you could show me how to adjust it? Thank you,