Caleb's Templates

Templates · Google Sheets

Small Business Pricing Calculator

Work out what your business needs to earn, turn it into an hourly floor, and price every product or service so it covers your costs, fees and your time.

  • Know your hourly floor
  • Price every product to profit
  • Compare quotes side by side
$7.00
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

Small Business Pricing Calculator in Google Sheets on a laptop, shown with sample data

What's inside

  • Start HereYour welcome page: a 4-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
  • PricingWhat your business needs to earn. Type your yearly expenses, take-home pay goal, tax set-aside %, working weeks and hours per week; your revenue needed, hourly floor and monthly sales target work themselves out.
  • Product PricingUp to 30 products or services, each priced from its real costs. Type the materials, your minutes of labor, packaging and your current price; the tab works out labor cost, total cost, break-even price, a suggested price at your target margin, a wholesale price, your profit and margin, and a Healthy / Below floor check.
  • QuotePrice one product or service up to three ways side by side, for example the normal price, a discounted price and a bigger order, and see the quote total, costs, fees, profit, margin and a verdict for each.
  • SettingsSet up once: your business name, selling fees (marketplace, payment processing and a fixed fee per order), your target profit margin and your wholesale percentage.

A closer look

Know your numbers: Your costs, taxes and pay goal become revenue needed and an hourly floor. (Pricing Calculator, sample data)
Price every product: Cost, break-even, suggested price and a Healthy or Below floor check for each item. (Pricing Calculator, sample data)
Suggested and wholesale prices: See the price that reaches your margin, and what to charge shops. (Pricing Calculator, sample data)
Compare quotes side by side: Try a discount or a bigger order and see if it still pays you. (Pricing Calculator, sample data)
Fees and margin built in: Marketplace, payment and fixed fees are counted in every price. (Pricing Calculator, sample data)

Screenshots show the Sample copy with made-up data.

Get set up in minutes

  1. Open your copy's Start Here tab.
  2. Settings: your business name, selling fees and target profit margin.
  3. Pricing: your yearly expenses, pay goal and working hours.
  4. Product Pricing: add your first product or service.
  5. Quote: try pricing a real job.

Good to know

  • Google Sheets: you need a free Google account. This isn't an Excel file.
  • Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
  • Nothing to install: no add-ons, no scripts.
  • You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.
How Pricing Calculator fits together

Ready when you are

$7.00
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

You might also like

Client Tracker Google Sheets template

Client Tracker

Keep your clients, jobs and payments in one place, move every job from lead to paid, and see what needs your attention today.

$6.00View template →
 Business Mileage Tracker Google Sheets template

Business Mileage Tracker

Log every business drive in seconds and see your miles and mileage deduction by month, purpose and vehicle for the whole tax year.

Coming soonView template →
 Business Expense Tracker Google Sheets template

Business Expense Tracker

Log every business expense with its category, business-use % and a link to the receipt, and see your deductible total by category and month for the whole tax year.

Coming soonView template →