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

Splitting a transaction with different VAT Amounts

Hi all,

I have only just started using QuickBooks so I am slowly finding my feet.

My current problem is that I buy items at auction and the VAT is only on the buyer's charges and not the full invoice amount. Here is the breakdown of one of the invoices...

Hammer £360.00 
Buyer's Premium £82.08 

Buyer's Charges £17.83

VAT on Buyer's Charges £3.57

Invoice Total £463.48 

I have been told to find the transaction and then split it but the amounts do not seem to work (screen shot attached). Am I doing something wrong here?

Thanks in advance

Mark



Solved
Best answer April 14, 2021

Accepted Solutions
GeorgiaC
QuickBooks Team

Splitting a transaction with different VAT Amounts

Thanks for getting back to us with that screenshot Mark, when adding transactions from the for-review section of the bank feed, the VAT will always be applied as inclusive of VAT. If you add the receipt with no VAT and then match this to the transaction with VAT, the matched transaction will override what you have selected on the receipt in terms of VAT. 

 

Please get back to us below if you have any Q's!

View solution in original post

GeorgiaC
QuickBooks Team

Splitting a transaction with different VAT Amounts

Hi Mark, sorry for any confusion, there are no issues showing with the calculations above. Once you've matched the receipt to the transaction, please then check your vat report (Taxes > Prepare return > Click into the figure showing against Box 1 > Locate the transaction listed in the VAT detail report that appears) to verify this is posting the £3.57 VAT amount only once on the transaction date. 

 

If there are any issues please get back to us below :) 

View solution in original post

9 REPLIES 9
absolutelynicevintage
Level 1

Splitting a transaction with different VAT Amounts

The screen shot did not attach in the first post sorry...

 

Screen Shot 2021-04-12 at 19.50.05.png

IamjuViel
QuickBooks Team

Splitting a transaction with different VAT Amounts

Hello there, @absolutelynicevintage.

 

You've on the right track in starting the splitting process. Let me share additional information so you'd be able to accurately split your downloaded bank transactions.

 

You'd want to add together the VAT amount and the buyers charge. This way, the vat on the buyer's charge will be accounted. You can refer to the screenshot below: 

 

You can read through the following articles to learn more about managing your downloaded bank transactions:

Get back to us here if you have other questions or concerns. I'm always here to help.

absolutelynicevintage
Level 1

Splitting a transaction with different VAT Amounts

Hi @IamjuViel,

 

Thanks so much for replying. 

I take it the £21.40 is inclusive of the VAT then?

 

Also, when I import/upload the receipt (screen shot below), do I just mark it as no VAT? Then Match the transaction top the receipt?

 

Thanks again!

 

 

absolutelynicevintage
Level 1

Splitting a transaction with different VAT Amounts

For some reason it won't let me add a photo in my initial posts/replies sorry

Screen Shot 2021-04-13 at 11.38.33.png

GeorgiaC
QuickBooks Team

Splitting a transaction with different VAT Amounts

Thanks for getting back to us with that screenshot Mark, when adding transactions from the for-review section of the bank feed, the VAT will always be applied as inclusive of VAT. If you add the receipt with no VAT and then match this to the transaction with VAT, the matched transaction will override what you have selected on the receipt in terms of VAT. 

 

Please get back to us below if you have any Q's!

absolutelynicevintage
Level 1

Splitting a transaction with different VAT Amounts

Thanks @GeorgiaC

Just so I have got it right...

 

When I upload the above auction receipt I will put zero VAT.

Then, once I match it to my split transaction from the bank feed where I have added the extra line for VAT of £21.40 (inclusive of £3.57 of VAT) it is the split transaction that overrides the zero VAT on the imported/uploaded receipt?

 

 

Jen_D
Moderator

Splitting a transaction with different VAT Amounts

Thanks for posting here again, @absolutelynicevintage,

 

Let's make sure you're able to apply the correct VAT correctly on the bank transactions in QuickBooks Online. For this, try some browser troubleshooting, by opening a private window.

 

This way, we can check if this is a caching concern. Unexpected issues in QuickBooks are mostly affected by the data accumulated in the cache. The regular browser will constantly save data by overwriting itself, but it will not remove any history automatically.

 

The incognito mode, on the other hand,  does not save any history, which makes it a great place to identify issues in the browser. Use these keyboard shortcuts to launch a new private window:

 

  • Google Chrome: press Ctrl Shift N  
  • Mozilla Firefox: press Ctrl Shift P
  • Safari: press Command Shift N

 

Clearing the cache can also help resolve browser issues in QBO.

 

If they already tried this, and still getting the same problem, I recommend getting in touch with our Support Team. They can help report this to our engineers who deals with program bugs and other technical concerns.

 

Also, regarding our support, we have made changes to our operation hours and our contact options. Our Live Help are available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM til 3:00 PM on Saturdays.

 

To get in touch with our representatives, follow the steps below:

 

  1. Go to the (?) Help menu to open the QB Assistant box.
  2. On the page, enter Contact Support.
  3. Pick Live Chat to connect with our live representative.
  4. Once done, click the Live Chat link provided in the pop-up box.
  5. On the next page, enter the description of the issue, then Let's Talk.
  6. Lastly, select Start a chat.

 

Kindly post again for updates after trying out the steps with the VAT split. Tag me in your reply so I'll get notified with your response. Have a good day!

absolutelynicevintage
Level 1

Splitting a transaction with different VAT Amounts

Hi @Jen_D 

 

Thanks for replying.

 

Is there something wrong with my calculations and from what you can see in the screenshots that would make it a good idea to clear my cache? I don't fully understand sorry

GeorgiaC
QuickBooks Team

Splitting a transaction with different VAT Amounts

Hi Mark, sorry for any confusion, there are no issues showing with the calculations above. Once you've matched the receipt to the transaction, please then check your vat report (Taxes > Prepare return > Click into the figure showing against Box 1 > Locate the transaction listed in the VAT detail report that appears) to verify this is posting the £3.57 VAT amount only once on the transaction date. 

 

If there are any issues please get back to us below :) 

Need to get in touch?

Contact us