cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
chrissmith
Level 2

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

 
Solved
Best answer September 09, 2022

Accepted Solutions
emmam6
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hello Community Uers, Just wanted to add some clarification onto this thread for any visitors. Using the example given on this thread

  • Drink - £2
  • Food - £5
  • Book - £10
  • Bill - £15.00 (net), £2.00 VAT, Total £17.00

And this has been paid as one single transaction where the VAT is not against every line item and therefore the individual rates are unknown.

If you do not know which items the VAT applies to/what should be Vatable on your expenses, that is something we can't advise you on it is worth looking at HMRC for that information. You would need to record the correct VAT https://www.gov.uk/guidance/rates-of-vat-on-different-goods-and-services. You could also confirm with an accountant. 

View solution in original post

10 REPLIES 10
JaneD
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hi chrissmith,

 

You can both create a bill or an invoice and enter multiple items with different VAT codes. Then, apply the payment from there.

 

Let me show you how:

  1. Sign in to QuickBooks Online (QBO).
  2. From the Plus (+) icon, choose Invoice under Customers.
  3. Choose the customer's name and set the Invoice date field.
  4. In the Amounts are drop down, choose Inclusive of Tax.4.PNG
  5. Under Product/Service, select all items and enter the VAT code in the VAT column.5.PNG
  6. Once done, click on Save and close.

See the Create an invoice article for further guidance.

 

To enter a bill, check out this link: How to enter and pay bills.

 

I'm also sharing some of our great resources that will help you in the future:

If you have any follow-ups or other concerns, just let me know by leaving a comment below. I'll be here to help. Have a wonderful day.

chrissmith
Level 2

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Thanks for the help.  As a follow up - what should I do if the receipt/invoice has multiple individual entries, but only one number for vat (ie I don’t know which vat rate applies to what line). How do you account for that using quickbooks?  Many thanks again.

Adrian_A
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Thanks for coming back to the Community, chrissmith

 

In QuickBooks, you’ll have to manually enter the VAT for the specific item. If you don’t know what rate applies to it, you can use the default rate.

 

If the item is not subjected to VAT, then you can select the No VAT option under the VAT column.

 

Please follow the steps provided by my colleague to select a rate. 

 

Feel free to browse the articles shared above about VAT.

 

I'm just a post away if you still need my help. Thanks!

chrissmith
Level 2

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hi - does that mean you can manually enter a vat amount rather than having to use a rate or %age.  That would make life much easier...  could you please advise how to do that?

 

Thanks!

Ryan_M
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hi @chrissmith,

 

I'll be joining this conversation to provide additional information on your query about VAT rates.

 

What my colleague, @Adrian_A meant above was, you'll have to manually select a VAT rate under the VAT column of your sales transactions. If you're not sure which VAT code to use, I suggest consulting your accountant to ensure that your VAT return will show accurate figures.

 

You mentioned manually entering the VAT amount, which is also possible. Let's take for example the screenshot provided above, which has 2 item lines with 2 different VAT codes. Below the Subtotal line, you'll also see 2 text boxes that  contain the VAT amount for each line.

 

Keep in mind, the VAT amount shown in the text box is the total amount of all items using that specific VAT code. It isn't specific for a single line item unless there's only 1 item using the VAT code in question.

 

Take some time to view this article that contains the default VAT codes available in QuickBooks Online: Common VAT Codes. It's here you can see a list of VAT codes automatically generated by the system when you enable VAT. It also includes a table of how each VAT code affects your VAT 100 return.

 

Do you have any other questions I can help with? Post them below, and I'll get back to you as soon as I can.

chrissmith
Level 2

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hi - thanks for the response - may be to help with the query:

If the firm has paid for a number of things on one bill e.g. food, stationary etc. and has received a VAT receipt - where you can't tell what VAT rates have been applied (only the total VAT), how can you account for it (as you can't use the rates in Quickbooks) - e.g.

  • Drink - £2
  • Food - £5
  • Book - £10
  • Bill - £15.00 (net), £2.00 VAT, Total £17.00

And this has been paid as one single transaction where the VAT is not against every line item and therefore the individual rates are unknown.

 

Hopefully this may make the query a little clearer?

 

Ta.

 

 

Angelyn_T
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hello, @chrissmith.

 

If you mean that the amount of the items are inclusive of tax, the rate usually depends on the VAT you've selected under the VAT column. You actually view the rates under the Subtotal section or by pulling up the transaction journal by clicking on More and selecting Transaction journal on the Invoice page.

 

You can see these screenshots for additional reference.

r7 1.PNG

r7 2.PNG

r7 3.PNG

Keep me posted if you have any other clarifications. I'll be always here to help!

chrissmith
Level 2

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hi - please can you advise if there is a contact number to discuss further as the advice isn’t quite answering the query.

 

Many thanks for your help so far.

GlinetteC
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Good to have you back, chrissmith.

 

I can route you to our phone support team. They'll be able to assist you further with your concern. 

 

Here's how to contact them:

  1. Select the Help icon at the upper right.
  2. Click Contact Us.
  3. Enter different VAT rates as your concern, then click Let's talk.
  4. Select Get a callback.

If you have more questions, don't hesitate to post them anytime here.

emmam6
Moderator

Hi - I have single payments which cover off a number of items with different VAT rates. How do I allow for this in QuickBooks as it only seems to allow 1 VAT rate?

Hello Community Uers, Just wanted to add some clarification onto this thread for any visitors. Using the example given on this thread

  • Drink - £2
  • Food - £5
  • Book - £10
  • Bill - £15.00 (net), £2.00 VAT, Total £17.00

And this has been paid as one single transaction where the VAT is not against every line item and therefore the individual rates are unknown.

If you do not know which items the VAT applies to/what should be Vatable on your expenses, that is something we can't advise you on it is worth looking at HMRC for that information. You would need to record the correct VAT https://www.gov.uk/guidance/rates-of-vat-on-different-goods-and-services. You could also confirm with an accountant. 

Need to get in touch?

Contact us