What's the difference between markup and margin?

Markup is added to cost; margin is the share of the price that's profit. 50% markup = 33.3% margin.

Should sales tax count as revenue?

No. It's collected for the government, so the sheet keeps it out of profit.

Duplicate the Estimate sheet, rename it Invoice and change the title. The app does this in one tap.

Free template · Excel & Google Sheets

Most estimate templates show the customer a total. This one also shows you the margin — before you send it.

No sign-up, no email. Opens in Excel, Google Sheets, Apple Numbers and LibreOffice.

Yellow cells are the ones you type in. Everything else calculates.

Line item	Type	Qty	Unit cost	Markup	Line cost	Price
Prep & patch walls	Labor	6 hr	$32.00	75%	$192.00	$336.00
Interior paint	Material	4 gal	$38.00	25%	$152.00	$190.00

In Settings, type your business name, tax rate, deposit and the lowest margin you'll accept.
On Estimate, add line items with your cost and markup.
Check the margin box — red means you're below your minimum.
Save rates you reuse in the Price Book. Print or export the Estimate as PDF.

Upload the file to Google Drive, then open it with Google Sheets. Formulas, drop-downs and colour rules carry over.

Markup is on cost; margin is profit ÷ price. A 50% markup is a 33% margin.

ScopeBid does this on your iPhone even with no signal, reuses pricing from past jobs and turns approved quotes into invoices.

What's the difference between markup and margin?: Markup is added to cost; margin is the share of the price that's profit. 50% markup = 33.3% margin.
Should sales tax count as revenue?: No. It's collected for the government, so the sheet keeps it out of profit.
Can I turn this into an invoice?: Duplicate the Estimate sheet, rename it Invoice and change the title. The app does this in one tap.

This template is free to use, share and adapt under CC BY 4.0. If you post it on your site, please link back to this page.