cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
bookkeepinghell
Level 2

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

10 Comments 10
AndréB
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!

bookkeepinghell
Level 2

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.

VickyHarrisonDesigns
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?

JamesM
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. 

Mel Equestrian
Level 1

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.

JamesM
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. 

EliCostello
Level 2

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

They're not asking about sales tax that they, the Quickbooks user, charges to customers.  They're talking about taxes that they, the Quickbooks user, *pays* on their business expenses.

EliCostello
Level 2

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

He's not talking about tax that he, the Quickbooks user, charges to customers; he's talking about taxes that he *pays* when he purchases items/services for his business.

Drifterscreamery
Level 1

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

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

Trish_T
QuickBooks Team

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

Hi Drifterscreamery,

 

Thanks for joining us here.  Having your sales tax applied accurately is key, in keeping your books accurate.  In your situation, I suggest speaking with an accounting professional for their expertise and best course of action.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

If you have any other questions, please reach back out.  We'd be glad to assist!

Need to get in touch?

Contact us