Thanks for visiting the Community
Can we just confirm are you using QuickBooks Online or QuickBooks Desktop?Is the VAT invoice a 100 percent VAT invoice?
it’s the online version. The fee is 20% VAT as normal to the end client, but the Commision fee to the insurance broker is no VAT.
Basically i need 2 invoices, both with the full fee and VAT but one to the broker minus their commision before VAT is charged.
We presume that you do not want the invoice to the client to show the commission. In this case you will have to create the invoice with one line showing the amount and 20%S tax, you will have to save it, the opaque save, print/send this to your client. You will then have to add a second line, creating a service for the commission, in the income account for the service you will have create/select a commission expense account and on the invoice enter the amount in a negative figure and select No VAT, select save, print/send to your broker.
Thanks John C,
I had thought along those lines. The only trouble with that is that i want one invoice in the Clients name and the other in the Brokers name but both with the same invoice number. I realise with your method i can achieve this but it’s alot of messing about and less than satisfactory in my opinion. Not that I’m blaming you of course.
I can’t be the only person that has to deal with an agent and an end client for the same transaction. It seems to be a restriction of the quickbooks process that costs me a fee every month.
Thanks for your assistance.
You can make use of QuickBooks Bundle feature to keep track of your sales and commission expense in QuickBooks. Let me guide you on how to do it.
QuickBooks Bundle is a group of items and services that you can sell and track in QuickBooks. By using this feature, you have the option not to show all the components of the invoice when sending it to your clients.
First, let's enable the custom field in your Sales Settings. This will allow you to indicate the name of the sales rep on the invoice for tracking purposes.
Next, let's ensure to set up Commission Expense and Commission Payable account. These accounts will be used to track commission related cost and liabilities.
Once completed, let's create the service items that will compose the bundle.
Now, let's create our bundle.
You can refer to this short video clip for more detailed instructions:
Always feel free to swing by here in the Community if you have other questions. I'm just a few posts away.