Handling the quickbooks entries can be done on the invoice with two lines instead of one. The first line is the purchase price, the second is the margin price (sale price - purchase price). You choose Exempt VAT* for the purchase price and standard (20%) VAT for the margin price. (Be sure to check "inclusive of VAT" on the invoice settings.)
line 1: purchase price £2,500
line 2: margin price £500
Subtotal : Sale price £3,000
This does have problems however. Displaying the purchase and margin separately is not something any dealer will want to show on invoices to their customers but thankfully there is a work around. Create a Bundle called "Second Hand Car Sales" for example and place the purchase product and margin price product in the bundle. Do not show individual products in the bundle and then you will only see the total of the bundle on the invoice in line 1.
line 1: bundle price £3,000
subline 1: purchase price £2,500 (hidden on invoice)
subline 2: margin price £500 (hidden on invoice)
Subtotal : Sale price £3,000
One thing to note is that using this method does hinder the use of the stock control feature of Quickbooks plus. If you tracked each individual item as its own unique product you would have to create bundles every time you sell an item, something I wouldn't recommend if you sell a lot of items. Personally I would use an external spreadsheet to manage your stock and calculate the margin.
This method eliminates the need for VAT margin journal adjustments.
I have one question however, how does this work with the requirement found on HMRC website
|Total price – you must not show VAT separately|
Can you avoid showing VAT on the invoice this way?
While quickbooks can turn off VAT from the sales line. there is currently no way to hide the Total VAT within quickbooks. What I would recommend is to import a custom form style.
click on Cog > Custom Form Styles.
click on New Style > Import Style
Download instructions and samples.
extract files to your computer and open one of the sample templates in word.
remove all references to VAT from the template and save
Upload the new DOCX file into quickbooks.
Check the fields, Preview and save once you are happy.
Then print a test invoice to make sure its all good. You can then set this new style as your default invoice.
Hi there, SN4 Cars.
Yes, since the amount of the item is 500 and you set the Vat in 20%, it will show 100 as the equivalent of the vat % you set up.
Please check these articles on how QuickBooks Online helps you automate your tax tracking and to see a different list of common VAT codes:
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
If your profit was £600 then the VAT amount would be £100
If your profit is £500 then the VAT amount would be £83.33
The VAT element is one sixth of your total profit (0.1666666)
Amount of profit X 0.16666666 = VAT amount