Google Sheet With Calculations Required

Hi,

I need to create an invoice template that my team can use to create invoices from and send as a PDF to customers for payment. This is for games of Laser Tag (Prices on our website are shown as INC VAT prices).

Essentially it needs to show a drop-down menu of different products (about 30 of them) along with a different price for each.

I need to be able to select a quantity, and then it will total at the end (INC VAT) price.

Under that I need a breakdown as follows:

Sub-Total:

Discount:

VAT:

Invoice Total:

The reason I need to do the VAT breakdown in this way is due to the way our booking system shows package prices to customers.

I have started to put together a Google sheet but then got stuck! I can send this to you if you wish to work with me on it?

Thanks!

Rob