Quote calculator

Price a quote from your price list, customer type, quantity and tax, and see the margin.

Three tabs. Settings holds the tax rate and discounts. Price list holds each product's price and cost. Quotes works out the discount, tax, total and margin for each quote from those two.

Try this template

Ask it things like

What you can do

What is in the sheet

Settings: Setting, Value

Price list: SKU, Product, Unit price, Unit cost

Quotes: Quote ID, Date, Customer, Customer type, SKU, Quantity, Product, Unit price, Discount, Subtotal, Tax, Total, Margin, Status