Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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!
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 :)
The screen shot did not attach in the first post sorry...
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.
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!
For some reason it won't let me add a photo in my initial posts/replies sorry
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!
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?
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:
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:
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!
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
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 :)
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.