Skip to main content
B
bookkeepinghell
January 27, 2020
Solved

How do I change the sales tax amount on an expense transaction?

  • January 27, 2020
  • 1 reply
  • 0 views

I have quite a few expenses/receipts where some (not all) of the items on the receipt are tax exempt.  The way Quickbooks online is working, is it will automatically calculate the GST and/or PST (at the set percentage) on the total amount of the expense/receipt.  I need to be able to amend these incorrect tax amounts and have tried overriding the amount that is automatically entered by QBO, but it then also alters the total, to adjust it so that the tax amount is the correct percentage again.  Is there any easy way to change these tax amounts on individual expenses?  I am looking to move to QBO from another product, however if there is no simple way of changing these amounts, it may have to be a dealbreaker for me!  Any help would be much appreciated, as I have searched and searched online and still not found an answer.  Thanks!

Best answer by AndréB12

Hi there,

 

I'm happy to see you're taking extra steps to ensure all taxes are recorded properly, and that you have a solid understanding of how QuickBooks is calculating taxes. When amounts are displayed Inclusive of Tax, the system will automatically adjust the line amounts when tax amounts are selected. This is very helpful when adding transactions from the bank feed, but we can easily avoid the conversion of these amounts if needed. I'll be happy to help sort this out. 

 

You can easily edit tax amounts in the subtotal if the Amounts are field is set to Exclusive of tax. Switching this option will automatically adjust your line items to maintain the underlying journal entry (amounts will be displayed before tax). You'll then be able to adjust tax amounts in the subtotal without affecting any other numbers. If your expense consists of a single line, you'll also be able to adjust the line amount manually to keep the same total.

 

If you'd like to see us tweak this feature, please submit feedback to our engineering team. Every bit of feedback you submit helps us continue building the features you find most valuable.

 

Let me know if you have any more questions!

1 reply

A
AndréB12Answer
January 27, 2020

Hi there,

 

I'm happy to see you're taking extra steps to ensure all taxes are recorded properly, and that you have a solid understanding of how QuickBooks is calculating taxes. When amounts are displayed Inclusive of Tax, the system will automatically adjust the line amounts when tax amounts are selected. This is very helpful when adding transactions from the bank feed, but we can easily avoid the conversion of these amounts if needed. I'll be happy to help sort this out. 

 

You can easily edit tax amounts in the subtotal if the Amounts are field is set to Exclusive of tax. Switching this option will automatically adjust your line items to maintain the underlying journal entry (amounts will be displayed before tax). You'll then be able to adjust tax amounts in the subtotal without affecting any other numbers. If your expense consists of a single line, you'll also be able to adjust the line amount manually to keep the same total.

 

If you'd like to see us tweak this feature, please submit feedback to our engineering team. Every bit of feedback you submit helps us continue building the features you find most valuable.

 

Let me know if you have any more questions!

B
bookkeepinghellAuthor
January 28, 2020
@AndréB12 wrote:

Hi there,

 

I'm happy to see you're taking extra steps to ensure all taxes are recorded properly, and that you have a solid understanding of how QuickBooks is calculating taxes. When amounts are displayed Inclusive of Tax, the system will automatically adjust the line amounts when tax amounts are selected. This is very helpful when adding transactions from the bank feed, but we can easily avoid the conversion of these amounts if needed. I'll be happy to help sort this out. 

 

You can easily edit tax amounts in the subtotal if the Amounts are field is set to Exclusive of tax. Switching this option will automatically adjust your line items to maintain the underlying journal entry (amounts will be displayed before tax). You'll then be able to adjust tax amounts in the subtotal without affecting any other numbers. If your expense consists of a single line, you'll also be able to adjust the line amount manually to keep the same total.

 

If you'd like to see us tweak this feature, please submit feedback to our engineering team. Every bit of feedback you submit helps us continue building the features you find most valuable.

 

Let me know if you have any more questions!


Thank you!  I thought I had tried that last night, but it wasn't working for me - I must've been doing something wrong, as it seems to be working now!  Oops!  Thanks for your help.

D
Drifterscreamery
September 23, 2023

When I change it to exclusive of tax, it still changes the total amount.

Terms & ConditionsAccessibility statement