cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Visit our new QuickBooks News section for news, updates, and opportunities to give feedback.
Highlighted
Level 1

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

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!

Solved
Best answer January 27, 2020

Best Answers
Highlighted
Level 7

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

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!

View solution in original post

6 Comments
Highlighted
Level 7

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

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!

View solution in original post

Highlighted
Level 1

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


@AndréB 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.

Highlighted
Level 1

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

I do business in different provinces. How do I change the tax paid on transactions?

Highlighted
QuickBooks Team

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

Hi there. Doing business in different provinces can a laborious task but I'm glad you're using QuickBooks to help streamline your business. Since you're doing business in multiple provinces, you'd have to set up your provincial tax codes using the steps outlined in this article: How to set up a new sales tax code. Here's what happens when you add a provincial tax code:

  • QBO will automatically set up any new agencies necessary (such as new PST agencies) and the most common codes for that province/territory
  • it prompts you to choose a province or territory from the drop-down. (tip: Only provinces that you haven't yet set up will be listed)

Once you've done this, you can edit your transaction by opening it and editing the tax. When creating an invoice, I encourage you to check out this resource here. The resource shows you how to manually add the appropriate tax code to your invoice or sales form. Let me know if you have questions. I'm here to help. 

Highlighted
New Member

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

I have the same problem but I am using QB Self Employed.  Is there a way to apply the GST on only some items of an expense transactions in the self employed version?

 

Thank you.

Highlighted
QuickBooks Team

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

Hi there. Glad to learn you're using QB Self-Employed to manage your business. I'll be happy to share info about managing your taxes. Based on what you've described, I encourage you to check out this helpful article with more info on: Sales Tax in QB Self-Employed. The article shows you how to apply different tax codes on your transactions. In case you need further assistance, I recommend contacting our Self-Employed team using this link here

 

Feel free to leave a comment below.