Simplify your life - Get more things done - No more overwhelm 
Based on 408 reviews
Follow us on
Inventory Tracker & Pricing Calculator Spreadsheet
  • Inventory Tracker & Pricing Calculator Spreadsheet
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 2
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 3
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 4
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 5
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 6
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 7
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 8
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 9
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 10
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 11
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 12

Inventory Tracker & Pricing Calculator Spreadsheet | Small Business Inventory, Profit and Loss, Google Sheets & Excel

4.9 (408 shop reviews)
Know what to charge, what's in stock and what you really earn. This small business spreadsheet works out the true cost of every product (materials, your time, packaging, overhead and fees), suggests a wholesale and retail price, keeps your inventory up to date and shows your profit month by month.
Original price was: $12.95.Current price is: $9.71.
View Cart
  • Instant Download: Get your planner now!
  • Google Sheets & Excel: pricing, inventory and profit
  • Become more organized and productive
Secure payment:
Secure payment

Planner description

Know what to charge, what's in stock and what you really earn. This small business spreadsheet works out the true cost of every product (materials, your time, packaging, overhead and fees), suggests a wholesale and retail price, keeps your inventory up to date and shows your profit month by month.

Made for makers, crafters and small shops that sell online, at markets or wholesale. Log what you make and sell once a week, and the stock levels, alerts and profit update by themselves.

📊 What's inside

  • Pricing Calculator: pick a product and see its materials and the full price breakdown, plus a price tester to try a new price before you change it
  • Products: cost per item, suggested wholesale and retail price, profit, margin and a price check (losing money, below suggested or good price)
  • Product Materials: what goes into one item; costs are calculated from your materials list
  • Materials: cost per unit from the pack price, stock that goes down as you make products, and reorder alerts
  • Inventory: starting stock, made, sold and in stock for every product, with "make more" alerts and stock value
  • Production Log, Sales Log, Material Purchases and Expenses
  • Sales Log: platform fees, cost of items and profit calculated for every sale, per sales channel
  • Profit & Loss: sales, fees, shipping, cost of items sold, expenses and net profit for every month of the year, plus expenses by category and sales by channel
  • Dashboard: sales, profit, items sold and expenses for any month, what to make more of, what to reorder, best sellers and sales by channel
  • Setup: your hourly rate, overhead, pricing rule, sales channels with their fees, and categories
  • Start Here: simple setup steps

✍️ Details

  • Works in Google Sheets and Excel (also in the Google Sheets app on your phone)
  • Up to 100 products, 150 materials and 1,500 sales lines
  • Works with any currency
  • Example data (a small candle business) included, plus a blank copy
  • ADHD-friendly: color alerts do the remembering, and the Dashboard is your to-do list

📦 You will receive

  • Small-Business-Inventory-Pricing-Spreadsheet.xlsx (with example data)
  • Small-Business-Inventory-Pricing-Spreadsheet-Blank.xlsx

✨ How to download

  1. Complete your purchase.
  2. Download your files from the order confirmation page or your email.
  3. Open them in Excel, or upload them to Google Drive and open them with Google Sheets.

💡 Please note

This is a digital product; no physical item will be shipped. This spreadsheet is a planning tool, not tax or accounting advice. Check your sales platforms for their current fees. For use in your own business; please don't share or resell the files.

Designed by Way to Plan with the help of AI tools. Every product is checked and tested before publishing.

🧾 More spreadsheets for your work and home

Read more
4.9 Great
Average rating based on 408 shop reviews

Reviews

Show more reviews
About Maya
Hey, I’m Maya, I’m Obsessed with notebooks!
Living with my ADHD has its ups and downs, But it taught me the importance of staying organised. Sure, focusing can be tough, but i’m all about finding tricks to make it easier.

You may also like these planners

  • Inventory Tracker & Pricing Calculator Spreadsheet
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 2
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 3
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 4
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 5
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 6
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 7
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 8
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 9
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 10
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 11
  • Inventory Tracker & Pricing Calculator Spreadsheet – image 12